T-SQL Training with Real World Scenarios-Tricks of the Trade_1

T-SQL Training with Real World Scenarios:Tricks of the Trade, available at $74.99, has an average rating of 4.55, with 52 lectures, 3 quizzes, based on 483 reviews, and has 2667 subscribers.

You will learn about Feel more confident in handling real life scenarios and writing complex codes This course is ideal for individuals who are Anyone who wants to enhance his/her knowledge to handle real life situations in T-SQL It is particularly useful for Anyone who wants to enhance his/her knowledge to handle real life situations in T-SQL.

Enroll now: T-SQL Training with Real World Scenarios:Tricks of the Trade

Summary

Title: T-SQL Training with Real World Scenarios:Tricks of the Trade

Price: $74.99

Average Rating: 4.55

Number of Lectures: 52

Number of Quizzes: 3

Number of Published Lectures: 44

Number of Published Quizzes: 3

Number of Curriculum Items: 55

Number of Published Curriculum Objects: 47

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Feel more confident in handling real life scenarios and writing complex codes

Who Should Attend

Anyone who wants to enhance his/her knowledge to handle real life situations in T-SQL

Target Audiences

Anyone who wants to enhance his/her knowledge to handle real life situations in T-SQL

In this online T-SQL training course , a lot of real life scenarios are included which i learnt by practicing on Microsoft SQL Server Technology over the years. I believe this Transact?SQL Programming & Development?video tutorial will deepen the understanding on T-SQL developer and participant will feel more confident in handling real life scenarios. I have covered not only the course contents but also i have covered the real life situations for every topic.

Real Life situations are as follow

How to view the structure of a table?

How to create your own shortcuts in SSMS

Dropping multiple tables in one go having a fixed pattern

Guidelines while performing DML Operations

How to create Solution File in SSMS and what is the need for it

How to insert a row with old identity value which was deleted

How to reset table identity

How to delete duplicate records from a table

How to select only duplicate records from a table

How to produce Date Dimension using Recursive CTE Query

How to Merge New Changes to an Existing Table

What are the advantages of Stored Procedure

BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT

How to produce running totals or cumulative totals?using sql server query

How to compare current year sales with the previous year sales?

How to compare current year sales since the start of the business year sales

How to switch between different SQL Servers within a query window in SSMS

How to use a single sql script file for different SQL Servers

Reducing Roundtrips using Table Valued Stored Procedure

Pagination in SQL Server using OFFSET-FETCH

BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT

Relevance of Batch in SQL Server

How to create and store customized errors

Guidelines of writing a Stored Procedure

Following are the major topics covered?

Deep dive into Window Functions

Ranking Functions –?(Rank, Dense_Rank Row_Number, NTile )

Aggregate Functions –?(Sum,Min,Max,Avg,Count)

Analytical Functions-(Lead , Lag, First_Value, Last_Value)

Stored Procedures

? ??Input Parameters

? ? Output Parameters

? ? Default Parameters

? ? Return

? ? Table Valued Parameters

Common Table Expressions

Recursive Common Table Expressions

Synonyms

Identity Columns

Transactions

Raiserror/Throw

Error Handling (Try….Catch)

Course Curriculum

Chapter 1: Introduction

Lecture 1: How to view the structure of a table & how to create your own shortcuts in SSMS

Chapter 2: Module1 – SSMS & DML Tricks , Solution Files and Identity etc

Lecture 1: Please download Demonstration Exercises 1

Lecture 2: Dropping multiple tables in one go having a fixed pattern

Lecture 3: Theory – Guidelines while performing Update and Delete Operations

Lecture 4: Guidelines while performing Update and Delete Operations

Lecture 5: How to switch between different SQL Servers within a query window in SSMS

Lecture 6: How to create Solution File in SSMS and what is the need for it

Lecture 7: How to use a single sql script file for different SQL Servers

Lecture 8: How to generate Identity Column

Lecture 9: How to insert a row with old identity value which was deleted

Lecture 10: How to reset table identity

Chapter 3: Module 2 – Window Functions (Ranking , Aggregate and Analytical Functions)

Lecture 1: Please download Demonstration Exercises 2

Lecture 2: Theoretical Explanation of Window Functions

Lecture 3: RANK DENSE_RANK ROW_NUMBER NTILE WINDOW FUNCTIONS

Lecture 4: SUM MIN MAX COUNT AVG Window Functions

Lecture 5: FIRST_VALUE LAST_VALUE LAG LEAD Window Function

Lecture 6: Scenarios on Window Functions

Lecture 7: Scenario1 – Solution on Aggregate Window Function

Lecture 8: Scenario2 – Solution on Cumulative totals

Lecture 9: Scenario3 – Solution on Analytical Window Function

Chapter 4: Module 3 – CTE , Recurssive CTE, Coalesce Function & Merge Commands etc

Lecture 1: Please download Demonstration Exercises 3

Lecture 2: How to use window function in the where clause using CTE and Derived Tables

Lecture 3: How to delete duplicate records from a table

Lecture 4: How to select only duplicate records from a table

Lecture 5: How to produce Date Dimension using Recursive CTE

Lecture 6: Hands On Question

Lecture 7: Scenario solved using Coalesce Function

Lecture 8: How to Merge New Changes to an Existing Table

Lecture 9: How to Merge New Changes to an Existing Table using Coalesce Function

Lecture 10: More On Merge Command

Chapter 5: Module 4 – Stored Procedure, Error Handling , Batch ,Pagination and Synonyms etc

Lecture 1: Please download Demonstration Exercises 4

Lecture 2: What are the advantages of Stored Procedure

Lecture 3: INPUT OUTPUT DEFAULT RETURN Options in Stored Procedure

Lecture 4: Hands On Questions on Stored Procedure

Lecture 5: What is a Batch and its need

Lecture 6: BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT

Lecture 7: Guidelines to write a Stored Procedure

Lecture 8: How to create and store customized errors

Lecture 9: THROW and RAISERROR Differences

Lecture 10: Error Handling Exercise for Practice

Lecture 11: Pagination in SQL Server using OFFSET FETCH

Lecture 12: Rename a table with dependencies USING SYNONYMS

Lecture 13: Reducing Roundtrips using Table Valued Stored Procedure

Lecture 14: Bonus Lecture

Instructors

Vikas Munjal
SQL Server | MSBI Microsoft Certified Trainer & Consultant

Rating Distribution

1 stars: 5 votes

2 stars: 10 votes

3 stars: 46 votes

4 stars: 148 votes

5 stars: 274 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!