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

MYSQL Workbench إنشاء و تصميم قواعد البيانات باستخدام

Omnya Khaled

فى نهاية هذا المشروع ، سوف تكون قادرًا على تحديد وفهم أساسيات workbench MYSQL وإنشاء اتصال بالسيرفر المحلي. ستتعلم أيضًا كيفية إنشاء قاعدة بيانات جديدة ومسحها وإنشاء جداول جديدة وحذفها. علاوة على ذلك ، ستتمكن من إعادة تسمية أعمدة الجدول ، وربط الجداول ببعضها البعض وإضافة البيانات إلى الجداول. وأخيرًا ستتعلم كيفية إضافة أعمدة وتطبيق بعض الميزات بشكل احترافي على هذه الأعمدة باستخدام بعض الكلمات الرئيسية مثل PRIMARY KEY و FOREIGN KEY و NOT NULL و AUTO_INCREMENT و DISTINCT وتحديث الجداول ببيانات جديدة. يتم استخدام SQL من قبل جميع الأسماء الكبيرة في مجال التكنولوجيا مثل Netflix أو Airbnb. إذا كنت تستهدف Google أو Facebook أو Amazon ، فإن لديهم بالطبع أنظمة قواعد البيانات الخاصة بهم. لكن SQL ستكون موجودة أيضًا للاستعلام عن البيانات وتحليلها.

Read more

فى نهاية هذا المشروع ، سوف تكون قادرًا على تحديد وفهم أساسيات workbench MYSQL وإنشاء اتصال بالسيرفر المحلي. ستتعلم أيضًا كيفية إنشاء قاعدة بيانات جديدة ومسحها وإنشاء جداول جديدة وحذفها. علاوة على ذلك ، ستتمكن من إعادة تسمية أعمدة الجدول ، وربط الجداول ببعضها البعض وإضافة البيانات إلى الجداول. وأخيرًا ستتعلم كيفية إضافة أعمدة وتطبيق بعض الميزات بشكل احترافي على هذه الأعمدة باستخدام بعض الكلمات الرئيسية مثل PRIMARY KEY و FOREIGN KEY و NOT NULL و AUTO_INCREMENT و DISTINCT وتحديث الجداول ببيانات جديدة. يتم استخدام SQL من قبل جميع الأسماء الكبيرة في مجال التكنولوجيا مثل Netflix أو Airbnb. إذا كنت تستهدف Google أو Facebook أو Amazon ، فإن لديهم بالطبع أنظمة قواعد البيانات الخاصة بهم. لكن SQL ستكون موجودة أيضًا للاستعلام عن البيانات وتحليلها.

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

Enroll now

What's inside

Syllabus

ملخص المشروع
فى نهاية هذا المشروع ، سوف تكون قادرًا على تحديد وفهم أساسيات workbench MYSQL وإنشاء اتصال بالسيرفر المحلي. ستتعلم أيضًا كيفية إنشاء قاعدة بيانات جديدة ومسحها وإنشاء جداول جديدة وحذفها. علاوة على ذلك ، ستتمكن من إعادة تسمية أعمدة الجدول ، وربط الجداول ببعضها البعض وإضافة البيانات إلى الجداول. وأخيرًا ستتعلم كيفية إضافة أعمدة وتطبيق بعض الميزات بشكل احترافي على هذه الأعمدة باستخدام بعض الكلمات الرئيسية مثل PRIMARY KEY و FOREIGN KEY و NOT NULL و AUTO_INCREMENT و DISTINCT وتحديث الجداول ببيانات جديدة. يتم استخدام SQL من قبل جميع الأسماء الكبيرة في مجال التكنولوجيا مثل Netflix أو Airbnb. إذا كنت تستهدف Google أو Facebook أو Amazon ، فإن لديهم بالطبع أنظمة قواعد البيانات الخاصة بهم. لكن SQL ستكون موجودة أيضًا للاستعلام عن البيانات وتحليلها.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Teaches the basics of workbench MYSQL, enabling learners to create, manage, and update databases
Builds a strong foundation for beginners in data design and databases, providing the first steps in database design
Covers core skills for data engineers and database administrators, making it relevant to industry
Uses SQL, which is prevalent in tech giants like Netflix and Airbnb, making it highly relevant
Requires no prerequisites, making it accessible to learners new to data design and databases

Save this course

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

Activities

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

Career center

Learners who complete MYSQL Workbench إنشاء و تصميم قواعد البيانات باستخدام will develop knowledge and skills that may be useful to these careers:
Database Administrator
A Database Administrator manages the organization's database management systems (DBMS). This includes installing, configuring, and maintaining the DBMS software and hardware. The Database Administrator also ensures that the database is running efficiently and that the data is backed up and secure. This course can help you build a foundation for a career as a Database Administrator by teaching you the basics of MySQL Workbench, including how to create and manage databases, tables, and indexes.
Data Analyst
A Data Analyst collects, analyzes, and interprets data to help organizations make informed decisions. Data Analysts use a variety of statistical and data mining techniques to identify trends and patterns in data. This course can help you build a foundation for a career as a Data Analyst by teaching you the basics of SQL, including how to query and manipulate data.
Data Scientist
A Data Scientist uses statistical and machine learning techniques to extract insights from data. Data Scientists work on a variety of projects, such as developing predictive models, identifying fraud, and optimizing marketing campaigns. This course can help you build a foundation for a career as a Data Scientist by teaching you the basics of SQL, including how to query and manipulate data.
Business Analyst
A Business Analyst helps organizations improve their business processes and systems. Business Analysts work with stakeholders to identify and analyze business needs, and then develop and implement solutions to meet those needs. This course can help you build a foundation for a career as a Business Analyst by teaching you the basics of SQL, including how to query and manipulate data.
Web Developer
A Web Developer designs, develops, and maintains websites and web applications. Web Developers work on a variety of projects, such as creating new websites, updating existing websites, and integrating websites with other systems. This course can help you build a foundation for a career as a Web Developer by teaching you the basics of SQL, including how to query and manipulate data.
Software Engineer
A Software Engineer designs, develops, and tests software applications. Software Engineers work on a variety of projects, such as developing new software products, maintaining existing software systems, and integrating software systems with other systems. This course can help you build a foundation for a career as a Software Engineer by teaching you the basics of SQL, including how to query and manipulate data.
Systems Analyst
A Systems Analyst analyzes and designs computer systems. Systems Analysts work with stakeholders to identify and analyze business needs, and then design and implement computer systems to meet those needs. This course can help you build a foundation for a career as a Systems Analyst by teaching you the basics of SQL, including how to query and manipulate data.
Computer Programmer
A Computer Programmer writes and tests code that implements software applications. Computer Programmers work on a variety of projects, such as developing new software products, maintaining existing software systems, and integrating software systems with other systems. This course can help you build a foundation for a career as a Computer Programmer by teaching you the basics of SQL, including how to query and manipulate data.
Information Systems Manager
An Information Systems Manager plans, implements, and manages information systems for organizations. Information Systems Managers work with stakeholders to identify and analyze business needs, and then plan, implement, and manage information systems to meet those needs. This course can help you build a foundation for a career as an Information Systems Manager by teaching you the basics of MySQL Workbench, including how to create and manage databases, tables, and indexes.
Database Designer
A Database Designer designs and implements database systems. Database Designers work with stakeholders to identify and analyze business needs, and then design and implement database systems to meet those needs. This course can help you build a foundation for a career as a Database Designer by teaching you the basics of MySQL Workbench, including how to create and manage databases, tables, and indexes.
Consultant
A Consultant provides advice and guidance to organizations on a variety of topics, such as business strategy, information technology, and human resources. Consultants work with clients to identify and analyze problems, and then develop and implement solutions to those problems. This course may help you build a foundation for a career as a Consultant by teaching you the basics of MySQL Workbench, including how to create and manage databases, tables, and indexes.
Project Manager
A Project Manager plans, implements, and manages projects. Project Managers work with stakeholders to identify and analyze project requirements, and then plan, implement, and manage projects to meet those requirements. This course may help you build a foundation for a career as a Project Manager by teaching you the basics of MySQL Workbench, including how to create and manage databases, tables, and indexes.
Technical Writer
A Technical Writer writes and edits technical documentation, such as user manuals, white papers, and training materials. Technical Writers work with subject matter experts to understand complex technical concepts, and then write and edit documentation that explains those concepts clearly and concisely. This course may help you build a foundation for a career as a Technical Writer by teaching you the basics of MySQL Workbench, including how to create and manage databases, tables, and indexes.
Teacher
A Teacher plans, implements, and manages educational experiences for students. Teachers work with students to help them learn and grow, and to develop their critical thinking skills. This course may help you build a foundation for a career as a Teacher by teaching you the basics of MySQL Workbench, including how to create and manage databases, tables, and indexes.
Data Entry Clerk
A Data Entry Clerk enters data into computer systems. Data Entry Clerks work with a variety of data sources, such as paper documents, spreadsheets, and databases. This course may help you build a foundation for a career as a Data Entry Clerk by teaching you the basics of MySQL Workbench, including how to create and manage databases, tables, and indexes.

Reading list

We've selected seven 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 MYSQL Workbench إنشاء و تصميم قواعد البيانات باستخدام.
This comprehensive textbook provides a thorough overview of database systems, covering a wide range of topics from data modeling to query optimization. It serves as an excellent reference for those seeking a deeper understanding of the subject.
This hands-on guide emphasizes the practical application of SQL in real-world scenarios. It provides numerous examples and exercises to help learners develop proficiency in writing and executing SQL queries.
Focuses on identifying and avoiding common pitfalls in SQL coding. It provides valuable insights into writing efficient, maintainable, and performant SQL queries.
This practical cookbook offers a collection of recipes and solutions for common MySQL tasks. It provides quick and efficient ways to solve specific problems related to MySQL database management.
This beginner-friendly book offers a step-by-step introduction to MySQL. It covers basic concepts, data types, and SQL commands, providing a solid foundation for further exploration of MySQL.

Share

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

Similar courses

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