• LOGIN
  • No products in the cart.

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

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.