SQL Master Class For Data Analysis (Udemy.com)

One of the best SQL courses I have taken by far. First I took the basic free introduction course provided by the instructor, which made me very interested to take the full course (this one). I highly recommend this course because: - The instructor (Paul) is a subject matter expert and provides precise instructions and detailed explanation for each topic. - He does a great job with his systematic approach to dissect a problem into smaller logical pieces, and gradually build up the queries. - He has also provided sample databases for hands-on exercise, which is great since you'd see your results to be identical to what he shows in the videos. - The Quizzes and Practice segments are great opportunities to apply what you have learned at each stage. * The only issue I had was the installation of SQLServer 2014 on Win10 that failed a few times due to .NET version conflict, which I finally resolved by installing the latest SQLServer 2022. As Paul mentioned in one of the first videos, all the queries discussed in this course are compatible with later versions of SQLServer (I verified them during my exercise). Thank you Paul for this great course! I found it very helpful and I learned new tricks and techniques! The great amount of positive energy you spent on creating this course is well-spent! Kudos!

I absolutely loved the course by instructor Paul Scotchford, as it provides excellent content for anyone seeking to enhance their skills in data analysis and SQL programming. The course delves into the intricacies of data analysis, enabling learners to identify patterns and behaviours within datasets. It covers expert-level coding techniques for quantitative analysis using complex functions, while also emphasizing the importance of developing a solid foundation in database management. Additionally, the course extensively covers the relational database model and equips learners with the ability to make data-driven decisions in their respective professional settings. With comprehensive explanations and practical exercises, including complex apply joins, this course is highly recommended for aspiring data analysts seeking proficiency in SQL programming.

I chose this course because my role changed and I needed to upskill. The databases used in this course are great and applicable to a variety of verticals like insurance or an online retailer. Thankfully, we never see the old go-to Adventure Works or Employee.employee examples that have been overdone elsewhere. The course is well organized up until the final section, but if you've gone through the course, it will be easy to pick up. I learned quite a bit and think you will too! Paul is very responsive to questions, so if you get stuck don't be kept back thinking you won't get your question answered until next week.

Paul sure knows his thing, and I can see he is passionate about data analysis. I loved that the course is full with pracs where I could see if I fully understood what was done in the video lectures. I loved that during the course I could get the real-life feeling that I am already working at my new job because there were various databases prepared and I could do real analysis with real data, not just type the code. This course is stuffed with useful staff and I definitely recommend it. Thank you, Paul!

Excellent course that beginners and mid-level pros alike can benefit from. This is an actual class rather than a high-level overview. You are going to learn how to query from Paul, and to query well. If a pure beginner, I recommend first reading a few articles on relational databases (Wikipedia is fine, don't go buying a book). If you have intermediate experience in Excel or a little experience in SQL, you can hit the ground and be querying with confidence in a few weeks (the most advanced concepts will take more time, of course). The key to learning SQL is to slow down and let the concepts sink in. Paul understands this and teaches in a clear and friendly manner, drawing examples from his own career. This is like having a senior analyst or DBA acting as your private tutor. Many SQL courses include a lengthy history of the language or simplistic examples that don't prove useful at work. This class has no such filler and instead shows you how to write the most frequently used queries in business and marketing. Let's say you need to do a cohort analysis. If you're like a lot of people, you may spend up to 2 hours on it in Excel, using multiple formulas and workbooks that make your PC crash. This course will teach you how to do the same analysis in SQL Server in a tenth of the time, and how to create a query that can be used again and again, with only minor adjustments to date ranges, for example. If you are a working analyst or other data professional then this is the kind of detail that will prove invaluable. So take your time and be prepared to repeat some of the modules, and you will soon be able to solve problems with SQL and put it on your resume.

Having been using SQL for a while, I was looking for a course in analytics, which I believe will be the next step for my job. This course fit the bill perfectly. There was a basic review of joins, which was helpful for one who is self-taught. Then came the analytics, along with practical projects. Cohort analysis was particularly useful, since I had no idea what that was. Well, maybe I knew the concepts a bit, but not the terminology. All was very useful and applicable to my current job. The instructor keeps us engaged and the projects are interesting. He even throws in "some other stuff you probably should know". Even though I knew most of that, I did discover some useful tips (truncate table!). Highly recommended!

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 !

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 course contains quite a bit of valuable information. I found the pace to be conducive to learning. The practice exercises reinforced the lectures. I think there is value to introducing the concept of visualization but I think that if there are going to be repeated references, the process of creating a visualization should be included. There were a few minor inconsistencies in the quizzes (e.g. Quiz 17 and view definition in Quiz 22) but most supporting information was consistent.

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.

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