SQL Beyond The Basics

SQL – Beyond The Basics, available at $64.99, has an average rating of 4.25, with 44 lectures, based on 623 reviews, and has 3807 subscribers.

You will learn about create and interact with SQL databases at an intermediate to advanced level utilize subqueries, variables, custom functions and more This course is ideal for individuals who are students who have taken the introductory SQL course or who have a basic understanding of SQL It is particularly useful for students who have taken the introductory SQL course or who have a basic understanding of SQL.

Enroll now: SQL – Beyond The Basics

Summary

Title: SQL – Beyond The Basics

Price: $64.99

Average Rating: 4.25

Number of Lectures: 44

Number of Published Lectures: 44

Number of Curriculum Items: 44

Number of Published Curriculum Objects: 44

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

create and interact with SQL databases at an intermediate to advanced level

utilize subqueries, variables, custom functions and more

Who Should Attend

students who have taken the introductory SQL course or who have a basic understanding of SQL

Target Audiences

students who have taken the introductory SQL course or who have a basic understanding of SQL

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.

Course Curriculum

Chapter 1: The Warm Up

Lecture 1: Important – Download These First – Working Files

Lecture 2: About This SQL Advanced Title

Lecture 3: Relational Databases And Key Terms Explained

Lecture 4: Recap Of SQL SELECT Command

Lecture 5: Overview Of The Other DML Statements

Lecture 6: How To Access Your Working Files

Lecture 7: Installing The Sample Data And Using The Working Files

Chapter 2: Useful Skills

Lecture 1: Converting Datatypes

Lecture 2: Creating A Temporary Table

Lecture 3: The DISTINCT And TOP Keywords In Action

Lecture 4: Indexing To Speed Up Your Life

Lecture 5: Declaring And Using Variables

Chapter 3: The Subquery

Lecture 1: What Is A Subquery?

Lecture 2: Subquery Vs Joins

Lecture 3: Using Correlated Subqueries

Lecture 4: Using The EXISTS Keyword

Lecture 5: Finding Duplicate Records

Chapter 4: The CASE Statement

Lecture 1: Getting Started With The CASE Statement

Lecture 2: Using The CASE Statement With Criteria On Multiple Columns

Lecture 3: Multiple Criteria Within The CASE Statement

Lecture 4: CASE In WHERE, ORDER BY, And GROUP BY Clauses

Lecture 5: CASE In UPDATE And INSERT Statements

Lecture 6: CASE Within Subqueries

Chapter 5: Numbering And Ranking

Lecture 1: Numbering Or Ranking Records In A SELECT Statement

Lecture 2: Filtering Results Based On Numbering Ranking

Lecture 3: Using Numbering Within Groups

Lecture 4: Filtering A Ranked Group To Determine Top N

Chapter 6: Functions

Lecture 1: Using Built In Functions

Lecture 2: Creating And Using Your Own Functions (UDF)

Chapter 7: Views

Lecture 1: Creating A View

Lecture 2: Example Views And Views In Views

Lecture 3: Using The UNION Clause

Chapter 8: Stored Procedures

Lecture 1: What Is A Stored Procedure?

Lecture 2: Creating A Stored Procedure

Lecture 3: Running A Stored Procedure

Lecture 4: Stored Procedures Within Stored Procedures

Lecture 5: The Global Variables @@Identity And @@Rowcount

Lecture 6: Looping With WHILE And IF

Lecture 7: Dynamically Build SQL Statements

Lecture 8: TRY And CATCH For Error Trapping

Lecture 9: Cursors In Use – Part 1

Lecture 10: Cursors In Use – Part 2

Lecture 11: Use Of Transactions

Chapter 9: Conclusions

Lecture 1: Wrap Up

Instructors

Infinite Skills
High Quality Training

Rating Distribution

1 stars: 7 votes

2 stars: 9 votes

3 stars: 70 votes

4 stars: 231 votes

5 stars: 306 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!