__STYLES__

/

/

SQL for Beginners

SQL for Beginners

MAVEN CRASH COURSE

MAVEN CRASH COURSE

MAVEN CRASH COURSE

SQL for Beginners

SQL for Beginners

SQL for Beginners

Alice Zhao

SQL

15 minutes

Beginner

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:

  1. Relational databases

  2. Queries

  3. SELECT

  4. FROM

  5. WHERE

  6. GROUP BY

  7. HAVING

  8. ORDER BY

  9. LIMIT

  10. COUNT

  11. DISTINCT

  12. 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

Alice Zhao

Data Science Instructor

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.

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.

Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.