Mysql For Database Administrator

Free Download Mysql For Database Administrator
Published 6/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.34 GB | Duration: 10h 28m
Oracle MySQL for DBA

What you’ll learn
Learn to manage MySQL Database Administration
Understanding MySQL Architecture
Configuring MySQL like a Professional
Securing MySQL
Configuring a Replication Topology
Administering a Replication Topology
High Availability with MySQL InnoDB Cluster
Requirements
RDBMS Knowledge
MySQL Database Basic idea
Description
Learn about the MySQL database, which is the world’s most popular open-source database and the best database for web based applications, powering leading websites worldwide, including Facebook, Twitter, and YouTube. MySQL is a well-known open source structured database because of its performance, easiness to use, and reliability. This is the most common choice of web applications for a relational database. In the current market, thousands of web-based applications rely on MySQL including giant industries such as Facebook, Twitter, and Wikipedia. It has also proven to be the database choice for Software as a Service (SaaS) based applications such as Twitter, YouTube, SugarCRM, Supply Dynamics, Workday, RightNow, Omniture, Zimbra, and many more. We will discuss this in detail in the use cases of MySQL section later in the chapter. MySQL was developed by MySQL AB, a Swedish company, and now it is distributed and supported by Oracle Corporation. MySQL carries a valuable history with it.Let’s take an in-depth look at MySQL 8 new features, benefits, use cases along with a few limitations of MySQL 8 after we have an overview of MySQL. This is going to be exciting, let’s get prepared. Many industries prefer open source technology because of the technology’s flexibility and cost-saving features, while MySQL has put its footprint in the market by becoming the most popular relational database for web applications. Open source means that you can view the source of MySQL and customize it based on your needs without any cost. You can download the source or binary files from its site and use them accordingly.The MySQL server is covered under the General Public License (GNU), which means that we can freely use it for web applications, study its source code, and modify it to suit our needs. It also has the Enterprise Edition as well with advanced features included. Many enterprises still purchase the support contract from MySQL to get ssistance on various issues.
Overview
Section 1: Introduction
Lecture 1 Introduction to MySQL Lab Environment
Section 2: Installing and Upgrading MySQL
Lecture 2 Installation and Upgrade MySQL
Lecture 3 Install MySQL on Linux
Lecture 4 Installing MySQL
Lecture 5 Installed Files and Directories
Lecture 6 Connecting to MySQL
Lecture 7 Configuring the MySQL Service
Lecture 8 Upgrading MySQL
Lecture 9 Deploying MySQL with Docker
Section 3: Understanding MySQL Architecture
Lecture 10 Configuring Tablespaces
Lecture 11 Configuring the Buffer Pool
Section 4: Configuring MySQL
Lecture 12 Modifying a Setting by Using Command-Line Arguments
Lecture 13 Modifying the Configuration File
Lecture 14 Changing Dynamic Settings
Lecture 15 Persisting Global Variables
Lecture 16 Configuring the Client
Lecture 17 Running Multiple MySQL Servers on the Same Host
Section 5: Monitoring MySQL
Lecture 18 Configuring the Slow Query Log
Lecture 19 Identify Slow Query Log
Lecture 20 Installing MySQL Enterprise Monitor
Lecture 21 Monitoring Server Activity
Section 6: Managing MySQL Users
Lecture 22 Creating Users and Roles
Lecture 23 Granting Permissions
Section 7: Securing MySQL
Lecture 24 Enabling SSL for Secure Connections
Lecture 25 Enabling SSL for Secure Connections_Demo
Lecture 26 Encrypting MySQL Data-at-Rest
Lecture 27 Configuring MySQL Enterprise Firewall
Professional DBA,Database Administrator,MySQL DBA,MySQL Database Administrator

Homepage

www.udemy.com/course/mysqldba/