Vikas Munjal
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
Courses : 6
Specification: T-SQL Training with Real World Scenarios:Tricks of the Trade
|
32 reviews for T-SQL Training with Real World Scenarios:Tricks of the Trade
Add a review
| Price | $17.99 |
|---|---|
| Provider | |
| Duration | 6 hours |
| Year | 2019 |
| Level | Intermediate |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
$17.99
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
DEEPAM PATEL –
Great
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!!
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 .
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.
Vijal Chokshi –
Very good content
Robert Mansell –
so far very good
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.
Wilson Ciprian –
I like that he goes straight to the point… so far so goo… the claw is intermedian and advance
Sumit Malik –
Clear expalantion. would have been better if more business scenarios were provided
Suryadeep Roy –
the explanations towards the end of the videos are abruptly cut short. It gives away the feeling some incompleteness.
Sukhdev Singh –
Great learning exp
Anshuman Panigrahi –
The course need to be more structured.
Ginger –
Instructor is excellent 🙂
Clarence Mbai –
Simply fantastic
Pooja Sharma –
I really liked the way instructor has explained things. Also really appreciate the shortcuts he tells while demonstrating.
Brandi Knowlin –
Great stuff so far!
Michael Koch –
Very useful course. Great!
Dawit Mirkano –
it is good course to understand some tricks in real time
Dawit Mirkano –
it is good course to understand some tricks in real time
Jorge Lima Perez –
This course teaches very valuable tips. I recommend it.
Jorge Lima Perez –
This course teaches very valuable tips. I recommend it.
Majid Shahikarijani –
teaching method, explanation and real issues are awesome. I believe that this course makes me professional. Thanks mate
Elena –
Great course, difficult things are explained in simple words
Riya Saluja –
I am an average SQL person. Knowing shortcuts, method to create them will help me in expediting my work.
Ashish Kumar Jha –
Good Content
Cherie Topham –
I liked the course but it would have been easier to follow if the code was formatted better
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.
Prashant Veer –
Good course for biginners.
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.
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.
IT Department –
Sometimes a bit of a language barrier, but overall great content and explanations!