Entry requirementsEntry requirements Familiarity with Linux (equivalent to the Linux Introductory course) plus a basic understanding of databases
Course descriptionGeneral information
The MySQL® database has become the world's most popular open source database because of its consistent fast performance, high reliability and ease of use. It's used in more than 8 million installations ranging from large corporations to specialized embedded applications on every continent in the world. Not only is MySQL the world's most popular open source database, it's also become the database of choice for a new generation of applications built on the LAMP environment (Linux, Apache, MySQL, PHP). MySQL runs on more than 20 platforms including Linux, Windows, OS/X, HP-UX, AIX, Netware. Whether you're new to database technology or an experienced developer or DBA, this one-day training course covers everything you need to start using MySQL.
Course content
GETTING STARTED WITH MySQL
* What do I need?
* Introduction: What is MySQL? Why use a database?
* Setting Up The Database
* Inserting Information
* Displaying Your Data
* Formatting Output
* Using Select
* USING MySQL
* Security Issues
* Individual Records and Errors
* Deleting & Updating
* Tips and tricks
* Organising your code
* The ALTER TABLE command Optimizing MySQL: EXPLAIN Queries and Indexes