Introduction to MySQL

• Course Goals
• Course Lesson Map
• MySQL Overview
• MySQL Database Server Editions
• MySQL Products
• MySQL Services and Support
• MySQL Resources
• Example Databases

MySQL Server and Client

• MySQL Client/Server Model
• Communication protocols
• MySQL Connectors
• The LAMP Stack
• Installation of the MySQL server
• MySQL Server and Client Startup
• Keyboard Editing
• Session Logging With the tee File

Database Basics

• Basics of Relational Databases
• Spreadsheet Versus Database
• Entities and Relationships
• Relationship Categories
• SQL Language and MySQL
• SQL data definition language
• SQL data manipulation language

Database Design

• Database Modeling
• Structure and Cardinality Diagram (ERD)
• Keys
• Normalization
• Database Design
• Viewing and Evaluating a Database

Table Data Types

• Data Types as Part of Database Design
• Numeric Data Types
• Temporal Data Types
• Character String Data Types
• Character Set and Collation
• Support Binary String Data Types
• Data Type Considerations
• The Meaning of NULL

Database and Table Creation

• Creating a Database
• Creating a Table
• Showing How a Table Was Created
• Column Options
• Table Options
• Table Indexing
• Table Constraints

Basic Queries

• The SELECT Statement
• Troubleshooting SQL
• Modes for Syntax
• Checking Common SQL Modes
• MySQL Workbench for SQL Development

Database and Table Maintenance

• Deleting databases and tables
• Creating a new table using an existing table
• Confirming the creation of a new table
• Copying an existing table structure
• Creating a temporary table
• Adding, removing and modifying table columns
• Adding, removing and modifying indexes and constraints

Table Data Manipulation

• Manipulating Table Row Data
• The INSERT Statement
• The REPLACE Statement
• The UPDATE Statement
• The DELETE Statement

Functions

• Functions in MySQL
• expressions Using Functions
• String Functions
• Temporal Functions
• Numeric Functions
• Control Flow Functions
• Aggregate Functions
• Spaces in Function Names

Exporting and Importing Data

• Exporting with a Query
• Exporting with a MySQL
• Utility Importing from a Data File
• Importing with a MySQL Utility

Joining Tables

• Combining Multiple Tables
• Joining Tables with SELECT
• Comma-Separated Joins
• Inner Joins
• Outer Joins
• Table Name Aliases

Table Subqueries

• Advantages of Using a Subquery
• Placement of Subqueries
• Subquery Categories
• Subquery Result Table Types
• Subquery Type/Placement
• Finding Mismatches
• Modifying Tables using Subqueries
• Converting Joins to Subqueries

MySQL Graphical User Interface Tools

• MySQL Workbench
• MySQL Enterprise Monitor

Supplementary Information

• Storage Engines
• Creating Views
• Transactions
• Retrieving Metadata
• Performance Schema MySQL
• Enterprise Backup

Conclusion

• Course Goals
• MySQL Curriculum Path
• MySQL Resources
• Evaluation
• Final Q&A