Latest Courses
Deep Learning: Top 4 Python Libraries You Must Learn in 2021Check course
Complete Python Course Beginners To Expert.Check course
Learn PHP and MYSQL(Build a Customer Loyalty Reward System).Check course
Build Real World Data Science And Machine Learning ProjectsCheck course
Basic to Advanced Python & Pandas - Complete GuideCheck course
Ethereum Blockchain Development: Smart Contracts + dAppCheck course
Create freelance marketplace website like fiverr in hindi ?Check course
Deep learning: A Natural Language Processing BootcampCheck course
Master HTML in 60 minsCheck course
Charge payments with Bubble & StripeCheck course
Deep Learning: Top 4 Python Libraries You Must Learn in 2021Check course
Complete Python Course Beginners To Expert.Check course
Learn PHP and MYSQL(Build a Customer Loyalty Reward System).Check course
Build Real World Data Science And Machine Learning ProjectsCheck course
Basic to Advanced Python & Pandas - Complete GuideCheck course
- 85% T-SQL Training with Real World Scenarios:Tricks of the Trade

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

$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 #22 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

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

4.5 out of 5
15
2
2
0
1
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. 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. DEEPAM PATEL

    Great

    Helpful(0) Unhelpful(0)You have already voted this
  3. 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. 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. 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. Vijal Chokshi

    Very good content

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

    so far very good

    Helpful(0) Unhelpful(0)You have already voted this
  8. Josh Mantovani

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  9. Wilson Ciprian

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

    Helpful(0) Unhelpful(0)You have already voted this
  10. Sumit Malik

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

    Helpful(0) Unhelpful(0)You have already voted this
  11. Suryadeep Roy

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

    Helpful(0) Unhelpful(0)You have already voted this
  12. Sukhdev Singh

    Great learning exp

    Helpful(0) Unhelpful(0)You have already voted this
  13. Anshuman Panigrahi

    The course need to be more structured.

    Helpful(0) Unhelpful(0)You have already voted this
  14. Ginger

    Instructor is excellent 🙂

    Helpful(0) Unhelpful(0)You have already voted this
  15. Clarence Mbai

    Simply fantastic

    Helpful(0) Unhelpful(0)You have already voted this
  16. Pooja Sharma

    I really liked the way instructor has explained things. Also really appreciate the shortcuts he tells while demonstrating.

    Helpful(0) Unhelpful(0)You have already voted this
  17. Brandi Knowlin

    Great stuff so far!

    Helpful(0) Unhelpful(0)You have already voted this
  18. Michael Koch

    Very useful course. Great!

    Helpful(0) Unhelpful(0)You have already voted this
  19. Dawit Mirkano

    it is good course to understand some tricks in real time

    Helpful(0) Unhelpful(0)You have already voted this
  20. Jorge Lima Perez

    This course teaches very valuable tips. I recommend it.

    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

    $14.99

    Price tracking

    Java Code Geeks
    Logo
    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare