Skip to content
Write a review
UdemySQLPaid courseIntermediate levelCertificate

T-SQL Training with Real World Scenarios:Tricks of the Trade (Udemy.com)

Transact SQL Query Programming & Developer Advanced Microsoft SQL Server Online Video Training Course by Vikas Munjal

4.5
515 reviews

Created by: Vikas Munjal

Last updated December 2024

icon
What you will learn

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

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.5 out of 5higher than 48% of them
  • Reviews515#205 of 389 by number of reviews
  • Length6.1 hoursshorter than 51% of them
  • Last updatedDecember 2024more recently than 61% of them

icon
Course Description

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 TransactSQL Programming & Developmentvideo 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 totalsusing 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)

Who this course is for:
Anyone who wants to enhance his/her knowledge to handle real life situations in T-SQL
Read More Intermediate Intermediate Level product length iconTime: 6.1h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Vikas Munjal

Having more than 12Years of rich experience.Successfully self-employed, i am a trusted consultant for businesses large and small.Currently working as a Corporate Trainer & Consultant forSQL Serverand MicrosoftBusiness Intelligence.Also worked as a SQL Server Developer.Lives inDelhi,India.
My style is to teach in such a way so thatstudent should be able to createimages or diagrams of the concept in his/her mind . Because i believe we understand , rememberandlearn all the things in pictures , diagrams or images . This is the science of learning.
My Microsoft Certifications are:
Microsoft Certified Solution Expert Data Platform
Microsoft Certified Solution Expert Business Intelligence
Microsoft Certified Solution Expert Data Management and Analytics
Microsoft Certified Solution Associate SQL Server 2012/2014
Microsoft Certified Professional

Read More

icon
More courses by Vikas Munjal

$19.99

$12.99

$10.99

All courses by Vikas Munjal

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

All SQL courses

icon
Reviews

4.5

515 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Suryadeep Roy on 10/17/2020

the explanations towards the end of the videos are abruptly cut short. It gives away the feeling some incompleteness.

By Clarence Mbai on 10/6/2020

Simply fantastic

By Sukhdev Singh on 10/5/2020

Great learning exp

By Ginger on 10/2/2020

Instructor is excellent :)

By Anshuman Panigrahi on 10/1/2020

The course need to be more structured.

By Sumit Malik on 9/23/2020

Clear expalantion. would have been better if more business scenarios were provided

By Josh Mantovani on 9/18/2020

Dude has an incredibly thick Indian accent and tends to start raising his voice in to the microphone often. This ends up with him basically yelling at us occasionally and it is very difficult to listen to.

By Wilson Ciprian on 9/12/2020

I like that he goes straight to the point... so far so goo... the claw is intermedian and advance

By Ferenc Fekete on 8/23/2020

Bad accent, lame "tricks"

By Mark Stevens on 8/15/2020

Great information in this course.

By Ankita Tripathi on 8/11/2020

Well explained

By Vijit Kumar on 8/1/2020

It is an excellent course content with real life scenario. I am Very Satisfied. And good practical examples for real life scenarios.Nicely explained each & everything and in a comprehensive way to allow for a deeper understanding of existing knowledge.

Showing 12 of 64 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

T-SQL Training with Real World Scenarios:Tricks of the Trade
Visit course on Udemy Write a review
  • Video Duration: icon 6.1h
  • Price: $69.99
  • Provider: icon Udemy
  • Updated: icon December 2024
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com