SQL Basics Course

What you will learn in 6 lessons

1. 1

   Relational Database Model

   Start here

   Explain how relational databases organize data in tables with rows, columns and keys, and read a simple database schema.

   5 learning goals

   What you will learn

   1. 1.Explain what databases and database management systems do
   2. 2.Read data organized in tables, rows and columns
   3. 3.Choose data types and handle missing values
   4. 4.Identify rows with keys and connect tables
   5. 5.Read and use a database schema
2. 2

   SQL SELECT

   Retrieve, filter and sort rows with SELECT, WHERE and ORDER BY, and combine conditions to answer questions about one table.

   6 learning goals

   What you will learn

   1. 1.Retrieve data with SELECT and FROM
   2. 2.Filter rows with WHERE
   3. 3.Match lists, ranges and text patterns
   4. 4.Work with missing values (NULL)
   5. 5.Sort and limit query results
   6. 6.Answer questions about one table
3. 3

   SQL CASE and Functions

   Build calculated columns with arithmetic, string and date functions, handle missing values and classify rows with CASE expressions.

   5 learning goals

   What you will learn

   1. 1.Build calculated columns with expressions and aliases
   2. 2.Handle missing values with NULL logic and COALESCE
   3. 3.Clean, combine and take apart text with string functions
   4. 4.Work with dates and times
   5. 5.Classify rows with CASE expressions
4. 4

   SQL GROUP BY

   Summarize data with aggregate functions, group rows with GROUP BY and filter groups with HAVING.

   5 learning goals

   What you will learn

   1. 1.Summarize data with aggregate functions
   2. 2.Group rows and summarize each group
   3. 3.Filter grouped results with HAVING
   4. 4.Calculate exact and well-rounded results
   5. 5.Answer business questions with summary queries
5. 5

   SQL Joins

   Combine data from related tables with inner and outer joins, and query one-to-many and many-to-many relationships.

   6 learning goals

   What you will learn

   1. 1.Understand how a join combines related tables
   2. 2.Combine matching rows with inner joins
   3. 3.Keep unmatched rows with outer joins
   4. 4.Join a table to itself and to every row of another
   5. 5.Query many-to-many relationships and chains of tables
   6. 6.Avoid duplicate rows and other join pitfalls
6. 6

   SQL CREATE TABLE

   Create tables with constraints and change data safely with INSERT, UPDATE and DELETE.

   6 learning goals

   What you will learn

   1. 1.Create tables with suitable column types
   2. 2.Protect data with constraints
   3. 3.Add rows with INSERT
   4. 4.Change and remove rows with UPDATE and DELETE
   5. 5.Group changes into transactions
   6. 6.Change table structure with ALTER TABLE and DROP TABLE