Beginner SQL for Data Analytics – No Coding Experience Req'd

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Download the course materials

Chapter 2: Intro to Databases & SQL

Lecture 1: Intro to Databases

Lecture 2: What is SQL

Lecture 3: Why do we need to know SQL

Lecture 4: The required course resources

Lecture 5: MAC USERS – READ THIS FIRST!

Lecture 6: Downloading MySQL

Lecture 7: Downloading the text editor and GUI

Chapter 3: Getting Started with SQL

Lecture 1: Relational databases

Lecture 2: Uploading our database

Lecture 3: Introduction to the GUI

Lecture 4: The basic SQL outline

Lecture 5: Intro to SELECT / FROM

Lecture 6: Using SELECT / FROM pt. I

Lecture 7: Using SELECT / FROM pt. II

Chapter 4: Expanding our Basic Code Outline

Lecture 1: Filtering our data with WHERE

Lecture 2: Using WHERE

Lecture 3: Refining our WHERE with AND / OR

Lecture 4: Using AND / OR

Lecture 5: Refining our OR clauses with IN

Lecture 6: Using IN

Lecture 7: Pulling in ranges of data with BETWEEN

Lecture 8: Pulling unique values with DISTINCT pt. I

Lecture 9: Pulling unique values with DISTINCT pt. II

Lecture 10: Ordering our data with ORDER BY pt. I

Lecture 11: Ordering our data with ORDER BY pt. II

Chapter 5: Arithmetic Functions & Joining Tables

Lecture 1: Arithmetic Functions: MIN / MAX

Lecture 2: Arithmetic Functions: COUNT / SUM / AVG

Lecture 3: Grouping our data with GROUP BY pt. I

Lecture 4: Grouping our data with GROUP BY pt. II

Lecture 5: Intro to joining our tables

Lecture 6: How to join our tables

Lecture 7: Example of joining tables together

Lecture 8: Challenge #1 – Joining tables

Lecture 9: Challenge #1 – Joining tables (solution)

Chapter 6: Using LEFT & HAVING

Lecture 1: Extracting data using LEFT

Lecture 2: Challenge #2 – LEFT MAX & Joining Tables

Lecture 3: Challenge #2 – LEFT MAX & Joining Tables (solution)

Lecture 4: Intro to utilizing HAVING

Lecture 5: Applying the HAVING clause

Lecture 6: Challenge 3 – HAVING

Lecture 7: Challenge 3 – HAVING (solution)

Chapter 7: Grouping on Multiple Items & Temporary Tables

Lecture 1: Challenge 4 – GROUPING on multiple items

Lecture 2: Challenge 4 – GROUPING on multiple items (Solution)

Lecture 3: Challenge 5 – Filtering using WHERE

Lecture 4: Challenge 5 – Filtering using WHERE

Lecture 5: Creating temporary tables pt. I

Lecture 6: Creating temporary tables pt. II

Lecture 7: Challenge 6 – Temporary tables

Lecture 8: Challenge 6 – Temporary tables (Solution)

Chapter 8: Conclusion

Lecture 1: Conclusion

Lecture 2: Final thoughts