SQL : The Hitch Hikers Guide To Writing SQL Queries
4.5 (896 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
19,532 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL : The Hitch Hikers Guide To Writing SQL Queries to your Wishlist.

Add to Wishlist

SQL : The Hitch Hikers Guide To Writing SQL Queries

Get started with the SQL query language and easily master the complexities of Table Joins
4.5 (896 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
19,532 students enrolled
Created by Paul Scotchford
Last updated 4/2017
English
Price: Free
Includes:
  • 3.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Proficiency in Table Join queries
  • A complete understanding of the structure of a SQL query
  • How to write aggregation based queries
  • Prepared and ready to learn more advanced SQL query techniques for data analysis and discovery
  • How to do backups and restores
  • Import raw data ready for analysis
View Curriculum
Requirements
  • No prior knowledge required
  • A Windows PC or (virtual box running Windows e.g. on a Mac) as you will want to code/modify the sample queries
  • Only have a Mac ? You can use Virtual Box, Windows Server Trial edition and SQL 2014 or 16 express.
Description

Greetings to all,

Welcome, this is a SQL course that I am sure you will complete and benefit a lot from. 

The course is aimed at Beginners to Intermediate levels.

It covers all the bases for you to get up to speed with writing SQL before you progress on to more advanced SQL for transforming and analysing data.

I will explain everything step by step and in detail so you get to know SQL very well. 

The course uses SQLServer 2014 express, and we all know the popularity of SQL Server and the thousands of enterprises that use it.

All data and scripts are included (for download) in the course so that you can practice what I teach and more.

You can contact me in the Q&A sections if you have any questions.

Best

Paul

Data Analyst and SQL Developer 

Qld, Australia



Who is the target audience?
  • Anyone looking to start using SQL in their day to day work
  • Newbies to SQL and relational databases
  • Graduates
  • Technical users connecting to database backends
  • Looking to start with foundation skills before getting into advanced SQL
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 27 Lectures Collapse All 27 Lectures 03:34:51
+
Let's get started
4 Lectures 33:31

Let's take a look at what the course will teach you

What is this FREE course about ? it's about SQL !
02:39

Step by step guide to downloading and installing SQL Express 2014.

This software is free to download,install and use.

Download and install SQL 2014 Express
10:40

A brief overview of the UI , where we will construct the SQL queries 

Introduction to the SQL Server management studio
10:31

An overview of what makes a Relational Database and how it is stored in SQL Server

What is a relational database ?
09:41

A quick quiz to ensure you understood this section aok

Pop quiz
5 questions
+
SQL Foundation skills
6 Lectures 58:01

How the SQL query is constructed and why

Anatomy of a query
05:40

This lecture will provide instructions  ...

  • Where the sample scripts and data are
  • How to restore the sample database to the environment
Where are the sample database and script files ?
07:33

How the SELECT statement works

The SELECT statement
10:20

Are you happy with the SELECT statement and it's basic function ?

Practice session with SELECT
2 questions

How to filter the data inside the SELECT statement using the WHERE clause , we also look at using LIKE and comparison operators in our predicate.

We'll also mix these up and look at the OR statement for alternate condition checking. 

As well as many more predicate options !

The SELECT statement with a WHERE predicate
12:13

Test your memory on filtering returned data within the SELECT statement

Practice session with SELECT with a WHERE predicate
2 questions

How to use the Group By clause and we look at how to use HAVING.

In addition we have a look at what the data looks like on a chart in QlikSense, reading tabular data returned from your query is never pretty so let's visualise this to reveal insight!

The Group By clause
12:16

Are you cool with Group By and Having ?

Practice session with Group By
2 questions

Understand the various data types for storing data values and see how Cast() works

A few tips about data types
09:59

Did you understand data types ?

Pop Quiz - Data types
2 questions
+
Table joins, how they work
7 Lectures 54:56

Chapter 3 has a sample database and scripts

Step by Step download and restore of the sample data and scripts

The database demonstrates Primary and Foreign key modelling

Where are the sample database and script files ?
04:06

We will review this database and it's model in the diagram tool, from here we can understand why Primary(PK) and Foreign (FK) Keys are used, we'll also have a look at how to create these keys.

And get a handle on a multi field Primary Key.

Review the Chapter 3 database and model (PK/FK)
11:42

Just checking you are awake :) !

Brain Teaser
5 questions

The workings of the Inner Join statement (aka JOIN)

How to do an Inner Join
11:11

Create a JOIN on the tables Product and ProductSubcategory, select the ProductName,Color and ProductSubcategoryName where the subcategory = 'Jerseys'

Prac time
1 question

The workings of the Left Outer Join statement (aka LEFT JOIN)

How to do a Left Outer Join
08:25

The workings of the Right Outer Join statement (aka RIGHT JOIN)

How to do a Right Outer Join
06:00

The workings of the Full Outer Join statement (aka FULL JOIN)

How to do a Full Outer Join
06:38

Create a FULL JOIN on tables Supplier and ProductSupplier selecting Supplier and the average lead time for the product supplier

Prac time
1 question

The workings and dangers of the Cross Join

Don't make the DBA cross :)

How to do a Cross Join
06:54
+
Transform data using aggregation functions
4 Lectures 33:48

Step by step instructions for download and restore sample database etc

Where are the sample database and script files ?
03:58

Counting data, and an introduction to using the OVER clause for partitioning , which removes the need for Group By when necessary

Counting stuff using the Count() function
11:17

Write a query to return the count of claims where the notification date is in the year 2014 and the claimants age is between 33 and 48

Prac Count()
1 question

Learn how to aggregate data and I will show you the Top(n) statement as well

Adding up using the Sum() function
10:15

Learn to use the Avg() function to calculate the mean value in your rowset

Calculate the mean using the Avg() function
08:18
+
Bonus content to enhance your knowledge
6 Lectures 34:35

Working on the UNION clause

What the heck is a UNION ?
06:25

Inserting to a table is the "C" in the term CRUD (Create-Read-Update-Delete)

In this lecture I will show you a couple of methods to do this

How to insert data to a table
09:20

Introduction to importing raw data files

Importing raw data from non database files
05:07

How to backup a database in SQLServer, backups are your insurance against loss

Backup your database(s)
05:34

Case is like If-Then-Else , lets look at how to code it, there are 2 types of Case statement

How to use the Case statement
08:07

Please review the instructions and follow the steps to receive your certificate.

How to get your Certificate Of Achievement
00:02
About the Instructor
Paul Scotchford
4.5 Average rating
1,334 Reviews
21,661 Students
3 Courses
Data Analyst and Qlik Development Specialist

Hello

I have been a Data Analyst/Engineer for over 20 years specialising in SQL Data Analysis and Development.

I am also an experienced developer in data visualisation using QlikView and QlikSense and my work is predominantly in consulting and specialist analysis projects.

I do have a passion for sharing knowledge with anyone that is interested and wants to learn more about the field of Data Engineering, Visualisations and Quantitative Analysis.

Check out my best value low cost courses, cost should never be a barrier to learning. 

Keep in touch.

Best

Paul