Expires in:
1D
19M
21S
MAVEN CRASH COURSE
MAVEN CRASH COURSE
MAVEN CRASH COURSE
Beginner SQL: Analyzing Student Records
Beginner SQL: Analyzing Student Records
Beginner SQL: Analyzing Student Records
SQL is a skill that every data professional should have in the arsenal.
And the best part? ANYONE can start learning SQL in just a matter of minutes – for free!
In this video, we'll cover 12 basic SQL concepts for the complete beginner:
Relational databases
Queries
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
COUNT
DISTINCT
LEFT JOIN
…all in less than 15 minutes! We use MySQL Workbench in this tutorial, but the code will run in any SQL editor.
Course Outline
Introduction
0:15
What is SQL?
0:47
What is a relational database?
0:56
SQL editors
2:08
Demo data
2:23
SELECT & FROM
2:37
WHERE
3:51
ORDER BY
4:50
GROUP BY
5:38
HAVING
7:44
The Big 6
9:29
LIMIT
10:50
COUNT
11:15
DISTINCT
12:00
LEFT JOIN + more...
13:05
Course Outline
Introduction
0:15
What is SQL?
0:47
What is a relational database?
0:56
SQL editors
2:08
Demo data
2:23
SELECT & FROM
2:37
WHERE
3:51
ORDER BY
4:50
GROUP BY
5:38
HAVING
7:44
The Big 6
9:29
LIMIT
10:50
COUNT
11:15
DISTINCT
12:00
LEFT JOIN + more...
13:05
Course Outline
Introduction
0:15
What is SQL?
0:47
What is a relational database?
0:56
SQL editors
2:08
Demo data
2:23
SELECT & FROM
2:37
WHERE
3:51
ORDER BY
4:50
GROUP BY
5:38
HAVING
7:44
The Big 6
9:29
LIMIT
10:50
COUNT
11:15
DISTINCT
12:00
LEFT JOIN + more...
13:05
About your instructor
About your instructor
Alice Zhao
Lead Data Science Instructor
Alice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She has taught numerous courses in Python, SQL, and R as a data science instructor at Maven Analytics and Metis, and as a co-founder of Best Fit Analytics.
Recommended
learning:
Explore more crash courses
Data Storytelling: How To Bring Data to Life
Data Storytelling: How To Bring Data to Life
Chris Dutton
Chris Dutton
Career
13 min
Beginner
The Data Analysis Framework
The Data Analysis Framework
Chris Dutton
Chris Dutton
Career
7 min
Beginner
Data-Driven Decision Making
Data-Driven Decision Making
Chris Dutton
Chris Dutton
Career
5 min
Beginner
FOR INDIVIDUALS
Master modern data skills
Start learning for Free. No credit card required. Master skills in data literacy, Excel, Power BI, SQL, Python and more.
FOR COMPANIES & TEAMS
Train your team in data
Create your team account today, request a demo, or start with a team assessment today.
FOR INDIVIDUALS
Master modern data skills
Start learning for Free. No credit card required. Master skills in data literacy, Excel, Power BI, SQL, Python and more.
FOR COMPANIES & TEAMS
Train your team in data
Create your team account today, request a demo, or start with a team assessment today.
FOR INDIVIDUALS
Master modern data skills
Start learning for Free. No credit card required. Master skills in data literacy, Excel, Power BI, SQL, Python and more.
FOR COMPANIES & TEAMS
Train your team in data
Create your team account today, request a demo, or start with a team assessment today.
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER