MySQL: A beginner’s guide to MySQL

MySQL is a complete beginners guide to learning MySQL in plain English.

Created by: Trevor Page
Senior Software Engineer

What Will I Learn?

• You'll learn how to install a database server on your own computer
• You'll learn how to create and manage multiple databases
• You'll be able to create, read, update and delete data from your databases
• You'll learn how to write advanced queries on your data that can be used in real reports
• You will be able to create stored functions and stored procedures
• You'll be able to know what kind of database indexes to use depeding on your specific environment

Requirements

• You will need to have basic Windows / Mac skills, as installation of software will be required
• You will need to install one piece of free software called TOAD for MySQL (We'll show you the exact steps in the course)
• Knowledge of programming is a "nice-to-have"

Target audience

• This Databases and SQL course is meant for beginners who have either no prior experience with Databases, or very limited experience. This course isn't meant for those who already have a solid foundation of knowledge in SQL.