Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.

4.40 (12915 reviews)
Advanced Databases and SQL Querying
3.5 hours
Dec 2017
last update
regular price

What you will learn

Write complex TSQL queries.

Know the different TSQL functionalities that exist

Write more efficient TSQL code


This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.

If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.




SQL Views

SQL Views - An Introduction
SQL Views - Deep Dive into Querying

SQL Triggers

SQL Triggers - An Introduction
SQL Triggers - Deep dive into Querying

SQL Computed Columns

SQL Computed Columns - An Introduction
SQL Computed Columns - Deep dive into Querying

SQL Stored Procedures

SQL Stored Procedures - An Introduction
SQL Stored Procedures - Deep dive into Querying

SQL User Defined Functions (UDF)

SQL User Defined Functions - An Introduction
SQL User Defined Functions - Deep dive into Querying

SQL Transactions and Error Handling

SQL Transactions and Error Handling - An Introduction
SQL Transactions and Error Handling - An Introduction (Continued)
SQL Transactions and Error Handling - Deep Dive into Querying

SQL grouping functions and Ranking functions

SQL Grouping Sets and Common Table Expressions
SQL Ranking Functions - An Introduction
SQL Ranking Functions - Deep Dive into Querying

SQL XML data-types

SQL XML Datatype - An Introduction
SQL XML Datatype - Deep Dive into Querying

SQL Partitions

SQL Partitions - An Introduction
SQL Partitions - Deep Dive into Querying

SQL Dynamic Queries

SQL Dynamic Queries and Pivots - An Introduction
SQL Dynamic Queries and Pivots - Deep dive into QUerying

SQL Filestream and Free-Text Search

SQL Filestream
SQL Free-Text Search

SQL Geography and Geometry datatype

Geometry and Geography Data Types

Conclusion and Next steps

Conclusion and Next Steps


May 22, 2023
Excelente, me gusto el curso muy completo, me cuesta un poco el ingles pero pude seguir la clase en general sin problemas.
May 20, 2023
So far so good, although more explanations are needed while introducing concepts. much better though than the introduction to database and sql querying course.
May 17, 2023
Not in depth video but it will give all information so that we can go ahead with any business problems.
April 29, 2023
Content explanation is good, but the subtitles are very very poor and 60% of the words are completely wrong, which has absolutely no match with what is being said in the lecture.
April 8, 2023
The overall content of the course wasn't too bad but I didn't like the fact that the instructor didn't make videos on how to install the necessary programs in order to do the homework questions.
February 26, 2023
Great course for professionals who are learning on the job. There are a lot of concepts and functions of MS SQL and this course puts it all in one place.
February 25, 2023
The information is very good, but there are multiple parts with bad audio and its difficult to listen to and pay attention without getting a headache.
January 19, 2023
I am finding this course really interesting as this course requires pre knowledge and is not wasting time in revising the basic sql queries like select,update delete etc. very knowlegaable and professional till now. Thanks alot...
December 30, 2022
o Curso é muito bom, com vários exemplos práticos, uma sugestão, realizar a tradução desse curso para o idioma português.
December 19, 2022
I learned basic knowledge on these topics according to your posted videos. Good Attempt and try to post more videos.
November 28, 2022
these topics are really helpful easily understandable most of things are covered in this so i rate this as one of the best
November 13, 2022
This is a very good course. Explanation is clear. Highly recommended. Good job course instructor!!!
September 27, 2022
Ive learned a lot thank you :D , usually database handling is not my thing but I needed to know ever strands on it and its basic , Im a front -end developer by the way :D
September 21, 2022
Very useful course on advanced SQL queries and functionality, instructor is wise and full of insights, recommended!
July 26, 2022
The course was very good but I felt like too much was compressed into this course which meant that some of the content was a bit rushed and could have been expanded on a little more.



Advanced Databases and SQL Querying - Price chart


Advanced Databases and SQL Querying - Ratings chart

Enrollment distribution

Advanced Databases and SQL Querying - Distribution chart
udemy ID
course created date
course indexed date
course submited by