Advanced SQL Bootcamp (Udemy.com)

Very detailed course with many examples and excercises. I learned a lot and I recommend this training.

I liked it. Very easy to follow along. Lectures were thorough. Good example problems.

Very complete course. I highly recommend to take the previous course before this one. All th basics are covered

This course was really helpful i wish MS SQL Server had this kind of functionality. The lessons were clear and concise to follow there were times i needed to rewatch videos but overall great course.

Negative: > The course is not taught by Jose, which is a misleading representation. The description should read 'Pierian Data' as Instructor > The volume is really low. Even on full speaker it's barely audible on my laptop > There is a considerable gap in level (pace and content) between the introductory course on SQL by Jose and this one > There is no introduction on the particular database the instructor uses. I created an ERD (Entity Relationship Diagram) myself in pgAdmin to explore the database, but that was only necessary because there was no sense of overview given by the instructor > It doesn't feel passionate, it feels rather factual. This could partially be due to the low volume > There could be much more use cases ('why do I need this?') for the concepts introduced, rather than only examples ('this is how you would do it'). It remains unclear why some of these concepts are useful > There are no hints for exercises, like in the introductory course, making it more demotivating doing those exercises Positive: > Most of the concepts are flawlessly explained, which is admirable given the level of the content

The previous course (or any other beginner SQL course) is definitely recommended before doing this one, as there is a step up in terms of material and exercises. The exercise format took a little while to get used to, there are no hints or support (there are of course answers/solutions afterwards, to check your knowledge). You get provided with 3-4 questions that you have to solve, after each chapter and that's it. It is expected that you familiarise yourself with the tables and table structure on your own - either by looking through the tables and running some basic queries or asking your SQL tool to make a hierarchy table. There is no hand-holding here. The course gets much easier towards the 50% mark, as by this time, you have seen the tables quite often and have a sense of where data is in each table and on which primary keys they can be joined together. Once you get used to this, however, it's actually quite empowering. This is exactly how questions come to me at work (the people requesting data often have no idea which tables the data is in - nor do they provide hints or clues as to where the data is or what method you should use to extract the data). It definitely feels great once you find the answer / data you need. I would say, if you stick with this course and do the exercises as intended, you will learn more that in other courses where you are provided tips/hints and more support - as these often become a crutch without you realising it. Personally, I also found that some of the information could have been presented in better ways. I find it very helpful to visualise what each SQL function does - especially for things like joins - so more diagrams would have been great. However, just like in real life, when I thought the material could have been explained further or if I had questions that weren't answered, Google and Stack Overflow provided the additional context I needed. It's also worth mentioning that this course deals exclusively with medical data. If that isn't your thing, then you might not like it. The course instructor is very knowledgable in this domain. Personally, I found it refreshing to experience a different domain than what I'm used to. Ultimately, after this course, I definitely have felt an improvement in my SQL skills and my confidence using SQL at work.

I think the only fall back in this course would be the course taker's unfamiliarity to the data he is working with. In some cases, you would feel falling short in completing the exercise due to this fact rather than the complexity of some queries he is presenting. Besides at my first attempt, I stopped this course @ 20% as there were stuff way over my league. I decided that completing a foundational postgreSQL course would be a good idea. Only after that I was able to complete all the way thru.

I've had much experience with other DBs (MS Access, MS SQL Server, Informix, Oracle) while working (I'm a retired systems developer), so much of the course was 'old hat' to me. Some thoughts based on experience with this course compared to other courses that I felt were highly rated: The lecturer had a lot of good knowledge about the subject and database and presented most of it well. .A more basic set of tables would have been useful. I noted in Q&A, a number of students seemed overwhelmed about where to get information from the tables. I had to jack up the volume (most videos I set to 25-30) to 60 in order to clearly hear the lecture. It would have been nice to have the slides with features and prototype information available to download. I understand that some courses don't want other people to take their information and create their course from it, BUT... The exercise description slides SHOULD have been available. It was a pain to have to extract the assignments from the transcript. in order to perform the exercises. A number of lessons made references to a techniques or operations but never had any examples or fleshed them out in the lecture. Saying refer to the documentation is lazy.

Been using SQL and Postgres for over 2 decades. This is a good and insightful presentation of the topic.

Sorry, I am retired. In my career I have worked a lot with Oracle Database. Postgresql good database for free source. Teacher is also very very good. Udemy courses are also much better than classroom courses. You are not disturbed, repeat it until you get it, even if it is months / years ago you want to watch them again.