SQL and Databases for Web Development
Learn the SQL fundamentals needed to be a successful full-stack web developer.
- Writing basic queries
- Calculating aggregates
- Combining data from multiple tables
- Determining web traffic attribution
- Creating usage funnels
- Analyzing user churn
Preview of the test database used in the exercises
LESSON 1 Queries
Learn the most commonly used SQL commands to query a table in a database.
Exercises
-
1. Introduction
-
2. Select
-
3. As
-
4. Distinct
-
5. Where
-
6. Like I
-
6.1 Like II
-
7. Is Null
-
8. Between
-
9. And
- 10. Or
LESSON 2 Manipulation
Get up and running with SQL by learning commands to manipulate data stored in relational databases.
Exercises
-
1. Introduction to SQL
-
2. Relational Databases
-
3. Statements
-
4. Create
-
5. Insert
-
6. Select
-
7. Alter
-
8. Update
-
9. Delete
-
10. Constraints
LESSON 3 Aggregate Functions
Learn how to use SQL to perform calculations during a query.
Exercises
-
1. Introduction
-
2. Count
-
3. Sum
-
4. Max-Min
-
5. Average
-
6. Round
-
7. Group By I
-
8. Group By II
-
9. Having
LESSON 4 Code Challenge: Aggregate Functions
Help the Codeflix streaming video site analyze some of their customer data using SQL aggregates.
LESSON 5 Multiple Tables
Learn how to query multiple tables using joins.
Exercises
-
1. Introduction
-
3. Combining Tables with SQL
-
4. Inner Joins
- 5. Left Joins
-
7. Cross Join
-
8. Union
-
9. With
LESSON 6 Learn Node SQLite
Learn how to use the sqlite3 node package to perform create, read, update, & delete operations on an SQLite database within JavaScript.
Exercises
-
1. Introduction
-
10. Serial Queries
-
11. Wrap Up