Welcome to the Learning Glue MySQL Essentials course. Throughout this course you will gain a good understanding and practical experience of MySQL databases and tables. You will learn how to manage data and become proficient is the creation, reading, updating and deletion of data (CRUD) using the MySQL console and using PHP via a web page.
MySQL is a relational database management system or a RDBMS that uses a client-server model which means that the database typically runs on a server, typically this server will be the Apache web server running on a Linux, Windows or Mac operating system. To get the best from this course you will be required to download and install MySQL, PHP and Apache onto your computer so that you can fully participate in the exercises throughput this course.
MySQL is a system that uses the Structured Query Language or SQL to define, update and query the database and tables within it. SQL is hands down the most popular database system language and it is used on virtually all major relational database systems so you will gain valuable knowledge that can be applied to many other database systems that use SQL.
Learning how to create, read, update and delete data from database tables.
MySQL Reference Sheets
This section contains a series of reference sheets to all commands covered in this course.