|
Learn Oracle from Oracle - Original Oracle University Seminar
Nur Oracle University Schulungen bieten die notwendige Voraussetzung zur Teilnahme an den Prüfungen zum:
OCA (Oracle Certified Assosiate)
OCP (Oracle Certified Professional)
OCM (Oracle Certified Master)
Seminarinhalt
Teilnehmerkreis
Vorkenntnisse
Sachgebiete
The MySQL[tm] Database Administrators and Performance Tuning Boot Camp training course provides students with an 11 hour-per-day immersion into the world of MySQL database administration. The program is an accelerated course that provides those individuals who want to learn how to administer MySQL servers along with the know-how to ensure that their servers perform optimally through performance monitoring and tuning. Students will learn from MySQL-Certified experts through a combination of lab exercises, lectures, and presentations. This is an intense immersion learning experience - live, breathe, eat, drink, MySQL administration and advanced performance tuning for one week!
Students that can benefit:
- MySQL Database Administrators looking for an intensive approach to learning to administer the database
nach oben
- Administratoren
- Technischer Berater
- Projektmanager
nach oben
Erforderliche Vorkenntnisse:
- Having attended the MySQL for Beginners course or some experience with Relational Databases and SQL.
- MySQL for Beginners
nach oben
Installing MySQL
- Installing the world Database
MySQL Architecture (PT 3.0 - Chapter 2)
- MySQL Architecture Overview (High Level)
- Client/Server Architecture
- Storage Engine Concept
- Data Directory
- Data Storage
- Locks
The MySQL Server (DBA 2.1 - Chapter 3)
- Types of MySQL Distributions
- Starting and Stopping MySQL on Windows
- Starting and Stopping MySQL on Linux
- Upgrading MySQL
Configuring the MySQL Server (DBA 2.1 - Chapter 4)
- MySQL Configuration
- Dynamic Server Variables
- Server SQL Modes
- Log and Status Files
- Binary Logging
MySQL Clients (DBA 2.1 - Chapter 5)
- Overview of Administrative Clients
- Invoking MySQL Client Programs
- Using the mysql Client
- The mysqladmin Client
- MySQL Connectors
- Third-Party APIs
MySQL Performance Tools (PT 3.0 - Chapter 3)
- Overview
- Benchmarking Tools
- Administration Tools
- Specific SHOW commands
Overview of Data Types (DBA 2.1 - Chapter 6)
- Data Types
- Numeric Data Types
- Character String Data Types
- NULLs
- Column Attributes
Schema Design (PT 3.0 - Chapter 4)
- Data Modeling
- Normalization
- Denormalization
- Data Types
- Partitioning
Metadata (DBA 2.1 - Chapter 7)
- Metadata Access Methods
- The INFORMATION_SCHEMA Database/Schema
- Using SHOW and DESCRIBE
- The mysqlshow Client
Storage Engines (DBA 2.1 - Chapter 8)
- Storage Engine Overview
- MyISAM Storage Engine
- InnoDB Storage Engine
- MEMORY Storage Engine
- Choosing Appropriate Storage Engines
- Using Multiple Storage Engines
- Storage Engine Comparison Chart
Partitioning (DBA 2.1 - Chapter 9)
- Creating a Partitioned Table
- Obtaining Partition Information
- Modifying and Removing Partitions
- Modification Performance Effects
- Pruning
- Storage Engine Partition Information
- Locking
- Limitations
Transactions and Locking (DBA 2.1 - Chapter 10)
- Transactions
- Transaction Control statements
- Isolation Levels
- Locking
Security and User Management (DBA 2.1 - Chapter 11)
- Security Risks
- Security Measures
- Privileges
- Access Levels
- User Account Maintenance
- Client Access Control
- Using Secure Connections
Table Maintenance (DBA 2.1 - Chapter 12)
- Table Maintenance
- SQL Statements for maintenance operations
- Client and Utility Programs for table maintenance
- Table Maintenance per Storage Engine
Exporting and Importing Data (DBA 2.1 - Chapter 13)
- Exporting and Importing Data
- Exporting and Importing Data Using SQL
- Import Data with the SQL scripts
Views (DBA 2.1 - Chapter 16)
- What is a view?
- Creating Views
- Updatable Views
- Managing Views
Programming with MySQL (DBA 2.1 - Chapter 14)
- Defining, Executing Stored Routines
- Execution Security
- Defining, Creating, Deleting Triggers
- Trigger Restrictions, Privileges
- Schedule Events
- DBAs Use of MySQL Programming
- Backup Stored Routines
Backup and Recovery (DBA 2.1 - Chapter 15)
- Planning for Recovery Backup
- Backup Types
- Backup Tools Overview
- Making Backups
- Backup Log and Status Files
- Replication as an Aid to Backup
- Backup Method Comparison
- Data Recovery
Managing Multiple Servers (DBA 2.1 - Chapter 20)
- Using Multiple Servers
- MySQL Replication
- MySQL Cluster Replication
Indexing (PT 3.0 - Chapter 5)
- Indexes
- MySQL Index Types
- Index Optimizations
Index Optimizations
- General SQL Tuning
- Caching
- General Monitoring
- Table Cache and Multi-threading Issues
- Row Storage Format
- MyISAM Tuning
- Transactions
- Crash Recovery
Dauer
Dauer: 5 Tage
nach oben
|
