Course Overview
Course Content
- MySQL Overview
- Basics of Relational Databases
- Entities and Relationships
- SQL Language and MySQL
- SQL data definition language and data manipulation language
- MySQL Client/Server Model
- MySQL Connectors
- Installation of the MySQL server
- Starting and stopping MySQL server
- Using the MySQL client
- MySQL Workbench
- Hands-On
- Creating a Database
- Creating a Table
- Showing How a Table Was Created
- Table Options
- Column Options
- Indexes, Keys, and Constraints
- Deleting database and tables
- Creating New Table Using an Existing Table
- Creating a Temporary Table
- Copying an Existing Table Structure
- Adding, removing and modifying table columns and indexes
- Hands-On
- The SELECT Statement
- Creating Views
- Querying Data from an Application
- Exporting and Importing a Delimited File
- Troubleshooting: Authorization Levels
- Manipulating Data and inserting records
- Replacing and updating existing records
- Deleting records
- Exporting and importing a script
- Multistatement Transactions
- Modifying Data from an Application
- Hands-On