We may earn an affiliate commission when you visit our partners.
Course image
Ali Amr Souidan

في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعلم كيفية تصميم قاعدة بيانات متكاملة بالكيانات و صفات الكيانات و العلاقات التي بين هذة الكيانات.

من خلال التصميم ستتعلم كيف تحدد الكيانات من الوصف.

Read more

في هذه الدورة التدريبية القائمة على المشروع والتي تستغرق ساعة واحدة، ستتعلم كيفية تصميم قاعدة بيانات متكاملة بالكيانات و صفات الكيانات و العلاقات التي بين هذة الكيانات.

من خلال التصميم ستتعلم كيف تحدد الكيانات من الوصف.

من خلال التصميم ستتعلم كيف تحدد صفات الكيانات و العلاقات البينهم من الوصف.

ستتعلم ايضا كيف تنفذ التصميم باستخدام SQL Server Management Studio , ستتعلم ايضا كيف تدخل البيانات في قاعدة البيانات, و في الاخر ستتعلم كيف تحضر البيانات من قاعدة البيانات عن طريق SQL Queries.

ملاحظة: تعمل هذه الدورة التدريبية بشكل أفضل للمتعلمين المقيمين في منطقة أمريكا الشمالية. نعمل حاليًا على توفير نفس التجربة في مناطق أخرى.

Enroll now

What's inside

Syllabus

ملخص المشروع
في نهاية المشروع هتقدر تعمل قاعدة بيانات او database لمنصة بيكون عليها شغل فنانين المنصة بتدي فرصة للفنانين انهم يعلنوا عن شغلهم. تصميم قاعدة البيانات هي مهارة مطلوبة جدا في سوق العمل و الاحتياج للمهارة دي بيزيد بسبب انتشار مواضيع زي data science مثلا . المشروع ده المشروع دا هيخليك تخطوا على اول خطوات المجال المشروع هوريكوا المفاهيم الرئيسية لتصميم قاعدة البيانات من المفاهيم دي الERD Entity Relationship Diagram و هو رسم للكيانات و العلاقات بينهم, فيه بردو querying و data insertion او وضع البيانات.

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

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
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
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
ستساعدك هذه الخطوات على فهم المفاهيم الأساسية لتصميم قاعدة بيانات وستنمكنك من تطبيق هذه المفاهيم من الناحية العملية.
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
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
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
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
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.

Career center

Learners who complete تصميم قاعدة البيانات باستخدام SQL Server Management Studio will develop knowledge and skills that may be useful to these careers:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.

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.
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 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.
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.
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.
A comprehensive textbook on generative adversarial networks, which are a type of deep learning model that can be used to generate new data.

Share

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

Similar courses

Here are nine courses similar to تصميم قاعدة البيانات باستخدام SQL Server Management Studio.
تصميم قاعدة بيانات باستخدام ماي سيكويل
Most relevant
Relational Databases - MySQL - قواعد البيانات العلائقية
Most relevant
Python استخدام قواعد البيانات مع
Most relevant
تعرَف على هياكل البيانات في بايثون من خلال التطبيق العملي
Most relevant
المشروع المتقدم لمهندس قاعدة البيانات
Most relevant
نشر تطبيق ويب باستخدام Docker و Kubernetes
Most relevant
من خلال التطبيق العملي GitHub و Git تعلّم أساسيات
Most relevant
ربط وحفظ المعلومات في تطبيق أندرويد باستخدام جافا وسيكويل
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