MySQL Administration

Focused View

Pinal Dave

2:01:08

61 View

1. Course Overview

1. Course Overview.mp4

01:24

2. Exploring Core MySQL Administration

1. Introduction.mp4

02:01

2. Importance of MySQL Administration.mp4

02:16

3. MySQL Architecture Overview.mp4

04:39

4. Demo - Installing and Configuring MySQL Server.mp4

02:21

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

07:28

6. Summary.mp4

01:08

3. Optimizing, Tuning, and Monitoring Performance

1. Introduction.mp4

01:37

2. Evaluating MySQL Server Tuning.mp4

09:46

3. Demo - Analyzing Query Performance and Index Tuning.mp4

11:23

4. Demo - Measuring Performance with MySQL.mp4

09:35

5. Demo - Monitoring and Optimizing Performance in MySQL.mp4

08:20

6. Demo - Leveraging Functions and Operators in MySQL.mp4

05:10

7. Summary.mp4

01:20

4. Securing and Protecting MySQL

1. Introduction.mp4

02:07

2. Understanding Backups and Recovery Strategies.mp4

08:50

3. Demo - Exploring Backup and Recovery Methods.mp4

05:22

4. Implementing Security Measures in MySQL.mp4

06:12

5. Demo - Managing User Accounts and Privileges.mp4

07:59

6. Summary.mp4

01:24

5. Advanced Administration Techniques and Scaling Solutions

1. Introduction.mp4

01:24

2. Demo - Exploring the MySQL Data Dictionary.mp4

05:10

3. Evaluating Partitioning for Performance and Manageability.mp4

04:26

4. Designing High Availability Architectures.mp4

07:26

5. Summary.mp4

02:20

Description

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.

What You'll Learn?

In this course, MySQL Administration, you'll acquire essential skills for managing, optimizing, and securing MySQL databases. First, you'll explore MySQL administration concepts, roles, and architecture. You'll learn to install, configure, and use MySQL command-line tools and utilities. Next, you'll focus on performance optimization, covering server tuning, query analysis, and index optimization to enhance database performance and scalability. Finally, you'll learn to secure MySQL databases with backup and recovery strategies, user account management, and security measures. By the end of this course, you'll have a solid understanding of MySQL administration, enabling you to effectively manage and optimize MySQL databases, ensuring high performance, security, and scalability.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Pinal Dave

Instructor's Courses

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.