100%

Use MySQL Shell, the first modern and advanced client for connecting to and interacting with MySQL. It supports SQL, Python, and JavaScript. That’s right! You can write Python scripts and execute them within the shell interactively, or in batch mode. The level of automation available from Python combined with batch mode is especially helpful to those practicing DevOps methods in their database environments. Introducing MySQL Shell covers everything you need to know about MySQL Shell. You will learn how to use the shell for SQL, as well as the new application programming interfaces for working with a document store and even automating your management of MySQL servers using Python. The book includes a look at the supporting technologies and concepts such as JSON, schema-less documents, NoSQL, MySQL Replication, Group Replication, InnoDB Cluster, and more. MySQL Shell is the client that developers and database administrators have been waiting for. Far more powerful than the legacy client, MySQL Shell enables levels of automation that are useful not only for MySQL, but in the broader context of your career as well. Automate your work and build skills in one of the most in-demand languages. With MySQL Shell, you can do both! What You'll LearnUse MySQL Shell with the newest features in MySQL 8 Discover what a Document Store is and how to manage it with MySQL Shell Configure Group Replication and InnoDB Cluster from MySQL Shell Understand the new MySQL Python application programming interfaces Write Python scripts for managing your data and the MySQL high availability features Who This Book Is For Developers and database professionals who want to automate their work and remain on the cutting edge of what MySQL has to offer. Anyone not happy with the limited automation capabilities of the legacy command-line client will find much to like in this book on the MySQL Shell that supports powerful automation through the Python scripting language.

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL Key FeaturesExplore the new and advanced features of MySQL 8.0Use advanced techniques to optimize MySQL performanceCreate MySQL-based applications for your enterprise with the help of practical examplesBook Description Advanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential. By the end of this book, you’ll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments. What you will learnExplore new and exciting features of MySQL 8.0Analyze and optimize large MySQL queriesUnderstand MySQL Server 8.0 settingsMaster the deployment of Group Replication and use it in an InnoDB clusterMonitor large distributed databasesDiscover different types of backups and recovery methods for your databasesExplore tips to help your critical data reach its full potentialWho this book is for Advanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.

Get a comprehensive overview on how to set up and design an effective database with MySQL. This thoroughly updated edition covers MySQL's latest version, including its most important aspects. Whether you're deploying an environment, troubleshooting an issue, or engaging in disaster and recovery, this practical guide provides the insights and tools necessary to take full advantage of this powerful RDBMS. Authors Vinicius Grippa and Sergey Kuzmichev from Percona show developers and DBAs methods for minimizing costs and maximizing availability and performance. You'll learn how to perform basic and advanced querying, monitoring and troubleshooting, database management and security, backup and recovery, and tuning for improved efficiency. This edition includes new chapters on high availability, load balancing, and using MySQL in the cloud. Learning MySQL will help you: Deploy MySQL databases on bare metal, on virtual machines, and in the cloud Design database infrastructures Code highly efficient queries Monitor and troubleshoot MySQL databases Execute efficient backup and restore operations Optimize database costs in the cloud Understand database concepts, especially those pertaining to MySQL

If you're a developer, you just can't ignore databases.Databases are the storage of the information that your program will process. From a simple web-app to a world-class corporation, data is inside databases.You have to know how to read, process and handle them.With this practical manual you will learn how to work with SQL databases, with a focus on MySQL.You'll have access to practical examples and discover the basics to start working with these powerful tools. With this book you will learn ... ▸ What is a database and why it is essential for any web project ▸ What are the types of databases and why you need to know MySQL ▸ How to create your development environment on Windows, Mac and Linux ▸ How to create and manage databases ▸ Functions to create and handle tables ▸ How to manage relationships between tables ▸ Sorting and aggregation functions ▸ What is MySQL Workbench and how to use it

Databases are everywhere, from social media and gaming to finance, government, and healthcare. Wrangling data into an organized and easily accessible form is key to unlocking better entertainment, cures for diseases, and reducing crime in our modern world. Through the colorful, unique activities in this volume, readers will learn how to change the world with data using structured query language or SQL and relational databases. These hands-on projects explore how databases are designed and structured, and how to update, change, and use them for analytics.

Are you a networking pro or a newbie? Our Networking Quiz will help you find out! From the basics of network architecture and protocols to advanced topics such as virtualization and cloud computing, this quiz covers a wide range of networking concepts. Test your knowledge of network design, troubleshooting, and management, and see how well you can navigate the complexities of modern networking. Whether you're a networking enthusiast or a professional in the field, this quiz is a great way to brush up on your skills and expand your knowledge.

How well do you know the ins and outs of cyber security? In today's digital world, it's more important than ever to stay informed and up-to-date on the latest security threats and trends. Our Cyber Security Quiz is designed to help you do just that. This quiz covers a range of topics related to cyber security, including network security, encryption, malware, phishing, and more. Test your knowledge and see how well you fare against today's ever-evolving cyber threats. Whether you're an IT professional, business owner, or just someone who wants to stay safe online, this quiz is a valuable resource for anyone who wants to improve their cyber security IQ.

Do you think you have what it takes to join the IT crowd? Put your knowledge to the test with our IT Crowd quiz! This quiz covers a variety of topics related to information technology, from hardware and software to programming and networking.