MySQL Fundamentals (D90871) – Outline

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