المشروع المتقدم لمهندس قاعدة البيانات 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

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