From Excel to SQL
1h 25mBeginner2025-07-25
Authors
James Parkin
Software engineer with 20+ years of experience
Madecraft
Full-Service Learning Content Company
Course details
Data is powerful, and the ability to access it quickly and accurately is important. In this course, you will learn how to leverage your skills with Excel to build your understanding of MySQL and how to use it to pull key insights. As more and more companies demand their teams access their own data, skills in SQL are important to your success. Throughout this course, you will explore similarities between MySQL and Excel, as you learn about common SQL functions as a way to motivate and inspire a deeper interest in continuing to build on your skillset.
Skills covered
MySQLDatabase AdministrationSpreadsheetsMicrosoft ExcelDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceMicrosoftSoftware DevelopmentOne-Off
Concepts
Introduction
- Moving from Excel to SQL
- Setting up your environment for SQL
Comparing Excel and SQL
- Spreadsheets vs. databases
- What is SQL
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
Working with Functions
- Using SUM in SQL
- AVG, MIN, MAX, and COUNT in SQL
- Finding unique values in SQL
- UPPER, LOWER, and LENGTH in SQL
Organizing Data
- Sorting data
- Grouping data
- Using a pivot table in SQL
- Subqueries in SQL
- Advanced subqueries in SQL
Combining Data
- Using joins
- The different types of joins
- Using VLOOKUP, HLOOKUP, and XLOOKUP in SQL
Conclusion
- Taking your SQL skills to the next level