هياكل قواعد البيانات وإدارتها باستخدام MySQL from Coursera

تطوير معرفة عملية بنظام إدارة قواعد بيانات MySQL (DBMS). اكتساب مهارات DBMS مثل إنشاء البيانات والاستعلام والمعالجة. ستكتسب المزيد من الخبرة في التعامل مع الجمل والعبارات وأنواع البيانات في لغة SQL.

بنهاية هذه الدورة التدريبية، ستتمكن من:

- استخدام MySQL DBMS لإنشاء قواعد البيانات العلائقية وتعديلها باستخدام SQL

- إضافة سجلات إلى قاعدة بيانات MySQL

- تنفيذ استعلامات معقدة على سجلات قاعدة البيانات مع عوامل التصفية والتجميعات

- إنشاء عوامل ضم وربط بسيطة داخل قاعدة بيانات

- إنشاء علاقات بين الجداول باستخدام المفاتيح الأساسية والخارجية

- إظهار القدرة على إكمال مشروع تسوية قاعدة البيانات

ستكتسب خبرة في الأدوات والبرامج التالية:

- MySQL DBMS

- عوامل الربط والضم

- عبارات SQL وجملها وأنواع البيانات

- المفاتيح الأساسية والخارجية

- تسوية قاعدة البيانات

What's inside

Syllabus

مقدمة إلى MySQL

في هذه الوحدة، ستتعلم استخدام MySQL DBMS لإنشاء قواعد البيانات العلائقية وتعديلها والاستعلام عنها باستخدام SQL.

تحديث قواعد البيانات والعمل باستخدام طرق العرض

في هذه الوحدة ستتعلم كيفية تحديث قواعد البيانات والعمل باستخدام طرق العرض.

الدوال والإجراءات المخزنة في MySQL

في هذه الوحدة الثالثة، ستستكشف أنواعًا مختلفة من الدوال وتتعلم كيفية التعامل مع إجراءات MySQL المخزنة.

التقييم المقيّم بدرجات

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

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops a practical understanding of the MySQL DBMS

Teaches DBMS skills such as creating, querying and manipulating data

Builds a foundation in the use of SQL statements, clauses, and data types

Enables learners to create and modify relational database using MySQL DBMS with SQL

Provides a solid understanding of adding records to a MySQL database

Offers hands-on experience with Joins and Unions in a database

Career center

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

Database Administrator

Database Administrators plan, implement, and maintain an organization's database systems. They ensure that databases are running smoothly, that data is secure, and that users have access to the data they need. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Database Administrator, as they allow you to manage and maintain databases effectively.

See salaries and explore the career path for Database Administrator

Data Analyst

Data Analysts collect, analyze, and interpret data to help organizations make informed decisions. They use their skills in statistics, programming, and data visualization to identify trends and patterns in data. This course can help you develop the skills you need to be a successful Data Analyst. You will learn how to use MySQL to query and analyze data, and you will gain experience with data visualization techniques.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts help organizations improve their performance by identifying and solving business problems. They use their skills in data analysis, process improvement, and stakeholder management to help organizations achieve their goals. This course can help you develop the skills you need to be a successful Business Analyst. You will learn how to use MySQL to collect and analyze data, and you will gain experience with process improvement techniques.

See salaries and explore the career path for Business Analyst

Software Engineer

Software Engineers design, develop, and maintain software applications. They use their skills in programming, data structures, and algorithms to create software that meets the needs of users. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Software Engineer, as they allow you to work with databases effectively.

See salaries and explore the career path for Software Engineer

Data Scientist

Data Scientists use their skills in statistics, machine learning, and data visualization to extract insights from data. They help organizations make informed decisions by identifying trends and patterns in data. This course can help you develop the skills you need to be a successful Data Scientist. You will learn how to use MySQL to query and analyze data, and you will gain experience with data visualization techniques.

See salaries and explore the career path for Data Scientist

Web Developer

Web Developers design and develop websites and web applications. They use their skills in HTML, CSS, JavaScript, and server-side programming to create websites that are both functional and visually appealing. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Web Developer, as they allow you to work with databases effectively.

See salaries and explore the career path for Web Developer

IT Support Specialist

IT Support Specialists provide technical support to users of computer systems and software. They troubleshoot problems, install and maintain software, and provide training to users. This course can help you develop the skills you need to be a successful IT Support Specialist. You will learn how to use MySQL to troubleshoot database problems and how to provide support to users.

See salaries and explore the career path for IT Support Specialist

Network Administrator

Network Administrators design, implement, and maintain computer networks. They ensure that networks are running smoothly and that users have access to the resources they need. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Network Administrator, as they allow you to manage and maintain databases effectively.

See salaries and explore the career path for Network Administrator

Computer Systems Analyst

Computer Systems Analysts design, implement, and maintain computer systems. They work with users to identify their needs and develop systems that meet those needs. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Computer Systems Analyst, as they allow you to work with databases effectively.

See salaries and explore the career path for Computer Systems Analyst

Information Security Analyst

Information Security Analysts protect computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. They develop and implement security measures to protect against threats such as malware, hackers, and data breaches. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for an Information Security Analyst, as they allow you to manage and maintain databases securely.

See salaries and explore the career path for Information Security Analyst

Database Designer

Database Designers design and develop database systems. They work with users to identify their needs and develop databases that meet those needs. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Database Designer, as they allow you to design and develop databases effectively.

See salaries and explore the career path for Database Designer

Data Warehouse Architect

Data Warehouse Architects design and develop data warehouses. They work with users to identify their needs and develop data warehouses that meet those needs. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Data Warehouse Architect, as they allow you to design and develop data warehouses effectively.

See salaries and explore the career path for Data Warehouse Architect

Big Data Engineer

Big Data Engineers design and develop systems to store and process large amounts of data. They work with users to identify their needs and develop systems that meet those needs. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Big Data Engineer, as they allow you to work with databases effectively.

See salaries and explore the career path for Big Data Engineer

Cloud Architect

Cloud Architects design and develop cloud-based systems. They work with users to identify their needs and develop systems that meet those needs. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Cloud Architect, as they allow you to work with databases effectively.

See salaries and explore the career path for Cloud Architect

Data Governance Analyst

Data Governance Analysts develop and implement policies and procedures to govern the use of data. They work with users to identify their needs and develop policies that meet those needs. This course can help you build a foundation in MySQL, a widely used database management system. You will learn how to create and modify databases, add records, and perform complex queries. These skills are essential for a Data Governance Analyst, as they allow you to work with databases effectively.

See salaries and explore the career path for Data Governance Analyst

هياكل قواعد البيانات وإدارتها باستخدام MySQL

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses