‏SQL لعلوم البيانات from Coursera

مع زيادة جمع البيانات بشكل كبير، تزداد الحاجة إلى الأشخاص المهرة في استخدام البيانات والتفاعل معها؛ لتكون قادرة على التفكير بشكل نقدي، وتقديم رؤى لاتخاذ قرارات أفضل وتحسين أعمالهم. هذا هو عالم بيانات، "عالم رياضيات جزئي، وعالم كمبيوتر جزئي، ومراقب اتجاهات جزئي" (SAS Institute، Inc.). وفقًا لـ Glassdoor، كونك عالم بيانات هي أفضل وظيفة في أمريكا؛ براتب أساسي متوسط قدره 110000 دولار، وآلاف من فرص العمل الشاغرة في وقت واحد. تشمل المهارات اللازمة لتكون عالم بيانات جيدًا القدرة على استرداد البيانات والعمل معها، وللقيام بذلك، يجب أن تكون على دراية جيدة بـ SQL، وهي اللغة القياسية للتواصل مع أنظمة قواعد البيانات.

وقد تم تصميم هذه الدورة لتمنحك الدليل التمهيدي في أساسيات SQL والعمل مع البيانات حتى يمكنك البدء في تحليلها لأغراض علوم البيانات. ستبدأ في طرح الأسئلة الصحيحة والتوصل إلى إجابات جيدة لتقديم رؤى قيمة لمؤسستك. تبدأ هذه الدورة بالأساسيات وتفترض أنك لا تملك أي معرفة أو مهارات في SQL. سيعتمد على هذا الأساس وسيطلب منك تدريجيًا كتابة استعلامات بسيطة ومعقدة لمساعدتك في تحديد البيانات من الجداول. ستبدأ في العمل مع أنواع مختلفة من البيانات مثل السلاسل والأرقام ومناقشة طرق تصفية النتائج وتقليلها.

ستنشئ جداول جديدة وستكون قادرًا على نقل البيانات إليها. سوف تتعلم العوامل المشتركة وكيفية دمج البيانات. سوف تستخدم بيانات الحالة والمفاهيم مثل إدارة البيانات والتنميط. سوف تناقش موضوعات حول البيانات، وتتدرب على استخدام مهام البرمجة في العالم الحقيقي. ستقوم بتفسير البنية والمعنى والعلاقات في بيانات المصدر واستخدام SQL كمحترف لتشكيل بياناتك لأغراض التحليل المستهدفة.

على الرغم من أنه ليست لدينا أي متطلبات مسبقة محددة أو متطلبات برامج لأخذ هذه الدورة، إلا إنه يوصى باستخدام محرر نصوص بسيط للمشروع النهائي. فما تنتظرون؟ هذه هي خطوتكم الأولى في الحصول على وظيفة في أفضل مهنة في الولايات المتحدة وقريبًا في العالم!

What's inside

Syllabus

الشروع في العمل وتحديد واسترجاع البيانات باستخدام SQL

في هذه الوحدة، سوف تكون قادرًا على تعريف SQL ومناقشة كيفية اختلاف SQL عن لغات الكمبيوتر الأخرى. ستكون قادرًا على مقارنة وتباين أدوار مسؤول قاعدة البيانات وعالم البيانات، وشرح الاختلافات بين علاقات رأس برأس، وعالقات رأس بأطراف، وعلاقات أطراف بأطراف مع قواعد البيانات. ستتمكن من استخدام عبارة SELECT والتحدث عن بعض قواعد بناء الجملة الأساسية. ستتمكن من إضافة تعليقات في التعليمة البرمجية الخاصة بك وتجميع أهميتها.

فلترة البيانات وفرزها وحسابها باستخدام SQL

في هذه الوحدة التدريبية، ستتمكن من استخدام العديد من الجمل والعوامل الجديدة مثل WHERE وBETWEEN وIN وOR وNOT وLIKE وORDER BY وGROUP BY. ستتمكن من استخدام وظيفة أحرف البدل للبحث عن سجلات أكثر تحديدًا أو أجزاء منها، بما في ذلك مزاياها وعيوبها وأفضل طريقة لاستخدامها. ستكون قادرًا على مناقشة كيفية استخدام عوامل الرياضيات الأساسية، بالإضافة إلى دوال التجميع مثل AVERAGE وCOUNT وMAX وMIN وغيرها لبدء تحليل بياناتنا.

الاستعلامات الفرعية والروابط في SQL

في هذه الوحدة التدريبية، ستتمكن من مناقشة الاستعلامات الفرعية، بما في ذلك مزاياها وعيوبها، ومتى تستخدمها. ستتمكن من تذكر مفهوم المجال الرئيسي ومناقشة كيف تساعدنا هذه الاستعلامات الفرعية في ربط البيانات باستخدام الروابط. ستكون قادرًا على تحديد وتعريف عدة أنواع من الروابط، بما في ذلك الربط الديكارتي، والربط الداخلي، والربط جهة اليسار واليمين، والروابط الخارجية الكاملة، والربط الذاتي. ستتمكن من استخدام الأسماء المستعارة والمؤهلات المسبقة لجعل التعليمة البرمجية SQL الخاصة بك أكثر نظافة وفعالية.

تعديل البيانات وتحليلها باستخدام SQL

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

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Introduces the SQL language and explains how it differs from other programming languages

Demonstrates how to filter, sort, and calculate data using SQL

Uses real-world programming tasks to practice using SQL

Covers essential SQL concepts for data analysis

Useful for learners with no prior experience with SQL

Students need a basic understanding of data management and normalization

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:

Organize and review course materials

Show steps

Stay organized by compiling and reviewing your course materials, including notes, assignments, and quizzes.

Show steps

Create a dedicated folder or notebook for the course.
File and organize your notes, assignments, and quizzes.
Review your materials regularly to reinforce your learning and identify areas where you need further clarification.

Review basic data manipulation concepts

Show steps

As a refresher, review basic data manipulation concepts such as data types, operators, and functions to strengthen your foundation for this course.

Browse courses on Data Manipulation

Show steps

Go over your notes or textbooks from previous courses that covered data manipulation.
Complete practice exercises or quizzes to test your understanding of the concepts.
Join online forums or discussion groups to ask questions and engage with others.

Revisit relational database concepts

Show steps

Refresh your knowledge of relational database concepts, including tables, relationships, and data integrity, to prepare for the course material.

Browse courses on Relational Databases

Show steps

Review lecture notes or online resources on relational database concepts.
Create a simple relational database using a tool like SQLite or MySQL.
Populate the database with data and practice writing SQL queries to retrieve and manipulate the data.
Discuss relational database concepts with classmates or online forums to reinforce your understanding.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Participate in peer study groups

Show steps

Engage with fellow students in peer study groups to discuss course concepts, share knowledge, and work together on assignments or projects.

Browse courses on SQL

Show steps

Identify classmates who are interested in forming a study group.
Set regular meeting times and establish a communication channel.
Choose topics for discussion based on the course material or areas where you need clarification.
Prepare for each meeting by reviewing the material and coming up with questions or insights to share.
Actively participate in discussions, ask questions, and contribute your own knowledge.

Solve daily SQL coding challenges

Show steps

Regular practice with SQL coding challenges will enhance your problem-solving skills and reinforce your understanding of SQL syntax and concepts.

Browse courses on SQL

Show steps

Identify online platforms or resources that offer daily SQL coding challenges.
Set aside a specific time each day to work on the challenge.
Attempt to solve the challenge on your own, without referring to external resources.
Review the solution and identify areas for improvement.
Repeat the process daily to build consistency and improve your skills.

Create an SQL visual dictionary

Show steps

Create a visual dictionary of SQL syntax and concepts to aid in memorization and quick reference during the course.

Browse courses on SQL

Show steps

Gather a comprehensive list of essential SQL keywords, functions, and operators.
Design a visual representation for each item, using colors, icons, or diagrams to illustrate their purpose and usage.
Organize the visual dictionary into logical categories or sections.
Review and refine the visual dictionary regularly to ensure its accuracy and completeness.

Follow guided tutorials on advanced SQL techniques

Show steps

Seek out and follow guided tutorials to expand your knowledge of advanced SQL techniques, such as window functions, joins, and subqueries.

Browse courses on SQL

Show steps

Identify reputable online courses or platforms that offer guided tutorials on advanced SQL techniques.
Select a tutorial that aligns with your learning objectives.
Follow the tutorial step-by-step, taking notes and practicing the concepts.
Complete the exercises and quizzes provided in the tutorial to test your understanding.
Apply the techniques you have learned to real-world data analysis projects.

Build a data analysis project using SQL

Show steps

Embark on a data analysis project that involves collecting, cleaning, and analyzing data using SQL. This will provide hands-on experience and solidify your understanding of the course concepts.

Browse courses on SQL

Show steps

Identify a real-world problem or dataset that you are interested in.
Design a research question or hypothesis that you want to investigate using the data.
Collect and clean the data using SQL queries.
Perform data analysis using SQL functions, aggregations, and visualizations.
Interpret the results and draw conclusions based on your analysis.
Communicate your findings through a report or presentation.

Career center

Learners who complete ‏SQL لعلوم البيانات will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts collect, clean, and analyze data to help businesses make informed decisions. SQL is an essential tool for Data Analysts, as it allows them to access and manipulate data from a variety of sources. This course provides a solid foundation in SQL, teaching you how to perform basic and advanced queries, filter and sort data, and create and modify tables. With this knowledge, you'll be well-equipped to excel as a Data Analyst.

See salaries and explore the career path for Data Analyst

Database Administrator

Database Administrators are responsible for maintaining and optimizing databases. They ensure that data is secure, accessible, and performant. SQL is essential for Database Administrators, as it allows them to create and manage databases, control user access, and troubleshoot performance issues. This course provides a comprehensive introduction to SQL, covering everything from basic queries to advanced database administration tasks. With this knowledge, you'll be well-prepared to pursue a career as a Database Administrator.

See salaries and explore the career path for Database Administrator

Data Scientist

Data Scientists use data to solve complex problems and make predictions. They combine skills in mathematics, statistics, and programming to extract insights from data. SQL is a fundamental tool for Data Scientists, as it allows them to access and manipulate large datasets. This course provides a solid foundation in SQL, teaching you how to perform complex queries, analyze data, and build data models. With this knowledge, you'll be well-prepared to succeed as a Data Scientist.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts use data to understand business needs and improve decision-making. They work closely with stakeholders to identify problems, analyze data, and recommend solutions. SQL is an important tool for Business Analysts, as it allows them to access and manipulate data from a variety of sources. This course provides a comprehensive introduction to SQL, covering everything from basic queries to advanced data analysis techniques. With this knowledge, you'll be well-prepared to succeed as a Business Analyst.

See salaries and explore the career path for Business Analyst

Data Engineer

Data Engineers design, build, and maintain data pipelines. They ensure that data is clean, consistent, and accessible to data analysts and other users. SQL is an essential tool for Data Engineers, as it allows them to create and manage databases, transform data, and build data pipelines. This course provides a comprehensive introduction to SQL, covering everything from basic queries to advanced data engineering techniques. With this knowledge, you'll be well-prepared to succeed as a Data Engineer.

See salaries and explore the career path for Data Engineer

Software Engineer

Software Engineers design, develop, and maintain software applications. They use a variety of programming languages and technologies to create software that meets user needs. SQL is a commonly used database technology, and Software Engineers often need to be able to query and manipulate data from databases. This course provides a solid foundation in SQL, teaching you how to perform basic and advanced queries, filter and sort data, and create and modify tables. With this knowledge, you'll be well-prepared to work as a Software Engineer who can effectively use SQL.

See salaries and explore the career path for Software Engineer

Statistician

Statisticians collect, analyze, and interpret data to provide insights and make predictions. They use a variety of statistical techniques to identify trends, patterns, and relationships in data. SQL is a commonly used tool for Statisticians, as it allows them to access and manipulate large datasets. This course provides a solid foundation in SQL, teaching you how to perform basic and advanced queries, filter and sort data, and create and modify tables. With this knowledge, you'll be well-prepared to work as a Statistician who can effectively use SQL.

See salaries and explore the career path for Statistician

Market Researcher

Market Researchers conduct research to understand consumer behavior and trends. They use a variety of methods to collect data, including surveys, interviews, and focus groups. SQL is a useful tool for Market Researchers, as it allows them to analyze data and identify trends. This course provides a basic introduction to SQL, teaching you how to perform simple queries and filter and sort data. With this knowledge, you'll be well-prepared to work as a Market Researcher who can effectively use SQL.

See salaries and explore the career path for Market Researcher

Financial Analyst

Financial Analysts use data to analyze financial performance and make investment recommendations. They use a variety of financial models and techniques to evaluate companies and make predictions about future performance. SQL is a commonly used tool for Financial Analysts, as it allows them to access and manipulate financial data. This course provides a basic introduction to SQL, teaching you how to perform simple queries and filter and sort data. With this knowledge, you'll be well-prepared to work as a Financial Analyst who can effectively use SQL.

See salaries and explore the career path for Financial Analyst

Epidemiologist

Epidemiologists investigate the causes and spread of diseases. They use a variety of methods to collect and analyze data, including surveys, interviews, and medical records. SQL is a useful tool for Epidemiologists, as it allows them to analyze data and identify trends. This course provides a basic introduction to SQL, teaching you how to perform simple queries and filter and sort data. With this knowledge, you'll be well-prepared to work as an Epidemiologist who can effectively use SQL.

See salaries and explore the career path for Epidemiologist

Actuary

Actuaries use mathematics and statistics to assess risk and uncertainty. They work in a variety of industries, including insurance, finance, and healthcare. SQL is a commonly used tool for Actuaries, as it allows them to access and manipulate large datasets. This course provides a basic introduction to SQL, teaching you how to perform simple queries and filter and sort data. With this knowledge, you'll be well-prepared to work as an Actuary who can effectively use SQL.

See salaries and explore the career path for Actuary

Health Data Analyst

Health Data Analysts use data to improve the quality and efficiency of healthcare. They work with a variety of data sources, including medical records, claims data, and patient surveys. SQL is an essential tool for Health Data Analysts, as it allows them to access and manipulate large datasets. This course provides a solid foundation in SQL, teaching you how to perform basic and advanced queries, filter and sort data, and create and modify tables. With this knowledge, you'll be well-prepared to succeed as a Health Data Analyst.

See salaries and explore the career path for Health Data Analyst

Quantitative Analyst

Quantitative Analysts use mathematics and statistics to analyze financial data. They develop and use mathematical models to make investment recommendations. SQL is a commonly used tool for Quantitative Analysts, as it allows them to access and manipulate large datasets. This course provides a basic introduction to SQL, teaching you how to perform simple queries and filter and sort data. With this knowledge, you'll be well-prepared to work as a Quantitative Analyst who can effectively use SQL.

See salaries and explore the career path for Quantitative Analyst

Data Miner

Data Miners use data to identify patterns and trends. They use a variety of data mining techniques to extract knowledge from data. SQL is a commonly used tool for Data Miners, as it allows them to access and manipulate large datasets. This course provides a basic introduction to SQL, teaching you how to perform simple queries and filter and sort data. With this knowledge, you'll be well-prepared to work as a Data Miner who can effectively use SQL.

See salaries and explore the career path for Data Miner

Database Architect

Database Architects design and implement database systems. They ensure that databases are efficient, reliable, and scalable. SQL is an essential tool for Database Architects, as it allows them to create and manage databases. This course provides a comprehensive introduction to SQL, covering everything from basic queries to advanced database administration tasks. With this knowledge, you'll be well-prepared to succeed as a Database Architect.

See salaries and explore the career path for Database Architect