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

What's inside

Syllabus

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

Good to know

Know what's good
, what to watch for
, 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

Save إنشاء جداول قاعدة البيانات باستخدام SQL to your list so you can find it easily later:
Save

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 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 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 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.
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.
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.
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.
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.
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.
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.
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

Here are nine courses similar to إنشاء جداول قاعدة البيانات باستخدام SQL.
تصميم قاعدة بيانات باستخدام ماي سيكويل
Most relevant
MySQL تكنولوجيا المعلومات مع
Most relevant
MYSQL Workbench إنشاء و تصميم قواعد البيانات باستخدام
Most relevant
Relational Databases - MySQL - قواعد البيانات العلائقية
Most relevant
كيفية استخدام ال SQL مع قواعد البيانات الكبيرة
Most relevant
هياكل قواعد البيانات وإدارتها باستخدام MySQL
Most relevant
معالجة البيانات من غير نظيفة إلى نظيفة
Most relevant
قواعد البيانات وSQL (لغة الاستعلام البنيوية) لعلم البيانات
Most relevant
معالجة البيانات وتحليل الأعمال باستخدام برنامج جدول...
Most relevant
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 - 2024 OpenCourser