Mastering MySQL for Web : a Beginner's Guide.

✍ Scribed by Sufyan Bin Uzayr

• Publisher: CRC Press
• Year: 2022
• Tongue: English
• Leaves: 309
• Series: Mastering Computer Science
• Edition: First edition.
• Category: Library

✦ Synopsis

MySQL

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 ........

✦ Table of Contents

Cover
Half Title
Series Page
Title Page
Copyright Page
Contents
About the Editor
CHAPTER 1: Introduction to MySQL
DATABASE BASICS
MySQL DATABASE
WHAT IS MySQL AND ITS FEATURES
MySQL MAJOR FEATURES
SCALABILITY AND LIMITS
DISADVANTAGES
CHAPTER 2: Getting Started with MySQL
INSTALLING AND CONFIGURING
Installing MySQL on Unix/Linux
Installing MySQL on FreeBSD
Installing MySQL on Microsoft Windows
Additional Installation Information
MySQL and Virus Checking Software
Installing MySQL on macOS
Installing MySQL on macOS Using Native Packages
CREATING AND MANAGING CONNECTIONS
Standard TCP/IP Connection Method
Configuring Server Management Wizard
SSH Configuration
Windows Management
Review Settings
MySQL Config File
Specify Commands
Complete Setup
The Password Storage Vault
Updating Old Authentication Protocol Passwords
Using MySQL Workbench to Upgrade Your Password
ACCESSING THE MySQL VIA THE COMMAND
Command Options for Connection Establishment
Command Options for Encrypted Connections
Command Options for Connection Compression
CHAPTER 3: Data Modeling
CREATING AND MANAGING TABLES AND RELATIONS
Primary Keys
Foreign Keys
The Relationship Editor
Foreign Key Tab
The ON DELETE Clause
STORING ROUTINES
Adding Routines to the Physical Schemata
The Routine Tab
The Privileges Tab
Adding Routine Groups to the Physical Schemata
Adding Routine Groups to an EER Diagram
Modifying a Routine Group Using the Properties Palette
The Routine Groups Tab
Stored Routine Syntax
Stored Routines and MySQL Privileges
Stored Routine Metadata
Stored Procedures, Functions, Triggers, and LAST_INSERT_ID
REVERSE ENGINEERING A DATABASE
Creating a DDL Script
CHAPTER 4: SQL Development
MANAGING SQL SCRIPTS
Advanced Scripting Options
MySQL.server—MySQL Server Startup Script
mysqld_multi—Manage Multiple MySQL Servers
mysql_upgrade—Check and Upgrade MySQL Tables
RUNNING A SQL FILE
EDITING DATA
Columns Tab
Indexes Tab
Foreign Keys Tab
Triggers Tab
Partitioning Tab
CHAPTER 5: Server Administration
INSTANCES
Creating a New Data Directory
Copying an Existing Data Directory
Starting Multiple MySQL Instances at the Windows Command Line
Starting Multiple MySQL Instances as Windows Services
Running Multiple MySQL Instances on Unix
CREATING AND MANAGING USERS AND ROLES
Creating Roles and Granting Privileges to Them
Defining Mandatory Roles
Checking Role Privileges
Activating Roles
Revoking Roles or Role Privileges
User and Role Interchangeability
IMPORTING AND EXPORTING DATABASE
Exporting a MySQL or MariaDB Database
Importing a MySQL or MariaDB Database
CHAPTER 6: Backing Up and Restoring MySQL Data
CREATING A BACKUP FILE
Physical and Logical Backups
Online and Offline Backups
Local and Remote Backups
Snapshot Backups
Full and Incremental Backups
Full and Point-in-Time (Incremental) Recovery
Making a Hot Backup with MySQL Enterprise Backup
Making Backups with mysqldump
Making Backups by Copying Table Files
Making Delimited-Text File Backups
Making Incremental Backups by Enabling the Binary Log
Making Backups Using Replicas
Making Backups Using a File System Snapshot
Establishing a Backup Habit
RESTORING FROM A BACKUP FILE
Reloading Delimited-Text Format Backups
Point-in-Time Recovery Using Binary Log
DUMPING DATA IN CSV FORMAT
TRANSFERRING DATA FROM ONE MySQL SERVER TO ANOTHER
APPRAISAL
INDEX