Advanced Databases and SQL Querying

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

4.37 (13081 reviews)
Udemy
platform
English
language
Other
category
Advanced Databases and SQL Querying
272,454
students
3.5 hours
content
Dec 2017
last update
FREE
regular price

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

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

Pravn
October 31, 2023
Very very nice, good explanation and good for interview purpose. Thank you for the valuable teaching. Wonderful
Vinay
October 9, 2023
Really Good For Who Are Beginners To Learn About SQL & MS SQL SERVER. Good Explanation With Demo Which Helps To Understand More Accurately. Most Important In Whole Course They Covered Main Topic / Points , Which Are Must Known To The Learner Like Partition, Spatial data , file stream, SP's etc....
Praveen
September 5, 2023
I found its a good course to refresh and revise my knowledge. I would expect more in terms of preparing interview for full stack developer or database developer. ( Theory and practical questions both)
Divya
August 11, 2023
I really liked this course covering the various ascents available in the MS Sql. Easy to follow with example queries and assignments. Thanks for putting all the info in this course.
Bo
August 6, 2023
One of the best taught course and instructor on Udemy. Outstanding content and teaching method.' I plan to look for other courses that he teaches and take them!
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.

Charts

Price

Advanced Databases and SQL Querying - Price chart

Rating

Advanced Databases and SQL Querying - Ratings chart

Enrollment distribution

Advanced Databases and SQL Querying - Distribution chart
584648
udemy ID
8/16/2015
course created date
7/7/2019
course indexed date
Bot
course submited by