Last updated 6/2018MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 3.93 GB | Duration: 8h 27m
Store, retrieve, and manipulate your data and design efficient database solutions with MySQL 8 What you'll learn Handle MySQL user management Set up and operate MySQL replication, including moving to GTID based replication Hands on experience of operations carried out on MySQL instances, running sysbench against them, and producing a workload Perform administration and performance-tuning tasks Master the new querying features in MySQL 8 Access databases with PHP, Python, or Java Requirements Basic understanding of database concepts is all you need Description MySQL is the most popular and widely used relational databases in the World today. The main purpose of this comprehensive course is to assist you on setting up MySQL 8 and running with replication, learn about database administration topics like backups, replication, monitoring, and point in recovery, switchovers, user management and version upgrades. It is packed with step-by-step instructions and working examples to solve any problem you might come across in MySQL querying and administrationContents and OverviewThis training program includes 2 complete courses, carefully chosen to give you the most comprehensive training possible.The first course, MySQL 8 for Administrators, covers the differences between various MySQL versions. It starts off with the basics: Installing MySQL and creating users. After that, we will get sysbench up and running. Sysbench, responsible for issuing queries against databases, is the de-facto benchmarking tool for MySQL. With that hands-on lab environment at hand, we will learn about various database administration topics like backups, replication, monitoring, and point in recovery, switchovers, user management and version upgrades. The second course, MySQL 8 Recipes, contains practical recipes on efficient MySQL administration, with tips on effective user management, security, database monitoring, troubleshooting, and more. Supplying quick solutions to common problems you might encounter while working with MySQL, the tutorial contains practical tips and tricks to give you the edge over others while designing, developing, and administering your MySQL solution. By the end of this training program, you will be well versed with high-performance querying and database administration using MySQL.About the Authors Peter Boros has more than 10 years of MySQL administration experience. Peter has also taught Oracle University courses about MySQL across EMEA, later he was a Principal Architect at Percona, a company specializing in MySQL consulting. Apart from this, he has worked with a few of the world’s largest MySQL deployments, belog to prestigious web properties. This course is a product of Peter’s immense work experience and his expertise on the subject.Simon Krenger is a Database Eeer for the Swiss Federal Railways (SBB) in Bern, Switzerland. He has worked with a wide variety of technologies, including Oracle databases (OCP), Linux, and automation software. He focuses on Information Security and has gained experience with common agile software development practices. Overview Section 1: MySQL 8 for Administrators Lecture 1 Course Overview Lecture 2 A Lab About the Labs Lecture 3 MySQL 8 Installation from Rpm Packages Lecture 4 MySQL 8 Installation from Deb Packages Lecture 5 Set Up MySQL 8 from Binary Tarball Lecture 6 Chag Configuration Parameters in my.cnf Lecture 7 Chag MySQL Configuration Parameters Online Lecture 8 New in MySQL 8: Persisting Configuration Parameters Lecture 9 Essential MySQL Configuration Parameters Lecture 10 Essential InnoDB Lecture 11 Creating Databases and Users for Applications Lecture 12 Detour: MySQL Usage Basics Lecture 13 New in MySQL 8: Roles Lecture 14 Using sysbench Lecture 15 Authentication Changes Lecture 16 The Binary Log Lecture 17 Setting Up a Replication Slave Lecture 18 Introduction to GTID Replication Lecture 19 Migrating to GTID Replication Lecture 20 Command Line Monitoring Lecture 21 External Monitoring Systems Lecture 22 Logical Backups Lecture 23 Physical Backups Lecture 24 Point in Recovery Lecture 25 Switchovers Lecture 26 Advanced Replication Lecture 27 Checking Replication Consistency Lecture 28 Migration Consideration Lecture 29 Replication Consistency Before Migration Lecture 30 Verifying Query Behavior Before Migration Section 2: MySQL 8 Recipes Lecture 31 The Course Overview Lecture 32 Learning MySQL 8 Lecture 33 Getting to Know the MySQL 8 Architecture Lecture 34 Installation via Package Manager Lecture 35 Installation via Manual Package Lecture 36 Upgrading an Existing Database to MySQL 8 Lecture 37 Using Tools to Access the Database Lecture 38 Getting to Know Your Database Lecture 39 Perfog Initial Database Configuration Lecture 40 Accessing the Data Dictionary Lecture 41 Managing Users Lecture 42 Perfog Basic Troubleshooting Lecture 43 Configuring Security Lecture 44 Perfog Backup and Recovery of Your Database Lecture 45 Optimizing Performance with Query Execution Plans Lecture 46 Learning SQL: Querying Data Lecture 47 Learning SQL: Inserting and Modifying Data Lecture 48 Learning SQL: Design Databases Lecture 49 Learning Best Practices for Writing Queries Lecture 50 Using the New Querying Features in MySQL 8 Lecture 51 Working with Indexes Lecture 52 Managing Big Databases Using Partitioning Lecture 53 Programming with PHP Lecture 54 Using a PHP Database Abstraction Layer Lecture 55 Programming with Python Lecture 56 Programming with Java New and returning MySQL DBAs, who are just getting to know MySQL, or who knew earlier versions and are curious about the latest administration differences in MySQL 8 HomePage: gfxtra__MySQL_Beco.part1.rar.html gfxtra__MySQL_Beco.part2.rar.html
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.