SQL : The hitch hikers guide to writing SQL queries

Get a head start with writing basic SQL before tackling advanced queries
4.5 (417 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.
12,221 students enrolled
Free
Start Learning Now
  • Lectures 26
  • Length 3.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

Course Description

Hi there,

Welcome to "The hitch hikers guide to writing SQL queries", this is a course that I am sure you will complete and learn a lot. 

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.

Enjoy this course, contact me in the Q & A pages if you have any questions , this is a free course, but you still get the same support as you would if you purchased any of my other courses.

See you in the course.

Paul

Data Analyst and SQL Developer 

Course Release date 20Apr16 Vers 1.0 


What are the requirements?

  • No prior knowledge required
  • A Windows PC or equivalent as you will want to code/modify the sample queries

What am I going to get from this course?

  • Understand the structure of a SQL query
  • Write aggregation based queries
  • Understand joining tables in a query
  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Let's get started
02:39

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

10:40

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

This software is free to download,install and use.

10:31

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

09:41

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

5 questions

A quick quiz to ensure you understood this section aok

Section 2: SQL Foundation skills
05:40

How the SQL query is constructed and why

07:33

This lecture will provide instructions  ...

  • Where the sample scripts and data are
  • How to restore the sample database to the environment
10:20

How the SELECT statement works

2 questions

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

12:13

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 !

2 questions

Test your memory on filtering returned data within the SELECT statement

12:16

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!

2 questions

Are you cool with Group By and Having ?

09:59

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

2 questions

Did you understand data types ?

Section 3: Table joins, how they work
04:06

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

11:42

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.

5 questions

Just checking you are awake :) !

11:11

The workings of the Inner Join statement (aka JOIN)

1 question

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

08:25

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

06:00

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

06:38

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

1 question

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

06:54

The workings and dangers of the Cross Join

Don't make the DBA cross :)

Section 4: Transform data using aggregation functions
03:58

Step by step instructions for download and restore sample database etc

11:17

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

1 question

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

10:15

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

08:18

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

Section 5: Bonus content to enhance your knowledge
06:25

Working on the UNION clause

09:20

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

05:07

Introduction to importing raw data files

05:34

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

08:07

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Hi there,

I am a Data Analyst, QlikView, QlikSense & SQL Developer that has worked with data since 2003 (when I started working with the Microsoft SQL stack) but moved into the QlikView environment in 2012 and commenced working with QlikSense in 2014 whilst it was still a beta release.

I still work with SQL as it is foundation to a substantial amount of my DA work.

Paul

Ready to start learning?
Start Learning Now