Web Databases with MySQL training - 1 day - private courses from £725 + vat
MySQL Database training uk
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 training 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 training 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.
Introduction to Web Databases with MySQL Training Recommended Reading
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide - Larry Ullman – buy from amazon
home book this course resources 01273 622272 info@siliconbeachtraining.co.uk
Need to learn web design skills? Our range of web design training and internet courses are taught by experienced designers and programmers.