Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

From Excel to SQL

via LinkedIn Learning

Write review

Coursera

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Unihackers

Launch Your Cybersecurity Career in 6 Months

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Get Full Access

As big data gets bigger, you may need to pull insights directly from SQL. Learn how to apply your knowledge of Excel to gain new skills at capturing data from SQL.

Syllabus

Introduction

Moving from Excel to SQL
Setting up your environment for SQL

1. Comparing Excel and SQL

Spreadsheets vs. databases
What is SQL?

2. SQL Basics

Viewing data in SQL
Identifying columns in SQL
Filtering rows in SQL
Combining filters in SQL
Limiting results in SQL
Comparison operators in SQL
The LIKE operator in SQL

3. Working with Functions

Using SUM in SQL
AVERAGE, MIN, MAX, and COUNT in SQL
Finding unique values in SQL
UPPER, LOWER, and LENGTH in SQL

4. Organizing Data

Sorting data
Grouping data
Using a pivot table in SQL
Subqueries in SQL
Advanced subqueries in SQL

5. Combining Data

Using JOINs
The different types of JOINs
Using VLOOKUP, HLOOKUP, XLOOKUP in SQL

Conclusion

Taking your SQL skills to the next level

Taught by

James Parkin and Madecraft

Reviews

4.8 rating at LinkedIn Learning based on 2943 ratings

Start your review of From Excel to SQL