Lauch School Backend Course Work - LS180 - Database Foundations
This course focuses on the relational model, the SQL language, and how to work with relational databases. We start with SQL and the relational data model, introduce core database concepts such as tables, rows, columns, keys, constraints and joins, and guide you to learn how to interact with databases from various types of applications. Before we depart, we'll also look at query optimization issues.
Schema, Data and SQL
The SQL Language
PostgreSQL Data Types
Working with a Single Table
Loading Database Dumps
More Single Table Queries
NOT NULL and Default Values
More Constraints
Using Keys
GROUP BY and Aggregate Functions
How PortgreSQL Executes Queries
Table and Column Aliases
Relational Data and JOINs
What is Relational Data?
Database Diagrams: Levels of Schema
Database Diagrams: Cardinality and Modality
A Review of JOINs
Working with Multiple Tables
Foreign Keys
One to Many Relationships
Extracting a 1:M Relationship From Existing Data
Many to Many Relationships
Converting a 1:M Relationship to a M:M Relationship