1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
From Excel to SQL Preview

From Excel to SQL

With James Parkin and Madecraft Liked by 5,754 users
Duration: 1h 24m Skill level: Beginner Released: 2/2/2021

Start my 1-month free trial Buy for my team

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.

Skills you’ll gain

Meet the instructors

Learner reviews

4.8 out of 5

3,172 ratings
  • 5 star
    Current value: 2,624 83%
  • 4 star
    Current value: 478 15%
  • 3 star
    Current value: 63 2%
  • 2 star
    Current value: 1 <1%
  • 1 star
    Current value: 6 <1%
  • Patrick C. Patrick C.

    Patrick C.

    5/5 February 28, 2025
    Suitable for someone looking to learn SQL basics, with or without an Excel background.
    Helpful · Report
  • Andrew Brown Andrew Brown

    Andrew Brown

    Business Intelligence Analyst. Power BI | Tableau | Domo Power User Certified. Delivering Operational Excellence through Data

    5/5 February 27, 2025
    Excellent
    Helpful · Report
  • Nazanin Ghelichi Nazanin Ghelichi

    Nazanin Ghelichi

    I build GenAI tools for learners, healers, and humans.

    5/5 February 27, 2025
    I haven't used SQL for a while, this course made me like SQL again.
    Helpful · Report

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.

Download on the App Store Get it on Google Play