- From openclassrooms.com
Retrieve data using SQL
- Self-paced
- Free Access
- Fee-based Certificate
- 4 Sequences
- Intermediate Level
Course details
Syllabus
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
Prerequisite
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.
Instructors
Kurt Schuepfer
Ph.D. from Miami University. Data Scientist. Founder and Chief Strategist at Accelerate Data Academy.
Editor
OpenClassrooms (formerly Le site du Zéro or SdZ) is a website that offers courses about computer science and entrepreneurship. Online courses can be made both by site staff, professors of universities or colleges partner as by its members.
Today, courses are available in several formats: MOOC (Massive Open Online Course), web text, e-book, book and video. The company delivers certifications for certain courses, including one recognized by the state in partnership with IESA multimedia.
Platform
OpenClassrooms (formerly Le site du Zéro or SdZ) is a website that offers courses about computer science and entrepreneurship. Online courses can be made both by site staff, professors of universities or colleges partner as by its members.
Today, courses are available in several formats: MOOC (Massive Open Online Course), web text, e-book, book and video. The company delivers certifications for certain courses, including one recognized by the state in partnership with IESA multimedia.