OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Course image
Coursera logo

تعليم مبادئ ال SQL Syntax

ahmed elshorafa

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

Database باستخدام ال SQL Queries. ، خلال المشروع ده، هتكون قادر تملي ال Database بالمعلومات و تعمل Tables جوا ال Database وهتكون قادر تستخدم ال SQL Aggregate Functionsعلي ال Tables.، وأخيرا ، هتقدر نكتب ال SQL Queries Using Conditions وهتكون قادر ت match ال strings باستخدام ال Wildcards.

Read more

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

Database باستخدام ال SQL Queries. ، خلال المشروع ده، هتكون قادر تملي ال Database بالمعلومات و تعمل Tables جوا ال Database وهتكون قادر تستخدم ال SQL Aggregate Functionsعلي ال Tables.، وأخيرا ، هتقدر نكتب ال SQL Queries Using Conditions وهتكون قادر ت match ال strings باستخدام ال Wildcards.

وهذا المشروع موجه للأشخاص المبتدئين المهتمين بالبدء في مجال ال Database و ال Backend Development وسيعزز هذا المشروع الموجه مهاراتكم في Database Design و كتابة ال Sql commands و بالتالي سيضعكم علي اول الطريق في مجال ال backend development و هو من اهم المجالات في ال Software Engineering . هنستخدم XAMPPو هي منصة open sourceوالتي تسمح للمستخدمين باستخدام MYSQL user interface و ال XAMPP يقدر يشتغل علي كل ال operating systems زي Windows,Linux,Macos

Enroll now

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until March 12, 2027
Save 40% Off 3 Months
Access thousands of top-rated learning programs with a Coursera Plus monthly subscription and take 40% off 3 months for a limited time.
Take
40%
off
Get offer

What's inside

Syllabus

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
هتتعلم أساسيات ال SQL و هتقدر تبني Database من خلال ال SQL Queries
يوضح لك مدى أهمية الDatabase في الBackend development
بيقدم ليك فرصة تبني مشروع حقيقي في مجال الـ Database Design
بيستخدم منصة XAMPP، وهي منصة مجانية وسهلة الاستخدام
موجه للمبتدئين في مجال الـDatabase و الBackend development

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

مبادئ sql للمبتدئين والتطوير الخلفي

وفقًا للمتعلمين، يقدم هذا المشروع الموجه مقدمة ممتازة وواضحة لمبادئ SQL Syntax، وهو مثالي تمامًا للمبتدئين في مجال قواعد البيانات والتطوير الخلفي. يبرز الطلاب الشرح المبسّط والمباشر، مما يجعل المفاهيم المعقدة سهلة الفهم. تُعد الأمثلة العملية واستخدام منصة XAMPP من نقاط القوة البارزة، حيث تتيح للمتعلمين تطبيق ما تعلموه يدويًا. بينما يوفر المساق أساسًا قويًا، يشير بعض المراجعين إلى أنهم كانوا يتمنون تعمقًا أكبر في الموضوعات المتقدمة أو المزيد من التمارين الواقعية. ومع ذلك، يعتبرونه بشكل عام مسارًا تأسيسيًا قيمًا للانطلاق في مسيرتهم المهنية.
الوتيرة مناسبة للمبتدئين، وقد تكون بطيئة لبعضهم.
"شرح واضح ومريح وسرعة مناسبة للمبتدئين تمامًا."
"أحيانًا كنت أجد سرعة الشرح بطيئة، وكنت أتمنى لو كانت هناك تحديات أكبر."
"الوتيرة مثالية بالنسبة لي كشخص ليس لديه أي خلفية سابقة في قواعد البيانات."
تركز على التطبيق العملي باستخدام XAMPP لتعزيز المهارات.
"الأمثلة العملية باستخدام XAMPP ساعدتني كثيرًا على تطبيق المفاهيم."
"المحاضرات قصيرة ومفيدة وتطبيقية، تعززت مهاراتي في كتابة أوامر SQL."
"ساعدتني التمارين العملية على فهم كيفية بناء قاعدة بيانات وتعبئتها."
شرح ممتاز ومباشر لأساسيات SQL، مثالي للمبتدئين.
"هذه الدورة ممتازة للمبتدئين الذين يرغبون في فهم أساسيات SQL. الشرح واضح ومباشر..."
"شرح الأستاذ رائع وواضح... من أفضل الدورات لتعلم SQL للمبتدئين."
"المحتوى منظم بشكل جيد ومناسب للمبتدئين تمامًا، تعلمت الكثير."
توفر أساسًا متينًا ولكنها لا تتعمق في الموضوعات المعقدة.
"أتمنى لو كان هناك المزيد من التمارين المتقدمة أو سيناريوهات حقيقية."
"الدورة مفيدة كأساس، لكنها لم تتعمق بما يكفي في بعض الجوانب."
"أشعر أنها جيدة كنقطة بداية، ولكن سأحتاج إلى مصادر إضافية لتعلم 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 تعليم مبادئ ال SQL Syntax with these activities:
Relational Database Concepts
Refresh your understanding of relational database concepts, including data models, normalization, and query optimization, to enhance your ability to design and manage effective databases.
Browse courses on Relational Database
Show steps
  • Review notes or textbooks on relational database theory.
  • Study examples of database normalization and optimization techniques.
  • Participate in online discussions or forums related to relational databases.
SQL Basics
Review the basics of SQL to strengthen your foundation before starting the course.
Browse courses on SQL Queries
Show steps
  • Review online tutorials or documentation on SQL syntax.
  • Practice writing simple SQL queries using an online SQL editor.
  • Create a small database and populate it with sample data.
XAMPP Installation and Configuration
Set up the XAMPP environment, including installing and configuring MySQL, to prepare for the hands-on database exercises in the course.
Browse courses on XAMPP
Show steps
  • Download and install XAMPP for your operating system.
  • Start the XAMPP control panel and configure MySQL.
  • Create a new database and user for the course exercises.
Eight other activities
Expand to see all activities and additional details
Show all 11 activities
Review SQL syntax
Reviewing the syntax and basic commands of SQL will help solidify understanding and make learning new concepts easier.
Browse courses on SQL Syntax
Show steps
  • Read through the online SQL tutorial
  • Practice writing basic SQL queries
  • Complete the SQL syntax quiz
Practice writing SQL queries
Writing SQL queries is a key skill in database management. This activity will help you practice writing queries and improve your proficiency.
Browse courses on SQL Queries
Show steps
  • Find a set of SQL practice exercises
  • Solve the exercises and check your answers against the provided solutions
  • Repeat until you feel comfortable writing SQL queries
Watch tutorials on SQL aggregate functions
Understanding how to use SQL aggregate functions will help you perform calculations and aggregations on your data.
Browse courses on SQL aggregate functions
Show steps
  • Search for tutorials on SQL aggregate functions
  • Watch the tutorials and take notes
  • Try out the examples provided in the tutorials
SQL Query Practice
Reinforce your understanding of SQL queries by practicing writing and executing various types of queries in the XAMPP environment.
Browse courses on SQL Queries
Show steps
  • Create a list of SQL queries covering different types of operations (e.g., data retrieval, filtering, aggregation).
  • Execute the queries against the database created in the previous activity.
  • Analyze the results and identify any errors or areas for improvement.
Practice using SQL aggregate functions
Practicing using SQL aggregate functions will help you master this skill and be able to use it effectively in your own projects.
Browse courses on SQL aggregate functions
Show steps
  • Find a set of SQL aggregate function exercises
  • Solve the exercises and check your answers against the provided solutions
  • Repeat until you feel comfortable using SQL aggregate functions
Practice writing SQL queries using conditions
Writing SQL queries using conditions is an essential skill for filtering and retrieving specific data from your database.
Browse courses on SQL Queries
Show steps
  • Find a set of SQL query exercises using conditions
  • Solve the exercises and check your answers against the provided solutions
  • Repeat until you feel comfortable writing SQL queries using conditions
Database Design Document
Develop a comprehensive database design document outlining the structure, relationships, and constraints for the database used in the course project.
Browse courses on Database Design
Show steps
  • Analyze the requirements and identify the entities and relationships involved.
  • Create an Entity-Relationship (ER) diagram to represent the database structure.
  • Translate the ER diagram into a SQL schema, including table definitions, constraints, and indexes.
  • Document the design decisions and assumptions made.
Course Project Database
Embark on a project where you design, implement, and populate a database based on the course concepts to solidify your skills and knowledge.
Browse courses on SQL Queries
Show steps
  • Define the scope and objectives of the project.
  • Gather requirements and create a database design document.
  • Create the database, tables, and constraints.
  • Populate the database with relevant data.
  • Write SQL queries to retrieve, manipulate, and analyze data from the database.

Career center

Learners who complete تعليم مبادئ ال SQL Syntax will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts leverage data, statistical modeling, and technology to uncover actionable insights that lead to informed decision-making. The 'Teach SQL Syntax' course provides a strong foundation in SQL, a fundamental tool for data analysts. By learning how to create and manage databases, extract and analyze data, and write SQL queries, individuals can gain practical experience and build a solid foundation for a successful career as a Data Analyst.
See salaries and explore the career path for Data Analyst
Database Administrator
Database Administrators are responsible for the design, implementation, and maintenance of database systems. The 'Teach SQL Syntax' course offers a comprehensive introduction to SQL, enabling individuals to gain hands-on experience in creating, managing, and querying databases. This knowledge is essential for aspiring Database Administrators, as it equips them with the skills to ensure the integrity, security, and performance of databases.
See salaries and explore the career path for Database Administrator
Data Engineer
Data Engineers design, build, and maintain data infrastructure that supports data-driven applications. The 'Teach SQL Syntax' course provides a solid foundation in SQL, a core technology for data engineers. By learning how to extract, transform, and load data, write SQL queries, and optimize database performance, individuals can develop the skills necessary to succeed in a Data Engineer role.
See salaries and explore the career path for Data Engineer
Business Intelligence Analyst
Business Intelligence Analysts use data to identify trends, uncover insights, and make recommendations that drive business decisions. The 'Teach SQL Syntax' course equips individuals with the SQL skills needed to extract and analyze data, enabling them to gain valuable insights and make data-informed recommendations. This course provides a strong foundation for a successful career as a Business Intelligence Analyst.
See salaries and explore the career path for Business Intelligence Analyst
SQL Developer
SQL Developers specialize in designing, developing, and implementing SQL-based database solutions. The 'Teach SQL Syntax' course provides a comprehensive introduction to SQL, enabling individuals to gain hands-on experience in creating, managing, and querying databases. This course is a valuable asset for aspiring SQL Developers, as it equips them with the skills to build and maintain high-performing database systems.
See salaries and explore the career path for SQL Developer
Software Engineer
Software Engineers design, develop, and maintain software systems. While the 'Teach SQL Syntax' course is not directly related to software engineering, it provides a valuable foundation in SQL, a core technology used in many software applications. By learning how to work with databases, write SQL queries, and optimize database performance, individuals can enhance their overall software engineering skills.
See salaries and explore the career path for Software Engineer
Data Scientist
Data Scientists use statistical modeling, machine learning, and other techniques to extract insights from data. While the 'Teach SQL Syntax' course does not cover data science in depth, it provides a foundational understanding of SQL, a key tool for data scientists. By learning how to extract and analyze data using SQL, individuals can gain valuable skills that complement their data science knowledge.
See salaries and explore the career path for Data Scientist
Web Developer
Web Developers design, develop, and maintain websites and web applications. While the 'Teach SQL Syntax' course focuses on SQL rather than web development, it provides a valuable foundation for web developers who need to work with databases. By learning how to create and manage databases, extract and analyze data, and write SQL queries, web developers can build more robust and data-driven web applications.
See salaries and explore the career path for Web Developer
IT Consultant
IT Consultants provide technology advice and solutions to businesses. While the 'Teach SQL Syntax' course does not directly cover IT consulting, it provides a valuable foundation in SQL, a core technology used in many business applications. By learning how to work with databases, write SQL queries, and optimize database performance, individuals can enhance their overall IT consulting skills.
See salaries and explore the career path for IT Consultant
Information Security Analyst
Information Security Analysts protect organizations from cyber threats. While the 'Teach SQL Syntax' course does not directly cover cybersecurity, it provides a foundational understanding of databases, which are often targeted by cyberattacks. By learning how to secure databases, write secure SQL queries, and monitor database activity, individuals can enhance their overall information security skills.
See salaries and explore the career path for Information Security Analyst
Product Manager
Product Managers are responsible for the development and launch of new products. While the 'Teach SQL Syntax' course does not directly cover product management, it provides a valuable foundation for product managers who need to work with data and databases. By learning how to extract and analyze data using SQL, product managers can gain valuable insights that inform product development and launch decisions.
See salaries and explore the career path for Product Manager
Technical Writer
Technical Writers create documentation and other materials that explain technical concepts. While the 'Teach SQL Syntax' course does not directly cover technical writing, it provides a valuable foundation for technical writers who need to write about databases and SQL. By learning how to work with databases, write SQL queries, and explain technical concepts, individuals can enhance their overall technical writing skills.
See salaries and explore the career path for Technical Writer
Project Manager
Project Managers plan, execute, and deliver projects. While the 'Teach SQL Syntax' course does not directly cover project management, it provides a valuable foundation for project managers who need to work with data and databases. By learning how to extract and analyze data using SQL, project managers can gain valuable insights that inform project planning, execution, and delivery.
See salaries and explore the career path for Project Manager
Data Architect
Data Architects design and manage the architecture of data systems. The 'Teach SQL Syntax' course may be useful for Data Architects, as it provides a foundational understanding of SQL, a core technology used in data systems. By learning how to work with databases, write SQL queries, and optimize database performance, individuals can gain valuable skills that complement their data architecture knowledge.
See salaries and explore the career path for Data Architect
Business Analyst
Business Analysts identify and analyze business needs and develop solutions to improve business processes. While the 'Teach SQL Syntax' course does not directly cover business analysis, it provides a valuable foundation for business analysts who need to work with data and databases. By learning how to extract and analyze data using SQL, business analysts can gain valuable insights that inform business decisions and improve business processes.
See salaries and explore the career path for Business Analyst

Reading list

We've selected 13 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in تعليم مبادئ ال SQL Syntax.
Cover image
Learning Snowflake SQL and Scripting
Save
Comprehensive guide to SQL. It covers all the major SQL concepts and provides numerous examples.
(English) Learning Snowflake SQL and Scripting: Generate,...
Paperback
$$
(English) Learning Snowflake SQL and Scripting
Kindle Edition
$$
Cover image
PostgreSQL 9.0 Official Documentation - Volume I....
Save
Comprehensive guide to PostgreSQL. It covers all the major PostgreSQL features and provides numerous examples.
PostgreSQL 9.0 Official Documentation - Volume I....
Paperback
Check
PostgreSQL 9.0 Official Documentation - Volume I....
Kindle Edition
Check
Cover image
MySQL Administrator's Guide and Language Reference
Save
Comprehensive guide to MySQL. It covers all the major MySQL features and provides numerous examples.
(English) MySQL Administrator's Guide and Language Reference...
Paperback
$$$
Cover image
Database Systems: The Complete Book
Save
Comprehensive guide to database systems. It covers all the major database concepts and provides numerous examples.
(English) Database Systems: The Complete Book
Kindle Edition
$$$
(English) Database Systems The Complete Book
Paperback
$$
(English) Database Systems: The Complete Book
Hardcover
$$$$
(English) Goal Student Access Code Card for Database Systems:...
Printed Access Code
$$
Cover image
IBM Spectrum Protect Plus Protecting Database...
Save
Comprehensive guide to IBM Db2. It covers all the major IBM Db2 features and provides numerous examples.
IBM Spectrum Protect Plus Protecting Database...
Paperback
Check
IBM Spectrum Protect Plus Protecting Database...
Kindle Edition
Check
Cover image
Inside Microsoft Dynamics AX 2012 R3
Save
Comprehensive guide to Microsoft SQL Server. It covers all the major Microsoft SQL Server features and provides numerous examples.
(English) Inside Microsoft Dynamics AX 2012 R3
Paperback
$$$
Cover image
Database Design for Mere Mortals
Save
Good starting point for learning SQL. It covers the basics of SQL, including data types, operators, and queries. It also provides some examples of how to use SQL to solve real-world problems.
Database Design for Mere Mortals
Paperback
Check
Database Design for Mere Mortals
Kindle Edition
Check
Cover image
SQL in a Nutshell
Save
Concise reference for SQL. It covers all the major SQL commands and provides examples of how to use them.
(English) SQL in a Nutshell
Kindle Edition
$$
Cover image
Head First SQL
Save
Fun and engaging way to learn SQL. It uses a unique visual approach to teach SQL concepts.
(English) Head First SQL: Your Brain on SQL -- A Learner's...
Paperback
$$
(English) Head First SQL 1st (first) edition Text Only
Unknown Binding
$$$
(Deutsch) SQL von Kopf bis Fuß (German Edition)
Kindle Edition
$$$
Cover image
SQL Performance Explained
Save
Deep dive into SQL performance. It covers all the major factors that affect SQL performance and provides tips on how to improve it.
(English) SQL Performance Explained Everything Developers...
Paperback
$$
Cover image
SQL Essentials For Dummies
Save
Good option for beginners who want to learn SQL. It covers the basics of SQL in a clear and concise manner.
SQL Essentials For Dummies
Paperback
Check
SQL Essentials For Dummies
Kindle Edition
Check
Cover image
SQL Injection Attacks and Defense
Save
Guide to SQL injection attacks and how to defend against them.
(English) SQL Injection Attacks and Defense
Paperback
$$$
(English) SQL Injection Attacks and Defense
Paperback
$$$
(English) SQL Injection Attacks and Defense
Kindle Edition
$$
(English) SQL Injection Attacks and Defense
Kindle Edition
$$
Cover image
SQL Antipatterns, Volume 1
Save
Collection of common SQL mistakes and how to avoid them.
(English) SQL Antipatterns, Volume 1: Avoiding the Pitfalls...
Paperback
$$
(English) SQL Antipatterns, Volume 1
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to تعليم مبادئ ال SQL Syntax.
Working with MySQL DB instance using AWS RDS
Most relevant
Join Tables in an SQL Query in LibreOffice Base
Most relevant
Introduction to SQL Window Functions
Most relevant
How to Use SQL with Large Datasets
Most relevant
Advanced Relational Database and SQL
Most relevant
Creating New BigQuery Datasets and Visualizing Insights
Most relevant
Working with Subqueries in SQL
Most relevant
Exploring ​and ​Preparing ​your ​Data with BigQuery
Most relevant
SQL Joins
Most relevant

Coursera Buyer Protection & Guarantee

Verified partner policies & purchase protections

Accredited University Partner
Free Trial & Audit

7-Day Free Trial & Free Audit

7-day free trial on monthly Coursera Plus subscriptions; free audit option available on most individual courses to explore video lectures and readings at no charge.

Return & Refund Policy

14-Day Refund Guarantee

14-day refund window on annual Coursera Plus subscriptions and single-course purchases prior to certificate issuance. Monthly subscriptions do not offer refunds once billed.

Buyer Protections

Verified Academic & Industry Partner

Accredited university and industry certifications (e.g. Stanford, Google, IBM, Yale), secure SSL payment processing, and verifiable digital certificate links.

Key Purchase Protections
14-day refund window on annual Coursera Plus and single courses
7-day free trial on monthly Coursera Plus subscriptions
Free course audit option for lectures and readings
Verified certificates from top universities & companies
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Effort
1 hour
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
ahmed elshorafa
Language
العربية
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
هتتعلم أساسيات ال SQL و هتقدر تبني Database من خلال ال SQL Queries
يوضح لك مدى أهمية الDatabase في الBackend development
بيقدم ليك فرصة تبني مشروع حقيقي في مجال الـ Database Design
بيستخدم منصة XAMPP، وهي منصة مجانية وسهلة الاستخدام
موجه للمبتدئين في مجال الـDatabase و الBackend development
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to تعليم مبادئ ال SQL Syntax.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser