Ponuka kurzov

Zasielanie noviniek




Autorizované školenia

  • Microsoft Partner Gold Learning
  • ORACLE Gold Partne
  • HP Eperto One
  • IBM Authorized Training
  • Apple Authorized Training Center
Potrebujete pomoc?
FAQ Kontakty Kontaktný formulár
Kontaktný formulár


Kontakty
Kód kurzu: D62178GC10« Krok zpět

MySQL Performance Tuning Bootcamp Accelerated Ed 1 (SQL-4552)

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!

Podrobnejšie informácie o kurze
Neboli nájdené žiadne termíny, kontaktujte náš klientsky servis.
V prípade záujmu o iný termín uvedeného kurzu, kontaktujte klientsky servis, prosím.

PobočkaDníKatalógová cenaCena príručkyITB
Bratislava5 3 492,00 EUR - 0

Požadované predpokladané znalosti

Ciele kurzu

  • Perform common DBA tasks
  • Use the INFORMATION_SCHEMA database to access metadata
  • Install and Upgrade
  • Perform start and shutdown
  • Configure server options
  • Utilize partitioning
  • Scale MySQL operations up
  • Develop a tuning strategy
  • Create, Maintain and Manage MySQL tables
  • Write queries
  • Display, decipher and edit server configuration variables to improve performance
  • Backup and restore

Témy kurzu

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

Predošlé kurzy

žiadne predošlé kurzy

Nasledujúce kurzy

žiadny nadväzujúci kurz
Žiadna literatura.
Uvedené ceny sú bez DPH.