SQL - Beyond The Basics
4.6 (192 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,156 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL - Beyond The Basics to your Wishlist.

Add to Wishlist

SQL - Beyond The Basics

Go beyond simple database creation and queries into subqueries, variables, functions and more.
4.6 (192 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,156 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • create and interact with SQL databases at an intermediate to advanced level
  • utilize subqueries, variables, custom functions and more
View Curriculum
Requirements
  • a working knowledge of SQL fundamentals
Description

In this SQL - Beyond the Basics training course, expert author Guy Vaccaro will dive deeper into SQL and covers advanced techniques. This course is designed for users that already have experience with SQL. You will start by learning a variety of useful skills, including how to convert datatypes, create a temporary table, and declare and use variables. From there, Guy will teach you about sub queries, the CASE statement, and numbering and ranking.

This video tutorial also covers using built in functions, creating and using your own functions, and creating views. Finally, you will learn about stored procedures, such as how to create and run a stored procedure, loop with WHILE and IF, and dynamically build SQL statements. Once you have completed this computer based training course, you will have expanded your skills and be able to make more efficient use of SQL.

Who is the target audience?
  • students who have taken the introductory SQL course or who have a basic understanding of SQL
Students Who Viewed This Course Also Viewed
Curriculum For This Course
44 Lectures
04:19:13
+
The Warm Up
7 Lectures 32:19



Recap Of SQL SELECT Command
07:38

Overview Of The Other DML Statements
05:29

How To Access Your Working Files
03:22

Installing The Sample Data And Using The Working Files
03:05
+
Useful Skills
5 Lectures 34:10
Converting Datatypes
07:58

Creating A Temporary Table
06:02

The DISTINCT And TOP Keywords In Action
05:20

Indexing To Speed Up Your Life
08:00

Declaring And Using Variables
06:50
+
The Subquery
5 Lectures 28:36
What Is A Subquery?
06:00

Subquery Vs Joins
04:59

Using Correlated Subqueries
07:05

Using The EXISTS Keyword
04:47

Finding Duplicate Records
05:45
+
The CASE Statement
6 Lectures 35:44
Getting Started With The CASE Statement
06:34

Using The CASE Statement With Criteria On Multiple Columns
05:34

Multiple Criteria Within The CASE Statement
06:10

CASE In WHERE, ORDER BY, And GROUP BY Clauses
04:49

CASE In UPDATE And INSERT Statements
06:33

CASE Within Subqueries
06:04
+
Numbering And Ranking
4 Lectures 22:15
Numbering Or Ranking Records In A SELECT Statement
06:20

Filtering Results Based On Numbering Ranking
05:53

Using Numbering Within Groups
04:45

Filtering A Ranked Group To Determine Top N
05:17
+
Functions
2 Lectures 12:42
Using Built In Functions
07:35

Creating And Using Your Own Functions (UDF)
05:07
+
Views
3 Lectures 16:50
Creating A View
05:20

Example Views And Views In Views
05:06

Using The UNION Clause
06:24
+
Stored Procedures
11 Lectures 01:10:00
What Is A Stored Procedure?
08:03

Creating A Stored Procedure
05:34

Running A Stored Procedure
04:55

Stored Procedures Within Stored Procedures
05:28

The Global Variables @@Identity And @@Rowcount
08:06

Looping With WHILE And IF
06:58

Dynamically Build SQL Statements
07:43

TRY And CATCH For Error Trapping
04:30

Cursors In Use - Part 1
06:32

Cursors In Use - Part 2
05:30

Use Of Transactions
06:41
+
Conclusions
1 Lecture 06:37
Wrap Up
06:37
About the Instructor
Infinite Skills
4.4 Average rating
46,717 Reviews
735,163 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.