Practical SQL Skills
4.2 (166 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,800 students enrolled

Practical SQL Skills

SQL: Now learn key SQL skills with SQL Server to boost your career and/or make you more productive in your current job
4.2 (166 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,800 students enrolled
Created by Gary Kind
Last updated 3/2020
English
English [Auto]
Current price: $20.99 Original price: $34.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 11 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Construct SQL queries to retrieve data
  • Understand how relational databases work
  • Harness the power of Microsoft SQL Server
Course content
Expand all 29 lectures 02:35:19
+ Introduction and Getting Started
6 lectures 18:26
Introduction to the course and a summary of what we will be covering.
Preview 04:48
Run OS X on an iMac or Macbook? Can you run MSSQL on it? Well Yes and No, this video explores your options.
What if I'm on Mac?
01:07
Where to download Microsoft SQL Server 2008 Express edition and sample data. Be sure to check out the Links document which has all the download links.
Downloading Microsoft SQL Server
02:36
We'll go through the installation process for getting MSSQL setup on your machine.
Installing Microsoft SQL Server
02:06

Having installed MSSQL we now need to setup the AdventureWorks sample database before we can progress.

The original links are out of date, please see the attached text document which has a link to get AdventureWorks.

Preview 03:20

If you are having trouble with your local instance of Adventureworks use Management Studio you downloaded to connect to a remote instance. This lecture shows you how.

Connecting to a Remote Adventureworks Database
04:29
+ Level 1 Introduction to SQL
7 lectures 34:51
Just some key points to consider before we begin.
Before We Begin
04:21
We'll take a quick look at Management Studio which is the tool we will be using to write our SQL.
A Quick Introduction to SQL Server Management Studio
01:30
Here we will start writing our first piece of SQL
Let's write some SQL!
07:42
Using the ORDER BY clause we can sort our data.
Using the ORDER BY Clause
04:37
How to aggregate data and group it using the GROUP BY command.
Grouping and Aggregating Data
05:51
We will look at the two most common types of join to join 2 tables in one query.
Using JOIN to return data from 2 or more tables
07:19
Here we look at using UNION to join the results of two tables together.
Using UNION to return data from 2 or more tables
03:31
+ Level 2 - Sub-queries, Views and Modifying Data
7 lectures 43:08
A look at using IN and EXISTS with sub-queries.
Sub-queries
05:44
Using the CASE statement we can perform transformation of data.
Conditional Processing using CASE
09:13
Staying with the CASE statement we look at how to turn rows into columns with our data.
Pivoting Data
03:41
Here we look at creating a VIEW and why you would use one.
Using VIEWs
03:21
This lecture looks at how to add records to a table using the INSERT command.
Modifying Data - the INSERT statement
12:11
We can modify existing data in a table using the UPDATE command and we look at examples of how to do this.
Modifying Data - the UPDATE statement
06:34
Use with caution! This is how we DELETE data from our database.
Modifying Data - the DELETE statement
02:24
+ Level 3 - Stored Procedures, Functions, Triggers and Cursors
4 lectures 38:08
We'll look at writing our first stored procedure using TransactSQL.
Stored Procedures
13:52
Here we look at 2 types of functions and how they are used within SQL Server.
Functions
06:54
Triggers
11:46
Finally cursors, what they, why you use them and how you use them.
Preview 05:36
+ Course Wrap-Up
1 lecture 02:10
Summary of what we covered.
What we Covered
02:10
+ Bonus Section
4 lectures 18:36
We take a quick look at using dynamic SQL.
Bonus 1 - Dynamic SQL
02:00
This is an example of using the PIVOT command.
Bonus Lecture 2 - Using PIVOT
07:09
Here we combine using dynamic SQL with the PIVOT command.
Bonus Lecture 3 - Using PIVOT with dynamic SQL
07:56

I know some of you have been having issues connecting, this new video explains how to connect and I have double checked the credentials, everything is setup correctly.

Additional Video for Remotely Connecting.
01:31
Requirements
  • No previous SQL knowledge is needed or assumed
  • Microsoft SQL Server Express (free download and course explains everything)
Description

This course is designed to give a detailed introduction to using and understanding structured query language (SQL) for manipulating business data. More and more companies rely on IT systems that store information in databases. This information is typically retrieved using SQL and its use is becoming widespread amongst not just IT teams but business users also.

The course contains walk through videos, printed documents of the course material as well as links to resources you need to be able to carry out the course.

The course is laid out over 3 levels starting with the very basics and assumes no prior SQL knowledge, right up to level 3 where we will be looking at Microsoft SQL Server specific functionality to really harness the power of a SQL database.

If you need to access any data be it online or within your own company then this course is for you. Financial systems form the hub of any business these days and many job roles require some level of SQL ability. This course will equip you with the knowledge you need to perform these tasks within your business or employment to improve your prospects.

Most business systems utilise some form of SQL database, typically Microsoft SQL Server which is why this course focuses on that particular product. Additionally we can download a free 'express' version of the product to work through the course.

And the unconditional, Udemy backed, 30 day money-back guarantee is not just any old guarantee, it's my personal promise to you that you will succeed ... just like my thousands of other Udemy students.

Who this course is for:
  • An employee working within a business that is looking to use SQL
  • A business owner who needs to better understand and utilise the data being used within their business
  • Someone looking to add SQL to their skills