Table of Contents
Preface
Section 1: Creating Your Database
Chapter 1: Background Concepts
Introducing databases
Database architecture
MS Access as a database
Database management system
RDBMS
Exploring MySQL
Data types
Exercise 1.01: Organizing data in a relational format
Exploring MySQL architecture
The MySQL layers
Storage engines (InnoDB and MyRocks)
ACID compliance
Data modeling
Normalization
Activity 1.01: Creating an optimized table for an employee project
Summary
Chapter 2: Creating a Database
Developing databases
The MySQL Workbench GUI
Connecting the Workbench GUI to MySQL
Exercise 2.01 – creating a connection with the MySQL Workbench GUI
Accessing MySQL through the command-line interface
Creating a database
Exercise 2.02 – creating ...
Get The MySQL Workshop now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
