· showing basics of MySQL and most common terminologies about databases .
· about HTTP and HTML Basics
· how to access MySQL and descripting about MySQL functions.
· Working with MySQL Database design
· Maintaining MySQL Database
Description
With well over ten million installations, MySQL is probably the most popular database management system for web servers. Developed in the mid-1990s, it’s now a mature technology that powers many of today’s most-visited Internet destinations. In this course you will learn principals of how to create and manage your MySQL database.
Audience :
Database designer, database developer.
Topics :
Introduction to MySQL
o MySQL Basics
o Summary of Database Terms
o Accessing MySQL via the Command Line
o Indexes
o MySQL Functions
o Accessing MySQL via phpMyAdmin
Mastering MySQL
o Database Design
o Normalization
o Relationships
o Transactions
o Using EXPLAIN
o Backing Up and Restoring
Recommended Knowledge :
Mastery of Windows operating system (any version)
Recommended Course(s) :
Category :
Training Materials :
Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition
Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
Credential :
This course is a necessary starting point for anyone wants to step into designing and managing database by MySQL.
