Getting started
- Introduction
- How to download and install SQL Server 2014 Express
- How to download the course sample data (from Dropbox)
- Navigating SQL management studio
- What is a relational database ?
- Pop Quiz - Key points before the next chapter
Chapter 2 - SQL Basics
- The anatomy of a SQL Query (Primer)
- Download chapter 2 sample database and restore it via the SQL Management Studio
- The SELECT statement
- Practice session using SELECT exercises
- The SELECT statement with a WHERE predicate (Condition)
- Practice session - using SELECT and the WHERE clause excersises
- Let's explore GROUP BY and HAVING to answer a marketing team question
- Practice session - Challenging brain teaser excercises
- What are data types ?
- Pop Quiz - Do you remember the datatypes ?
Chapter 3 - Forming relationships using JOIN's
- Download chapter 3 sample database and restore it via SQL management studio
- Overview of Chapter 3 database and the PK,FK model
- Brain Teaser
- Working with the INNER JOIN (JOIN) statement
- Prac time
- Working with the LEFT OUTER join
- Prac time
- Working with the RIGHT OUTER join
- Prac time
- Working with the FULL OUTER join
- Prac time
- Working with the CROSS join
- Prac time
- Working with the SELF join (Overview)
- Working with the SELF join (Providing initial insight)
- Working with a SELF join (Add value to the insight)
- Working with a SELF join (Finally the last join)
- Prac time
- A CROSS join can be your buddy (Pt 1)
- A CROSS join can be your buddy (Final)
- Brain teaser
- Working with CROSS and OUTER APPLY (Pt1)
- Working with CROSS and OUTER APPLY (Pt2)
- Working with CROSS and OUTER APPLY (Final)
- So you want more eh ?
Getting started with SQL for quantitative analytics
- Download chapter 4 insurance database and restore it via SQL management studio
- Counting by using Count() and OVER()
- Prac count()
- Adding it all up using the Sum() function
- Prac sum()
- Finding the mean with the Avg() function
- Prac avg()
- Using Min() to find first value
- Prac min()
- Using Max() to find the last value
- Prac max()
- Just how do we calculate a median value ?
- Prac median
- Using the CASE...END statement (if,then,else)
- Prac case
- Show me how to calculate quartiles
- Prac quartile
Immerse yourself into SQL analytics project scenarios
- Download and restore the sample Web Analytics database (and scripts)
- Project 1 - Website visitor analysis
- Prac Project 1 (Challenge #1)
- Prac Project 1 (Challenge #2)
- Prac Project 1 (Challenge #3)
- Prac Project 1 (Challenge #4)
- Project 2 - Insurance claims margin analysis
- Prac Project 2 (Challenge #1)
- Project 3 - Ranking customers and products by sales
- Prac Project 3 (Challenge #1 )
- Project 4 - Category performance analysis (time series)
- Prac Project 4 (Challenge #1)
SQL How To Sessions - Coding more advanced SQL analytics
- What is cohort analysis ?
- How do I do cohort analysis in SQL (Pt 1) ?
- How do I do cohort analysis in SQL (Pt 2) ?
- How to analyse customer acquisition in SQL (Pt 1) ?
- How to analyse customer acquisition in SQL (Pt 2) ?
Other stuff you probably should know
- Create database and a table from scratch
- Creating a table from a SQL Query
- How to create a view
- What is a Union query ?
- How to code the insert statement (crud 1)
- How to code the update statement (crud 2)
- How to code the delete statement (crud 3)
- What is date arithmetic and how to code it ?
- Using the case statement to discretize (aka Banding,Bucketizing) data
- How to import raw data from files
- How to obtain your certificate
Qlik Sense Desktop Installation
- How to download/install Qlik Sense desktop and register for a QSD lic file.
