Intermediate T-SQL Querying concepts.

About Course

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.

Skill level: Intermediate Level

Languages: English

Lectures: 27

Video: 3.5 total hours

Course Content

Introduction

Introduction

01:00

SQL Views

Triggers

SQL Computed Columns

SQL Stored Procedures

SQL User Defined Functions (UDF)

SQL Transaction and Error Handling

SQL grouping functions and Ranking function

SQL XML data-types

SQL Partitions

SQL Dynamic Queries

SQL Filestream and Free-Text Search

SQL Geography and Geometry datatype

Conclusion and Next steps

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Introduction

Introduction

SQL Views

SQL views-An Introdution

SQL Views – Deep Drive into Querying

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 Transaction 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 function

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

23. SQL Dynamic Queries and Pivots Deep dive into Querying

SQL Filestream and Free-Text Search

24 SQL Filestream

25. SQL Free Text Search

SQL Geography and Geometry datatype

Geometry and Geography Data Types

Conclusion and Next steps

Conclusion and Next Steps

Student Ratings & Reviews

Quick Link

Resources

Support