100 comments

  1. Question: why does some of the functions that appear colored as red on your PopSQL (like SUM or AVG) often appear to me with the other color of every other SQL text?

  2. Hi Mike Giraffe, huge thanks for your excellent delivery of many useful videos! The best not only for newbies but also the complete reviews

  3. I want to learn SQL from this course so what is the difference between My SQL and SQL? Please help me and guide me to the right way.

  4. hey mike bro..i'm from india… your tutorials are so good…you are expressing it in a single video…i hope that this course made me to learn new skills and help me to crack interviews,. hats off to you

  5. Wow! Great course. Many thanks Mike. Comprehensive and excellent presentation for one and all to understand (and enjoy!). Much appreciated!

  6. The UPDATE query around 1:50:04 isnt running properly on PopSQL anymore, I get the message '0 rows affected'. Has the command changed since this video?

  7. you are a really good instructor.. i will be checking out more. After i get thru this 4 hrs. Thanks for sharing.

  8. hi
    whenever i try to install mysql, I'm getting an error while adding root password. It shows cant connect to MySQL using this password. i tried all kind of passwords. nothing is working ๐Ÿ™

  9. I love the way this guy teaches! It is very very clear and every time he says Michael Scott( by brain says โ€œ that is what she saidโ€

  10. Can you give me answer of following question

    1.Write a PL/SQL block to find the maximum number between the three numbers using %type.

    2.Write a PL/SQL block to check whether the given number is palindrome or not using %row type.

  11. Hey great tutorial. I just found a little inconsistency (no big deal) in the video and in the code.
    Should be select COUNT(emp_id) from employee where sex = 'F' and birth_day > '1970-01-01';
    not birth_date.

  12. how do u add the column in your desired postion. I added another column as u showed but it wasnt where i wanted it to be

  13. I just finished the course 10 minutes ago and it took about about 2 weeks to complete it all.

    I have to say, I feel extremely grateful. The moment I left my pen finishing my notes as Mike closed the tutorial, felt amazing. I believe I built very strong foundation to take the next leap ahead. The course was great, it covered lots of details and if I still had a question, it was so small that a simple Google search or just experimenting was enough to solve it.

    Now as Mike already said, it is a beginners course, which is fine. I feel more than ready to tackle more advanced stuff and I cannot wait to do so in the next few weeks. I feel ready to apply my new SQL knowledge in my favourite languages and take my game a step further.

    I also saw that Mike has lots of other tutorials as well. Something tells me that I will learn more from him soon.
    Thank you so much for creating this course for free and for actually investing your valuable time to teach us.

  14. All of my friends: Stop watching the Office all the time! It will never be useful in your life
    Me: understanding this tutorial

  15. ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

  16. 2:52:14 for the month you can also use this (a month is always MM a year is always AAAA- and a day is always -DD ) to distinct the months from th days or the years

  17. โญ๏ธ Contents โญ
    โŒจ๏ธ (0:00) Introduction
    โŒจ๏ธ (2:36) What is a Database?
    โŒจ๏ธ (23:10) Tables & Keys
    โŒจ๏ธ (43:31) SQL Basics
    โŒจ๏ธ (52:26) MySQL Windows Installation
    โŒจ๏ธ (1:01:59) MySQL Mac Installation
    โŒจ๏ธ (1:15:49) Creating Tables
    โŒจ๏ธ (1:31:05) Inserting Data
    โŒจ๏ธ (1:38:17) Constraints
    โŒจ๏ธ (1:48:11) Update & Delete
    โŒจ๏ธ (1:56:11) Basic Queries
    โŒจ๏ธ (2:08:37) Company Database Intro
    โŒจ๏ธ (2:14:05) Creating Company Database
    โŒจ๏ธ (2:30:27 ) More Basic Queries
    โŒจ๏ธ (2:26:24) Functions
    โŒจ๏ธ (2:45:13) Wildcards
    โŒจ๏ธ (2:53:53) Union
    โŒจ๏ธ (3:01:36) Joins
    โŒจ๏ธ (3:11:49) Nested Queries
    โŒจ๏ธ (3:21:52) On Delete
    โŒจ๏ธ (3:30:05) Triggers
    โŒจ๏ธ (3:42:12) ER Diagrams Intro
    โŒจ๏ธ (3:55:53) Designing an ER Diagram
    โŒจ๏ธ (4:08:34) Converting ER Diagrams to Schemas

    **Copied from video description

  18. Excellent presentation ๐Ÿ‘
    I am from Rural India and able to understand your pronunciation in English perfectly , everything what u have explained is crystal clear with good audio

  19. hey i'm not able to click on run button in popsql can you please help me out!
    the run button doesn't appear to clickable it's gone grey i don't know what's wrong

  20. ๐Ÿ“ฒ*00212645752301* *Whatapps*๐Ÿ“ฒ
    ุณู€ู…ู€ุนู€ุช๐Ÿงโ€โ™‚๏ธ ูƒู€ู€ุซู€ู€ูŠู€ู€ุฑ ู…ู€ู† ุงู„ู€ุดู€ุจู€ุงุจ ูŠู€ุจู€ุญู€ุซู€ูˆู† ุนู€ู€ู† ุทู€ู€ุฑูŠู€ู€ู‚ู€ู€ุฉ ูู€ุนู€ุงู„ู€ุฉโœ… ู„ู€ุชู€ูƒู€ุจู€ูŠู€ุฑ ุงู„ู€ู€ู‚ู€ู€ุถู€ู€ูŠู€ู€ุจ
    ูˆุฃู†ู€ู€ุง ุฃุจู€ู€ุดู€ู€ุฑูƒู€ู€ู…๐Ÿ˜‰ ุฃู†ู€ู€ูŠ ุญู€ุตู€ู„ู€ุช ุนู€ู€ู„ู€ู€ู‰ ุงู„ู€ุทู€ุฑูŠู€ู‚ู€ุฉ ุงู„ุฃุตู€ู€ุญ๐Ÿ‘ ูˆุงู„ู€ู…ู€ู†ู€ุงุณู€ุจู€ุฉ๐Ÿ‘ ูˆู‡ู€ู€ุชู€ู€ุดู€ู€ูƒู€ู€ุฑู†ู€ู€ูŠ ุจู€ู€ุนู€ู€ุฏูŠู€ู€ู‡ู€ู€ุง
    ุชู€ูˆุงุตู€ู„ ู…ู€ู€ุนู€ู€ูŠ ูˆุฃู†ู€ุง ุจู€ู€ุดู€ู€ุฑุญ ู„ู€ูƒ ุณู€ุฑ ุงู„ู€ูˆุตู€ูู€ุฉ ุงู„ู€ูˆุงุชู€ุณู€ุงุจ *00212645752301*๐Ÿ“ฒ

  21. colleges really be charging $500+ for beginner DBMS classes and it takes 4 months to learn where as this guy does it for free and under 5 hours.

  22. Best succinct and complete tutorial about SQL .Gave me the theoretical definitions in a simple way. Keep up with the good work.

  23. A slight mistake was made in 1:42:49, The reason it is a syntax error is because you put the chemistry major in double quotations and not single quotations. Chemistry should have been 'Chemistry' but you made it "Chemistry". Once you fix that mistake you will get the correct error which say "Column name cannot be null".

  24. Best tutorial ever. I have understood everything I need for my module work for tommorow within 4 hours..
    Such a comprehensive explanation, a lot of useful examples, not just learning syntaxes. Great job, man

  25. the exercise at 3:16:00 why did you go for an newsted query ? I tried to do the same using an join and got the exact result.

    SELECT distinct employee.first_name, employee.last_name
    FROM works_with
    inner join employee
    on works_with.emp_id = employee.emp_id
    WHERE works_with.total_sales > 30000;

    Which solution would be the best here? I feel like the smaller and more readable the querrie the better.
    But which does useally get prefered ?

  26. Some of this YouTubers really know how to prepare and convey tech materials way better than some lecturers in high-end institutions. Thank you so much for this upload.

Leave a Reply

Your email address will not be published. Required fields are marked *