SQL Fundamentals for Data Analysts

This course is part of multiple programs.

Instructor: CFI (Corporate Finance Institute)

Access provided by SVEC + MBU

10,585 already enrolled

7 modules

Gain insight into a topic and learn the fundamentals.

70 reviews

Beginner level

No prior experience required

5 hours to complete

Flexible schedule

Learn at your own pace

7 modules

Gain insight into a topic and learn the fundamentals.

70 reviews

Beginner level

No prior experience required

5 hours to complete

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

1 assignment

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 7 modules in this course

Focus on the skills you need to get started with SQL as a data analyst, allowing you to read & transform data and gather insights from a company database.

• Learn the basic SQL syntax that will help you access a whole new world of data. • Focus on the read-only functionality that matters for a data analyst, and get to insights quickly. • Perform the basics of data sorting, filtering, and aggregation in SQL to start uncovering valuable insights • Solidify your understanding through real-world scenarios, applying your newfound SQL skills in a variety of practical exercises

Welcome to the SQL Fundamentals course.

What's included

1 video1 reading

In this module, we will learn to retrieve and filter data using basic SQL queries.

What's included

31 videos

31 videos Total 45 minutes

Introduction 1 minute
Installation and Introduction to Azure Data Studio 1 minute
Creating a Connection to a Database 2 minutes
What is Adventure Works? 1 minute
Example SQL Code 2 minutes
Saving Your Queries in Notepad 2 minutes
SELECT and FROM 2 minutes
SELECT Specific Columns 3 minutes
Creating a Column Alias 2 minutes
Using WHERE to Filter Rows 2 minutes
Checking the Impact of a WHERE Filter 0 minutes
Limiting Results to 1 Invoice Number for Testing 1 minute
Using GROUP BY to Combine Rows 2 minutes
Using GROUP BY to Combine Invoice Numbers 2 minutes
Using HAVING to Filter Grouped Rows 1 minute
Filtering Grouped Invoices with HAVING 1 minute
SQL Order of Operations 3 minutes
Using ORDER BY to Sort Query Rows 1 minute
Recap and Common Errors 2 minutes
Filtering Rows TOP N 2 minutes
Filtering Rows TOP N Percent 2 minutes
Filtering Rows OFFSET FETCH 2 minutes
Filtering Rows DISTINCT 2 minutes
ORDER BY Another Column 1 minute
ORDER BY Another Column 1 minute
Exercise 1a 1 minute
Exercise 1a Review 1 minute
Exercise 1b 1 minute
Exercise 1b Review 0 minutes
Exercise 1c 1 minute
Exercise 1c Review 1 minute

In this module, we will learn manipulate data with the help of numerical date and text functions.

What's included

40 videos

40 videos Total 79 minutes

Introduction 1 minute
Recap of Aggregate Functions 1 minute
Counting Rows with COUNT( ) Aggregation 2 minutes
How Aggregate Functions Respond to NULL Values 1 minute
The Importance of Data Types 1 minute
Numeric Data Types 2 minutes
Numeric Functions 2 minutes
Where is the Boolean Data Type 2 minutes
Date and Time Data Types 1 minute
Date Parts 0 minutes
Date and Time Functions 1 minute
Date and Time Functions in Practice 4 minutes
The DATEADD Function 1 minute
Working with Specific Dates 2 minutes
Server Properties Collation 4 minutes
Text or String Data Types 2 minutes
String Functions 1 minute
The CONCAT String Function 2 minutes
LEN UPPER LOWER REPLACE String functions 2 minutes
Flexible LEFT and RIGHT Functions 3 minutes
Comparison Operators 3 minutes
Comparison Operators - Dealing with NULL 3 minutes
Logical Operators 1 minute
Logical Operators - Common Errors 4 minutes
Advanced Logical Operators - IN and BETWEEN 1 minute
IN and BETWEEN in Practice 4 minutes
Advanced Logical Operators - LIKE 1 minute
LIKE in Practice 3 minutes
Using IIF Statements to Create a Conditional Column 1 minute
Using a CASE Statement for Multiple Conditions 4 minutes
Basic SQL Formatting 1 minute
Using IIF in a WHERE Statement 1 minute
Replacing NULL Using IIF, ISNULL and COALESCE 3 minutes
Using CAST to Change the Data Type 1 minute
Practical Examples Using CAST 4 minutes
Using a NATIONAL for UNICODE Best Practice 2 minutes
Exercise 2a 0 minutes
Exercise 2a Review 1 minute
Exercise 2b 1 minute
Exercise 2b Review 2 minutes

In this module, we will learn the difference between OLTP and data warehouse and also understand the essential terminology related to SQL.

What's included

12 videos

12 videos Total 21 minutes

Introduction 1 minute
A History of SQL 1 minute
SQL Terminology 3 minutes
RDBMS Installation Options 2 minutes
Data Security 3 minutes
Types of Database System 2 minutes
Data Normalization in OLTP Systems 3 minutes
De-normalization in DW Systems 1 minute
Fact and Dimension Tables 1 minute
Relationships & Keys 1 minute
The Star Schema 1 minute
Snowflake Hybrid Schema 2 minutes

In this module, we will learn to combine data from multiple tables using a single query. Additionally, we will understand how SQL databases deal with many-to-many relationships.

What's included

30 videos

30 videos Total 74 minutes

Introduction 1 minute
Relationships and ER Diagrams 3 minutes
Purpose of DW Relationships 3 minutes
Internet Sales Schema 2 minutes
Types of JOIN 4 minutes
A Basic INNER JOIN Using Sales and Customers 3 minutes
Returning Only the TOP 100 Customers 4 minutes
Order of Operations Review 1 minute
INNER JOIN the Currency Table 3 minutes
HAVING or WHERE 3 minutes
When INNER JOIN Doesn't Work 6 minutes
RIGHT JOIN to Retrieve Full Product Catalogue 2 minutes
LEFT JOIN vs RIGHT JOIN 3 minutes
Bridge Tables for Many-to-many Relationships 4 minutes
Creating JOINS Across Bridge Tables 4 minutes
Caution with Duplicate Data 3 minutes
Reading SQL Code 2 minutes
Appending Data with a UNION 1 minute
Exploring the Reseller Schema 1 minute
Creating a UNION between Internet and Reseller Sales 3 minutes
Identifying the Source of Each UNION Row 2 minutes
Using ORDER BY with a UNION 1 minute
Other Types of JOIN 1 minute
Creating a View 3 minutes
Querying a View 2 minutes
Creating Dynamic Results Using Subqueries 3 minutes
Exercise 4a 1 minute
Exercise 4a Review 2 minutes
Exercise 4b 1 minute
Exercise 4b Review 2 minutes

In this module, we will learn how to use SQL in popular BI tools and create summary reports using advanced functions.

What's included

12 videos

12 videos Total 26 minutes

Introduction 1 minute
Connecting to SQL Server from Excel 1 minute
Connecting to SQL Server from Power BI 2 minutes
Connecting to SQL from Tableau 1 minute
Using CUBE to Return Subtotals and Totals 2 minutes
Using ROLLUP to Return Subtotals and Totals 1 minute
Common Scenario Percent of total 4 minutes
Introducing the Finance Schema 3 minutes
Exercise 5a 1 minute
Exercise 5a Review 4 minutes
Exercise 5b 1 minute
Exercise 5b Review 5 minutes

What's included

1 assignment

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(17 ratings)

CFI (Corporate Finance Institute)

Corporate Finance Institute

29 Courses 116,556 learners

Offered by

Corporate Finance Institute

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
84.28%
4 stars
12.85%
3 stars
1.42%
2 stars
1.42%
1 star
0%

Showing 3 of 70

Reviewed on Mar 3, 2025

something is wrong with 2nd last question in the final test, I tried multiple ways but the answer didn't match. Maybe there is a change in the database or the options!!

Reviewed on May 9, 2025

It's okay with beginner level. With Combination between theory and practice. I evaluate that, this is the ideal course for who want to start with SQL

Reviewed on Jul 20, 2025

The instructor explained everything in great detail, and it was easy to follow along.

View more reviews