Nature and target：
MySQL is a very popular relational database. It is free for most application. While not open source it is heavily used by the open source community and it runs easily on Windows and UNIX.
The major objective of this course is to train participants to effectively to administrate a MySQL implementation. Both Day to day tasks such as database backups and repair and specialized tasks such as security will be covered.
Upon completion, participants will be able to manage a MySQL database implementation.
Content：
l Understand the fundamentals of relational databases.
l Understand the concept of normalization and be able to create a proper table structure.
l Understand the benefits of MySQL, MySQL licensing and the typical usage scenarios of MySQL.
l Know the major features and road map of MySQL.
l Understand the client/server environment in which MySQL works.
l Perform a MySQL installation on Windows or Linux.
l Use the standard command-line and graphical clients to connect with the MySQL Server and execute commands.
l Be familiar with the graphical clients available to create databases and run queries.
l Be comfortable with the process of creating a database and its structure from ideas or existing data.
l Identify column types and their characteristics, and be able to choose the appropriate type.
l Create and modify databases and tables (Data Definition Language).
l Insert, update and delete data when working with your database tables (Data Manipulation Language).
l Import and export data to and from ODBC applications such as Microsoft Access and Microsoft Excel, allowing seamless integration of MySQL.
l Understand and use the most common functions and expressions to help in utilizing MySQL to build efficient database applications.
l Write and execute basic SQL queries including joins and aggregation.
l Create and modify indexes to help MySQL process your queries in a faster and more efficient way.
l Understand the basic concepts of query optimization done by MySQL's optimizer.
l Understand the MySQL storage engine concept and be able to chose the appropriate one for OLTP (On-Line Transaction Processing), OLAP (On-Line Analytical Processing) and memory based computing.
Position:Course Searching
