2.2 Queries with AND/OR | Break Into Tech

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Data Analytics Certificate Course

Getting Started

Join our Discord Community (1:10)
How to Ask Questions Throughout the Course

Module 1: Introduction to SQL Basics

1.1 Data, Databases, & SQL (4:27)
1.2 Creating & Querying Tables (5:10)
1.3 SQL Challenge #1 (1:09)
1.4 Aggregating Data (3:05)
1.5 SQL Challenge #2
1.6 SQL Project #1: Superstore Analysis
1.7 Create Your SQL Portfolio (We'll Add Projects Throughout the Course!) (2:51)
1.8 Your First Achievement in SQL

Module 2: Advanced SQL Basics

2.1 Intro to Advanced SQL (0:32)
2.2 Queries with AND/OR (3:50)
2.3 SQL Challenge #3
2.4 Subqueries and "IN" or "NOT IN" Operators (5:12)
2.5 SQL Challenge #4
2.6 The HAVING Clause (5:16)
2.7 SQL Challenge #5
2.8 CASE Statements (5:33)
2.9 SQL Challenge #6
2.10 SQL Project #2: Fortune 500 Analysis
2.11 Your Second SQL Certificate

Module 3: Relational Queries in SQL

3.1 Introduction to SQL Joins (6:45)
3.2 SQL Challenge #7
3.3 Inner, Left, Right, and Full Joins (6:20)
3.4 Challenge #8
3.5 Multiple Joins in One SQL Query (8:49)
3.6 Challenge #9
3.7 Project #3: Netflix Database Analysis (8:19)
3.8 Relational Queries in SQL Certificate

Module 4: SQL Bootcamp

4.0 Welcome to the SQL Bootcamp
4.1 RDBMS: Relational Database Management Systems (2:53)
4.2 SQLite Studio Download & Database Setup
4.3 Customer & Order Analytics Project
4.4 Advanced Data Filtering Techniques in SQL
4.5 SQL Order of Execution
4.6 Advanced Customer & Order Analytics
4.7 Spotify Data Analytics Project
4.8 CTEs: Common Table Expressions ("Temporary Tables")
4.9 More CTE Practice with Bike Lane Data
4.10 How to Solve Unique SQL Problems (Window Functions Practice)
4.11 How to use AI to Debug your SQL Queries (ChatGPT Example)
4.12 Additional Practice & Resources
4.13 Final SQL Project
4.14 SQL Test Study Guide
4.15 SQL Test
4.16 Certificate of Achievement in SQL

Module 5: Using Tableau to Visualize Data

5.1 Intro to Tableau (1:49)
5.2 Connecting Tableau to Data (3:41)
5.3 Building a Tableau Dashboard: World COVID Data Project (29:44)
5.4 Tableau Product & Order Analytics Project
5.5 Tableau Product & Order Analytics Project, Part 2
5.6 Tableau Creator Training: Executive Overview Project
5.7 World Happiness Report Dashboard Project
5.8 Certificate of Achievement in Tableau
5.9 Troubleshooting

Module 6: Bringing It All Together

6.1 Excel for Data Analytics (6:16)
6.2 Corporate Analytics Lingo
6.3 RDBMS & Visualization Tools on the Job
6.4 Cleaning Data and ETL
6.5 Your New Updated Resume
6.6 Data Analytics Projects On the Job (7:05)
6.7 Continue Adding to Your SQL & Tableau Portfolios

Your Certificate & Next Steps

You're Ready to Break Into Tech (0:57)

2.2 Queries with AND/OR

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock