Overview
-
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
- Spreadsheets vs. databases
- What is SQL?
- 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
- Using SUM in SQL
- AVERAGE, MIN, MAX, and COUNT in SQL
- Finding unique values in SQL
- UPPER, LOWER, and LENGTH in SQL
- Sorting data
- Grouping data
- Using a pivot table in SQL
- Subqueries in SQL
- Advanced subqueries in SQL
- Using JOINs
- The different types of JOINs
- Using VLOOKUP, HLOOKUP, XLOOKUP in SQL
- Taking your SQL skills to the next level
