SQL Crash Course – Beginner to Intermediate




In this course we will cover all of the fundamentals of the SQL (Structured Query Language). This course is great for beginners and also intermediates. We will …

Original source


23 responses to “SQL Crash Course – Beginner to Intermediate”

  1. Dudeeee you are the best, i have been trying to get any keys about it to understand even the book was so confusing. Thank you so much for the straightforward info, the voice was so clear, the language you used was very simple and clear nothing hard no philosophy in it!! Do more videos for the intermediate levels and advanced, please. Keep up the good work. Once again, thanks a lot :))

  2. Hi, If I have products and categories and when I delete one category, what happens to the products of that category which was deleted? Should I move those products to a different categories? How to automate this process? Thanks.

  3. having an error in this brad

    INSERT INTO orders(orderNumber, productId, customerId) VALUES
    (001,1,4),
    (002,3,1),
    (004,1,1),
    (005,1,2),
    (006,1,1),
    (007,4,6),
    (008,4,4),
    (009,2,5);
    mysql said
    "#1452 – Cannot add or update a child row: a foreign key constraint fails (`acme`.`orders`, CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`customerId`) REFERENCES `customers` (`id`))"

  4. All of your joins returns the same rows all the time. Having a more diverse data set would really help to understand how the different joins really work. I found the entire lecture very informative but the joins really need to produce different results otherwise I'm looking at the same data wondering how the joins are different.

Leave a Reply