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)

Udemy

platform

English

language

Other

What you will learn

Write complex TSQL queries.

Know the different TSQL functionalities that exist

Write more efficient TSQL code

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.

Content

Introduction

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

Reviews

Mauricio

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.

Mwandha

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.

Rohan

May 17, 2023

Not in depth video but it will give all information so that we can go ahead with any business problems.

PHANISHANKAR

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.

Javier

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.

Jason

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.

Kevin

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.

Ananya

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

Eneas

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.

Jhansi

December 19, 2022

I learned basic knowledge on these topics according to your posted videos. Good Attempt and try to post more videos.

Punith

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

NoName

November 13, 2022

This is a very good course. Explanation is clear. Highly recommended. Good job course instructor!!!

Eva

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

Nicola

September 21, 2022

Very useful course on advanced SQL queries and functionality, instructor is wise and full of insights, recommended!

Andy

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.

Charts

Price

Rating

Enrollment distribution

Advanced Databases and SQL Querying - Distribution chart