We may earn an affiliate commission when you visit our partners.
Ali Amr Souidan
في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعلم كيفية تصميم قاعدة بيانات متكاملة بالكيانات و صفات الكيانات و العلاقات التي بين هذة الكيانات.
من خلال التصميم ستتعلم كيف تحدد الكيانات من الوصف.
من خلال التصميم ستتعلم كيف تحدد صفات الكيانات و العلاقات البينهم من الوصف.
ستتعلم ايضا كيف تنفذ التصميم باستخدام SQL Server Management Studio , ستتعلم ايضا كيف تدخل البيانات في قاعدة البيانات, و في الاخر ستتعلم كيف تحضر البيانات من قاعدة البيانات عن طريق SQL Queries.
Read more
في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعلم كيفية تصميم قاعدة بيانات متكاملة بالكيانات و صفات الكيانات و العلاقات التي بين هذة الكيانات.
من خلال التصميم ستتعلم كيف تحدد الكيانات من الوصف.
من خلال التصميم ستتعلم كيف تحدد صفات الكيانات و العلاقات البينهم من الوصف.
ستتعلم ايضا كيف تنفذ التصميم باستخدام SQL Server Management Studio , ستتعلم ايضا كيف تدخل البيانات في قاعدة البيانات, و في الاخر ستتعلم كيف تحضر البيانات من قاعدة البيانات عن طريق SQL Queries.
Read more
في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعلم كيفية تصميم قاعدة بيانات متكاملة بالكيانات و صفات الكيانات و العلاقات التي بين هذة الكيانات.
من خلال التصميم ستتعلم كيف تحدد الكيانات من الوصف.
من خلال التصميم ستتعلم كيف تحدد صفات الكيانات و العلاقات البينهم من الوصف.
ستتعلم ايضا كيف تنفذ التصميم باستخدام SQL Server Management Studio , ستتعلم ايضا كيف تدخل البيانات في قاعدة البيانات, و في الاخر ستتعلم كيف تحضر البيانات من قاعدة البيانات عن طريق SQL Queries.
ملاحظة: تعمل هذه الدورة التدريبية بشكل أفضل للمتعلمين المقيمين في منطقة أمريكا الشمالية. نعمل حاليًا على توفير نفس التجربة في مناطق أخرى.
Register for this course and see more details by visiting:
OpenCourser.com/course/p1soo3/tSmym
What's inside
Syllabus
ملخص المشروع
في نهاية المشروع هتقدر تعمل قاعدة بيانات او database لمنصة بيكون عليها شغل فنانين المنصة بتدي فرصة للفنانين انهم يعلنوا عن شغلهم.
تصميم قاعدة البيانات هي مهارة مطلوبة جدا في سوق العمل و الاحتياج للمهارة دي بيزيد بسبب انتشار مواضيع زي data science مثلا . المشروع ده المشروع دا هيخليك تخطوا على اول خطوات المجال
المشروع هوريكوا المفاهيم الرئيسية لتصميم قاعدة البيانات من المفاهيم دي الERD Entity Relationship Diagram و هو رسم للكيانات و العلاقات بينهم, فيه بردو querying و data insertion او وضع البيانات.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
مصمم لتدريس اساسيات اولية حول قاعدة البيانات, مثل مخطط ارتباط الكيانات Entity Relationship Diagram, الاستعلام, بالاضافة الي كيفية ادخال و استرجاع البيانات
مفيد في سوق العمل بسبب زيادة الطلب علي مهارات تصميم قواعد البيانات
يعتمد علي رسم مخطط ارتباط الكيانات, وهي تمثل الكيانات و العلاقات بينهم, مما يحسن جودة التصميم النهائي لقاعدة البيانات
يأتي مع محاضرات مرئية و نصية, بالإضافة الي أمثلة و تمارين تساعد علي فهم المفاهيم
يستخدم MS SQL Server كأداة تطبيق ولكنه لا يتطرق الي أدوات اخري
Save this course
Save تصميم قاعدة البيانات باستخدام SQL Server Management Studio to your list so you can find it easily later:
Save
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 Server Management Studio with these
activities:
Peer Code Review Sessions
Show steps
Collaborating with peers through code reviews will enhance your understanding of database design and implementation.
Browse courses on
Peer Review
Show steps
-
Form study groups with classmates.
-
Share your database design projects or SQL queries for peer feedback.
-
Provide constructive criticism and suggestions for improvement.
-
Incorporate feedback into your own work.
SQL Server Management Studio Tutorials
Show steps
These tutorials will strengthen your foundational skills in data manipulation and management within SQL Server Management Studio.
Browse courses on
SQL
Show steps
-
Begin with introductory tutorials on creating and managing databases.
-
Explore tutorials on data retrieval, modification, and deletion using SQL queries.
-
Follow tutorials on data analysis, aggregation, and filtering techniques.
-
Practice creating and modifying tables, views, and indexes.
-
Complete tutorials on database security and user management.
تابع خطوات تصميم
قاعدة بيانات باستخدام
SQL Server Management Studio
Show steps
ستساعدك هذه الخطوات على فهم المفاهيم الأساسية لتصميم قاعدة بيانات وستنمكنك من تطبيق هذه المفاهيم من الناحية العملية.
Browse courses on
SQL
Show steps
-
شاهد الفيديو التعليمي حول
تصميم قاعدة البيانات باستخدام SQL Server Management Studio
المقدم من Plural sight.
-
اتبع الخطوات الواردة في الفيديو لإنشاء قاعدة بيانات جديدة و جدول جديد وإضافة بيانات إلى الجدول.
-
استخدم استعلامات SQL الأساسية لاسترداد البيانات من الجدول.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Create a Diagram Collection
Show steps
This collection of database design diagrams will enhance your visual understanding of database structures and their components.
Show steps
-
Gather diagrams from online resources, textbooks, and tutorials.
-
Organize diagrams into categories such as data modeling techniques, schema design patterns, and database normalization.
-
Annotate diagrams with explanations of key concepts and relationships.
SQL Query Practice
Show steps
Repeated practice of SQL queries will enhance your proficiency in data retrieval, manipulation, and analysis.
Browse courses on
SQL
Show steps
-
Solve coding challenges on platforms like LeetCode or HackerRank.
-
Create your own practice exercises based on database scenarios.
-
Utilize online SQL query builders to test your understanding.
-
Contribute to open-source SQL projects on platforms like GitHub.
-
Participate in SQL coding competitions or hackathons.
Technical Documentation
Show steps
Creating technical documentation will strengthen your ability to communicate complex database concepts clearly and effectively.
Browse courses on
Technical Writing
Show steps
-
Identify the purpose and audience of your documentation.
-
Gather information and organize it logically.
-
Write clear and concise instructions, explanations, and diagrams.
-
Proofread and edit your documentation carefully.
-
Share your documentation with others for feedback and improvement.
Contribute to Open Source Database Projects
Show steps
Contributing to open-source database projects will expose you to real-world database challenges and best practices.
Browse courses on
Open Source
Show steps
-
Identify open-source database projects on GitHub or other platforms.
-
Read the documentation and familiarize yourself with the project's codebase.
-
Identify areas where you can contribute, such as bug fixes, feature enhancements, or documentation improvements.
-
Submit pull requests with your contributions and engage with the project maintainers.
-
Participate in online discussions and forums related to the project.
Peer Code Review Sessions
Show steps
Collaborating with peers through code reviews will enhance your understanding of database design and implementation.
Browse courses on
Peer Review
Show steps
Show steps
Show steps
- Form study groups with classmates.
- Share your database design projects or SQL queries for peer feedback.
- Provide constructive criticism and suggestions for improvement.
- Incorporate feedback into your own work.
SQL Server Management Studio Tutorials
Show steps
These tutorials will strengthen your foundational skills in data manipulation and management within SQL Server Management Studio.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Begin with introductory tutorials on creating and managing databases.
- Explore tutorials on data retrieval, modification, and deletion using SQL queries.
- Follow tutorials on data analysis, aggregation, and filtering techniques.
- Practice creating and modifying tables, views, and indexes.
- Complete tutorials on database security and user management.
تابع خطوات تصميم
قاعدة بيانات باستخدام
SQL Server Management Studio
Show steps
ستساعدك هذه الخطوات على فهم المفاهيم الأساسية لتصميم قاعدة بيانات وستنمكنك من تطبيق هذه المفاهيم من الناحية العملية.
Browse courses on
SQL
Show steps
Show steps
Show steps
- شاهد الفيديو التعليمي حول تصميم قاعدة البيانات باستخدام SQL Server Management Studio المقدم من Plural sight.
- اتبع الخطوات الواردة في الفيديو لإنشاء قاعدة بيانات جديدة و جدول جديد وإضافة بيانات إلى الجدول.
- استخدم استعلامات SQL الأساسية لاسترداد البيانات من الجدول.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Create a Diagram Collection
Show steps
This collection of database design diagrams will enhance your visual understanding of database structures and their components.
Show steps
Show steps
Show steps
- Gather diagrams from online resources, textbooks, and tutorials.
- Organize diagrams into categories such as data modeling techniques, schema design patterns, and database normalization.
- Annotate diagrams with explanations of key concepts and relationships.
SQL Query Practice
Show steps
Repeated practice of SQL queries will enhance your proficiency in data retrieval, manipulation, and analysis.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Solve coding challenges on platforms like LeetCode or HackerRank.
- Create your own practice exercises based on database scenarios.
- Utilize online SQL query builders to test your understanding.
- Contribute to open-source SQL projects on platforms like GitHub.
- Participate in SQL coding competitions or hackathons.
Technical Documentation
Show steps
Creating technical documentation will strengthen your ability to communicate complex database concepts clearly and effectively.
Browse courses on
Technical Writing
Show steps
Show steps
Show steps
- Identify the purpose and audience of your documentation.
- Gather information and organize it logically.
- Write clear and concise instructions, explanations, and diagrams.
- Proofread and edit your documentation carefully.
- Share your documentation with others for feedback and improvement.
Contribute to Open Source Database Projects
Show steps
Contributing to open-source database projects will expose you to real-world database challenges and best practices.
Browse courses on
Open Source
Show steps
Show steps
Show steps
- Identify open-source database projects on GitHub or other platforms.
- Read the documentation and familiarize yourself with the project's codebase.
- Identify areas where you can contribute, such as bug fixes, feature enhancements, or documentation improvements.
- Submit pull requests with your contributions and engage with the project maintainers.
- Participate in online discussions and forums related to the project.
Career center
Learners who complete تصميم قاعدة البيانات باستخدام SQL Server Management Studio will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
As a Database Administrator, you design, build, and maintain databases using SQL, which plays a key role in core database administration tasks like planning, developing, testing, and deploying data storage systems. This course provides a perfect stepping-stone for your career in database administration. It teaches the concepts of database design, including identifying and managing entities, attributes, and relationships. These concepts are crucial in database administration, as they provide the foundation for creating and managing databases that are both efficient and scalable. Additionally, the hands-on experience you gain in this course using SQL Server Management Studio will help you perform tasks such as inserting and extracting data from databases, which are critical skills for database administrators.
Data Analyst
Data Analyst
As a Data Analyst, you will have to design databases to manage and analyze large datasets, understanding SQL and the concepts of database design is fundamental to this role. This course teaches you how to design databases using the Entity Relationship Diagram (ERD) and how to implement them using SQL Server Management Studio. These skills are essential for data analysts as they provide a foundation for understanding how data is structured and stored in databases. The course also provides hands-on experience in querying data from databases, which is another key skill for data analysts.
Database Developer
Database Developer
As a Database Developer, you will be responsible for designing, developing, implementing, and maintaining databases. This course will give you a solid foundation in database design and SQL Server Management Studio, giving you a strong advantage for a career in this field.
Data Architect
Data Architect
As a Data Architect, you will be responsible for designing and managing the architecture of databases, requiring a deep understanding of database design principles and how to implement them using SQL. This course provides a solid foundation in these areas, teaching you how to create ERDs and implement them using SQL Server Management Studio.
Software Engineer
Software Engineer
As a Software Engineer, you may be required to work with databases, requiring you to have knowledge of database design principles and how to implement them in code. This course provides a great foundation in these areas, teaching you the fundamentals of database design and demonstrating how to implement databases using SQL Server Management Studio. Whether you are working with relational databases or NoSQL databases, the knowledge gained from this course will be valuable.
Data Scientist
Data Scientist
As a Data Scientist, you may need to interact with databases to extract data for analysis and modeling. Understanding database design principles and being able to query databases using SQL is fundamental to this role. This course provides a solid foundation in these areas, teaching you the concepts of database design and providing hands-on experience in querying data from databases.
Business Analyst
Business Analyst
As a Business Analyst, you may need to work with databases to gather data for analysis and reporting. This course will teach you the basics of database design and SQL, providing you with the skills to understand the structure of a database, retrieve data, and generate reports.
IT Consultant
IT Consultant
As an IT Consultant, you may be required to work with clients who need help with database design and implementation. This course can provide you with additional expertise in these areas, allowing you to offer more comprehensive services to your clients.
Project Manager
Project Manager
As a Project Manager, you may need to work with teams who are responsible for designing and developing databases. This course can provide you with the foundational knowledge of database design principles and SQL, enabling you to better understand the work your team is doing and communicate with them more effectively.
Web Developer
Web Developer
As a Web Developer, you may need to interact with databases to store and retrieve data for your web applications. This course can provide you with the basic skills you need to understand database design and perform basic SQL queries.
Technical Writer
Technical Writer
As a Technical Writer, you may need to document database designs and SQL code. This course can provide you with the basic knowledge of database design and SQL syntax to enable you to write clear and accurate documentation.
Systems Analyst
Systems Analyst
As a Systems Analyst, you may need to work with databases to gather data for analysis and reporting. This course can provide you with the basic skills you need to understand the structure of a database and retrieve data using SQL.
Quality Assurance Analyst
Quality Assurance Analyst
As a Quality Assurance Analyst, you may need to test database applications. This course can provide you with the basic skills you need to understand the structure of a database and perform basic SQL queries, enabling you to test the functionality of database applications.
Network Administrator
Network Administrator
As a Network Administrator, you may need to interact with databases to troubleshoot network issues. This course can provide you with basic knowledge of database design and SQL syntax, enabling you to understand the structure of databases and retrieve data when needed.
Computer Support Specialist
Computer Support Specialist
As a Computer Support Specialist, you may need to assist users with database-related issues. This course can provide you with basic knowledge of database design and SQL syntax, allowing you to better understand user queries and provide support.
For more career information including salaries, visit:
OpenCourser.com/course/p1soo3/tSmym
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 Server Management Studio.
Save
Provides a comprehensive overview of the principles and practices of designing data-intensive applications, covering topics such as data modeling, storage, processing, and querying.
A classic text on entity-relationship modeling, which fundamental concept in database design.
A widely-read book on software development practices, including topics such as design, testing, and debugging.
A comprehensive introduction to data structures and algorithms, which are essential concepts for database design and implementation.
Save
A beginner-friendly guide to SQL, which is the language used to interact with databases.
A comprehensive textbook on database systems, covering topics such as data models, query processing, and transaction management.
A more advanced book on data-intensive application design, covering topics such as distributed systems, NoSQL databases, and data pipelines.
A collection of recipes for solving common SQL problems, covering topics such as data manipulation, query optimization, and data analysis.
Save
A comprehensive textbook on data mining, which field that uses data analysis techniques to extract valuable information from large datasets.
A practical guide to machine learning for data science, covering topics such as supervised learning, unsupervised learning, and model evaluation.
A comprehensive textbook on deep learning for natural language processing, covering topics such as text classification, machine translation, and question answering.
A classic textbook on reinforcement learning, which field that uses machine learning to learn how to make decisions in complex environments.
Save
A comprehensive textbook on generative adversarial networks, which are a type of deep learning model that can be used to generate new data.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/p1soo3/tSmym
Share
Similar courses
Here are nine courses similar to
تصميم قاعدة البيانات باستخدام SQL Server Management Studio.
تصميم قاعدة بيانات باستخدام ماي سيكويل
OpenCourser.com/course/m278n5/tSmym
تصميم قاعدة بيانات باستخدام ماي سيكويل
Most relevant
Relational Databases - MySQL - قواعد البيانات العلائقية
OpenCourser.com/course/p59jh5/relational
Relational Databases - MySQL - قواعد البيانات العلائقية
Most relevant
Python استخدام قواعد البيانات مع
OpenCourser.com/course/xxr6lh/python
Python استخدام قواعد البيانات مع
Most relevant
تعرَف على هياكل البيانات في بايثون من خلال التطبيق العملي
OpenCourser.com/course/e7nemw/t`raf
تعرَف على هياكل البيانات في بايثون من خلال التطبيق العملي
Most relevant
المشروع المتقدم لمهندس قاعدة البيانات
OpenCourser.com/course/aht08c/lmshrw`
المشروع المتقدم لمهندس قاعدة البيانات
Most relevant
نشر تطبيق ويب باستخدام Docker و Kubernetes
OpenCourser.com/course/ky4f8a/nshr
نشر تطبيق ويب باستخدام Docker و Kubernetes
Most relevant
من خلال التطبيق العملي GitHub و Git تعلّم أساسيات
OpenCourser.com/course/792uou/mn
من خلال التطبيق العملي GitHub و Git تعلّم أساسيات
Most relevant
ربط وحفظ المعلومات في تطبيق أندرويد باستخدام جافا وسيكويل
OpenCourser.com/course/wt1zyn/rbT
ربط وحفظ المعلومات في تطبيق أندرويد باستخدام جافا وسيكويل
Most relevant
برنامج شامل لإستخدام "باور بيفوت" عبر برنامج إكسل
OpenCourser.com/course/mtindr/brnmj
برنامج شامل لإستخدام "باور بيفوت" عبر برنامج إكسل
Most relevant
Effort
1.5 hours
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
Ali Amr Souidan
Language
العربية
Good to know
مصمم لتدريس اساسيات اولية حول قاعدة البيانات, مثل مخطط ارتباط الكيانات Entity Relationship Diagram, الاستعلام, بالاضافة الي كيفية ادخال و استرجاع البيانات
مفيد في سوق العمل بسبب زيادة الطلب علي مهارات تصميم قواعد البيانات
يعتمد علي رسم مخطط ارتباط الكيانات, وهي تمثل الكيانات و العلاقات بينهم, مما يحسن جودة التصميم النهائي لقاعدة البيانات
يأتي مع محاضرات مرئية و نصية, بالإضافة الي أمثلة و تمارين تساعد علي فهم المفاهيم
يستخدم MS SQL Server كأداة تطبيق ولكنه لا يتطرق الي أدوات اخري
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