Query company databases with confidence: SELECT and filtering, joins, aggregations, subqueries and CTEs, window functions, date analysis and business case studies in SQL Server and PostgreSQL.
Course Curriculum
| 1. Database Basics | |||
| 1.1 Databases, tables and keys for analysts | 00:09:00 | ||
| 1.2 Installing SQL Server and PostgreSQL | 00:09:00 | ||
| 2. Querying | |||
| 2.1 SELECT, aliases and DISTINCT | 00:10:00 | ||
| 2.2 WHERE, operators and NULLs | 00:12:00 | ||
| 2.3 ORDER BY, TOP and LIMIT | 00:08:00 | ||
| 2.4 String, number and date functions | 00:12:00 | ||
| 2.5 CASE WHEN | 00:09:00 | ||
| 3. Aggregation & Joins | |||
| 3.1 GROUP BY and HAVING | 00:12:00 | ||
| 3.2 INNER, LEFT, RIGHT and FULL joins | 00:14:00 | ||
| 3.3 Self joins and UNION | 00:09:00 | ||
| 4. Advanced SQL | |||
| 4.1 Subqueries | 00:12:00 | ||
| 4.2 Common table expressions (CTEs) | 00:10:00 | ||
| 4.3 Window functions: ROW_NUMBER, RANK, LAG, LEAD | 00:15:00 | ||
| 4.4 Running totals and moving averages | 00:10:00 | ||
| 4.5 Views and stored procedures for analysts | 00:09:00 | ||
| 5. Business Analysis | |||
| 5.1 Cohort and retention analysis in SQL | 00:12:00 | ||
| 5.2 Sales, customer and product analysis case study | 00:15:00 | ||
| 5.3 Final project: answer 20 business questions from a company database | 00:22:00 | ||
Course Reviews
No Reviews found for this course.






Up Academy Data & AI Team