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.
I have other videos like this in which I teach HTML, CSS, JavaScript, PHP, Object Oriented PHP and Java in one video if you’re interested.
If you like videos like this, it helps to tell others with a click here [googleplusone]
Cheat Sheet / Transcript from the Video
Could you please put your videos on http://www.youku.com or http://www.tudou.com? Because we can’t reach youtube in China. That would be really helpful not only for me but also other learners in China.
I’ll try to upload to those sites again. For some reason some of my videos were taken down when I tried about a year and a half ago.
Thanks for the tutorial. It’s very informative and concise.
Thank you 🙂
Are you going to cover transactions, triggers, functions and similar operations on databases? Can I request this?
I’ll cover using PHP with MySQL next. I’ll then make a tutorial on how to build a web service. I’ll see if I can fit other topics in based on requests
Please consider making a tutorial on transactions, triggers etc. It would be great if you could cover this! It might be a good idea to use MS SQL Server and MySql (both) to show the differences in syntax (are there many?). 🙂 Thank you for all your effort 😀
I covered them a bit with SQLite. I can definitely cover them with MySQL. I don’t have access to SQL Server though sorry
MySQL will be ok. Thank you 🙂
You’re very welcome 🙂
You’re just pure awesome. But sometimes its overwhelming 😀 how do you know so much stuffff???! 😀 god knows how much time it will take me to learn all of this stuff
Just take your time. I’m not that smart so I’m sure you can learn everything
please help me an error generate generate on MYSql 5.6 Command Line Client
mysql> CREATE TABLE student(
->first_name VARCHAR(30) NOT NULL);
ERROR 1046(3D000): No database selected
You need to first define your database. So if your database is named studentinfo, first type use studentinfo; in mysql
ya got it thanks a lot..
Hi!!!
What about doing a guide over noSQL database??
I plan on covering those when I start my Java enterprise tutorial
Thank you a lot!!!
You’re very welcome 🙂
Thanks for the great video Derek. A great asset for beginners and very well explained.
You’re very welcome 🙂 Thank you
Thank you!
You’re very welcome 🙂
Hi Derek:
Could you make a video for triggers, views, and transactions? It would be great help! Thanks for your other videos, very informative!
I’ll do that asap
what else i need to know about sql? thank you!
This is a vast majority of it. There are more complex topics and you’ll also have to learn how to properly use joins to get at the data in exactly the way you want. I may make another video to cover the rest
Great Tutorial Darek! I am a big fan of yours!
Thank you 🙂