.png)
Part 2: Intermediate SQL for Data Science
in Data Analytics with SQLWhat you will learn?
Build a strong foundation in SQL, from writing simple queries to complex data manipulation.
Master techniques to filter, aggregate, and analyze data effectively.
Gain proficiency in combining datasets through advanced join techniques such as inner join, left join and full join.
Apply conditional logic and advanced operators to enhance data queries.
About this course
Unlock the full potential of SQL to analyze, manipulate, and retrieve data with confidence. This comprehensive course is designed to take you from the basics of SQL querying to advanced techniques used by professionals in data analytics, business intelligence, and data science.
Through practical lessons, hands-on exercises, and real-world examples, you’ll learn how to transform raw data into meaningful insights that drive decision-making.
What You’ll Learn
👉 Build a strong foundation in SQL, from writing simple queries to complex data manipulation.
👉 Master techniques to filter, aggregate, and analyze data effectively.
👉 Gain proficiency in combining datasets through advanced join techniques.
👉 Apply conditional logic and advanced operators to enhance data queries.
Why Take This Course?
In today’s data-driven world, SQL is a vital skill for anyone working in analytics, business intelligence, or data science. By the end of this course, you’ll have the expertise to confidently query databases, solve real-world problems, and make data-driven decisions.
Who This Course is For
Analysts, data scientists, and business professionals looking to enhance their data querying skills.
Students and recent graduates preparing for careers in tech or analytics.
Professionals transitioning into data-centric roles.
Prerequisites
Basic familiarity with SQL is helpful but not necessary.
Prerequisites
.png)
Comments (0)
Welcome to the course
Learn how to install Microsoft SQL Server and SSMS
Exploring Microsoft SQL Server Mgt Studio
Introduction to Microsoft SQL Server and SSMS
Setting up the SSMS Environment
Introduction to Azure Data Studio
Introduction to MYSQL server and Workbench
Installing MYSQL(Workbench + Server)
Exploring the interface of workbench
Dataset
Download the file for the practical exercises
Introduction to SELECT clause
The SELECT clause with Expressions
Using Alias
SELECT with DISTINCT
Select TOP N records
SELECT with WHERE clause
WHERE operators
Filter records with comparizon operators
Filter records with the AND operator
Filter records with the OR operators
Filter records with the IN operator
Filter records with BETWEEN
Using the LIKE operator
Filter records with NULL values
Handling NULL values
Working with Aggregate Functions
Working with GROUP BY clause
Sorting records with ORDER BY clause
Filtering Grouped result with HAVING clause
Understanding the Order of execution
Order of Execution demo
Applying conditional logic with CASE
Introduction to Joins
Download the dataset and the resources
Exploring the dataset queries
Introduction to Inner Join
Inner join demo 1
Inner Join demo 2
Introduction to LEFT JOIN
LEFT JOIN demo
Introduction to RIGHT JOIN
RIGHT JOIN demo
Introduction to FULL JOIN
FULL JOIN demo
Summazing data from multiple tables
Using alias in Joins
Joining 3 tables with INNER JOIN
Protips for writing your queries
Introduction to set opertions
Set operation - INTERCEPT AND EXCEPT
DEMO - INTERCEPT AND EXCEPT
Demo - UNION Vs UNION ALL
Congratulations
.jpg)
.png){kind=small}
.png){kind=small}
.png)