Latest Courses
Beginners Eclipse Java IDE Training CourseCheck course
Xamarin Android - A Master Guide to App Development in C#Check course
Python for beginnersCheck course
Salesforce Integration With External SystemsCheck course
Game Audio 101 & 201: Beginner to Advanced Game Sound DesignCheck course
Xamarin on Steroids: Xamarin Forms Shell and MVVMCheck course
Linux FundamentalsCheck course
Fullstack JavaScript : Learn JavaScript,React ,Node,Mongo DBCheck course
SQL Server 2017 in 90 minutesCheck course
Object Detection Web App with TensorFlow, OpenCV and FlaskCheck course
Beginners Eclipse Java IDE Training CourseCheck course
Xamarin Android - A Master Guide to App Development in C#Check course
Python for beginnersCheck course
Salesforce Integration With External SystemsCheck course
Game Audio 101 & 201: Beginner to Advanced Game Sound DesignCheck course
- 85% T-SQL Training with Real World Scenarios:Tricks of the Trade

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

$99.99 $14.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.8/10 (Our Score)
Product is rated as #23 in category 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

Instructor Details

I am Microsoft Certified Trainer. Having more than 12 Years of rich experience.Successfully self-employed, i am a trusted consultant for businesses large and small. Currently working as a Corporate Trainer & Consultant for SQL Server and Microsoft Business Intelligence . Also worked as a SQL Server Developer. Lives in Delhi,India. My style is to teach in such a way so that student should be able to create images or diagrams of the concept in his/her mind . Because i believe we understand , remember and learn 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 Trainer Microsoft Certified Professional

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

Duration 6 hours
Year 2019
Level Intermediate
Certificate Yes
Quizzes Yes

7 reviews for T-SQL Training with Real World Scenarios:Tricks of the Trade

4.9 out of 5
6
1
0
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Obiajulu Felix–Udneze

    I have taken classes in SQL , finished the course work but couldn’t quite figure out the real life application of things like CTE, Window functions and temp table. This course brakes it down with logic of how T SQL queries are processed. This course deserves a 10 star, thanks Vikas

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    DEEPAM PATEL

    Great

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Komal

    Yes it was definitely a good match. This course gives insights into real world business problems and the use of T SQL for solving them. The instructor has shared these tricks that only a working professional SQL programmer uses on a daily basis to make queries efficient. It was great learning them!!

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Biswa

    Great explanation brother . Keep bringing up more course on sub queries and dynamic sql. Could you make a video on how to loop through a set of record and make update or insert biased on If condition by setting counter .

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Daniel Chen

    The instructor was good. He explained everything very well and in a comprehensive way to allow for a deeper understanding of existing knowledge.

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Vijal Chokshi

    Very good content

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Robert Mansell

    so far very good

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

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

    $99.99 $14.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare