Course duration
- 2 days
Course Benefits
- Understand the MySQL Architecture.
- Learn to start and shutdown the MySQL server.
- Learn to install MySQL.
- Learn to configure MySQL components.
- Learn to use different storage engines supported in MySQL.
- Learn to secure the elements of a MySQL installation.
- Learn to maintain security of a MySQL installation via user management and access rights.
- Learn to work with the MySQL Administrator Graphical User Interface.
- Learn to perform backup and restore operations using multiple MySQL tools.
- Learn to optimize MySQL at various levels - installation, database and queries.
- Learn to perform database replication in MySQL.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Course Outline
- Database design and implementation
- How to design a database
- How to design a data structure
- The basic steps for designing a data structure
- How to identify the data elements
- How to subdivide the data elements
- How to identify the tables and assign columns
- How to identify the primary and foreign keys
- How to enforce the relationships between tables
- How normalization works
- How to identify the columns to be indexed
- How to normalize a data structure
- The seven normal forms
- How to apply the first normal form
- How to apply the second normal form
- How to apply the third normal form
- When and how to denormalize a data structure
- How to use MySQL Workbench for database design
- How to open an existing EER model
- How to create a new EER model
- How to work with an EER model
- How to work with an EER diagram
- How to design a data structure
- How to create databases, tables, and indexes
- How to work with databases
- How to create and drop a database
- How to select a database
- How to work with tables
- How to create a table
- How to code a primary key constraint
- How to code a foreign key constraint
- How to alter the columns of a table
- How to alter the constraints of a table
- How to rename, truncate, and drop a table
- How to work with indexes
- How to create an index
- How to drop an index
- A script that creates a database
- How to use MySQL Workbench
- How to work with the columns of a table
- How to work with the indexes of a table
- How to work with the foreign keys of a table
- How to work with character sets and collations
- An introduction to character sets and collations
- How to view character sets and collations
- How to specify a character set and a collation
- How to work with storage engines
- An introduction to storage engines
- How to view storage engines
- How to specify a storage engine
- How to work with databases
- How to create views
- An introduction to views
- How views work
- Benefits of using views
- How to work with views
- How to create a view
- How to create an updatable view
- How to use the WITH CHECK OPTION clause
- How to insert or delete rows through a view
- How to alter or drop a view
- An introduction to views
- How to design a database
- Database administration
- An introduction to database administration
- Database administration concepts
- Database administrator responsibilities
- Types of database files
- Types of log files
- How to monitor the server
- How to view the server status
- How to view and kill processes
- How to view the status variables
- How to view the system variables
- How to configure the server
- How to set system variables using MySQL Workbench
- How to set system variables using a text editor
- How to set system variables using the SET statement
- How to work with logging
- How to enable and disable logging
- How to configure logging
- How to view text-based logs
- How to manage logs
- Database administration concepts
- How to secure a database
- An introduction to user accounts
- An introduction to SQL statements for user accounts
- A summary of privileges
- The four privilege levels
- The grant tables in the mysql database
- How to work with users and privileges
- How to create, rename, and drop users
- How to specify user account names
- How to grant privileges
- How to view privileges
- How to revoke privileges
- How to change passwords
- A script that creates users
- How to work with roles
- How to create, manage, and drop roles
- A script that creates users and roles
- How to use MySQL Workbench
- How to work with users and privileges
- How to connect as a user for testing
- An introduction to user accounts
- How to backup and restore a database
- Strategies for backing up and restoring a database
- A backup strategy
- A restore strategy
- How to back up a database
- How use mysqldump to back up a database
- A SQL script file for a database backup
- How to set advanced options for a database backup
- How to restore a database
- How to use a SQL script file to restore a full backup
- How to execute statements in the binary log
- How to import and export data
- How to export data to a file
- How to import data from a file
- How to check and repair tables
- How to use the CHECK TABLE statement
- How to repair a MyISAM table
- How to repair an InnoDB table
- How to use the mysqlcheck program
- How to use the myisamchk program
- Strategies for backing up and restoring a database
- An introduction to database administration
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this MySQL class:
- General SQL knowledge and principles
Experience in the following would be useful for this MySQL class:
- Understanding of DDL objects - tables, Indexes, constraints and others
- Basic knowledge of hardware and OS
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.