Latest Courses
SQL/ETL Developer - T-SQL/Stored Procedures/ETL/SSISCheck course
ServiceNow IT Service Management (CIS-ITSM) Rome Delta TestsCheck course
React JS - Build 5 Projects With (Redux, React Router, MUI)Check course
Ansible MasteryCheck course
Game Development for beginners with PythonCheck course
Advanced Web Animations with GSAP [ JavaScript SVG CSS ]Check course
R for Data Science: Your First Step as a Data ScientistCheck course
ARM 64-bit Assembly Language with Raspberry PiCheck course
SQL Server Master Series - Beginner CourseCheck course
Build A TodoList with Laravel and ReactCheck course
SQL/ETL Developer - T-SQL/Stored Procedures/ETL/SSISCheck course
ServiceNow IT Service Management (CIS-ITSM) Rome Delta TestsCheck course
React JS - Build 5 Projects With (Redux, React Router, MUI)Check course
Ansible MasteryCheck course
Game Development for beginners with PythonCheck 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

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

4.5 out of 5
23
5
3
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. Dawit Mirkano

    it is good course to understand some tricks in real time

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

    This course teaches very valuable tips. I recommend it.

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

    This course teaches very valuable tips. I recommend it.

    Helpful(0) Unhelpful(0)You have already voted this
  23. Majid Shahikarijani

    teaching method, explanation and real issues are awesome. I believe that this course makes me professional. Thanks mate

    Helpful(0) Unhelpful(0)You have already voted this
  24. Elena

    Great course, difficult things are explained in simple words

    Helpful(0) Unhelpful(0)You have already voted this
  25. Riya Saluja

    I am an average SQL person. Knowing shortcuts, method to create them will help me in expediting my work.

    Helpful(0) Unhelpful(0)You have already voted this
  26. Ashish Kumar Jha

    Good Content

    Helpful(0) Unhelpful(0)You have already voted this
  27. Cherie Topham

    I liked the course but it would have been easier to follow if the code was formatted better

    Helpful(0) Unhelpful(0)You have already voted this
  28. Vinicius Fernandes

    At first I was surprised with the approach quite uncommon compared to other courses I have taken, he presented real cases of workspace with various examples and detailed explanation. It was very useful and thanks for it. Cheers.

    Helpful(0) Unhelpful(0)You have already voted this
  29. Prashant Veer

    Good course for biginners.

    Helpful(0) Unhelpful(0)You have already voted this
  30. Sunil Rao

    Very well explained. The explanations of concepts was very thorough and easy to understand. Most importantly, they were very practical oriented, meaning, the application of the concept in real world was explained and shown via a demonstration. The was I think about data has improved. I highly recommend this course for people wanting to improve their T SQL knowledge.

    Helpful(0) Unhelpful(0)You have already voted this
  31. Sunil Rao

    Very well explained. The explanations of concepts was very thorough and easy to understand. Most importantly, they were very practical oriented, meaning, the application of the concept in real world was explained and shown via a demonstration. The way I think about data has improved. I highly recommend this course for people wanting to improve their T SQL knowledge.

    Helpful(0) Unhelpful(0)You have already voted this
  32. IT Department

    Sometimes a bit of a language barrier, but overall great content and explanations!

    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