Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.
4.3 (1,327 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.
33,326 students enrolled
Start Learning Now
  • Lectures 27
  • Length 3.5 hours
  • 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

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.

What are the requirements?

  • People should have worked with SQL server and know how to query using management studio
  • They should be able to setup their databases and environments.
  • Must be comfortable writing TSQL code and must know basic syntax like SELECT, INSERT, UPDATE etc.
  • If you are an absolute newbie, please watch my previous course titled "Introduction to Databases and Querying"

What am I going to get from this course?

  • Write complex TSQL queries.
  • Know the different TSQL functionalities that exist
  • Write more efficient TSQL code

Who is the target audience?

  • This SQL course is meant for people who have some experience in writing TSQL code. If you are a newbie, I recommend watching my previous course titled "Introduction to databases and Querying". This course covers advanced topics like views, triggers, dynamic queries, pivots etc. If you are an absolute starter, this course is not for you.

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.


Section 1: Introduction

Welcome this course! We revisit some concepts from the previous course (Introduction to Databases and Querying) and walk you through the agenda for this course

Section 2: SQL Views

A brief walkthrough of the concept of SQL views.

SQL Views - Deep Dive into Querying
Section 3: SQL Triggers
SQL Triggers - An Introduction
SQL Triggers - Deep dive into Querying
Section 4: SQL Computed Columns
SQL Computed Columns - An Introduction
SQL Computed Columns - Deep dive into Querying
Section 5: SQL Stored Procedures
SQL Stored Procedures - An Introduction
SQL Stored Procedures - Deep dive into Querying
Section 6: SQL User Defined Functions (UDF)
SQL User Defined Functions - An Introduction
SQL User Defined Functions - Deep dive into Querying
Section 7: 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
Section 8: 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
Section 9: SQL XML data-types
SQL XML Datatype - An Introduction
SQL XML Datatype - Deep Dive into Querying
Section 10: SQL Partitions
SQL Partitions - An Introduction
SQL Partitions - Deep Dive into Querying
Section 11: SQL Dynamic Queries
SQL Dynamic Queries and Pivots - An Introduction
SQL Dynamic Queries and Pivots - Deep dive into QUerying
Section 12: SQL Filestream and Free-Text Search
SQL Filestream
SQL Free-Text Search
Section 13: SQL Geography and Geometry datatype
Geometry and Geography Data Types
Section 14: Conclusion and Next steps
Conclusion and Next Steps

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

I am a coder, manager, educator and a gamer. I love data and analytics. In my day job, I work with database technologies including SQL , Big Data and Tableau. I am passionate about technologies and love coding and managing teams. In my spare time I like to teach Big Data analytics, Databases, Programming etc. I am currently working on certain machine learning and Data Science projects and love to explore more in the Statistics field.

Ready to start learning?
Start Learning Now