We may earn an affiliate commission when you visit our partners.
Hima Vasudevan
and
Rav Ahuja
ي عالمنا اليوم، نرى كثيرًا من البيانات مسجَّلة في قواعد بيانات. تعد لغة SQL (لغة الاستعلام البنيوية) لغة قوية، تستخدم للتواصل مع قواعد البيانات واستخراج البيانات منها. ولا بد من المعرفة العملية بقواعد البيانات وبلغة SQL (لغة الاستعلام البنيوية) إذا كنت تريد...
Read more
ي عالمنا اليوم، نرى كثيرًا من البيانات مسجَّلة في قواعد بيانات. تعد لغة SQL (لغة الاستعلام البنيوية) لغة قوية، تستخدم للتواصل مع قواعد البيانات واستخراج البيانات منها. ولا بد من المعرفة العملية بقواعد البيانات وبلغة SQL (لغة الاستعلام البنيوية) إذا كنت تريد...
Read more
ي عالمنا اليوم، نرى كثيرًا من البيانات مسجَّلة في قواعد بيانات. تعد لغة SQL (لغة الاستعلام البنيوية) لغة قوية، تستخدم للتواصل مع قواعد البيانات واستخراج البيانات منها. ولا بد من المعرفة العملية بقواعد البيانات وبلغة SQL (لغة الاستعلام البنيوية) إذا كنت تريد أن تصبح عالمًا من علماء البيانات.
الغرض من هذه الدورة هو تقديم مفاهيم قواعد البيانات العلائقية ومساعدتك على تعلُّم المعرفة الأساسية بلغة SQL (لغة الاستعلام البنيوية) وتطبيق هذه المعارف عمليًا. الغرض من هذه الدورة أيضًا مساعدتك على الشروع في البدء باستخدام وصول SQL (لغة الاستعلام البنيوية) في بيئة علم البيانات.
ينصب تركيز هذه الدورة على التدريب الفعلي والتعلم العملي. وبالتالي، سوف تتعامل مع قواعد بيانات حقيقية وأدوات علوم بيانات حقيقية ومجموعات بيانات واقعية. ستقوم بإنشاء مثيل قاعدة بيانات في السحابة. من خلال سلسلة من التمرينات المعملية العملية، سوف تتدرب على إنشاء استعلامات SQL (لغة الاستعلام البنيوية) وتشغيلها. كما ستتعلم أيضًا الوصول إلى قواعد البيانات من دفاتر جوبيتر باستخدام SQL (لغة الاستعلام البنيوية) وبايثون.
لا تتطلب هذه الدورة معرفة مُسْبقة بقواعد البيانات أو بلغة SQL (لغة الاستعلام البنيوية) أو بايثون أو البرمجة.
؛ إذ يمكن لأي شخص تدقيق (مراجعة) هذه الدورة مجانًا. إذا اخترت الالتحاق بهذه الدورة والحصول على شهادة الدورة من Coursera، فيمكنك أيضًا الحصول على شارة رقمية من IBM عند إكمال الدورة بنجاح.
عرض لفترة محدودة: للتمكن من الوصول إلى المواد المُقيَّمة والحصول على شهادة، فإن قيمة الاشتراك الشهري هي 39 دولارًا أمريكيًا فقط.
Register for this course and see more details by visiting:
OpenCourser.com/course/qyt71s/qw`d
Two deals to help you save
We found two deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Designed for learners with no SQL or Python experience, making it a great entry-level course
Provides hands-on training with real-world data sets
Develops practical skills in accessing SQL databases from Jupyter Notebooks
Emphasizes practical applications in data science
Taught by reputable instructors with expertise in SQL and data science
Save this course
Save قواعد البيانات وSQL (لغة الاستعلام البنيوية) لعلم البيانات 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 (لغة الاستعلام البنيوية) لعلم البيانات with these
activities:
Review SQL fundamentals
Show steps
Reinforce understanding of SQL fundamentals to build a strong foundation.
Show steps
-
Read documentation or tutorials on SQL syntax and concepts.
-
Review examples and practice writing simple SQL queries.
-
Take online quizzes or tests to assess understanding.
-
Attend workshops or webinars on SQL fundamentals.
Review SQL basics
Show steps
A quick review of SQL basics will help refresh your memory and ensure you have a solid foundation before starting the course.
Browse courses on
SQL
Show steps
-
Review your notes or online resources on SQL syntax and concepts
-
Practice writing simple SQL queries
Organize course materials and notes
Show steps
Enhance learning by organizing and reviewing course materials.
Show steps
-
Review lecture slides, notes, and assignments.
-
Create summaries or mind maps to consolidate information.
-
Organize materials into folders or digital notebooks.
-
Highlight key concepts and mark areas for further study.
-
Review organized materials regularly.
11 other activities
Expand to see all activities and additional details
Show all 14 activities
Form a SQL study group
Show steps
Study groups provide opportunities to discuss concepts, ask questions, and collaborate with fellow learners, fostering improved understanding and retention of the course material.
Browse courses on
SQL
Show steps
-
Find other learners who are taking the same SQL course or who have similar interests
-
Establish regular meeting times and a study schedule
-
Take turns presenting concepts and leading discussions
-
Work on group projects or exercises
Follow tutorials on SQL data modeling
Show steps
Learn the principles of SQL data modeling to optimize database design.
Show steps
-
Identify the entities and relationships in a given business scenario.
-
Map the entities and relationships to tables and columns.
-
Create an ER diagram to visualize the data model.
-
Normalize the data model to reduce redundancy and improve data integrity.
-
Practice creating data models for different use cases.
Follow a SQL tutorial series
Show steps
Completing a series of guided SQL tutorials will provide practical exercises, guidance, and reinforcement of key concepts.
Browse courses on
SQL
Show steps
-
Identify a tutorial series that aligns with your learning goals
-
Follow the tutorial steps and instructions
-
Complete the exercises and assignments
Write sample SQL queries
Show steps
Practice writing SQL queries to gain familiarity with the syntax and structure.
Show steps
-
Create a database and table using SQL commands.
-
Insert data into the table using INSERT statements.
-
Write SELECT queries to retrieve specific data from the table.
-
Use WHERE clauses to filter the results of SELECT queries.
-
Practice using ORDER BY and GROUP BY clauses to sort and group data.
Engage in study groups or discussions with peers
Show steps
Collaborate with peers to exchange knowledge, clarify concepts, and provide support.
Show steps
-
Form study groups or join existing discussion forums.
-
Participate in discussions, ask questions, and share insights.
-
Review and discuss practice problems or assignments together.
-
Provide constructive feedback and support to other group members.
-
Reflect on discussions and identify areas for improvement.
Complete SQL coding challenges
Show steps
Solving coding challenges will improve your understanding of SQL syntax, enhance your problem-solving skills, and enable you to apply SQL in practical scenarios.
Browse courses on
SQL
Show steps
-
Identify an online platform or resource that provides SQL coding challenges
-
Start solving challenges and practice writing SQL queries
-
Review your solutions and identify areas for improvement
Build a small data analysis project using SQL
Show steps
Apply SQL skills to a practical project to solidify understanding and gain experience.
Show steps
-
Define the scope and objectives of the project.
-
Gather and import the necessary data into a database.
-
Write SQL queries to extract, transform, and analyze the data.
-
Create visualizations or reports to present the results.
-
Evaluate the results and identify areas for improvement.
Start a SQL blog
Show steps
Writing a blog about SQL concepts will help you solidify your understanding of SQL, learn how to communicate your knowledge, and encourage you to explore different topics within the field.
Browse courses on
SQL
Show steps
-
Decide on a topic and audience
-
Research and gather information
-
Write and edit your post
Write blog posts or articles about SQL best practices
Show steps
Share knowledge and reinforce understanding by writing about SQL best practices.
Show steps
-
Identify common pitfalls and challenges in using SQL.
-
Research and gather information on best practices for SQL coding.
-
Write clear and concise blog posts or articles that explain the best practices.
-
Share the content on relevant platforms or forums.
-
Monitor the feedback and engagement on the content.
Build a personal SQL project
Show steps
Working on a personal project will provide an opportunity to apply your SQL skills to a real-world problem, enhance your problem-solving skills, and showcase your abilities to potential employers.
Browse courses on
SQL
Show steps
-
Identify a problem or need that can be addressed using SQL
-
Design and plan your project, including the data sources and SQL queries you will use
-
Develop and implement your SQL solution
-
Test and evaluate your project
Mentor junior data analysts or SQL enthusiasts
Show steps
Share knowledge, provide guidance, and reinforce understanding by mentoring others.
Show steps
-
Identify opportunities to mentor junior data analysts or SQL enthusiasts.
-
Share knowledge and provide guidance on SQL concepts and best practices.
-
Review code and provide constructive feedback.
-
Encourage and support mentees in their learning journey.
-
Track progress and measure the impact of mentoring.
Review SQL fundamentals
Show steps
Reinforce understanding of SQL fundamentals to build a strong foundation.
Show steps
Show steps
Show steps
- Read documentation or tutorials on SQL syntax and concepts.
- Review examples and practice writing simple SQL queries.
- Take online quizzes or tests to assess understanding.
- Attend workshops or webinars on SQL fundamentals.
Review SQL basics
Show steps
A quick review of SQL basics will help refresh your memory and ensure you have a solid foundation before starting the course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review your notes or online resources on SQL syntax and concepts
- Practice writing simple SQL queries
Organize course materials and notes
Show steps
Enhance learning by organizing and reviewing course materials.
Show steps
Show steps
Show steps
- Review lecture slides, notes, and assignments.
- Create summaries or mind maps to consolidate information.
- Organize materials into folders or digital notebooks.
- Highlight key concepts and mark areas for further study.
- Review organized materials regularly.
11 other activities
Expand to see all activities and additional details
Show all 14 activities
Form a SQL study group
Show steps
Study groups provide opportunities to discuss concepts, ask questions, and collaborate with fellow learners, fostering improved understanding and retention of the course material.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Find other learners who are taking the same SQL course or who have similar interests
- Establish regular meeting times and a study schedule
- Take turns presenting concepts and leading discussions
- Work on group projects or exercises
Follow tutorials on SQL data modeling
Show steps
Learn the principles of SQL data modeling to optimize database design.
Show steps
Show steps
Show steps
- Identify the entities and relationships in a given business scenario.
- Map the entities and relationships to tables and columns.
- Create an ER diagram to visualize the data model.
- Normalize the data model to reduce redundancy and improve data integrity.
- Practice creating data models for different use cases.
Follow a SQL tutorial series
Show steps
Completing a series of guided SQL tutorials will provide practical exercises, guidance, and reinforcement of key concepts.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Identify a tutorial series that aligns with your learning goals
- Follow the tutorial steps and instructions
- Complete the exercises and assignments
Write sample SQL queries
Show steps
Practice writing SQL queries to gain familiarity with the syntax and structure.
Show steps
Show steps
Show steps
- Create a database and table using SQL commands.
- Insert data into the table using INSERT statements.
- Write SELECT queries to retrieve specific data from the table.
- Use WHERE clauses to filter the results of SELECT queries.
- Practice using ORDER BY and GROUP BY clauses to sort and group data.
Engage in study groups or discussions with peers
Show steps
Collaborate with peers to exchange knowledge, clarify concepts, and provide support.
Show steps
Show steps
Show steps
- Form study groups or join existing discussion forums.
- Participate in discussions, ask questions, and share insights.
- Review and discuss practice problems or assignments together.
- Provide constructive feedback and support to other group members.
- Reflect on discussions and identify areas for improvement.
Complete SQL coding challenges
Show steps
Solving coding challenges will improve your understanding of SQL syntax, enhance your problem-solving skills, and enable you to apply SQL in practical scenarios.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Identify an online platform or resource that provides SQL coding challenges
- Start solving challenges and practice writing SQL queries
- Review your solutions and identify areas for improvement
Build a small data analysis project using SQL
Show steps
Apply SQL skills to a practical project to solidify understanding and gain experience.
Show steps
Show steps
Show steps
- Define the scope and objectives of the project.
- Gather and import the necessary data into a database.
- Write SQL queries to extract, transform, and analyze the data.
- Create visualizations or reports to present the results.
- Evaluate the results and identify areas for improvement.
Start a SQL blog
Show steps
Writing a blog about SQL concepts will help you solidify your understanding of SQL, learn how to communicate your knowledge, and encourage you to explore different topics within the field.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Decide on a topic and audience
- Research and gather information
- Write and edit your post
Write blog posts or articles about SQL best practices
Show steps
Share knowledge and reinforce understanding by writing about SQL best practices.
Show steps
Show steps
Show steps
- Identify common pitfalls and challenges in using SQL.
- Research and gather information on best practices for SQL coding.
- Write clear and concise blog posts or articles that explain the best practices.
- Share the content on relevant platforms or forums.
- Monitor the feedback and engagement on the content.
Build a personal SQL project
Show steps
Working on a personal project will provide an opportunity to apply your SQL skills to a real-world problem, enhance your problem-solving skills, and showcase your abilities to potential employers.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Identify a problem or need that can be addressed using SQL
- Design and plan your project, including the data sources and SQL queries you will use
- Develop and implement your SQL solution
- Test and evaluate your project
Mentor junior data analysts or SQL enthusiasts
Show steps
Share knowledge, provide guidance, and reinforce understanding by mentoring others.
Show steps
Show steps
Show steps
- Identify opportunities to mentor junior data analysts or SQL enthusiasts.
- Share knowledge and provide guidance on SQL concepts and best practices.
- Review code and provide constructive feedback.
- Encourage and support mentees in their learning journey.
- Track progress and measure the impact of mentoring.
Career center
Learners who complete قواعد البيانات وSQL (لغة الاستعلام البنيوية) لعلم البيانات will develop knowledge and skills
that may be useful to these careers:
Database Analyst
Database Analyst
A Database Analyst designs and maintains database systems, ensuring that they meet the needs of the organization. They analyze data requirements, develop database schemas, and implement and maintain database systems. This course provides a strong foundation in relational database concepts and SQL, which are essential skills for Database Analysts. By completing this course, you will be well-prepared to enter the field of database analysis and to succeed in this role.
Data Analyst
Data Analyst
A Data Analyst collects, analyzes, and interprets data to help businesses make informed decisions. They use a variety of statistical and analytical techniques to identify trends, patterns, and insights in data. This course provides a solid foundation in SQL, which is a key tool for Data Analysts. By completing this course, you will be able to effectively access and analyze data from databases, which is a valuable skill for Data Analysts.
Data Scientist
Data Scientist
A Data Scientist uses scientific methods and statistical techniques to extract knowledge and insights from data. They develop and implement data models, and use machine learning and other advanced techniques to solve business problems. This course provides a strong foundation in SQL, which is a key tool for Data Scientists. By completing this course, you will be able to effectively access and analyze data from databases, which is a valuable skill for Data Scientists.
Business Analyst
Business Analyst
A Business Analyst works with stakeholders to understand their business needs and develop solutions to improve business processes. They use data analysis and modeling techniques to identify opportunities for improvement and to develop recommendations for change. This course provides a strong foundation in SQL, which is a valuable tool for Business Analysts. By completing this course, you will be able to effectively access and analyze data from databases, which is a valuable skill for Business Analysts.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software applications. They use a variety of programming languages and technologies to build software systems that meet the needs of users. This course provides a strong foundation in SQL, which is a key technology for Software Engineers. By completing this course, you will be able to effectively access and manipulate data from databases, which is a valuable skill for Software Engineers.
Web Developer
Web Developer
A Web Developer designs and develops websites and web applications. They use a variety of programming languages and technologies to create websites that are both functional and aesthetically pleasing. This course provides a strong foundation in SQL, which is a key technology for Web Developers. By completing this course, you will be able to effectively access and manipulate data from databases, which is a valuable skill for Web Developers.
Information Security Analyst
Information Security Analyst
An Information Security Analyst protects an organization's information systems from security threats and vulnerabilities. They use a variety of security tools and techniques to identify and mitigate risks to information security. This course provides a strong foundation in SQL, which is a key technology for Information Security Analysts. By completing this course, you will be able to effectively access and analyze data from security logs and other data sources, which is a valuable skill for Information Security Analysts.
Data Engineer
Data Engineer
A Data Engineer designs, builds, and maintains data pipelines and data warehouses. They use a variety of data engineering tools and technologies to ensure that data is accessible, reliable, and scalable. This course provides a strong foundation in SQL, which is a key technology for Data Engineers. By completing this course, you will be able to effectively access and manipulate data from databases, which is a valuable skill for Data Engineers.
Database Administrator
Database Administrator
A Database Administrator manages and maintains database systems. They ensure that databases are running smoothly and efficiently, and that data is protected from unauthorized access. This course provides a strong foundation in SQL, which is a key technology for Database Administrators. By completing this course, you will be able to effectively manage and maintain databases, which is a valuable skill for Database Administrators.
System Administrator
System Administrator
A System Administrator manages and maintains computer systems and networks. They ensure that systems are running smoothly and efficiently, and that data is protected from unauthorized access. This course provides a strong foundation in SQL, which is a key technology for System Administrators. By completing this course, you will be able to effectively manage and maintain systems, which is a valuable skill for System Administrators.
Network Administrator
Network Administrator
A Network Administrator manages and maintains computer networks. They ensure that networks are running smoothly and efficiently, and that data is protected from unauthorized access. This course provides a strong foundation in SQL, which is a key technology for Network Administrators. By completing this course, you will be able to effectively manage and maintain networks, which is a valuable skill for Network Administrators.
Security Analyst
Security Analyst
A Security Analyst investigates and responds to security incidents. They use a variety of security tools and techniques to identify and mitigate risks to security. This course provides a strong foundation in SQL, which is a key technology for Security Analysts. By completing this course, you will be able to effectively access and analyze data from security logs and other data sources, which is a valuable skill for Security Analysts.
IT Auditor
IT Auditor
An IT Auditor evaluates the security and effectiveness of an organization's IT systems. They use a variety of auditing techniques to identify and mitigate risks to IT systems. This course provides a strong foundation in SQL, which is a key technology for IT Auditors. By completing this course, you will be able to effectively access and analyze data from IT systems, which is a valuable skill for IT Auditors.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst uses data to identify and solve business problems. They use a variety of data analysis and modeling techniques to develop insights and recommendations for business leaders. This course provides a strong foundation in SQL, which is a key technology for Business Intelligence Analysts. By completing this course, you will be able to effectively access and analyze data from databases, which is a valuable skill for Business Intelligence Analysts.
Data Management Analyst
Data Management Analyst
A Data Management Analyst plans and manages the storage, retrieval, and use of data. They ensure that data is accessible, reliable, and secure. This course provides a strong foundation in SQL, which is a key technology for Data Management Analysts. By completing this course, you will be able to effectively manage and analyze data, which is a valuable skill for Data Management Analysts.
For more career information including salaries, visit:
OpenCourser.com/course/qyt71s/qw`d
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 (لغة الاستعلام البنيوية) لعلم البيانات.
This comprehensive textbook provides a thorough foundation in database systems, covering concepts, design, and implementation. It valuable resource for both beginners and experienced professionals.
This widely used textbook offers a comprehensive introduction to database management systems. It covers both theoretical and practical aspects, making it suitable for both students and professionals.
A beginner-friendly introduction to SQL, this book provides clear explanations and practical examples. It is ideal for those with little to no prior knowledge of SQL.
This cookbook-style book provides practical recipes for solving common SQL problems. It valuable reference for both beginners and experienced SQL users.
This textbook provides a comprehensive overview of relational database management systems. It covers both the fundamental concepts and practical aspects of database design, implementation, and management.
This practical guide to data science covers essential concepts and tools, including SQL. It provides a solid foundation for understanding and applying SQL in a data science context.
Focuses on optimizing SQL performance. It provides techniques and best practices for writing efficient SQL queries, which is essential for data scientists who need to process large datasets.
This beginner-friendly book provides a concise overview of SQL. It quick and easy way to get started with SQL for those who have little to no prior experience.
This popular book introduces Python libraries for data analysis, including pandas and NumPy. It useful resource for learning how to use Python for data manipulation and analysis, which complements the SQL skills covered in the course.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/qyt71s/qw`d
Share
Similar courses
Here are nine courses similar to
قواعد البيانات وSQL (لغة الاستعلام البنيوية) لعلم البيانات.
مقدمة عن قواعد بيانات للتطوير على الخادم
OpenCourser.com/course/t3nz3t/mqdm@
مقدمة عن قواعد بيانات للتطوير على الخادم
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/4q3s1b/mqdm@
مقدمة عن قواعد البيانات
Most relevant
المشروع المتقدم لمهندس قاعدة البيانات
OpenCourser.com/course/aht08c/lmshrw`
المشروع المتقدم لمهندس قاعدة البيانات
Most relevant
عملاء قاعدة البيانات
OpenCourser.com/course/m6iw4o/`ml
عملاء قاعدة البيانات
Most relevant
هياكل قواعد البيانات وإدارتها باستخدام MySQL
OpenCourser.com/course/41zdxy/hykl
هياكل قواعد البيانات وإدارتها باستخدام MySQL
Most relevant
SQL لعلوم البيانات
OpenCourser.com/course/rth2er/sql
SQL لعلوم البيانات
Most relevant
MYSQL Workbench إنشاء و تصميم قواعد البيانات باستخدام
OpenCourser.com/course/vik9cn/mysql
MYSQL Workbench إنشاء و تصميم قواعد البيانات باستخدام
Most relevant
Time
16 hours
Via
Coursera
Institutions
IBM
IBM Skills Network
Instructors
Hima Vasudevan
Rav Ahuja
Good to know
Designed for learners with no SQL or Python experience, making it a great entry-level course
Provides hands-on training with real-world data sets
Develops practical skills in accessing SQL databases from Jupyter Notebooks
Emphasizes practical applications in data science
Taught by reputable instructors with expertise in SQL and data science
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