المشروع المتقدم لمهندس قاعدة البيانات

Introduction to the course, project overview, curriculum, and success tips.

• Set up the project environment
• Learn about version control and Git repository setup
• Prepare MySQL database and basic SQL concepts
• Create entity-relationship model and implement it in MySQL

Learn to create sales report queries, develop a table reservation system, and optimize MySQL queries using stored procedures and prepared statements.

• Build summary tables for sales data
• Enhance MySQL queries with stored procedures and prepared statements
• Create SQL queries for managing and analyzing reservations

Perform visual data analysis using Tableau and build a customer database with Python.

• Set up Tableau Workspace for data analysis
• Create interactive dashboards for sales and profits
• Implement Python functions for customer database queries

Summary of the course, final assessment details, self-review, and reflection on the Little Lemon database project.

• Complete the Little Lemon database project
• Prepare for the final graded assessment
• Reflect on the project and think about further learning