MySQL - MySQL Introduction

MySQL is a useful and widely used open source database

Basics

A Database Software stores data so that it is easily accessible
Relational Databases store Like Data in Tables and those Tables are then
How to get MySQL

For both MySQL and MAriaDB some features are behind a paywall subscription
Why Use MySQL

Back end for WordPress, ZDrupal many apps
Available on Hosting Plans
Easy, and well known
How to use MySQL

Command line – MySQL has a command line interface
Front End – Phpmyadmin offers a GUI front end for MySQL Administration
Coding _ languages like PHP allow to write code to interact with the database
SQL – Structured Query Language

SQL is the language you use to communicate with the database
SELECT * FROM Users = Retrieve ALL Records from Table named USERS
SELECT Name,Age FROM Users ORDER BY Age = Retrieve Name and Age Values from Users Table and Sort by Age

[Kunaispa]

Very awesome Eli, the way your present the lecture in such an interactive way with great insightful. One of the unique IT channel I ever found on Youtube. I have been connected from the majestic mountains of Himalayas and Karakorum.

[ackinito]

I started by building sinus server and while it was a very steep curve, I do not regret it. I am actually glad i went this route since I learned quite a lot.

[PsclKmn]

Wow, this arrived right when I need it. Thanks for being awesome, Eli!

[absolute]

Hearing u speak of 'legacy' equipment, actually is making me feel like less of a useless dinosaur. 20 yr IT professional, everything from installs, to NOC work, then engineering. Left old employer, now out in the new world and I feel lost :( . I wish to now learn about cloud/ security. Yes, SQL and this is so helpful and bringing back my confidence, on my acquired knowledge.

[aayushmantyagi]

I am not seeing any change in u after 6year wow great explained

[battle-techs]

Great video Eli!!! I've been trying to make time to learn mySQL, and you just started me off on the right foot. You made this very clear. Thanks!

[Eddjos]

Eli thanks for your Knowledge share and even I have more than 15 years moving on the field I found in your methodology the best way to update my personal knowledge. Excellent I started looking at you three years ago when I arrived to USA from my country. I'll keep in contact because I'm starting to get a JOb in the area but I'm living at Sarasota FL and it is not easy....

[flyapplewj]

Thank you Eli, it's really happy to find your videos here

[victorgulart]

Man this guy is the best.... I'm gonna make a little soft just to like all his videos and maybe even share all of them. xD

[dilbyjones]

Just looked up the old Eli then saw this! Great info

[maximiliangirouxdavis]

Just discovered your videos

Really amazing, you are bright and generous!

[dalerhan]

this guy is with big G! Thank you for an amazing materials!

[personalaccount]

You cool kids and your MySQL... *stares blankly at Microsoft SQL at work*

[PhucNguyen-pfqb]

i'm really looking forward to this series! Thanks a lot Eli!

[eladdieyo]

You are the GOAT. Man i appreciate you so much

[joanapapa]

Thank you for sharing your knowledge with passion and for free. 👏👏

[aryanghasemi]

Eli, you're amazing! Thanks for your informative videos. I love you personally

[binaryconsole]

Hi Eli, I am a big fan of your videos and building my own infra to learn something. I dindt understand what problem will be caused if i learn network/storage/lunix/etc while building something :-). I believe that actually helps in real world while talking to other tech teams to resolve issues.

[AlexanderKnibbe]

Great intro to SQL. Can't wait to listen to the next lesson.

[toombo]

Glad I'm not the only one who stared at that blinking cursor waiting for something to happen.