Crisp Metrics

1. What is a Database

2. Install Postgres Database on Mac

4. Install Postgres on Windows

5. Create Table and Insert Statements

7. Prepare the Database

1. Introducing the SELECT Statement

2. Filter Data Using the WHERE Clause + AND & OR

3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN

4. [EXERCISES] WHERE Clause and Operators

5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns

1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation

2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE()

3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT()

3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT()

1. Understanding Grouping

2. GROUP BY & HAVING Clauses

3. [EXERCISES] Using GROUP BY and HAVING Clauses

1. Aliasing Sources of Data

2. Introducing Subqueries

3. Subqueries Continued + [EXERCISES]

4. Subqueries with ANY and ALL Operators + [EXERCISES]

5. [EXERCISES] More Practice with Subqueries

1. Conditional Expressions Using CASE Clause + [EXERCISES]

2. Transposing Data using the CASE Clause + [EXERCISES]

1. Understanding Correlated Subqueries

2. [EXERCISES] Correlated Subqueries Continued

1. Introducing Table Joins

2. INNER and OUTER Joins + [EXERCISES]

3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES]

4. Cartesian Product with the CROSS JOIN

5. [EXERCISES] Joins and Subqueries Continued

6. Creating Views vs. Inline Views

1. Window Functions using the OVER() Clause

2. Ordering Data in Window Frames

3. RANK, FIRST_VALUE and NTILE Functions

4. LEAD and LAG Functions

5. Working with Rollups and Cubes