English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 24m | 923 MB
Data is powerful, and the ability to access it quickly and accurately is important. In this course, instructor James Parkin helps you use your existing Excel skills to master the basics of working with data in SQL, one of the most common languages for database wrangling. James shows you how to set up your environment for SQL and shares some differences between spreadsheets and databases. He steps through SQL basics that you need to know to access and identify the data you need. In both Excel and SQL, you work with functions. James covers several, including SUM, AVERAGE, MIN, MAX, COUNT. He explains different methods of sorting, grouping, and organizing your data in SQL. James concludes by showing you how to use joins, VLOOKUP, HLOOKUP, and XLOOKUP to combine your data.
Table of Contents
1 Moving from Excel to SQL
2 Setting up your environment for SQL
3 Spreadsheets vs. databases
4 What is SQL
5 Viewing data in SQL
6 Identifying columns in SQL
7 Filtering rows in SQL
8 Combining filters in SQL
9 Limiting results in SQL
10 Comparison operators in SQL
11 The LIKE operator in SQL
12 Using SUM in SQL
13 AVERAGE, MIN, MAX, and COUNT in SQL
14 Finding unique values in SQL
15 UPPER, LOWER, and LENGTH in SQL
16 Sorting data
17 Grouping data
18 Using a pivot table in SQL
19 Subqueries in SQL
20 Advanced subqueries in SQL
21 Using JOINs
22 The different types of JOINs
23 Using VLOOKUP, HLOOKUP, XLOOKUP in SQL
24 Taking your SQL skills to the next level
Resolve the captcha to access the links!