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 (69 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,392 students enrolled
Instructed by Gary Kind Development / Databases
$19
$30
37% off
Take This Course
  • Lectures 28
  • Length 2.5 hours
  • Skill Level All Levels
  • 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 6/2013 English

Course 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.

What are the requirements?

  • No previous SQL knowledge is needed or assumed
  • Microsoft SQL Server Express (free download and course explains everything)

What am I going to get from this course?

  • Construct SQL queries to retrieve data
  • Understand how relational databases work
  • Harness the power of Microsoft SQL Server

What 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

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: Introduction and Getting Started
04:48
Introduction to the course and a summary of what we will be covering.
01:07
Run OS X on an iMac or Macbook? Can you run MSSQL on it? Well Yes and No, this video explores your options.
02:36
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.
02:06
We'll go through the installation process for getting MSSQL setup on your machine.
03:20
Having installed MSSQL we now need to setup the AdventureWorks sample database before we can progress.
04:29

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.

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Gary Kind, 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.

Ready to start learning?
Take This Course