From Excel to SQL
- Offered byLinkedin Learning
From Excel to SQL at Linkedin Learning Overview
Duration | 2 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
From Excel to SQL at Linkedin Learning Highlights
- 1 exercise file
- 5 quizzes
- Access on tablet and phone
From Excel to SQL at Linkedin Learning Course details
- In this course, instructor James Parkin helps learner use their existing Excel skills to master the basics of working with data in SQL, one of the most common languages for database wrangling
- James shows learner how to set up environment for SQL and shares some differences between spreadsheets and databases
From Excel to SQL at Linkedin Learning Curriculum
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
AVERAGE, 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, XLOOKUP in SQL
Conclusion
Taking your SQL skills to the next level
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?