A gentle introduction to the world of SQL
- Free tutorial
- Rating: 4.5 out of 54.5 (702 ratings)
- 16,742 students
- 57min of on-demand video
- Created by Sean Coyne, Jules Malin
- English
What you’ll learn
- A Basic Understanding of SQL
- How to Query and Filter Data Using SQL
- How to Group and Aggregate Data Using SQL
- Hands On Practice Using SQL
- SQL Challenges
Requirements
- None
Description
Why Learn SQL?
We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.
Take-Away Skills:
In this course, you’ll learn how to communicate with relational databases through SQL. You’ll learn—and practice hands on—how to manipulate data and build queries that communicate with more than one table.
Who this course is for:
- Beginners curious about SQL
- Data analysts, Data Scientists or Data Engineers that want to learn more about SQL
- Those looking to make a move to data science or data engineering
Show less
Course content
6 sections • 5 lectures • 56m total lengthCollapse all sections
Introduction To SQL1 lecture • 13min
- Introduction To SQL13:05
- Setting Up SQL Fiddle1 question
- Quiz4 questions
Basic Queries1 lecture • 6min
- Basic Queries06:18
- Hands On: Selecting Filtering and Ordering Data4 questions
- Quiz3 questions
Aggregate Queries1 lecture • 9min
- Aggregates Queries09:25
- Hands On: Grouping, Aggregating and Using Having4 questions
- Quiz4 questions
Connecting Tables using Joins1 lecture • 11min
- Intro to Joins11:14
- Hands On: Joins3 questions
- Quiz4 questions
Additional SQL Operators1 lecture • 17min
- Additional SQL Operators16:56
- Hands On: Case Statements, Like and Limits4 questions
- Quiz3 questions
SQL Challenges0 lectures • 0min
- Challenge 11 question
- Challenge 21 question
- Challenge 31 question