Day 0. Introduction and download & install Postgres (walkthrough).

Day 1. SELECT, FROM and WHERE.

Day 2. ORDER BY and Table Joins.

Day 3. GROUP BY & Aggregation and the CASE Statement.

Day 4. Date Functions and String Handling.

Day 5. CAST and NULL Handling.

Plus additional bonus training & resources:

Data Career Kickstarter mini-program featuring 4 training videos

1. A video tutorial on the three most commonly user SQL platforms, and what you need to know about them when planning your own SQL learning journey.

2. “Your Skills Matrix” a video seminar covering three highly popular data roles (analyst, engineer and scientist), and two BI roles (analyst and developer) and what you need to break into those roles – technical skills, soft skills and some further insights into those roles.

3. Creating a showcase CV (video training) – What to put in your CV (and what to leave out), what order to list items on your CV, how to lay it all out on the page.

4. “Smash that Interview” – a video guide on what to expect in a technical assessment and how to impress the interviewer / hiring manager. 

Also

SQL Assessment & Feedback – complete our online SQL assessment then receive personalised detailed feedback from Nick on what you need to focus on, and what your next steps should be.

Download and keep PDF versions of al the video training described above.

And that’s not all

Weekly group support calls for one month from your sign-up date.

A one-to-one call with your trainer and mentor to be taken within one month of your sign-up date.

All this for just £97.

“If that’s not incredible value, I don’t know what is.” – Thomas Keane, Senior Data Analyst, Tech Training Institute