Learn essential MySQL commands and techniques for working with large databases in this comprehensive video tutorial. Discover how to log in as the root user, navigate databases, and perform various operations on the employees database. Master the SELECT query to retrieve specific data, apply filters, limit output, and order results. Explore advanced techniques like searching within columns, inserting new records, updating existing data, and deleting entries. Gain practical skills to effectively manage and manipulate MySQL databases, building upon the foundations covered in the first part of this beginner's guide.
Overview
Syllabus
Introduction
How to Login to MySQL as the Root User
How to Use the Show Database Command
How to Access the Employees Database
Showing the Tables in the Employee Database
How to Use the Select Query
How to Limit the Output
How to Specify a Specific Column
How to Select More Than One Column
How to Filter Out Information
How to Add In Select Columns
How to Order the List by a Specific Column
How to Search Within a Specific Column
How to Use the Insert Query
How to Update or Rename a Record
How to Use the Delete Query
Conclusion
Taught by
Linode
