Free Online Course from Coursera: SQL for Data Science
Learn SQL basics in order to be able to retrieve and work with data.
- English
- With Certificate
Tutor Name
CourseraAbout the Course
Coursera platform is offering a free online course entitled “SQL for Data Science”.This course is designed to give you a primer in the fundamentals of SQL and working with data so that you can begin analyzing it for data science purposes. You will begin to ask the right questions and come up with good answers to deliver valuable insights for your organization. This course starts with the basics and assumes you do not have any knowledge or skills in SQL. You'll start to work with different types of data like strings and numbers and discuss methods to filter and pare down your results. You will create new tables and be able to move data into them. You will learn common operators and how to combine the data. You will use case statements and concepts like data governance and profiling.
Duration:
The total duration of the course is about 20 hours.
Learning Outcomes:
- Identify a subset of data needed from a column or set of columns and write a SQL query to limit to those results.
- Use SQL commands to filter, sort, and summarize data.
- Create an analysis table from multiple queries using the UNION operator.
- Manipulate strings, dates, & numeric data using functions to integrate data from different sources into fields with the correct format for analysis.
Syllabus:
- Week 1: Getting Started and Selecting & Retrieving Data with SQL
In this module, you will be able to define SQL and discuss how SQL differs from other computer languages. You will be able to compare and contrast the roles of a database administrator and a data scientist and explain the differences between one-to-one, one-to-many, and many-to-many relationships with databases. You will be able to use the SELECT statement and talk about some basic syntax rules.
- Week 2: Filtering, Sorting, and Calculating Data with SQL
In this module, you will be able to use several newer clauses and operators including WHERE, BETWEEN, IN, OR, NOT, LIKE, ORDER BY, and GROUP BY. You will be able to use the wildcard function to search for more specific or parts of records, including their advantages and disadvantages, and how best to use them. You will be able to discuss how to use basic math operators, as well as aggregate functions like AVERAGE, COUNT, MAX, MIN, and others to begin analyzing our data.
- Week 3: Subqueries and Joins in SQL
In this module, you will be able to discuss subqueries, including their advantages and disadvantages, and when to use them. You will be able to recall the concept of a key field and discuss how these help us link data together with JOINs. You will be able to identify and define several types of JOINs, including the Cartesian join, an inner join, left and right joins, full outer joins, and a self-join.
- Week 4: Modifying and Analyzing Data with SQL
In this module, you will be able to discuss how to modify strings by concatenating, trimming, changing the case, and using the substring function. You will be able to discuss the date and time strings specifically. You will be able to use case statements and finish this module by discussing data governance and profiling. You will also be able to apply fundamental principles when using SQL for data science. You'll be able to use tips and tricks to apply SQL in a data science context.
Course Fees:
- This course is part of the platform's specialized program entitled “Learn SQL Basics for Data Science”. This program consists of four different courses (for more information here).
- Coursera offers the opportunity to enroll in the course for free for 7 days. The students can obtain a certificate by completing the course individually, or for the whole program. They can include this certificate in their cv or share it on the LinkedIn account.
- If the student is unable to pay the required cost, he\she will be able to register for financial assistance.
About Coursera:
Coursera is an American online learning platform founded by Stanford professors Andrew Ng and Daphne Koller that offers massive open online courses (MOOC), specializations, and degrees.
See more available Master’s scholarships on For9a
See more available fellowships on For9a
See more available opportunities in Turkey on For9a
Taught by
كورسيرا (Coursera) هي منصة تعليمية رائدة عبر الإنترنت توفر دورات تدريبية بالتعاون مع أكثر من 300 جامعة عالمية وشركات رائدة (مثل Google و Meta و IBM) لتقديم تعليم مرن ومرتبط بسوق العمل. تقدم المنصة مجموعة واسعة من الخيارات التعليمية، بما في ذلك الشهادات المهنية، الدورات التخصصية (Specializations)، ودرجات البكالوريوس أو الماجستير عبر الإنترنت في مجالات مثل علوم البيانات، التكنولوجيا، الأعمال، والصحة. تستخدم المنصة الذكاء الاصطناعي لترجمة آلاف الدورات، وتوفير ترجمة نصية (Subtitles) بلغات متعددة، بما في ذلك اللغة العربية.
Read more.