MySQL Administration

سرفصل های دوره

In this course, you'll learn essential concepts and practical techniques to effectively adminstrate MySQL databases, including performance tuning, security, query optimization, partitioning, and high availability architectures.

1. Course Overview

1. Course Overview

2. Exploring Core MySQL Administration

1. Introduction

2. Importance of MySQL Administration

3. MySQL Architecture Overview

4. Demo - Installing and Configuring MySQL Server

5. Demo - Utilizing MySQL Command-line Tools and Utilities

6. Summary

3. Optimizing, Tuning, and Monitoring Performance

1. Introduction

2. Evaluating MySQL Server Tuning

3. Demo - Analyzing Query Performance and Index Tuning

4. Demo - Measuring Performance with MySQL

5. Demo - Monitoring and Optimizing Performance in MySQL

6. Demo - Leveraging Functions and Operators in MySQL

7. Summary

4. Securing and Protecting MySQL

1. Introduction

2. Understanding Backups and Recovery Strategies

3. Demo - Exploring Backup and Recovery Methods

4. Implementing Security Measures in MySQL

5. Demo - Managing User Accounts and Privileges

6. Summary

5. Advanced Administration Techniques and Scaling Solutions

1. Introduction

2. Demo - Exploring the MySQL Data Dictionary

3. Evaluating Partitioning for Performance and Manageability

4. Designing High Availability Architectures

5. Summary

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight