Retrieve data using SQL

Familiarity with variable types (whole number integer: decimal, float, character string, Boolean, date).

If you are unfamiliar with this vocabulary, we highly recommend taking the following course: Think like a computer: understanding the logic of programming.

Part 1 - Represent data using the relational model
1. Get the most out of this course
2. Discover the concept of the relation
3. Identify a key in a relation
4. Choose a primary key among candidate keys
5. Create links between your relations using foreign keys
6. Identify and reconfigure a redundant table
7. Create an association table
Quiz: Test your knowledge on the relational model

Part 2 - Manipulate data using relational algebra operations
1. Filter a relation using projection and restriction
2. Combine relations using set operators
3. Combine two relations using the cartesian product operation
4. Link relations using joins
5. Aggregate rows in a table
6. Understand the importance of keys for joins
Quiz: Test your knowledge on relational algebra operations

Part 3 - Execute simple SQL queries
1. Set up your work environment
2. Create a table with keys
3. Execute queries with SELECT, FROM, and WHERE clauses
4. Execute a union, a difference, and an intersection
5. Join tables with the JOIN clause
6. Aggregate your data using GROUP BY
7. Get Some Practice Executing Simple SQL Queries

Part 4 - Execute advanced SELECT Queries
1. Sort your data using ORDER BY
2. Improve your aggregations using HAVING
3. Search character strings using LIKE
4. Nest queries using IN, ALL, ANY, and EXISTS
5. Understand window functions using OVER and PARTITION BY
6. Get Some Practice Executing Advanced SQL Queries

Certificate

Kurt Schuepfer
Ph.D. from Miami University. Data Scientist. Founder and Chief Strategist at Accelerate Data Academy.