Unit 3: Intro to SQL: Querying and managing data
About this unitLearn how to use SQL to store, query, and manipulate data. SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations.
We'll show you the basics of creating tables and selecting data in various different ways.
Learn how to perform more advanced SQL queries using AND/OR, IN, LIKE, HAVING, and more.
Learn how to store related data in multiple tables and use joins to bring them together (inner joins, outer joins, and self joins).
Learn how to update data, delete data, and change table schemas with SQL commands UPDATE, DELETE, ALTER, and DROP.