Mastering MySQL for Web

In real-world applications, we see large amounts of data being generated on an hourly basis. How do you think we can handle this data? To solve our problems with large-sized data, MySQL shines bright as it is built to handle data pools of all sizes with ease.

Mastering MySQL for Web: A Beginner’s Guide attempts to explain why MySQL is considered to be one of the most popular relative databases on the market, scoring great points at critical parameters such as the number of downloads, mentions in search results, and frequency of technical discussions on Internet forums. We shall look at how fast, scalable, and easy to use this database management system is compared to Microsoft SQL Server and Oracle Database.

MySQL is an open-source relational database management system that works on many platforms in conjunction with PHP scripts to create dynamic server-side or web-based enterprise applications. It provides multi-user access to support many storage engines and is backed by Oracle. In this Mastering MySQL for Web guide, you will learn about database fundamentals, MySQL Workbench, MySQL basics, Normalization, Data sorting in MySQL, MySQL functions, Advanced MySQL operations, and many more exciting concepts about MySQL.

This book serves as a blueprint to the entire lifecycle of a MySQL Cluster installation, starting with the installation and initial configuration, moving through online configuration and schema changes, and concluding with online upgrades. It aims to teach, step by step, about MySQL compatibility with various models, capacity to produce new models, support for common modeling activities, and management of relationships and dependencies between models and their items. In addition, this book walks you through the most common tools for generating backups in several formats and shows what types and characteristics are there.

Learning MySQL with the help of our Mastering series will help you to quickly understand how database management systems operate in general. It can also enhance your logical thinking and problem-solving ability. Moreover, SQL skills are in high demand because almost every technical role in such industries as Finance, Accounting, Web Development, and Digital Marketing require an understanding of SQL. Therefore, no need to wait anymore, go forward and learn SQL to advance your skill set!

Learn more about our other Mastering titles at:

https://www.routledge.com/Mastering-Computer-Science/book-series/MCS

Table of Contents

CHAPTER 1: Introduction to MySQL

CHAPTER 2: Getting Started with MySQL

CHAPTER 3: Data Modeling

CHAPTER 4: SQL Development

CHAPTER 5: Server Administration

CHAPTER 6: Backing Up and Restoring MySQL Data

About the Author

Sufyan bin Uzayr is a writer, coder and entrepreneur with over a decade of experience in the industry. He has authored several books in the past, pertaining to a diverse range of topics, ranging from History to Computers/IT.

Sufyan is the Director of Parakozm, a multinational IT company specializing in EdTech solutions. He also runs Zeba Academy, an online learning and teaching vertical with a focus on STEM fields.

Sufyan specializes in a wide variety of technologies, such as JavaScript, Dart, WordPress, Drupal, Linux and Python. He holds multiple degrees, including ones in Management, IT, Literature and Political Science.

Sufyan is a digital nomad, dividing his time between four countries. He has lived and taught in universities and educational institutions around the globe. Sufyan takes a keen interest in technology, politics, literature, history and sports, and in his spare time, he enjoys teaching coding and English to young students.