Advanced Databases and SQL Querying

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 you'll Learn

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

Course Preview

Requirements

People should have worked with SQL server and know how to query using management studio. All videos are recorded in Windows OS. You can however follow this course on Mac/Linux, if you have a Win VM setup
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"

Search This Blog