We may earn an affiliate commission when you visit our partners.
Course image
Course image
Coursera logo

إنشاء جداول قاعدة البيانات باستخدام SQL

Yasmine Elfares

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

Read more

في نهاية هذا المشروع ، سوف تكون قادرًا على تطبيق "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

Coming soon We're preparing activities for إنشاء جداول قاعدة البيانات باستخدام SQL. These are activities you can do either before, during, or after a course.

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