Detailed Course Outline
Introduction to MySQL
- Course Goals
- Course Lesson Map
- Classroom Environment
- MySQL Overview
- MySQL Resources
- MySQL Training
MySQL Server and Client
- MySQL Client/Server Model
- MySQL Connectors
- Installation of the MySQL server
- Setting the root Password
- Starting and stopping the MySQL server
- Using the mysql client
- MySQL Workbench
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
Designing Your Database
- Database Modeling
- Keys
- Normalization
- Database Design
- Viewing and Evaluating a Database
Data Types
- Data Types as Part of Database Design
- Numeric Data Types
- Temporal Data Types
- String Data Types
- Character Set and Collation Support
- Data Type Considerations
- The Meaning of NULL
Creating Databases and Tables
- Creating a Database
- Creating a Table
- Showing How a Table Was Created
- Column Options
- Table Options
- Indexes, Keys, and Constraints
Modifying Databases and Tables
- 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
Querying Table Data
- The SELECT Statement
- Creating Views
- Querying Data from an Application
- Exporting and Importing a Delimited File
- Troubleshooting
Modifying Table Data
- Manipulating Data
- Inserting records
- Replacing existing records
- Updating existing records
- Deleting records
- Exporting and importing a script
- Multistatement Transactions
- Modifying Data from an Application
Functions
- Functions in MySQL Expressions
- Using Functions
- String Functions
- Date and time functions
- Numeric Functions
- Aggregate Functions
- Spaces in Function Names
Joining Tables
- Querying Multiple Tables
- Joining Tables with SELECT
- Inner Joins
- Outer Joins
- Table Name Aliases
Conclusion
- Course Goals
- MySQL Curriculum Path
- MySQL Resources
- Evaluation
- Final Q&A