Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Vinicius M. Grippa, Sergey Kuzmichev
Learning MySQL, 2nd Edition
1. Installing MySQL
MySQL Forks
MySQL community
Percona Server for MySQL
MariaDB Server
MySQL Enterprise
Installation Choices and Platforms
Installing Linux
Installing MySQL 8 on Centos 7 using yum
Installing MySQL 8 on Centos 8
Installing MySQL 8 on Ubuntu 20.04 LTS (Focal Fossa)
Installing Percona Server 8 on Centos 7
Installing Percona Server 8 on Ubuntu 20.04 LTS (Focal Fossa)
Installing MariaDB 10.5 on Centos 7
Installing MariaDB 10.5 on Ubuntu 20.04 LTS (Focal Fossa)
The Contents of the MySQL Directory
MySQL 5.7 default files
MySQL 8 default files
Using the Command-Line Interface
Using Docker
Installing Docker
Using Sandboxes
Upgrading the MySQL Server
2. Modeling and Designing Databases
How Not to Develop a Database
The Database Design Process
The Entity Relationship Model
Representing Entities
Representing Relationships
Partial and Total Participation
Entity or Attribute?
Entity or Relationship?
Intermediate Entities
Weak and Strong Entities
Database Normalization
Normalizing an example table
Entity Relationship Modeling Examples
The Music Database
The University Database
The Flight Database
Using the Entity Relationship Model
Mapping Entities and Relationships to Database Tables
Converting the Music Database ER Model to a Database Schema
Using Tools for Database Design
3. Basic SQL
Using the Sakila Database
The SELECT Statement and Basic Querying Techniques
Single Table SELECTs
Choosing Columns
Choosing Rows with the WHERE Clause
ORDER BY Clauses
The LIMIT Clause
Joining Two Tables
The INSERT Statement
INSERT Basics
Alternative Syntaxes
The DELETE Statement
DELETE Basics
Using WHERE, ORDER BY, and LIMIT
Removing All Rows with TRUNCATE
The UPDATE Statement
Examples
Using WHERE, ORDER BY, and LIMIT
Exploring Databases and Tables with SHOW and mysqlshow
4. Working with Database Structures
Creating and Using Databases
Creating Tables
Basics
Collation and Character Sets
Other Features
Column Types
Keys and Indexes
The AUTO_INCREMENT Feature
Altering Structures
Adding, Removing, and Changing Columns
Adding, Removing, and Changing Indexes
Renaming Tables and Altering Other Structures
Deleting Structures
Dropping Databases
Removing Tables
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Learning MySQL
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset