Course Description

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.

Data Analyst , Qlik Dev, SQL Dev

Awari School of Analytics : Paul Scotchford

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 teach I 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 QlikSenseProfessionally 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 ServerI 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.SummaryBecause 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.KindlyPaul

Course curriculum

  • 1

    Chapter 1 - Lets Get Started

    • What Does This Course Offer

    • How to navigate this course and it's features

    • How to Download and Install SQL Server Express

    • Introduction to the SQL Server Management Studio User Interface

    • What Is A Relational Database ?

    • Quiz 1 - Just a quick quiz before moving on
  • 2

    Chapter 2 - Foundation Skills

    • Anatomy of a SQL Query (Introduction)

    • How to download and restore your sample data and scripts for this Chapter.

    • The SELECT statement

    • Quiz 2 - Practice your SELECT statement to answer these questions

    • The SELECT Statement Using a WHERE Clause Predicate

    • Quiz 3 - Practice session with SELECT with a WHERE predicate

    • How to Use the Group By Clause

    • Quiz 4 - Practice writing a query using the Group By Clause to answer the presented scenarios

    • Let's Talk About Data Types

    • Quiz 5 - What datatypes do you remember ?

    • Sample Database and Scripts
  • 3

    Chapter 3 - How to Code Table Joins

    • How to download and restore your sample data and scripts for this Chapter.

    • Overview of the Chapter 3 database and the PK, FK Model

    • Quiz 6 - A brain teaser to keep you busy

    • How to do a Inner Join Query

    • Quiz 7 - Write a query to provide the correct answer

    • How to do a Left Outer Join Query

    • How to do a Right Outer Join Query

    • How to do a Full Outer Join

    • Quiz 8 - Write a query to provide the correct answer to the question

    • How to do a Cross Join

    • Sample Database and Scripts
  • 4

    Chapter 4 - Getting Started With SQL For Quantitative Analytics

    • How to download and restore your sample data and scripts for this Chapter.

    • Why do we use the Count Function ?

    • Using the Sum function for aggregation

    • Using the Avg function to find the mean

    • Quiz 9 - Write a query to provide the correct answer to the question

    • Sample Database and Scripts
  • 5

    Chapter 5 - Other things you should know

    • Union clauses explained

    • Introduction to the Insert statement

    • How to Import raw data into your database

    • How to Backup your database

    • Use the Case statement to test for a condition

Reviews

5 star rating

SQL

Bandaru Lakshmi Prasanna

Very easy and understandable.

Very easy and understandable.

Read Less
5 star rating

Pallavi Bhandare

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

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

Read Less
5 star rating

A great introduction to SQL Management Studio

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 ...

Read More

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 tutor for this course, is both knowledgeable and easy to understand.

Read Less
5 star rating

TUMISO SEKHWELA (9405286188083)

Read Less
5 star rating

Great

Kolawole Omolola

Great

Great

Read Less