Applet Orchard

MySQL Tutorial

[ad_1]
Cheat Sheet / Transcript is Here :

Best MySQL Book :

Support Me on Patreon :

Welcome to my MySQL video tutorial. I’ll cover 95 – 98% of everything you’ll ever need to know in one video.

I cover creating / destroying databases, creating / destroying tables, data types, NULL, DEFAULT, ENUM, AUTO_INCREMENT, primary keys, foreign keys, atomic data, normalized, DESCRIBE, INSERT, ALTER, SELECT, SHOW, RENAME, WHERE, logical operators, comparison operators, ORDER BY, GROUP BY, LIMIT, string operators, joins, LIKE, DISTINCT, math functions and more.

Posted

in

by

appletorchard

Tags:

Comments

40 responses to “MySQL Tutorial”

  1. Don't be stupid Avatar
    Don’t be stupid

    This is video is great! Thank you!

    Reply
  2. Rachel Hodos Avatar
    Rachel Hodos

    Thanks! Super helpful!

    Reply
  3. Ann-Marie Thompson Avatar
    Ann-Marie Thompson

    Awesome video! Finished it and will probably watch again tomorrow!

    Reply
  4. Rohan Mathur Avatar
    Rohan Mathur

    Very Informative!!
    Really helped me go through my exams 😛

    Reply
  5. Josip Rajkovic Avatar
    Josip Rajkovic

    i like this video but i love your accent man 😀

    Reply
  6. Mukesh Chouhan Avatar
    Mukesh Chouhan

    PostgreSQL video please ! Thanks

    Reply
  7. Zeitun Hassan Avatar
    Zeitun Hassan

    Thanks lot we need more videos which usefully like these

    Reply
  8. veerain grover Avatar
    veerain grover

    You the man! got an exam tomorrow, just revised JavaScript, PHP, MySQL easily because of you man. watched all three of them. now I can play Forza without any guilt.

    Reply
  9. Paul Spencer Avatar
    Paul Spencer

    Great tutorial. Very efficiently covered lots of ground in a really clear way. Just at the start of my journey into MySQL. Thanks.

    Reply
  10. Bhawna Bhatia Avatar
    Bhawna Bhatia

    Its a good video which covers many topics.

    Reply
  11. Adam Sir Avatar
    Adam Sir

    As everyone should say: a great great tutorial!
    You only need a little bit background in whatever programming language to understand this video (by pausing a lot of course).
    Really great to see how people could efficiently explain something that's called a course in a concentrated 41-minutes-video.
    Thank you so much!

    Reply
  12. Andy Kench Avatar
    Andy Kench

    I got to the end. Thanks man.

    Reply
  13. David Zanke Avatar
    David Zanke

    Found this video very helpful( did watch entire thing). I've worked /w SQL databases since 1989, but primarily w/ MS SQL server since late 90s. This video showed showed some of the differences between the two. I had worked a little w/ mySQL before, but that was 20 years ago. One thing I wish to point out, and this is true of all SQL databases I've worked w/, is that the "between" operator is inclusive. That is to say that "between 4 && 6" includes 4 & 6, not just 5, that threw me a little bit when I first started using it.

    Reply
  14. arsenalcanada Avatar
    arsenalcanada

    Watched the whole thing, thanks

    Reply
  15. juansmoob Avatar
    juansmoob

    How dare you put only 'F' and 'M as sex choices

    Reply
  16. Jack Aylward Avatar
    Jack Aylward

    What version of mysql is he using 🙂

    Reply
  17. whit 11b Avatar
    whit 11b

    Without a doubt, the best coding video I have ever seen. And from the Palm Springs of Washington to top it off. Thank you.

    Reply
  18. Dean Jay Mathew Avatar
    Dean Jay Mathew

    This video is the best! Thanks, man!

    Reply
  19. Will Walsh Avatar
    Will Walsh

    stewwwdents

    Reply
  20. ajam ansari Avatar
    ajam ansari

    this tutorial very nice for beginng

    Reply
  21. Ciaran Byrne Avatar
    Ciaran Byrne

    Love the class full of Twin Peaks characters, also great video…. using it to revise for a job interview tomorrow morning.

    Reply
  22. Danish Nayeem Avatar
    Danish Nayeem

    Awesomely Awesome!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    Downloaded !!!!

    Reply
  23. M Askari Avatar
    M Askari

    This is way very fast for a beginner

    Reply
  24. Jerry Naidoo Avatar
    Jerry Naidoo

    WOW

    Reply
  25. Aaron Hadenfeldt Avatar
    Aaron Hadenfeldt

    Very thorough in a condensed amount of time. I appreciate the video!

    Reply
  26. ferds814 Avatar
    ferds814

    None of these commands work lmao

    Reply
  27. Rick Hema Avatar
    Rick Hema

    Awesome, thank you.

    Reply
  28. Maths4Everyone Avatar
    Maths4Everyone

    I am only half way through, but this is excellent. A million thanks – Now to watch the rest 🙂

    Reply
  29. Lisa Ingram Avatar
    Lisa Ingram

    looks like a good tutorial, which are hard to find. Do you have any newer ones? maybe mysql 6.3?

    Reply
  30. Mahlon Kirwa Avatar
    Mahlon Kirwa

    This might be a silly question but what commands do you use to shrink the data in the tables in mysql?

    Reply
  31. Marc Santos Avatar
    Marc Santos

    Good video, but did not discuss about views and procedures and the workbench shortcuts

    Reply
  32. Sabu Thomas Avatar
    Sabu Thomas

    Love it. Very concise but at the same time covered all the basics. Great job Derek!

    Reply
  33. djthoth1 Avatar
    djthoth1

    you talk fast but super accurate!!!

    Reply
  34. Peter Hill Avatar
    Peter Hill

    Nice Twin Peaks references 😉 useful video, thanks!

    Reply
  35. SecHummer Avatar
    SecHummer

    Awesome, I found this video to be very helpful!!!

    Reply
  36. Arshan Memon Avatar
    Arshan Memon

    Nice

    Reply
  37. niFe Avatar
    niFe

    MySQL Walk with Me

    Reply
  38. Harsh Kumar Avatar
    Harsh Kumar

    Thanks Derek. The explanations were simply amazing .

    Reply
  39. kaly XXI Avatar
    kaly XXI

    oh man you're good

    Reply
  40. CallMe Tai Avatar
    CallMe Tai

    Do you have a tutorial on Mysql backup and recovery?

    Reply

Leave a Reply

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