Practical SQL Skills
4.0 (85 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.
2,494 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Practical SQL Skills to your Wishlist.

Add to Wishlist

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.0 (85 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.
2,494 students enrolled
Created by Gary Kind
Last updated 6/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Construct SQL queries to retrieve data
  • Understand how relational databases work
  • Harness the power of Microsoft SQL Server
View Curriculum
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
28 Lectures
02:33:48
+
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.
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
3 Lectures 17:05
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
About the Instructor
Gary Kind
4.2 Average rating
846 Reviews
41,464 Students
12 Courses
Developer, Author, Marketeer

Gary Kind is a highly experienced IT professional and business owner with over 25 years in and around software development and 20+ years running businesses as an individual and in partnerships.

He has a wide spread of business knowledge working in the SME sector as well as delivering KPI and financial reporting for large corporations. He has spent the past few years combining marketing with IT to cover areas such as pay per click, copywriting and conversion optimisation.