SQL for Data Science

Description

In this course, you will learn:

• Introduce you to popular SQL operations for doing Data Science tasks, including a few practical examples.
• begins with a discussion of SQL clauses and progresses to other statements such as GROUP BY, ALIAS, JOINS and their types (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and SELF JOIN). You will also learn how to work with subqueries, including their types and execution, after which you will comprehend Python's relationship with SQL and its popularity.
• The course includes a guide on Python installation. The course also offers exams to help you track your progress.
• Complete the course for free and receive a certificate. We refer you to the accompanying materials for reference.

Syllabus:

• Intro to Clauses
• Group By Statement
• Demo for Group By Statement
• Having Clause Statement
• Demo For having Clause
• Alias in SQL
• Joins in SQL
• Types of Joins in SQL
• INNER Join
• LEFT Join
• RIGHT Join
• FULL Join
• SELF Join
• Intro to Subquery
• Problem Statement
• What is a Subquery?
• How Subquery Executes?
• Type of Subquery
• Demo for Subqueries
• Introduction to SQL with Python
• History of Python
• Why Should You Learn Python?
• Why is Python So Popular?
• Installing Python