From Excel to SQL
With James Parkin and Madecraft
Liked by 5,741 users
Duration: 1h 24m
Skill level: Beginner
Released: 2/2/2021
Course details
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.
This course was created by Madecraft. We are pleased to host this training in our library.
This course was created by Madecraft. We are pleased to host this training in our library.
Skills you’ll gain
Meet the instructors
Learner reviews
-
-
Andrew Brown
Andrew Brown
Business Intelligence Analyst. Power BI | Tableau | Domo Power User Certified. Delivering Operational Excellence through Data
-
Nazanin Ghelichi
Nazanin Ghelichi
Data Analyst | Business Intelligence | Machine Learning Enthusiast | Data-Driven Insights | Mathematics
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 5 quizzes
- Learn on the go Access on tablet and phone
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.