Oracle My SQL Training

MySQL for Database Administrators

Make an Appointment
Description

Description

Oracle My SQL Training at Massive Tech – This MySQL for Database Administrators training is a foundation course. It teaches database administrators and developers how to use this powerful database.

Students Who Will Benefit from this Course:

  • DBAs and developers who want to administer MySQL.
  • Students wishing to prepare for the MySQL Database Administrator Exams.
  • Learn how to secure users privileges, set resource limitations and access controls.
  • Instructors will show you how tocreate and use Stored Procedures, Triggers and Views.
Prerequisites

Prerequisites

  • Attend the MySQL for Beginners course or some experience with Relational Databases and SQL.
Key Features
line
  • LIVE Instructor-led Classes
  • 24x7 on-demand technical support for assignments, queries, quizzes, project, etc.
  • Flexibility to attend the class at your convenient time.
  • Server Access to Massive's Tech Management System until you get into your dream carrier.
  • A huge database of Interview Questions
  • Professional Resume Preparation
  • Earn a Skill Certificate
  • Enroll today and get the advantage.
Curriculum
line
  • Describing MySQL
  • Listing MySQL Products and Professional Services
  • Describing MySQL Enterprise Subscription
  • Currently Supported Operating Systems
  • Describing MySQL Certification Program
  • Listing Available MySQL Courses
  • Describing Installation of MySQL
  • Describing Installation of world Database
  • Client/Server Architecture
  • MySQL Architecture Overview
  • How MySQL Uses Disk Space
  • How MySQL Uses Memory
  • The MySQL Plug-In Interface
  • Types of MySQL Distributions
  • Starting and Stopping MySQL on Windows
  • Starting and Stopping MySQL on Linux
  • Upgrading MySQL
  • Managing Multiple Servers
  • MySQL Configuration
  • Dynamic Server Variables
  • Server SQL Modes
  • Log and Status Files
  • Binary Logging
  • Overview of Administrative Clients
  • Invoking MySQL Client Programs
  • Using the mysql Client
  • The mysqladmin Client
  • MySQL Connectors
  • Third-Party APIs
  • Data Types
  • Numeric Data Types
  • Character String Data Types
  • Binary String Data Types
  • Temporal Data Types
  • NULLs
  • Column Attributes
  • Metadata Access Methods
  • The INFORMATION_SCHEMA Database/Schema
  • Using SHOW and DESCRIBE
  • The mysqlshow Command
  • Storage Engine Overview
  • MyISAM, InnoDB, and MEMORY Storage Engines
  • Other Storage Engines
  • Choosing Appropriate Storage Engines
  • Using Multiple Storage Engines
  • Storage Engine Comparison Chart
  • Overview of Partitioning and reasons for using Partitioning
  • Creating a Partitioned Table
  • Obtaining Partition Information
  • Modifying and Removing Partitions
  • Partition Modification Performance Effects
  • Partition Pruning
  • Storage Engine Partition Information
  • Partitioning and Locking and Limitations
  • Transactions
  • Transaction Control statements
  • Isolation Levels
  • Locking
  • Security Risks
  • Security Measures
  • Privileges
  • Access Levels, including: 1 – User Accounts, 2 – Databases, 3 – Tables, 4 – Columns, 5 – Stored Routines
  • User Account Maintenance
  • Client Access Control
  • Using Secure Connections
  • Table Maintenance
  • SQL Statements for maintenance operations
  • Client and Utility Programs for table maintenance
  • Table Maintenance per Storage Engine
  • Exporting and Importing Data
  • Exporting and Importing Data Using SQL
  • Import Data with the SQL scripts
  • Defining, Executing and Examining Stored Routines
  • Stored Routines and Execution Security
  • Defining, Creating, and Deleting Triggers
  • Trigger Restrictions and Privileges
  • Defining Events
  • Schedule Events
  • DBA’s Use of MySQL Programming
  • Backup Stored Routines
  • What is a view?
  • Creating Views
  • Updatable Views
  • Managing Views
  • Planning for Recovery Backup
  • Backup Tools Overview
  • Making Raw Backups
  • Making Logical (Text) Backups
  • Backup Log and Status Files
  • Replication as an Aid to Backup
  • Backup Method Comparison
  • Data Recovery
  • Using EXPLAIN to Analyze Queries
  • General Table Optimizations
  • Setting and Interpreting MySQL Server Variables
  • MySQL Replication
  • Course Overview
  • Training and Certification Website
  • Course Evaluation
  • Thank You!
  • Q&A Session

Have Any Questions?

We are happy to answer any questions and we appreciate every feedback about our work!