SQL Fundamentals for Data Analysts

This course is part of multiple programs.

Instructor: CFI (Corporate Finance Institute)

Sponsored by Louisiana Workforce Commission

1,881 already enrolled

7 modules

Gain insight into a topic and learn the fundamentals.

4.7

(15 reviews)

Beginner level

No prior experience required

5 hours to complete

3 weeks at 1 hour a week

Flexible schedule

Learn at your own pace

7 modules

Gain insight into a topic and learn the fundamentals.

4.7

(15 reviews)

Beginner level

No prior experience required

5 hours to complete

3 weeks at 1 hour a week

Flexible schedule

Learn at your own pace

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

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

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

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 videosTotal 44 minutes

Introduction1 minutePreview module
Installation and Introduction to Azure Data Studio1 minute
Creating a Connection to a Database1 minute
What is Adventure Works?1 minute
Example SQL Code1 minute
Saving Your Queries in Notepad2 minutes
SELECT and FROM1 minute
SELECT Specific Columns3 minutes
Creating a Column Alias2 minutes
Using WHERE to Filter Rows1 minute
Checking the Impact of a WHERE Filter0 minutes
Limiting Results to 1 Invoice Number for Testing1 minute
Using GROUP BY to Combine Rows1 minute
Using GROUP BY to Combine Invoice Numbers2 minutes
Using HAVING to Filter Grouped Rows0 minutes
Filtering Grouped Invoices with HAVING0 minutes
SQL Order of Operations2 minutes
Using ORDER BY to Sort Query Rows1 minute
Recap and Common Errors1 minute
Filtering Rows TOP N1 minute
Filtering Rows TOP N Percent1 minute
Filtering Rows OFFSET FETCH1 minute
Filtering Rows DISTINCT2 minutes
ORDER BY Another Column0 minutes
ORDER BY Another Column0 minutes
Exercise 1a0 minutes
Exercise 1a Review0 minutes
Exercise 1b0 minutes
Exercise 1b Review0 minutes
Exercise 1c0 minutes
Exercise 1c Review0 minutes

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

What's included

40 videos

40 videosTotal 78 minutes

Introduction1 minutePreview module
Recap of Aggregate Functions0 minutes
Counting Rows with COUNT( ) Aggregation2 minutes
How Aggregate Functions Respond to NULL Values1 minute
The Importance of Data Types1 minute
Numeric Data Types1 minute
Numeric Functions2 minutes
Where is the Boolean Data Type1 minute
Date and Time Data Types1 minute
Date Parts0 minutes
Date and Time Functions1 minute
Date and Time Functions in Practice3 minutes
The DATEADD Function1 minute
Working with Specific Dates2 minutes
Server Properties Collation3 minutes
Text or String Data Types1 minute
String Functions1 minute
The CONCAT String Function2 minutes
LEN UPPER LOWER REPLACE String functions2 minutes
Flexible LEFT and RIGHT Functions3 minutes
Comparison Operators2 minutes
Comparison Operators - Dealing with NULL2 minutes
Logical Operators1 minute
Logical Operators - Common Errors4 minutes
Advanced Logical Operators - IN and BETWEEN1 minute
IN and BETWEEN in Practice4 minutes
Advanced Logical Operators - LIKE0 minutes
LIKE in Practice3 minutes
Using IIF Statements to Create a Conditional Column1 minute
Using a CASE Statement for Multiple Conditions3 minutes
Basic SQL Formatting0 minutes
Using IIF in a WHERE Statement1 minute
Replacing NULL Using IIF, ISNULL and COALESCE2 minutes
Using CAST to Change the Data Type1 minute
Practical Examples Using CAST4 minutes
Using a NATIONAL for UNICODE Best Practice1 minute
Exercise 2a0 minutes
Exercise 2a Review0 minutes
Exercise 2b0 minutes
Exercise 2b Review1 minute

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 videosTotal 21 minutes

Introduction1 minutePreview module
A History of SQL1 minute
SQL Terminology2 minutes
RDBMS Installation Options1 minute
Data Security2 minutes
Types of Database System2 minutes
Data Normalization in OLTP Systems2 minutes
De-normalization in DW Systems1 minute
Fact and Dimension Tables1 minute
Relationships & Keys1 minute
The Star Schema1 minute
Snowflake Hybrid Schema1 minute

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.