SQL Server - Master Class For Data Analysis (Udemy.com)

Very useful course with lots of practical exercises and well structured. For improvement of chapter "SQL for Quantitive Analytics" I would suggest to add more real life examples and coding challenges on the topic of "quartiles" and others. At the same note, in my opinion, there was no need to provide separate lessons for MIN, MAX, SUM and AVG - these functions are pretty obvious, could be covered shortly in one lesson.
In general, the through the course I have heard quite often " I am running out of time for this lesson", as there is some kind of time pressure always. I find this kind of sayings unnecessary for online courses in general.

The quality of the course was excellent. It was in dept and gave me a good confidence in SQL. Content was really good, though some of the concepts like correlated sub-query could have been made more simple.

valuable sql course with good and helpful teacher...for me many new useful analytical functions explanaited...good designed exercises forced you to stop and thinking about...thanks

This is a very practice SQL course aiming data analysis.
Dispite i've been using SQL for years, i've learned some very usefull functionalities. I've enjoyed the content.

Really a great course for data analysts, specifically the Web analytics project. Got to learn a lot of useful analytical functions with day-to-day situations based illustrations.

Fast pace course, many topics covered, good examples, presenting SQL Server abilities. Broad knowledge of the instructor.

I have mixed feelings about this course. What I liked best was that the teaching method is based on real world scenarios and questions. For example, the course will frequently ask you to compile data for the fictitious CFO or policy manager for a specific business purpose. Concepts and methods are explained in reference to a specific task or application and not so much in a formal or theoretical manner. I also appreciated the focus on breaking down bigger questions into smaller parts and on building base queries first. The instructor clearly wants to share his way of approaching problems and his workflow - which is great, because he clearly has tons of valuable experience. The example databases are pretty comprehensive and give you a good sense of "real world data".
On the other hand, I thought that the course could have been structured better. In section 1, there is no comprehensive course overview, for instance. It was also weird to have the data importing and the INSERT/UPDATE/DELETE stuff at the very end, a more conventional approach would have put them at the beginning. The videos felt a bit ad-hoc as well, as a lot of clips will end with reference to the 10 minute time limit (apparently enforced by Udemy!?). I regard it as the instructor's job to script and plan out the videos in advance. The instructor also uses Qlike for data visualization - which clearly produces nice results - but doesn't really explain how to use the included Qlike sample files yourself. If you are not also enrolling in the instructor's Qlike course, the Qlike stuff in this course will hardly add any value at all. While the course has helpful excercises and quiz questions, I was disappointed to see that section 6 towards the end - which features quite complex stuff - doesn't have any.
I also asked the instructor a couple of questions, which one is frequently encouraged to do. Unfortunately, the replies were not all that helpful and left quite a few points unaddressed.

Generally this course has been well built and is super useful for Data Analysis. What can be adjusted more - just some more interesting exercises with using of T-SQL :-) Thank you for a great explanation!

J'avais déjà suivi le premier cours sur SQL, et je n'ai pas été déçu par celui-ci. Il va encore plus loin dans les requêtes, et m'a déjà sauvé la vie plusieurs fois au boulot !!
Le formateur prend le juste rythme, construit les requêtes progressivement pour que l'on puisse suivre. Il propose des questionnaires réguliers, et même quelques projets d'écriture de requêtes un peu plus complexes.
C'est un cours que je recommande chaudement à celui qui est intéressé par le SQL !

Enjoyed the course. Extensive course content for SQL beginners and very well explained. Suggestion would be to include few more lectures on APPLY and Partition.

great course, great instructor. The material was presented clearly and concisely and offered a valuable learning experience. I would have liked to see some practice scenarios pertaining to the final lectures as I found myself replaying lectures and practising on my own in order to fully comprehend the material (ie. LAG() function and computing percentages). Overall, well worth the time

i thought this was a very good course, certainly quite comprehensive, with some solid exercises to help the learning process. I liked some of the detailed explanations and the manner in which the instructor built "foundational" queries and built the solutions bit by bit, very helpful!