Relational Databases - MySQL - قواعد البيانات العلائقية from Coursera

في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعلم كيفية استخدام لغة الاستعلام البنائية SQL للحصول على معلومات من قاعدة البيانات.

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

هذا المشروع هو للمبتدئين تماماً في مجال قواعد البيانات العلائقية

What's inside

Syllabus

Module 1

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

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Introduces foundational concepts in SQL for beginners with no prior relational database experience

Provides hands-on, project-based learning, promoting practical application of SQL

Covers fundamental SQL operations such as data retrieval, filtering, sorting, and table manipulation

Utilizes MySQL as the database management system for practical examples and exercises

Taught by Amani Abbas, an experienced instructor in the field of data analysis and SQL

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 Relational Databases - MySQL - قواعد البيانات العلائقية with these activities:

Find a SQL mentor

Show steps

Connect with experienced SQL professionals for guidance and support.

Show steps

Attend industry events or join online communities
Reach out to professionals in your network
Prepare questions and schedule informational interviews

Watch SQL tutorials

Show steps

Review SQL syntax and concepts before starting the course.

Browse courses on Structured Query Language

Show steps

Find beginner-friendly SQL tutorials online
Watch videos or read articles to learn the basics of SQL
Practice writing simple SQL queries

Solve SQL practice problems

Show steps

Reinforce your understanding of SQL syntax and concepts.

Browse courses on SQL Queries

Show steps

Find online SQL practice problems or quizzes
Solve the problems using SQL queries
Check your answers and identify areas for improvement

Five other activities

Expand to see all activities and additional details

Show all eight activities

Create a SQL cheat sheet

Show steps

Summarize key SQL concepts and syntax for easy reference.

Browse courses on SQL Syntax

Show steps

Gather SQL syntax and concepts from your notes or online resources
Organize the information into a cheat sheet
Review the cheat sheet regularly

Volunteer in a data-related organization

Show steps

Gain practical experience and contribute to the community by volunteering your SQL skills.

Browse courses on Data Science

Show steps

Research organizations that use SQL
Identify opportunities to assist with data management or analysis projects
Apply your SQL skills to real-world problems

Build a mini database project

Show steps

Apply your SQL skills to create a practical database solution.

Browse courses on Database Design

Show steps

Define the scope and purpose of your project
Design the database schema
Create the database and tables
Populate the database with data
Write SQL queries to retrieve and manipulate data

Contribute to open-source SQL projects

Show steps

Enhance your SQL skills and contribute to the open-source community.

Browse courses on Open-Source Software

Show steps

Find SQL-related open-source projects on platforms like GitHub
Identify areas where you can contribute your skills
Submit bug reports, feature requests, or code contributions

Start a personal SQL project

Show steps

Extend your SQL skills by working on a self-directed project.

Browse courses on Data Analysis

Show steps

Identify a problem or question you want to solve or explore
Gather data from available sources or create your own
Design and implement a SQL solution
Analyze the results and draw conclusions

Career center

Learners who complete Relational Databases - MySQL - قواعد البيانات العلائقية will develop knowledge and skills that may be useful to these careers:

Data Analyst

A Data Analyst uses SQL to organize and interpret large amounts of data. Through this course, learners will gain foundational knowledge in SQL that they can leverage to confidently apply SQL on the job. Many Data Analyst roles require a master's degree, with experience in a related field.

See salaries and explore the career path for Data Analyst

Database Administrator

Database Administrators develop and maintain the databases that power a range of applications. They use SQL to interact with databases and ensure that data is secure and accessible. This course provides a solid foundation in SQL that can help aspiring Database Administrators succeed in their role.

See salaries and explore the career path for Database Administrator

Software Engineer

Software Engineers use SQL to manage data and ensure that applications can access and manipulate data efficiently. This course will help learners build a strong foundation in SQL, which is an essential skill for Software Engineers working with relational databases.

See salaries and explore the career path for Software Engineer

Data Scientist

Data Scientists use SQL to analyze and interpret data to uncover patterns and trends. This course provides a good introduction to SQL, which can be helpful for aspiring Data Scientists looking to gain a foundational understanding of data querying and manipulation.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts use SQL to extract insights from data and make recommendations that can improve business outcomes. This course can provide learners with a valuable introduction to SQL, which can be beneficial for Business Analysts who need to understand data and communicate insights effectively.

See salaries and explore the career path for Business Analyst

Information Security Analyst

Information Security Analysts use SQL to protect databases from unauthorized access and data breaches. This course can help learners develop a basic understanding of SQL, which can be useful for Information Security Analysts who need to understand database security and compliance.

See salaries and explore the career path for Information Security Analyst

Web Developer

Web Developers use SQL to manage data for websites and web applications. This course can provide learners with a basic understanding of SQL, which can be helpful for Web Developers who need to interact with databases and retrieve data for their projects.

See salaries and explore the career path for Web Developer

Product Manager

Product Managers use SQL to understand customer data and make informed decisions about product development. This course can provide learners with a basic understanding of SQL, which can be helpful for Product Managers who need to interact with data and understand customer behavior.

See salaries and explore the career path for Product Manager

Project Manager

Project Managers use SQL to track project data and manage resources effectively. This course can provide learners with a basic understanding of SQL, which can be helpful for Project Managers who need to interact with data and monitor project progress.

See salaries and explore the career path for Project Manager

Marketing Analyst

Marketing Analysts use SQL to analyze marketing data and measure the effectiveness of marketing campaigns. This course can provide learners with a basic understanding of SQL, which can be helpful for Marketing Analysts who need to interpret data and make recommendations.

See salaries and explore the career path for Marketing Analyst

Financial Analyst

Financial Analysts use SQL to analyze financial data and make investment recommendations. This course can provide learners with a basic understanding of SQL, which can be helpful for Financial Analysts who need to understand financial data and make informed decisions.

See salaries and explore the career path for Financial Analyst

Operations Manager

Operations Managers use SQL to track operational data and improve efficiency. This course can provide learners with a basic understanding of SQL, which can be helpful for Operations Managers who need to interact with data and make informed decisions.

See salaries and explore the career path for Operations Manager

Salesperson

Salespeople use SQL to track sales data and manage customer relationships. This course can provide learners with a basic understanding of SQL, which can be helpful for Salespeople who need to interact with data and understand customer behavior.

See salaries and explore the career path for Salesperson

Customer Service Representative

Customer Service Representatives use SQL to track customer interactions and resolve issues. This course can provide learners with a basic understanding of SQL, which can be helpful for Customer Service Representatives who need to interact with data and understand customer needs.

See salaries and explore the career path for Customer Service Representative

Administrative Assistant

Administrative Assistants use SQL to manage data and support various departments within an organization. This course can provide learners with a basic understanding of SQL, which can be helpful for Administrative Assistants who need to interact with data and perform administrative tasks.

See salaries and explore the career path for Administrative Assistant