Mastering MySQL for Web: A Beginner’s Guide
- Length: 200 pages
- Edition: 1
- Language: English
- Publisher: CRC Press
- Publication Date: 2022-02-24
- ISBN-10: 1032135123
- ISBN-13: 9781032135120
- Sales Rank: #0 (See Top 100 Books)
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 ……..
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
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.