SQL is a programming language designed for managing and manipulating data in relational database management systems (RDBMS). It is used to perform various operations, such as creating, modifying, and querying databases. SQL is a standard language for accessing, managing, and modifying data in relational databases.
To perform aggregations like finding the average sales per region.
The middle of the bootcamp is where the "Zero" starts to fade away. This is where you learn to combine data from different sources using . Understanding the difference between an INNER JOIN , a LEFT JOIN , and a FULL OUTER JOIN is the moment most students feel their "data superpowers" begin to develop. You’ll also dive into:
Complete SQL Bootcamp 2020: Go from Zero to Hero
Jose Portilla explains concepts step‑by‑step with a calm, steady pace. He uses a movie rental database (DVD rental) throughout, so you work with realistic business data.
Learning how to point at a table and ask for specific information.