MySQL for Beginners Part 2 | Working With Data
In Part 2 of this MySQL for beginner's guide, we'll cover even more common MySQL commands and show you how to interact with a large database. Check out part one here: https://youtu.be/26II9eZmLSY
Chapters:
0:00 Introduction
0:50 How to Login to MySQL as the Root User
1:58 How to Use the Show Database Command
2:35 How to Access the Employees Database
3:13 Showing the Tables in the Employee Database
3:37 How to Use the Select Query
5:34 How to Limit the Output
6:40 How to Specify a Specific Column
8:03 How to Select More Than One Column
9:09 How to Filter Out Information
11:35 How to Add In Select Columns
12:39 How to Order the List by a Specific Column
14:32 How to Search Within a Specific Column
17:29 How to Use the Insert Query
22:11 How to Update (or Rename) a Record
24:40 How to Use the Delete Query
26:30 Conclusion
New to Linode? Get started here with a $100 credit → https://www.linode.com/linodetube
Read the doc for more information on SQL Commands → https://www.linode.com/docs/guides/sql-commands/
Learn more about MySQL → https://www.linode.com/docs/guides/databases/mysql/
Subscribe to get notified of new episodes as they come out → https://www.youtube.com/linode?sub_confirmation=1
#Linode #Databases #MySQL #MySQLTutorial
Product: Linode, Database, MySQL; @KeepItTechie ;