Intro to SQL
About
This module is all about learning to use SQL, the go-to language for interacting with relational databases. You’ll learn how to set up tables, manage data through inserting, updating, and deleting records, and how to retrieve information with queries. Whether you’re looking to boost your data analysis skills or develop powerful data-driven apps, these skills are the foundation of learning SQL.
Content
| Lesson | Video Time | Video | Skills |
|---|---|---|---|
| Setup | 2 min | link | Setting up the development environment. |
| Concepts | 4 min | link | Understand the SQL and Relational Databases. |
| Anatomy of a Relational Database | 5 min | link | Explore the anatomy and structure of a relational database. |
| Creating Databases and Tables | 6 min | link | Creating new databases and tables in PostgreSQL. |
| Inserting and Selecting Data | 8 min | link | Inserting and Selecting Data with the WHERE clause. |
| Relating and Querying Data | 15 min | link | Apply conditional logic with the WHERE clause and JOIN data across tables. |
| Modifying and Deleting Data | 4 min | link | Modify and delete data in a database with DELETE. |
| Total content | 44 min | – |