We may earn an affiliate commission when you visit our partners.
Course image
Yasmine Elfares

في نهاية هذا المشروع ، سوف تكون قادرًا على تطبيق "SQL Basic Syntax" لإنشاء database tables. بصفتك مبرمج databases مبتدئ ، ستتمكن من إنشاء files SQL وإنشاء databases وأخيراً إنشاء tables لتمثيل علاقات database.

من خلال هذا المشروع ، سننشئ قاعدة بيانات كاملة لشركة 'Nike' بما في ذلك موظفيها.

سيساعدك فهم قواعد البيانات على التقدم في العمل لأن قواعد البيانات ضرورية لأي منظمة لأنها تعمل على توصيل المعلومات بسهولة وكفاءة.

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.

What's inside

Syllabus

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
This course allows you to apply SQL to create database tables and store employees' data, which is useful in many organizations for tracking personnel data
Beginners in database programming will gain a solid foundation in SQL syntax and database concepts, enabling them to delve deeper into database management

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 بمثابة نقطة انطلاق ممتازة للمبتدئين في مجال قواعد البيانات. يبرز الطلاب الشرح الواضح والمباشر، والتطبيق العملي من خلال المشروع العملي الذي يسمح بإنشاء قاعدة بيانات حقيقية. كما أشاد العديد بـالمحتوى المنظم جيدًا وفعالية المحاضر في توصيل المعلومات، مما يعزز الثقة في التعامل مع البيانات. بينما يرى بعض المتعلمين أنها أساسية جدًا لمن لديهم معرفة مسبقة، وأنها قد تستفيد من تمارين إضافية أو تعميق في مواضيع أكثر تقدمًا، إلا أنها تبقى موصى بها بشدة كمدخل قوي ومفيد.
المحاضر يقدم المفاهيم المعقدة بطريقة سهلة ومباشرة.
"الشرح كان بسيطًا ومباشرًا والأمثلة عملية جدًا."
"محتوى رائع ومنظم بشكل جيد. Instructor كان ممتازًا في توصيل المعلومة."
"لقد كانت الخطوات مشروحة بوضوح تام، مما جعل المتابعة سهلة وفعالة."
يركز الكورس على التطبيق العملي من خلال مشروع حقيقي.
"الكورس مفيد جداً وخصوصاً الجزء العملي. استطعت تطبيق ما تعلمته مباشرة."
"هذا المشروع العملي رائع! تمكنت من إنشاء قاعدة بيانات كاملة لشركة نايكي كما هو موضح."
"التعلم الممتع والمفيد أتى من التطبيق العملي، فقد ساعدني المشروع على فهم الأساسيات."
نقطة انطلاق قوية لتعلم أساسيات 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 with these activities:
مراجعة المفاهيم الأساسية في برمجة قواعد البيانات
سيساعدك هذا النشاط على تحديث معرفتك بالمفاهيم الأساسية في برمجة قواعد البيانات.
Browse courses on SQL
Show steps
  • مراجعة المحاضرات والملاحظات من الدورات السابقة حول برمجة قواعد البيانات
  • إعادة قراءة الكتب والمقالات حول برمجة قواعد البيانات
  • حل مشكلات الممارسة المتعلقة ببرمجة قواعد البيانات
Study SQL basics
Review the basics of SQL to strengthen your foundation and prepare for the course materials.
Browse courses on SQL
Show steps
  • Review online tutorials or documentation on SQL syntax and commands.
  • Practice writing basic SQL queries to create, insert, update, and delete data from a database.
تجميع موارد حول SQL
سيساعدك هذا النشاط في العثور على الموارد التي يمكن أن تساعدك في تعلم SQL.
Show steps
  • البحث عن دورات SQL عبر الإنترنت
  • البحث عن كتب SQL
  • البحث عن منتديات ومجموعات SQL عبر الإنترنت
  • إنشاء قائمة بالموارد التي تجدها
15 other activities
Expand to see all activities and additional details
Show all 18 activities
Follow a tutorial on database normalization
Expand your understanding of database design and data integrity by following a tutorial on database normalization.
Browse courses on Database Design
Show steps
  • Search for a tutorial on database normalization.
  • Follow the tutorial step-by-step.
  • Take notes on the key concepts and techniques.
متابعة دورة تدريبية عبر الإنترنت حول SQL
ستساعدك هذه الدورة التدريبية على تعلم أساسيات SQL.
Show steps
  • التسجيل في دورة SQL عبر الإنترنت
  • متابعة الدروس وممارسة التمارين
  • إكمال الاختبارات والواجبات
  • الحصول على شهادة إتمام
Solve SQL exercises
Engage in practice exercises to refine your SQL skills and reinforce concepts covered in the course.
Browse courses on SQL
Show steps
  • Find online platforms or resources that offer interactive SQL exercises.
  • Solve a variety of exercises covering different SQL topics, such as data manipulation, aggregation, and joins.
  • Review your answers and identify areas for improvement.
Create a database table using SQL
Reinforce your understanding of SQL syntax and database table creation by practicing creating a database table.
Browse courses on SQL Syntax
Show steps
  • Review the SQL syntax for creating a table.
  • Identify the columns and data types for your table.
  • Write the SQL statement to create the table.
  • Execute the SQL statement to create the table.
ممارسة كتابة استعلامات SQL
ستساعدك هذه التمارين على تحسين مهاراتك في كتابة استعلامات SQL.
Show steps
  • إيجاد جميع العملاء الذين لديهم رصيد أكبر من 100 دولار
  • إيجاد جميع المنتجات التي تم بيعها بأكثر من 10 وحدات
  • إيجاد جميع الموظفين الذين عملوا لأكثر من عامين
مشاركة الملاحظات مع زميل
يمكن أن يساعدك هذا النشاط في فهم المفاهيم بشكل أفضل من خلال مناقشتها مع شخص آخر.
Show steps
  • العثور على زميل في الفصل للدراسة معه
  • مشاركة الملاحظات مع بعضكما البعض
  • مناقشة المفاهيم التي تجدون صعوبة في فهمها
  • مساعدة بعضكما البعض على حل المشكلات
Insert data into a database table using SQL
Solidify your understanding of SQL syntax and data manipulation by practicing inserting data into a database table.
Browse courses on SQL Syntax
Show steps
  • Review the SQL syntax for inserting data.
  • Prepare the data you want to insert into the table.
  • Write the SQL statement to insert the data.
  • Execute the SQL statement to insert the data.
Follow SQL tutorials
Seek out guided tutorials to supplement your understanding of SQL concepts and techniques.
Browse courses on SQL
Show steps
  • Identify reputable online courses or tutorials that align with your learning objectives.
  • Follow the tutorials step-by-step, taking notes and practicing the concepts as you progress.
Query data from a database table using SQL
Sharpen your SQL syntax and data retrieval skills by practicing querying data from a database table.
Browse courses on SQL Syntax
Show steps
  • Review the SQL syntax for querying data.
  • Identify the columns and rows you want to retrieve.
  • Write the SQL statement to query the data.
  • Execute the SQL statement to query the data.
Compile SQL resources
Gather and organize a collection of valuable SQL resources to support your learning journey.
Browse courses on SQL
Show steps
  • Identify and bookmark useful online tutorials, documentation, and references related to SQL.
  • Categorize and organize the resources based on topics, difficulty levels, or other relevant criteria.
  • Share your compilation with classmates or fellow learners to foster collaboration and knowledge sharing.
إنشاء قاعدة بيانات SQLite باستخدام SQL
يمكن أن يساعدك هذا النشاط في فهم كيفية إنشاء قواعد بيانات SQLite وتنفيذها باستخدام SQL.
Show steps
  • تثبيت SQLite على جهاز الكمبيوتر الخاص بك
  • إنشاء قاعدة بيانات SQLite جديدة
  • إنشاء جدول في قاعدة البيانات
  • إضافة بيانات إلى الجدول
  • استعلام البيانات من الجدول
مساعدة زميل آخر في تعلم SQL
يمكن أن يساعدك هذا النشاط في تعزيز فهمك لمفاهيم SQL من خلال شرحها للآخرين.
Show steps
  • العثور على زميل يكافح في SQL
  • مساعدته على فهم المفاهيم
  • الإجابة على أسئلته
  • مساعدته على حل المشكلات
Create an ER diagram for a simple database
Apply your understanding of database design and modeling by creating an ER diagram for a simplified database.
Browse courses on Database Design
Show steps
  • Identify the entities and relationships in the database.
  • Draw the ER diagram using appropriate notation.
  • Label the entities and relationships with appropriate attributes.
  • Review and refine your ER diagram.
Create a personal SQL project
Design and implement a personal SQL project to apply your skills and deepen your understanding.
Browse courses on SQL
Show steps
  • Identify a real-world problem or scenario that can be addressed using SQL.
  • Design the database schema and create the necessary tables.
  • Populate the database with relevant data and implement SQL queries to retrieve and analyze the data.
  • Present your project outcomes, highlighting the SQL techniques and concepts you employed.
Contribute to open-source SQL projects
Engage with the open-source community by contributing to SQL-related projects to enhance your skills.
Browse courses on SQL
Show steps
  • Identify open-source SQL projects that align with your interests and skill level.
  • Review the project documentation and contribute bug fixes, feature enhancements, or documentation improvements.
  • Interact with the project maintainers and engage in discussions to deepen your understanding.

Career center

Learners who complete إنشاء جداول قاعدة البيانات باستخدام SQL will develop knowledge and skills that may be useful to these careers:
Data Engineer
A Data Engineer is responsible for designing, building, and maintaining data pipelines. They work with stakeholders to gather requirements, design and implement data pipelines, and test and debug code. This course provides a strong foundation in SQL, which is the language used to store and retrieve data in databases. By taking this course, you will gain the skills necessary to succeed as a Data Engineer by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
Database Developer
A Database Developer is responsible for designing and developing database systems. They work with stakeholders to gather requirements, design and implement database schemas, and test and debug code. This course provides a strong foundation in SQL, which is the language used to create and manage databases. By taking this course, you will gain the skills necessary to succeed as a Database Developer by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
Data Architect
A Data Architect is responsible for designing and managing the data architecture of an organization. They work with stakeholders to gather requirements, design and implement data models, and develop data management strategies. This course provides a strong foundation in SQL, which is the language used to create and manage databases. By taking this course, you will gain the skills necessary to succeed as a Data Architect by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
Data Analyst
A Data Analyst is responsible for collecting, cleaning, and analyzing data to identify trends and patterns. They use this information to make recommendations to businesses on how to improve their operations. This course provides a strong foundation in SQL, which is the language used to extract and analyze data from databases. By taking this course, you will gain the skills necessary to succeed as a Data Analyst by learning how to query databases, create reports, and visualize data.
Data Scientist
A Data Scientist is responsible for developing and implementing data science models to solve business problems. They use a variety of tools and techniques to extract insights from data, including SQL. This course provides a strong foundation in SQL, which is the language used to query and manipulate data in databases. By taking this course, you will gain the skills necessary to succeed as a Data Scientist by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
Business Intelligence Analyst
A Business Intelligence Analyst is responsible for analyzing data to identify trends and patterns. They use this information to make recommendations to businesses on how to improve their operations. This course provides a strong foundation in SQL, which is the language used to extract and analyze data from databases. By taking this course, you will gain the skills necessary to succeed as a Business Intelligence Analyst by learning how to query databases, create reports, and visualize data.
Business Analyst
A Business Analyst is responsible for understanding the business needs of an organization and translating those needs into technical requirements. They work with stakeholders to gather requirements, analyze data, and develop solutions. This course provides a strong foundation in SQL, which is the language used to access and manipulate data in databases. By taking this course, you will gain the skills necessary to succeed as a Business Analyst by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
Database Administrator
A Database Administrator is responsible for the day-to-day management of databases. They ensure that databases are running smoothly, data is secure, and performance is optimized. This course provides a strong foundation in SQL, which is the language used to create and manage databases. By taking this course, you will gain the skills necessary to succeed as a Database Administrator by learning how to perform database administration tasks, such as creating and modifying tables, inserting and retrieving data, and managing user permissions.
Cloud Engineer
A Cloud Engineer is responsible for designing and managing cloud computing systems. They work with stakeholders to gather requirements, design and implement cloud solutions, and test and debug code. This course provides a strong foundation in SQL, which is the language used to store and retrieve data in databases. By taking this course, you will gain the skills necessary to succeed as a Cloud Engineer by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
DevOps Engineer
A DevOps Engineer is responsible for bridging the gap between development and operations teams. They work with both teams to ensure that software is developed and deployed quickly and efficiently. This course provides a strong foundation in SQL, which is the language used to store and retrieve data in databases. By taking this course, you will gain the skills necessary to succeed as a DevOps Engineer by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
Information Security Analyst
An Information Security Analyst is responsible for protecting an organization's information systems from unauthorized access, use, disclosure, disruption, modification, or destruction. They use a variety of tools and techniques to identify and mitigate security risks, including SQL. This course provides a strong foundation in SQL, which is the language used to access and manipulate data in databases. By taking this course, you will gain the skills necessary to succeed as an Information Security Analyst by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
Software Engineer
A Software Engineer is responsible for designing, developing, and maintaining software applications. They work with stakeholders to gather requirements, design and implement solutions, and test and debug code. This course provides a strong foundation in SQL, which is the language used to store and retrieve data in databases. By taking this course, you will gain the skills necessary to succeed as a Software Engineer by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
Product Manager
A Product Manager is responsible for the development and management of a product. They work with stakeholders to gather requirements, define product vision, and prioritize features. This course provides a strong foundation in SQL, which is the language used to access and manipulate data in databases. By taking this course, you will gain the skills necessary to succeed as a Product Manager by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.
Project Manager
A Project Manager is responsible for planning, executing, and closing projects. They work with stakeholders to define project goals, develop project plans, and track progress. This course provides a strong foundation in SQL, which is the language used to store and retrieve data in databases. By taking this course, you will gain the skills necessary to succeed as a Project Manager by learning how to create and modify database tables, insert and retrieve data, and manage user permissions.

Reading list

We've selected nine 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.
Highlights common pitfalls and anti-patterns in SQL programming, helping learners avoid errors and write efficient and maintainable code. It valuable resource for those who want to improve their SQL skills and best practices.
Offers a unique perspective on SQL, focusing on the art and craft of writing efficient and elegant queries. It provides valuable insights for those seeking to improve their SQL skills and develop a deeper understanding of the language.
Serves as a comprehensive reference for database systems, covering advanced topics such as database design, query optimization, and data mining. While it may not be essential for this course, it provides a valuable resource for those seeking a deeper understanding of the subject.
Offers a quick and accessible introduction to SQL, making it a useful resource for those who need a concise overview of the language. It can serve as a starting point for beginners or a refresher for those already familiar with SQL.
Provides a collection of recipes and solutions for common MySQL tasks. While it is specifically tailored for MySQL, it offers valuable insights and techniques that can be applied to other SQL databases as well.
Offers a comprehensive guide to PostgreSQL, another popular open-source SQL database. While not directly related to the course's focus on creating database tables, it provides valuable insights for those interested in exploring alternative SQL databases.
Focuses on SQL injection attacks and defense mechanisms, providing valuable insights for those concerned with database security. It useful resource for understanding the risks associated with SQL injection and developing strategies to mitigate them.
Provides an overview of NoSQL databases, which are becoming increasingly popular for handling large and complex data sets. While not directly related to the course's focus on SQL, it offers valuable insights into alternative database technologies.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
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