The Advanced SQL Server Masterclass For Data Analysis (Udemy.com)

This course, IMO, is intermediate to advanced. If you're just learning SQL, this course might be too much for you. Also, this course is not a code-along. The instructor teaches you a concept, then has prepared exercises for the student to complete on their own. The exercises are where the learning is reinforced, and are far more beneficial than a code along. Overall, this is a great course. The instructor gets straight to the point, there's no fluff in this course, just learning. I give five stars.

Hi Travis, I really got some valuable tricks and methods i can use in my workplace. I really loved the way you showed how correlated subqueries can be so impactful along with use of exist statement. I just have one suggestion, you can improve the SQL optimization section by including how the query planning works & what are the different joins like hash join, lookup join etc to tune the query. I would love that if you can include the extensive section on this. Also, if you could include materalized views.

Definitely one of the best courses I have taken on Udemy and will be a good course to reference back to in the future. There were only a couple exercises where I wish a little more explaination could have gone into why it was solved in the way presented. The last lesson in Dynamic SQL for example, what was shown in the videos was way simpler that what was asked for in the exercises. Being new to Dynamic SQL, it was a large leap for me to actually understand what to do enough to solve the exercises. That being said, those types of exercises were very rare exceptions in the class. This class was great for someone with at least an intermidiate SQL skill level. I took this class to get better at CTEs, Subqueries, Stored Procedures and Temp tables, but the optimizing and programming SQL was still very interesting to me, even if I won't do much of it in my current role as a data analyst. Bottom line, I wouldn't hesistate to take another class from this instructor.

I recently completed an online course on T-SQL, and I must say it was an outstanding experience. The instructor was exceptional, demonstrating deep expertise and an ability to explain complex concepts in a clear and engaging manner. The course materials were top-notch, providing comprehensive coverage of T-SQL topics with well-structured content and practical examples. The exercises greatly enhanced my learning experience, allowing me to apply what I learned in practical contexts. Overall, this course exceeded my expectations. Highly recommended!

If you are looking for an excellent Udemy course that shores up your SQL coding skills and exceeds expectations just like Jose Portilla's Complete SQL Bootcamp: Go from Zero to Hero course, then Travis Cuzick's Advanced SQL Server Masterclass for Data Analysis is the course to purchase and enroll in. Cuzick's video lectures explains SQL window functions, subqueries, common table expressions (CTEs), temp tables, query optimization, and SQL programming in a very easy-to-follow, stepwise, and logical style. Even better, the instructor provides very clear and detailed exercise instructions, knowing well that his students are unfamiliar with the AdventureWorks data set used in this course. Best of all, what I love most about this course is that I have rapidly shored up my SQL coding skills and confidence, especially with regards to my current work projects, and in an open-source and current downloadable version of SQL Server Management Studio. Ben Brooks, the Udemy Advanced SQL Bootcamp instructor, should enroll in this course and take serious notes on how to prepare a high-quality and caliber advanced SQL course. The only aspect that I would like Travis Cuzick to improve is add a video lecture and exercise on triggers in SQL Server. Overall, thank you very much to Mr. Cuzick for putting together the best advanced SQL course on Udemy!

Excellent teaching skills. The material covered was very in-depth. I can say my knowledge is more sound after the experience gotten from the exercises and lessons contained here. NOTE: Just a quick tip for the author and viewers. When editing code in SSMS you can used the SHIFT+ALT+UP ARROW (or DOWN ARROW) to place your cursor to alter code in among several lines simultaneously. Nice trick that will save you some time.

The course is relatively extensive, even though it doesn't have a very high total duration of hours watched, because it manages to handle the topics swiftly without missing any important informations. Even though some explanations are hard to understand, the examples are making it much easier to comprehend the concepts. I finished that course in 5 days, meaning that I was learning at a very fast rate. The only thing that maybe could improve this course is adding a few more exercises that are a little bit harder, because most of them are a bit too simple, but that's just my opinion. I would indeed highly recommend this course to anyone who has a solid foundation of the basics of SQL.

This course is very useful when you reach a good level of understanding and practice doing SQL. One of the best things is it gives you tools to write sql queries during the process with real data. This course will take you to another level of understanding. My only complaint is in some lectures the written query is long and the teacher doesn't have it available to copy paste or at least have a long look at it. Loving the tips and tricks on subqueries, CTE's and Create Table.

This course is so great. I have completed only 95% as of now and I gave first interview for my first switch after working 6 years as a SSIS & SQL developer and I nailed it. I'm writing this review after getting my offer that too in The UK. Thank you so much Travis for such a nice and informative course and explaining it in a very basic manner. Please keep on adding more new advanced topic to this course. Big thumbs up. Keep up the good work. Cheers!!

Exercises ramp up way too much in difficulty towards the last 3rd of the course, that you're better off just skipping them since there's no point getting hung up on questions you won't be prepared to know how to answer. You'll learn a lot from stuff at the beginning but then you won't learn anything after that.