Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

From Excel to SQL

via LinkedIn Learning

Write review
Scrimba Ad

Get 20% off all career paths from fullstack to AI

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
As big data gets bigger, it's useful to be able to pull insights directly from MySQL. Learn how to apply your knowledge of Excel to gain new skills at capturing data from MySQL.

Syllabus

Introduction
  • Moving from Excel to SQL
  • Setting up your environment for SQL
1. Comparing Excel and SQL
  • Spreadsheets vs. databases
  • What is SQL?
2. 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
3. Working with Functions
  • Using SUM in SQL
  • AVG, MIN, MAX, and COUNT in SQL
  • Finding unique values in SQL
  • UPPER, LOWER, and LENGTH in SQL
4. Organizing Data
  • Sorting data
  • Grouping data
  • Using a pivot table in SQL
  • Subqueries in SQL
  • Advanced subqueries in SQL
5. Combining Data
  • Using joins
  • The different types of joins
  • Using VLOOKUP, HLOOKUP, and XLOOKUP in SQL
Conclusion
  • Taking your SQL skills to the next level

Taught by

James Parkin and Madecraft

Reviews

4.8 rating at LinkedIn Learning based on 216 ratings

Start your review of From Excel to SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.