The Hitch Hikers Guide to writing SQL Queries
SQL 101 - Mastering SQL Table Joins and Writing Queries in SQL Server
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 ...
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.
Awari School of Analytics : Paul Scotchford
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
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
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
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
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
Very easy and understandable.
Very easy and understandable.
Read LessThis 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 LessOverall, 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 MoreOverall, 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 LessGreat
Great
Read Less