MySQL Database Development Mastery [Video]

By Trevoir Williams
    Advance your knowledge in tech with a Packt subscription

  • Instant online access to over 7,500+ books and videos
  • Constantly updated with 100+ new titles each month
  • Breadth and depth in over 1,000+ technologies

About this video

MySQL is a database that is used by the biggest social media platforms, such as Facebook, Twitter, and YouTube. Thanks to its performance, reliability, and ease-of-use, MySQL has become one of the most popular open-source databases. This course will help you get to grips with the fundamentals of the two most powerful MySQL assets—MySQL Server and MySQL Workbench—for effectively designing and maintaining databases.

The course begins with an introduction to MySQL Server and its databases and demonstrates the process of installing MySQL Server and MySQL Workbench on your machine. Once the setup is complete, you’ll explore the concepts of manipulating data and tables with MySQL queries. Moving on, you will discover how to connect, create, and remove a database; how to insert data into the table using SQL scripts and Workbench; how to select, update, and delete data in the table; along with learning some CRUD operations. As you progress, you’ll understand the importance of relationships, foreign keys, and normalization in MySQL. Finally, you will delve into aggregate functions, such as AVG, COUNT, MIN, and MAX, and find out how to perform calculations on a set of values and return a single value.

By the end of this course, you’ll have gained the basic MySQL Server and MySQL Workbench skills needed to design and maintain databases.

The code files are placed here:

Publication date:
October 2020
4 hours 19 minutes

About the Author

  • Trevoir Williams

    Trevoir Williams is a software engineer and part-time lecturer. With a master’s degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud System, and server administration. He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.

    Browse publications by this author
Book Title
Access this video and the full library for only $5/m
Access now