SQL - Beyond The Basics

Go beyond simple database creation and queries into subqueries, variables, functions and more.
4.4 (102 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.
1,723 students enrolled
$50
Take This Course
  • Lectures 44
  • Contents Video: 4.5 hours
    Other: 0 mins
  • Skill Level Intermediate 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 3/2015 English

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

What are the requirements?

  • a working knowledge of SQL fundamentals

What am I going to get from this course?

  • create and interact with SQL databases at an intermediate to advanced level
  • utilize subqueries, variables, custom functions and more

What is the target audience?

  • students who have taken the introductory SQL course or who have a basic understanding of 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: The Warm Up
Important - Download These First - Working Files
Preview
Article
About This SQL Advanced Title
Preview
04:59
Relational Databases And Key Terms Explained
Preview
07:45
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
Section 2: Useful Skills
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
Section 3: The Subquery
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
Section 4: The CASE Statement
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
Section 5: Numbering And Ranking
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
Section 6: Functions
Using Built In Functions
07:35
Creating And Using Your Own Functions (UDF)
05:07
Section 7: Views
Creating A View
05:20
Example Views And Views In Views
05:06
Using The UNION Clause
06:24
Section 8: Stored Procedures
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
Section 9: Conclusions
Wrap Up
06:37

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, 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.

Ready to start learning?
Take This Course