MySQL Performance

Course code: MYSQLP

This training teaches how to safely and effectively optimize the performance of MySQL server.

620 EUR

750 EUR including VAT

The earliest date from 22.04.2024

Selection of dates

onas

Do you have a question?

+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

View soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates
Course description
Course structure

Course dates

Starting date: 22.04.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Starting date: 17.06.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Starting date: 19.08.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Starting date: 14.10.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Starting date: 09.12.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

Starting date: Upon request

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 620 EUR

	Starting date	Place	Type	Course duration	Language	Price without VAT
	22.04.2024		In-person/Virtual	2 days	en/cz	620 EUR	Register

	17.06.2024		In-person/Virtual	2 days	en/cz	620 EUR	Register

	19.08.2024		In-person/Virtual	2 days	en/cz	620 EUR	Register

	14.10.2024		In-person/Virtual	2 days	en/cz	620 EUR	Register

	09.12.2024		In-person/Virtual	2 days	en/cz	620 EUR	Register

	Upon request		In-person/Virtual	2 days	en/cz	620 EUR	Register
G	Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Course description

This training teaches how to safely and effectively optimize the performance of MySQL server. Students understand how to use the tools to monitor, evaluate and tune. The course makes participants proficient in evaluating architecture, using tools, configuring databases, and tuning SQL code and applications.

Course structure

Performance Schema
Memory, Connections, and Threads
Tables, Files, and Logs
Statement Monitoring, Sort Buffer and Query Cache
InnoDB Storage Engine
Schema Design and Performance
Query Optimization
Using EXPLAIN to Analyze Queries
General Table Optimizations
Monitoring status variables that affect performance

Follow-up courses

MongoDB Developer en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MongoDB Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MySQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL for DB Developers en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Performance en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

SQL for beginners en/cz

Vendor: EDU Trainings

Area: Databases

Price from

460 EUR without VAT

SQL for intermediate users en/cz

Vendor: EDU Trainings

Area: Databases

Price from

460 EUR without VAT

MS SQL Server administration comprehensively and efficiently en/cz

Vendor: EDU Trainings

Area: Databases

Price from

1 210 EUR without VAT

Optimization and monitoring of T-SQL queries en/cz

Vendor: EDU Trainings

Area: Databases

Price from

790 EUR without VAT