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

في هذه الدورة التدريبية، ستكمل مشروعًا متقدمًا حيث ستنشئ قاعدة بيانات وعملاء لمطعم Little Lemon.

لإكمال هذه الدورة التدريبية، ستحتاج إلى خبرة في هندسة قواعد البيانات.

يمكّنك المشروع المتقدم من إظهار مهارات متعددة من الشهادة من خلال حل مشكلة حقيقية موجودة بالفعل. تتضمن كل وحدة ملخصًا موجزًا وروابط للمحتوى الذي تعرفت عليه في الدورات التدريبية السابقة في هذا البرنامج.

في هذه الدورة التدريبية، ستظهر مجموعة مهاراتك الجديدة من خلال تصميم وإنشاء حل لقاعدة بيانات، وستستخدم جميع المهارات والتقنيات التي تعلمتها خلال هذا البرنامج لحل المشكلة المطروحة.

بنهاية هذه الدورة التدريبية، ستكون قد أثبتت قدرتك على:

-إعداد مشروع قاعدة بيانات،

-إضافة تقارير المبيعات،

-إنشاء نظام لحجز الطاولات،

-التعامل مع تحليلات البيانات وعرضها بشكل مرئي،

-وإنشاء عميل قاعدة بيانات.

ستظهر أيضًا قدرتك باستخدام الأدوات والبرامج التالية:

-Git،

-MySQL Workbench،

-Tableau،

-ولغة Python.

What's inside

Syllabus

معلومات المشروع

توفر هذه الوحدة خبرة عملية في استخدام MySQL. قم بإعداد خادم مثيل MySQL في MySQL Workbench، ثم أنشئ نموذج بيانات مخطط علاقة الكيانات ER وقم بتنفيذه في MySQL.

إجراءات استعلامات قاعدة البيانات والجمل المعدة

استخدم SQL لإنشاء الجداول الافتراضية والإجراءات المخزنة والجمل المعدة لمطعم Little Lemon.

العملاء والعرض المرئي

قم بإنشاء عرض مرئي لبيانات المبيعات لمطعم وتنفيذ عميل قاعدة البيانات في لغة Python.

تقييم المشروع

إكمال مراجعة الأقران لمشروع قاعدة بيانات Little Lemon والانعكاس على ما تعلمته.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Taught by Meta staff, who are recognized for their work in developing and deploying Meta's products

Develops skills and knowledge that are core to the discipline of database design and engineering

Uses software that is highly relevant to industry, such as MySQL Workbench, Tableau, and Python

Requires learners to have extensive background skill in database engineering

Assumes learners can learn an entire stack of software (MySQL, Tableau, Python) without issue

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in المشروع المتقدم لمهندس قاعدة البيانات with these activities:

Compile a resource list on database best practices

Show steps

Gather and organize valuable resources on database best practices to enhance your knowledge and skills.

Browse courses on Database Design

Show steps

Research and identify credible sources of information on database best practices.
Compile a list of articles, books, or online resources that cover various aspects of database design and optimization.
Categorize and organize the resources for easy access and reference.
Share your compilation with fellow students or within online forums for wider benefit.

Explore advanced MySQL features

Show steps

Expand your knowledge of MySQL by learning about advanced features and techniques.

Show steps

Identify areas where you need to enhance your MySQL skills.
Find online tutorials or documentation that cover these advanced features.
Follow the tutorials and practice implementing the features in your own MySQL environment.
Test your understanding by completing exercises or quizzes related to the advanced features.

Practice SQL queries

Show steps

Reinforce your understanding of SQL syntax and commands by practicing writing queries.

Browse courses on SQL

Show steps

Set up a local MySQL environment.
Create a sample database with tables and data.
Write SQL queries to retrieve, insert, update, and delete data.
Test your queries and troubleshoot any errors.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Peer review of database solutions

Show steps

Gain valuable feedback on your database solutions by discussing and evaluating them with peers.

Show steps

Form a study group with fellow students.
Share your database solutions with the group for review.
Provide constructive feedback to your peers, focusing on strengths and areas for improvement.
Incorporate feedback into your own solutions to enhance their quality.

Design an ER diagram for Little Lemon

Show steps

Consolidate your understanding of Little Lemon's business processes by creating a visual representation of their database structure.

Show steps

Identify the entities and relationships involved in Little Lemon's operations.
Draw the ER diagram using appropriate symbols and notation.
Review and refine your diagram to ensure it accurately reflects the business requirements.
Present your ER diagram to a peer or instructor for feedback.

Develop a Python script for data analysis

Show steps

Apply your knowledge of Python and data analysis techniques to extract insights from Little Lemon's data.

Browse courses on Python

Show steps

Gather and clean the necessary data from the Little Lemon database.
Write Python code to perform data analysis, such as calculating averages, finding trends, or generating visualizations.
Interpret the results of your analysis and draw meaningful conclusions.
Document your code and analysis in a clear and concise manner.

Build a prototype database application

Show steps

Apply your skills in database design and development to create a functional database application.

Show steps

Define the scope and requirements of your database application.
Design and implement the database schema using MySQL.
Develop the application logic using Python or another programming language.
Test and debug your application to ensure it meets the requirements.
Deploy your application and make it accessible to users.

Career center

Learners who complete المشروع المتقدم لمهندس قاعدة البيانات will develop knowledge and skills that may be useful to these careers:

Database Engineer

A Database Engineer designs, builds, and maintains databases. They ensure that data is organized and accessible to users. This course can help you develop the skills needed to succeed in this role by teaching you how to create and manage databases, write SQL queries, and use data analysis tools.

See salaries and explore the career path for Database Engineer

Data Analyst

A Data Analyst collects, cleans, and analyzes data to help businesses make informed decisions. This course can help you develop the skills needed to succeed in this role by teaching you how to use data analysis tools, interpret data, and communicate your findings.

See salaries and explore the career path for Data Analyst

Data Scientist

A Data Scientist uses data to solve business problems. They develop and implement data-driven solutions to improve business performance. This course can help you develop the skills needed to succeed in this role by teaching you how to use data analysis tools, machine learning, and artificial intelligence.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer designs, develops, and maintains software applications. They use their knowledge of programming languages and software development tools to create software that meets the needs of users. This course can help you develop the skills needed to succeed in this role by teaching you how to design and develop software applications.

See salaries and explore the career path for Software Engineer

Web Developer

A Web Developer designs, develops, and maintains websites. They use their knowledge of HTML, CSS, and JavaScript to create websites that are visually appealing and easy to use. This course can help you develop the skills needed to succeed in this role by teaching you how to design and develop websites.

See salaries and explore the career path for Web Developer

IT Manager

An IT Manager plans, organizes, and directs the IT operations of an organization. They are responsible for ensuring that the organization's IT systems are running smoothly and efficiently. This course can help you develop the skills needed to succeed in this role by teaching you how to manage IT infrastructure, implement IT solutions, and lead IT teams.

See salaries and explore the career path for IT Manager

Business Analyst

A Business Analyst helps businesses to understand their needs and develop solutions to improve their operations. They use their knowledge of business processes, data analysis, and technology to identify opportunities for improvement and develop recommendations for change.

See salaries and explore the career path for Business Analyst

Project Manager

A Project Manager plans, organizes, and executes projects. They are responsible for ensuring that projects are completed on time, within budget, and to the required quality standards. This course can help you develop the skills needed to succeed in this role by teaching you how to plan and manage projects, track progress, and communicate with stakeholders.

See salaries and explore the career path for Project Manager

Technical Writer

A Technical Writer creates and maintains technical documentation, such as user manuals, training materials, and technical reports. They use their knowledge of technical subjects and writing skills to communicate complex information clearly and concisely.

See salaries and explore the career path for Technical Writer

Systems Analyst

A Systems Analyst studies the needs of an organization and designs and implements solutions to improve its operations. They use their knowledge of business processes, technology, and data analysis to identify opportunities for improvement and develop recommendations for change.

See salaries and explore the career path for Systems Analyst

Database Administrator

A Database Administrator manages and maintains databases. They are responsible for ensuring that databases are running smoothly and efficiently, and that data is secure and backed up. This course can help you develop the skills needed to succeed in this role by teaching you how to manage databases, implement data security measures, and troubleshoot database issues.

See salaries and explore the career path for Database Administrator

Data Warehouse Engineer

A Data Warehouse Engineer designs, builds, and maintains data warehouses. They use their knowledge of data warehousing technologies and data integration techniques to create data warehouses that meet the needs of users. This course can help you develop the skills needed to succeed in this role by teaching you how to design and build data warehouses, implement data integration solutions, and manage data warehouse performance.

See salaries and explore the career path for Data Warehouse Engineer

Software Tester

A Software Tester tests software applications to identify and fix bugs. They use their knowledge of software testing tools and techniques to ensure that software applications are working as intended. This course can help you develop the skills needed to succeed in this role by teaching you how to test software applications, identify and fix bugs, and write test reports.

See salaries and explore the career path for Software Tester

Network Administrator

A Network Administrator manages and maintains computer networks. They are responsible for ensuring that networks are running smoothly and efficiently, and that network security is maintained. This course can help you develop the skills needed to succeed in this role by teaching you how to manage networks, implement network security measures, and troubleshoot network issues.

See salaries and explore the career path for Network Administrator

Security Analyst

A Security Analyst protects computer networks and systems from unauthorized access and attacks. They use their knowledge of security tools and techniques to identify and mitigate security risks. This course can help you develop the skills needed to succeed in this role by teaching you how to implement security measures, identify and respond to security threats, and investigate security incidents.

See salaries and explore the career path for Security Analyst