MySQL Database Administration
Course
In London
£ 1,495
+ VAT
Description
-
Type
Course
-
Location
London
This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and SQL commands.
Facilities
Location
Start date
London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU
Start date
On request
Reviews
Have you taken this course?
Subjects
- Database
- Database training
- IT
- MySQL
- Database Administration
Course programme
Follow-On Course
- MySQL Performance & Tuning
- Introduction
- MySQL
- MySQL Admin
- Exercises: Using Client Programs
- What is Metadata?
- The mysqlshow Client Program
- The SHOW and DESCRIBE Commands
- The Information_Schema
- Show Command and Information_Schema Differences
- Exercises: Obtaining Information about MySQL
- MySQL Server Options and Variables
- MySQL Status Variables
- Configuring MySQL Enterprise Audit
- Exercises: Configuring the Server
- MySQL Distributions
- Installing on Windows
- Installing on Linux and UNIX
- Starting and Stopping on Windows
- Starting and Stopping on UNIX/Linux
- Status Files
- Upgrading the Server
- Time Zone Tables
- Exercises: Installing, stopping and starting
- MySQL Error Messages
- The SHOW Errors Statement
- The SHOW Warnings Statement
- SQL Modes
- Note Messages
- The PERROR Utility
- The General Log
- The Error Log
- The Slow Query Log
- The Binary Logs
- Exercises: Interpreting Errors and Configuring the Logs
- Client/Server Overview
- Communication Protocols
- The SQL Parser and Storage Engine Tiers
- How MySQL Uses Disk Space
- How MYSQL Uses Memory
- Exercises: Examining the Architecture
- Table Properties
- Creating Tables
- Altering Tables
- Dropping Tables
- Emptying Tables
- Obtaining Table Metadata
- Column Attributes
- Bit Data Type
- Numeric Data Types
- Character String Data Types
- Binary String Data Types
- Enum and Set Data Types
- Temporal Data Types
- Auto_Increment
- Handling Missing or Invalid Data Values
- Exercises: Creating and Maintaining Tables
- Locking Concepts
- Explicit Table Locking
- Advisory Locking
- Exercises: Locking
- Introduction
- The MYISAM Engine
- The Merge Engine
- Other Engines: Archive, Memory, Federated, Blackhole, CSV
- Cluster Engine Overview
- Overview of High Availability Techniques
- Memcached and NoSQL Overview
- Exercises: Using Storage Engines
- Introduction
- Features of Innodb
- Transactions
- Referential Integrity
- Physical Characteristics of Innodb Tables
- System Tablespace Configuration
- Log File and Buffer Configuration
- Innodb Status
- Exercises: Using the InnoDB Engine
- Table Maintenance Operations
- Check Table
- Repair Table
- Analyze Table
- Optimize Table
- MySQL Check
- MYISAMCHK
- Repairing Innodb Tables
- Enabling MYISAM AutoRepair
- Exercises: Maintaining Tables
- The Advantages and Disadvantages of Different Methods
- Binary Backups of MYISAM Tables
- Binary Backups of Innodb Tables
- Recovery
- Import and Export Operations
- Exporting Using SQL
- Importing Using SQL
- Exporting from the Command Line using mysqldump
- Importing from the Command Line using mysqlimport
- Exercises: Backing Up and Recovery
- Introduction
- User Accounts
- Creating Users
- Renaming Users
- Changing Passwords
- Dropping Users
- Granting Privileges
- The User Table
- Connection Validation
- Exercises: Creating, Managing and Dropping Users
- Introduction
- Types of Privileges
- Revoking Privileges
- Resource Limits
- The MySQL Database
- The Show Grants Command
- Exercises: Granting and Revoking Privileges
- User Variables
- Prepared Statements
- Exercises: User Variables and Prepared Statements
- Types of Stored Routines
- Benefits of Stored Routines
- Stored Routines Features
- Stored Routine Maintenance
- Obtaining Stored Routine Metadata
- Stored Routine Privileges and Execution Security
- DML Triggers
- Security Risks
- Users, Operating System, File System and Network Security
- Using SSL With MySQL
- Remote Connecting to the MySQL Server Using SSH
- Exercises: Securing the Server
- Tuning Overview
- Identifying Candidates for Query Analysis
- Using Explain to Analyze Queries
- Meaning of Explain Output
- Explain Extended
- Exercises: Explaining and Tuning Queries
- Indexes for Performance
- Creating and Dropping Indexes
- Obtaining Index Metadata
- Indexing Principles
- Exercises: Creating and Using Indexes
- Indexing and Joins
- Fulltext Indexes
- MyISAM Index Caching
- Exercises: Creating and Using Indexes
- General Table Optimizations
- Myisam Specific Optimizations
- Innodb Specific Optimizations
- Other Engine Specific Optimizations
- Exercises: Tuning Tables
- Status Variables
- Server Variables
- Performance Schema Overview
- The Query Cache
- Exercises: Tuning the Server
- Event scheduler concepts
- Event scheduler configuration
- Creating, altering and dropping events
- Event scheduler monitoring
- Events and privileges
- Exercises: Using the event scheduler
- Partitioned tables concepts
- Obtaining Partitioned Table Metadata
- Types of Partitioning
- Subpartitioning
- Maintenance of partitioned tables
- Exercises: Using partitioned tables
- Replication Overview
- Testing Replication
- Monitoring and Troubleshooting Replication
- Files and Threads Involved in Replication
- Excluding Databases or Tables From Replication
- Complex Replication Topologies
- Example: Setting Up a Master Slave Replication
- Replication Using GTIDs
- MySQL Replication Utilities
- Controlled Switchover
- Exercises: Setting Up and Testing Replication
- Installation
- Connecting
- Screens
- Exercises: Using MySQL Workbench
MySQL Database Administration
£ 1,495
+ VAT