• Free

Intro to SQL

  • Course
  • 14 Lessons

Learn the fundamental commands and functions within SQL! Even if you have zero experience using SQL, this course will make you feel more confident in your database querying abilities. Course Length: 70 Minutes

Want to start learning SQL? This is the course for you!

In this course, you will learn some of more fundamental functions within SQL, such as:

  • SELECT/SELECT DISTINCT/FROM

  • WHERE/AND/IN/BETWEEN/OR/NULL

  • COUNT/SUM/AVG/MIN/MAX

  • ORDER BY/LIMIT

  • GROUP BY/HAVING

  • Lookup Functions

SQL is one of, if not, the most important technical tool any aspiring analyst should learn. Having the ability to select and find data within databases is a skill that can truly take your analytics career to the next level!

Contents

Introduction

Welcome!
Course Dataset
Intro to SQL PowerPoint Slides

Intro to SQL (Part 1)

What is SQL?
Installing BigQuery
Selecting Data
Filtering Data

Mid-Course Assessment

Mid-Course Assessment

Intro to SQL (Part 2)

Sorting Data
Aggregating Data
Grouping Data

End-of-Course Assessment

End-of-Course Assessment

Conclusion

Submit your Info for the Leaderboard
Thank you!

Meet your Instructor

Chris French

CEO at DataFrenchy Academy, Senior Analyst at Spring Health

Hi everyone! As a current senior analyst with 5+ years of data analytics experience, I thoroughly enjoy helping others navigate the data analytics world. My goal is to always bring 100% effort into anyone who wants to make a difference in their career and life. I look forward to working with you!