The Hitch Hikers Guide to writing SQL Queries

SQL 101 - Mastering SQL Table Joins and Writing Queries in SQL Server | taught by Awari School of Analytics : Paul Scotchford
Enroll for free
Kolawole Omolola

Great

Great

Pallavi Bhandare

This course created interest for SQL in me & I am enthusiastic to look forward to new courses like these.

Alex Wilkinson

A great introduction to SQL Management Studio

Overall, this course serves as a great starting point into the use of SQL for data analysis. The content is broken up into bite-sized chunks, which enables learners to do a little bit of training whenever they a spare half an hour, and Paul, the ...

Kolawole Omolola

Great

Pallavi Bhandare

This course created interest for SQL in me & I am enthusiastic to look forward to new courses like these.

Alex Wilkinson

Overall, this course serves as a great starting point into the use of SQL for data analysis. The content is broken up into bite-sized chunks, which enables learners to do a little bit of training whenever they a spare half an hour, and Paul, the ...

Awari School of Analytics       :          Paul Scotchford
Awari School of Analytics : Paul Scotchford
Data Analyst , Qlik Dev, SQL Dev

About the instructor

Hello and Welcome,

My name is Paul Scotchford and I am thrilled that you are reading this.

As well as my normal consulting work in Australian business and govt I teach here at the Awari School of Analytics. 

There are 3 very distinct technology specialisations I work with and these are the QlikView, QlikSense and SQL Server for delivering Data Analytics and Visualisations.

QlikView and QlikSense

Professionally I have been delivering QlikView  solutions to business and government users for the past 5 years and QlikSense since it first released in 2014. Qlik delivers these products to the market and is an industry leader in the BI and Analytics world.

SQL Server

I have been delivering data analytics with the SQL Server (Tech Stack) for more than 14 years as this technology (in my humble opinion) is the best Relational Database and Data Warehouse (Mart) product on the market and will continue to be well into the future.

Summary

Because of my passion and experience working with these technologies in the real-world you can be assured that you will be getting first class training from my courses here on Awari School of Analytics.

I am super stoked and looking forward to sharing my ongoing experience and passion for data analytics with you. 

Looking forward to seeing you in one of my courses soon.

Kindly

Paul

LinkedIn Tweet Blog

The biggest challenge when writing SQL is to truly understand how table joins are implemented when engaging with the relational data model in a SQL database.

During my career I have met many people that have struggled at times with the notion of working around the complexities of the SQL Query Language most predominantly the struggle is around Table Joins.

Table Joins can be very confusing as they become more complex, especially when mixing the join types into a single query construct.

But if you practice and master the basic tenets of relating tables together through join statements then the rest of your SQL life will get easier.

This FREE course will teach you all about SQL Joins and other interesting topics to help with enhancing your SQL skills and make your day to day data tasks flow more fluently.

We will cover all of the join types SQL offers, your confidence in writing SQL queries as part of your career skill will increase significantly, in addition the course is free of charge and you will have lifetime access so you can reference it at anytime to refresh your knowledge.

The course is presented as a combination of ...

  1. Whiteboard diagrams
  2. Video Lectures with actual code
  3. Practice exercises for download
  4. Optional test quizzes to challenge your knowledge
  5. A Certificate of Achievement at course completion (All Practice Activities and Quizzes should be completed to receive a certificate)

This course is presented using SQL Server Express 2014 and later versions.

Microsoft provides SQL Server Express for free, I will show you how to download and install it in Lecture 2.

You have nothing to lose and everything to gain by enrolling in this course, I look forward to teaching you SQL.

Course Contents

27 Videos
9 Quizzes
3 Downloads
24.0 hrs

Course Curriculum