Free online courseIntroduction to MySQL

Course Description

Welcome to the comprehensive Introduction to MySQL course spanning a robust 12 hours and 51 minutes. If you're looking to build a solid foundation in MySQL, this course is perfect for you, encompassing essential aspects to give you a well-rounded understanding of database management. As an invaluable resource under the Information Technology category, specifically in the Database subcategory, this course ensures you gain practical, hands-on experience from start to finish.

The course kicks off with an insightful introduction to MySQL, where you will get acquainted with the basic structure and data types that form the backbone of how MySQL functions. You'll understand what makes MySQL a popular choice for database management and how its structures are meticulously organized to make data handling efficient and streamlined.

You will then learn to install a LAMP server tailored for MySQL laboratories using tasksel, an integral part of ensuring your environment is set up correctly for the various tasks and exercises you'll be performing. Building on this foundation, you’ll dive into creating and managing databases, where you will explore commands to create, delete, and show grants for databases and understand their significance in real-world applications.

The next key area is table management. Here, you'll learn to create, alter, and delete tables, a fundamental part of managing any database effectively. You will also delve into adding records and performing searches within tables, covering critical commands like insert and select.

Updating and deleting records are crucial skills, and this course provides you with a thorough understanding of the respective commands. The instructional videos guide you step-by-step through the processes, ensuring you are adept at maintaining and modifying your database as needed.

User management is another critical portion of the course. You'll learn how to create and delete user accounts, grant necessary privileges, and understand how to show grants, providing a complete framework on managing permissions efficiently.

One of the more advanced topics covered is Table Joins, starting with inner joins. These lessons give you a glimpse into how to combine multiple tables to extract the data you need seamlessly. Following this, procedures and functions are introduced, equipping you with the knowledge to automate repetitive tasks and enhance database performance.

The course also covers Backup, Restore, and Copy procedures for tables and databases, ensuring you know how to safeguard and manage data effectively. You get hands-on experience in connecting MySQL with PHP using the mysqli extension, and this knowledge is further expanded by printing records to HTML, inserting data into tables, and updating records with PHP.

Invaluable skills are developed in managing HTML forms and PHP to insert, update, and search records. This includes utilizing PHP prepared statements and sanitizing variables to ensure secure and efficient data handling. You will also learn how to perform validations using PHP's filter_var function.

Lastly, you will explore how to select unique values from tables, compute average values in a column, and find minimum and maximum values, tying together all the key aspects required to master MySQL.