D66376OROracleOR-D663764.0<ul> <li>Define and implement a backup strategy</li><li>Perform physical and logical backups of your data</li><li>Describe MySQL replication and its role in high availability and scalability</li><li>Configure simple and complex replication topologies</li><li>Administer a replication topology</li><li>Install the MySQL server and client programs</li><li>Upgrade MySQL on a running server</li><li>Describe MySQL architecture</li><li>Explain how MySQL processes, stores, and transmits data</li><li>Configure MySQL server and client programs</li><li>Use server logs and other tools to monitor database activity</li><li>Create and manage users</li><li>Protect your data from common security risks</li><li>Identify and optimize poorly-performing queries</li><li>Troubleshoot server slowdowns and other common problems</li><li>Gain an understanding of MySQL Cloud</li></ul><h5>Required Prerequisites:</h5><ul> <li>Should be knowlegeable with relational database concepts and using the mysql command-line client</li><li>Should be knowlegeable with MySQL data types and executing basic DDL and DML queries using SQL</li><li>Should be knowlegeable with Joining tables</li><li><span class="attentionbbcode" title="inactive or disabled course: OR-D90871">!</span>MySQL Fundamentals <span class="fl-prod-pcode">(D90871)</span></li></ul><h5>Suggested Prerequisites:</h5><ul> <li><span class="attentionbbcode" title="inactive or disabled course: OR-D61830">!</span>MySQL for Developers <span class="fl-prod-pcode">(D61830)</span></li></ul><ul> <li>Database Administrators</li><li>Database Developers</li><li>Technical Consultant</li></ul><ul> <li>Introduction to MySQL</li><li>Installing MySQL</li><li>MySQL Architecture</li><li>Configuring MySQL</li><li>Monitoring MySQL</li><li>User Management</li><li>MySQL Security</li><li>Maintaining a Stable System</li><li>Optimizing Query Performance</li><li>Backup Strategies</li><li>Performing Backups</li><li>Configuring a Replication Topology</li><li>Administering a Replication Topology</li><li>Group Replication</li><li>Conclusion</li></ul><h5>Introduction to MySQL</h5><ul> <li>MySQL overview</li><li>MySQL Enterprise Edition</li><li>MySQL on the Web</li><li>MySQL in the Cloud</li><li>The MySQL community</li></ul><h5>Installing MySQL</h5><ul> <li>Installing MySQL</li><li>Installed Files and Directories</li><li>Initial Configuration</li><li>Starting and Stopping MySQL</li><li>Upgrading MySQL</li></ul><h5>MySQL Architecture</h5><ul> <li>Architectural Overview</li><li>How MySQL Transmits Data</li><li>How MySQL Processes Requests</li><li>How MySQL Stores Data</li><li>Tablespaces</li><li>Redo and Undo Logs</li><li>How MySQL Uses Memory</li><li>Plug-in Interface</li></ul><h5>Configuring MySQL</h5><ul> <li>Server Options, Variables, and the Command Line</li><li>Option Files</li><li>System Variables</li><li>Launching Multiple Servers on the Same Host</li></ul><h5>Monitoring MySQL</h5><ul> <li>Monitoring MySQL with Log Files</li><li>Monitoring MySQL with Status Variables</li><li>Monitoring MySQL with Performance Schema</li><li>MySQL Enterprise Audit</li><li>MySQL Enterprise Monitor</li><li>Monitoring User Activity</li></ul><h5>User Management</h5><ul> <li>MySQL Privilege System</li><li>Creating and Modifying User Accounts</li><li>Configuring Passwords and Account Expiration</li><li>Authentication Plug-Ins</li><li>Granting Permissions</li><li>Grant Tables</li><li>Resetting a Forgotten Root Password</li></ul><h5>MySQL Security</h5><ul> <li>Security Risks</li><li>Network Security</li><li>Secure Connections</li><li>Password Security</li><li>Operating System Security</li><li>Protecting Against SQL Injections</li><li>MySQL Enterprise Firewall</li></ul><h5>Maintaining a Stable System</h5><ul> <li>Stability</li><li>Why Databases Fail</li><li>Capacity Planning</li><li>Troubleshooting</li><li>Identifying the Causes of Server Slowdowns</li><li>InnoDB Recovery</li></ul><h5>Optimizing Query Performance</h5><ul> <li>Identifying Slow Queries</li><li>The EXPLAIN statement</li><li>Working with Indexes</li><li>Index Statistics</li></ul><h5>Backup Strategies</h5><ul> <li>Understanding Backups</li><li>Backup Techniques</li><li>Creating a Backup Strategy</li></ul><h5>Performing Backups</h5><ul> <li>MySQL Backup Tools</li><li>Raw Backup Methods</li><li>Techniques that Use the Binary Log</li></ul><h5>Configuring a Replication Topology</h5><ul> <li>Overview of Replication</li><li>Replication Conflicts</li><li>When to Use Replication</li><li>Configuring Replication</li></ul><h5>Administering a Replication Topology</h5><ul> <li>Failover</li><li>MySQL Utilities</li><li>Replication Threads</li><li>Monitoring Replication</li><li>Troubleshooting Replication</li></ul><h5>Group Replication</h5><ul> <li>Overview</li><li>Single-Primary and Multi-Primary Modes</li><li>Configuring Group Replication</li><li>Monitoring Group Replication</li></ul><h5>Conclusion</h5><ul> <li>Course Overview</li><li>MySQL Curriculum</li><li>Course Evaluation</li><li>Thank You!</li><li>Q&amp;A Session</li></ul>- Define and implement a backup strategy - Perform physical and logical backups of your data - Describe MySQL replication and its role in high availability and scalability - Configure simple and complex replication topologies - Administer a replication topology - Install the MySQL server and client programs - Upgrade MySQL on a running server - Describe MySQL architecture - Explain how MySQL processes, stores, and transmits data - Configure MySQL server and client programs - Use server logs and other tools to monitor database activity - Create and manage users - Protect your data from common security risks - Identify and optimize poorly-performing queries - Troubleshoot server slowdowns and other common problems - Gain an understanding of MySQL CloudRequired Prerequisites: - Should be knowlegeable with relational database concepts and using the mysql command-line client - Should be knowlegeable with MySQL data types and executing basic DDL and DML queries using SQL - Should be knowlegeable with Joining tables - MySQL Fundamentals (D90871) Suggested Prerequisites: - MySQL for Developers (D61830)- Database Administrators - Database Developers - Technical Consultant- Introduction to MySQL - Installing MySQL - MySQL Architecture - Configuring MySQL - Monitoring MySQL - User Management - MySQL Security - Maintaining a Stable System - Optimizing Query Performance - Backup Strategies - Performing Backups - Configuring a Replication Topology - Administering a Replication Topology - Group Replication - ConclusionIntroduction to MySQL - MySQL overview - MySQL Enterprise Edition - MySQL on the Web - MySQL in the Cloud - The MySQL community Installing MySQL - Installing MySQL - Installed Files and Directories - Initial Configuration - Starting and Stopping MySQL - Upgrading MySQL MySQL Architecture - Architectural Overview - How MySQL Transmits Data - How MySQL Processes Requests - How MySQL Stores Data - Tablespaces - Redo and Undo Logs - How MySQL Uses Memory - Plug-in Interface Configuring MySQL - Server Options, Variables, and the Command Line - Option Files - System Variables - Launching Multiple Servers on the Same Host Monitoring MySQL - Monitoring MySQL with Log Files - Monitoring MySQL with Status Variables - Monitoring MySQL with Performance Schema - MySQL Enterprise Audit - MySQL Enterprise Monitor - Monitoring User Activity User Management - MySQL Privilege System - Creating and Modifying User Accounts - Configuring Passwords and Account Expiration - Authentication Plug-Ins - Granting Permissions - Grant Tables - Resetting a Forgotten Root Password MySQL Security - Security Risks - Network Security - Secure Connections - Password Security - Operating System Security - Protecting Against SQL Injections - MySQL Enterprise Firewall Maintaining a Stable System - Stability - Why Databases Fail - Capacity Planning - Troubleshooting - Identifying the Causes of Server Slowdowns - InnoDB Recovery Optimizing Query Performance - Identifying Slow Queries - The EXPLAIN statement - Working with Indexes - Index Statistics Backup Strategies - Understanding Backups - Backup Techniques - Creating a Backup Strategy Performing Backups - MySQL Backup Tools - Raw Backup Methods - Techniques that Use the Binary Log Configuring a Replication Topology - Overview of Replication - Replication Conflicts - When to Use Replication - Configuring Replication Administering a Replication Topology - Failover - MySQL Utilities - Replication Threads - Monitoring Replication - Troubleshooting Replication Group Replication - Overview - Single-Primary and Multi-Primary Modes - Configuring Group Replication - Monitoring Group Replication Conclusion - Course Overview - MySQL Curriculum - Course Evaluation - Thank You! - Q&A Session5 days2390.002390.00