Company: Packt Publishing Author: Simon Krenger Full Title: MySQL 8 Recipes Year: 2017 Language: English Genre: Educational: Big Data Skill Level: - Price: €124.99 - Files: MP4 (+ Code Files) Time: 03:02:04 Video: AVC, 1920 x 1080 (1.778) at 30.000 fps, 500 kbps Audio: AAC at 160 Kbps, 2 channels, 48.0 KHz Recipes to guide you in MySQL 8 anytime. MySQL is one of the most popular and widely used relational databases in the World today. With the recently released MySQL 8, it promises to be better and more efficient than ever, giving you high-performance querying results and easy configurability as an administrator. This course contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and configuration of your MySQL instance, the video jumps into the querying aspects of MySQL and shows you the newest improvements in MySQL 8 when it comes to querying and programming with other languages such as Python, PHP, and more. If you’ve already worked with MySQL before and are looking to migrate your solution to MySQL 8, this video will also show you how to do that. The tutorial also 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. Style and Approach: This friendly course takes you through MySQL 8. It is packed with step-by-step instructions and working examples. This comprehensive course is divided into clear bite-size chunks so you can learn at your own pace and focus on the areas of most interest to you. Learn: ✓ Install and configure a new MySQL 8 database ✓ Upgrade existing databases to MySQL 8 ✓ Perform typical administration tasks ✓ Master the new querying features in MySQL 8 ✓ Perform performance-tuning tasks ✓ Optimize your database ✓ Access databases with PHP, Python, or Java Features: ✓ Store, retrieve, and manipulate your data and design efficient database solutions with MySQL 8 ✓ Solve any problem you might come across in MySQL querying and administration ✓ A practical tutorial designed for MySQL developers and administrators Lessons: 1. Overview and Installation 01. The Course Overview 02. Learning MySQL 8 03. Getting to Know the MySQL 8 Architecture 04. Installation via Package Manager 05. Installation via Manual Package 06. Upgrading an Existing Database to MySQL 8 2. Working with the Database 07. Using Tools to Access the Database 08. Getting to Know Your Database 09. Performing Initial Database Configuration 10. Accessing the Data Dictionary 11. Managing Users 3. Administration Topics 12. Performing Basic Troubleshooting 13. Configuring Security 14. Performing Backup and Recovery of Your Database 15. Optimizing Performance with Query Execution Plans 4. Querying the Database 16. Learning SQL: Querying Data 17. Learning SQL: Inserting and Modifying Data 18. Learning SQL: Design Databases 19. Learning Best Practices for Writing Queries 20. Using the New Querying Features in MySQL 8 21. Working with Indexes 22. Managing Big Databases Using Partitioning 5. Programming Examples 23. Programming with PHP 24. Using a PHP Database Abstraction Layer 25. Programming with Python 26. Programming with Java Our members see more. Join us! ------------- Our members see more. Join us!