Learn Bench


Introduction

  • The MySQL for Database Administrators course is the foundation course for database administrators and developers who want to use this powerful database.
  • In this course you will learn how to secure users privileges, set resource limitations, and access controls.
  • In addition, you will learn multiple new features such as creating and using Stored Procedures, Triggers and Views.

Students who can benefit from this course

  • DBAs and developers who want to administer MySQL
  • Students wishing to prepare for the MySQL Database Administrator Certification Exams

Prerequisites

  • Attend the MySQL for Beginners course or some experience with Relational Databases and SQL.
  • MySQL for Beginners (SQL-4401)

Objectives

  • Install and Upgrade MySQL for the most common operating systems
  • Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
  • Use the INFORMATION_SCHEMA database to access metadata
  • Perform the MySQL start and shutdown operations
  • Configure MySQL server options at runtime
  • Evaluate data types and character sets for performance issues
  • Understand data locking concepts and the different levels of locking in MySQL
  • Differentiate between the multiple storage engines available in MySQL
  • Perform backup and restore operations utilizing multiple MySQL tools
  • Maintain integrity of a MySQL installation utilizing security protocols
  • Use stored routines and triggers for administration tasks
  • Manage, apply and understand the reason for using views
  • Improve performance through query optimization
  • Optimize Schemas (Databases) utilizing multiple techniques
  • Utilize MySQL monitoring tools to improve server performance
  • Compare multiple environment options to improve server performance
    The MySQL Server
  • Types of MySQL Distributions
  • Starting and Stopping MySQL on Windows
  • Starting and Stopping MySQL on Linux
  • Upgrading MySQL
  • Managing Multiple Servers
  • Configuring the MySQL Server
  • MySQL Configuration
  • Dynamic Server Variables
  • Server SQL Modes
  • Log and Status Files
  • Binary Logging
  • MySQL Clients
  • Overview of Administrative Clients
  • Invoking MySQL Client Programs
  • Using the mysql Client
  • The mysqladmin Client
  • MySQL Connectors
  • Third-Party APIs
  • Overview of Data Types
  • Data Types
  • Numeric Data Types
  • Character String Data Types
  • Binary String Data Types
  • Temporal Data Types
    Transactions and Locking
  • Transactions
  • Transaction Control statements
  • Isolation Levels
  • Locking
  • Security and User Management
  • Security Risks
  • Security Measures
  • Privileges
  • User Account Maintenance
  • Client Access Control
  • Using Secure Connections
  • Table Maintenance
  • Table Maintenance
  • SQL Statements for maintenance operations
  • Client and Utility Programs for table maintenance
  • Table Maintenance per Storage Engine
  • Programming with MySQL
  • Defining, Executing and Examining Stored Routines
  • Stored Routines and Execution Security
  • Defining, Creating, and Deleting Triggers
  • Trigger Restrictions and Privileges
<

certification







May i help u

 
Live Chat
We're with you 24/7

latest product