Home » Training Courses » Programming & Networking Training » MySQL Training

MySQL Training

1 day - private courses from £725 + vat

This MYSQL Database training course is an introduction to the use and management of the MySQL client-server relational database management system (RDMBS), covering its installation, configuration, use, database administration and optimization.

This MYSQL Database course will be valuable for anyone involved in administering MySQL or creating dynamic, database-driven Web sites.

Introduction to Web Databases with MySQL Training Course Objectives

After this MySQL Web Databases course, you will be able to:

• Administer MySQL databases and develop database-enabled Web applications
• Design, create and maintain MySQL databases
• Optimize database performance and enhance reliability
• Construct efficient SQL queries incorporating MySQL extensions

Introduction to Web Databases with MySQL Training Course Content

Relational Database Management Systems:

• Introduction
• Database Modelling
• Entity-Relationship concepts and Terminology
• Second Normal Form
• Third Normal Form

MySQL Basics:

• Installation on Windows
• Installation and administration on Linux
• MySQL Admin Tools
• Command Line tool
• PHPMyAdmin
• DB Manager
• Creating a Database
• Table Management and Data Types

SQL for MySQL:

• Principles of SQL
• SELECT Queries
• GROUP BY
• Advanced SELECT queries
• Inserting records
• Updating records
• Deleting Records

Conclusion:

Introduction to Web Databases with MySQL Course Prerequisites

Knowledge of other databases is not required. A basic familiarity with MySQL is an advantage.

MySql Training Course Recommended Reading:-

PHP and MySQL Web Development - Luke Welling, Laura Thomson - buy from amazon

Download course outline as pdf.

Share This

• Digg
• Twitter
• Stumbleupon
• Delicious
• Facebook
• Myspace
• Google
• Technorati
• Newsvine