From 0 To 1:SQL And Databases - Heavy Lifting (Udemy.com)

Summary: - Overall, this was a very good course, that is highly recommended, especially if you want a solid theoretical understanding of SQL programming. I would give this course 5 stars if there were more opportunities to test the learnings. Pros: - The lessons are very well presented, comprehensive and easy to understand. Cons: - The course could be improved with additional exercises as there is relatively little opportunity to test the learnings. - I also feel that the course could be enhanced with quizzes on the more theoretical aspects of the lessons.

Up until lecture 7 at least it gives information on both theory and practice, which is nice. But also makes you look for the commands to understand them completely with practice, instead of just telling you everything. At the last 1/4 of the course explanations are sometimes skipped - it made me look it up and study it, but still some people could be turned off. You would need to know python or get their python course for the last section about databases.

In the first and second sections, many basics were covered, and it was very good to get this information. In the third section, almost all of the information was very valuable. However, the last two touched on things that I had no understanding of, and I didn't feel were well explained. More because I had no idea what it was about than because I didn't understand them. In the 4th section, a table was used that was not normalized, and it was not mentioned to be a bad table. But, it fit the examples that were given, so it ends up okay that it is used. Going through the 4th section, a mention of joins occurred. A bit randomly. But, in the 5th section, everything was mentioned that I was hoping for and all of it started to make sense. Overall, I am enjoying how detailed this series of lectures are. It has lots of wonderful information. I hope that I can learn more and get a lot of good from this.

Fantastic course: comprehensive, very clear and detailed. I found the few advanced examples on 'applied sql' especially helpful (e.g. the Python db section). Would like to know also: How to best handle boolean flags in table design ?

Very hard to understand the male teacher I really wished it was the female very clear and easy to learn but stored procedures, populating a table with a sub query and triggers all important topics but I wasn't able to understand. Please add the female teacher on these topics I would rate 5 star if so.

The course is simply incredible. The content and its delivery stands out big time. @prospective students - I highly recommend this course as it's better in all aspects as compared to any other course on the topic of Databases/SQL by a margin. @LooneyCorn Team - Keep up the brilliant job! Keep rocking!!!

So far finished section 1 and 2. Basis concepts of DB are explained in very good manner , and in very organised way. Information goes into brain very smoothly. Lets see remaining sections. done with section 3 . I must say,its very well explained.concepts such as constraints , keys ,insert ,create statements are covered in great detail. What i also like is the way , author brushes up some previous sections covered , when explaining next sections that may require that information.We usually tend to forget ,or need to look up again.So like that thing too. Lets see how other section goes.

This is a solid effort, and I would recommend taking the course. I do think it would be helpful if the tables in the example database were more complete and had more rows. And since most people learn SQL for on the job reasons, I found those example problems to be the most useful. Overall, the course was very insightful and you will know your way around SQL queries, including advanced concepts.

Hard to understand some concepts where multiple arguments are added at the same time (e.g. lecture 19 is a nightmare). However, other lectures are clear despite explaining complex topics (e.g. table creation, date calculations etc.). So far, not bad, potentially a 4-5 star course, will get back to this review later.

I signed up immediately and straight away watched the sections on outer joins and normal forms. Best explanation I have ever seen for these topics. Finally I understood them.