Mastering MySQL for Web
A Beginner's Guide
- Available for pre-order. Item will ship after February 24, 2022
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? Correct, 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 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 like the number of downloads, mentions in search results, and frequency of technical discussions on the 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 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.
The book serves as a blueprint to walks you through the entire lifecycle of a MySQL Cluster installation: starting with the installation and initial configuration, moving through online configuration and schema changes, and completing 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 particular book shall walk you through the most common tools for generating backups in several formats and seeing 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 industries like Finance, Accounting, Web Development, Digital Marketing requires 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
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 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.
Learn more at sufyanism.com