Overview
MySQL training course teaches attendees how to develop SQL statements, views, stored procedures, and triggers for their MySQL databases. Participants also learn how to design and implement a database and how to work with foreign keys, transactions, and stored programs.
Objectives
At the end of MySQL training course, participants will
- Work with any database
- Use MySQL Workbench to work with a database and run SQL statements
- Retrieve, add, update, and delete data from a database
- Work with summary queries, subqueries, data types, and functions
- Use MySQL Workbench to create an EER (enhanced entity-relationship) model for their database
- Design and implement their own databases
- Use MySQL to create stored procedures, functions, triggers, and events
- Manage transactions and locking
Prerequisites
Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.
Course Outline
- An Introduction to Client/Server Systems
- An Introduction to the Relational Database Model
- An Introduction to SQL and SQL-Based Systems
- The SQL Statements
- How to Use SQL From An Application Program
- An Introduction to MySQL Workbench
- Using Workbench to Run SQL Statements
- Using the Reference Manual
- Command Line Client
- An Introduction to the SELECT Statement
- The SELECT Clause
- The WHERE Clause
- The ORDER BY Clause
- The LIMIT Clause
- Inner Joins
- Outer Joins
- Other Skills For Working With Joins
- How to Work With Unions
- Creating Test Tables
- Inserting New Rows
- Updating Existing Rows
- Deleting Existing Rows
- Aggregate Functions
- How to Group and Summarize Data
- An Introduction to Subqueries
- How to Code Subqueries In the WHERE Clause
- How to Code Subqueries In Other Clauses
- Working With Complex Queries
- String Data
- Numeric Data
- Date/Time Data
- Other Functions You Should Know About
- Design A Data Structure
- Normalize A Data Structure
- Using MySQL Workbench For Database Design
- Databases
- Tables
- Indexes
- A Script That Creates A Database
- How to Use MySQL Workbench
- Character Sets and Collations
- Storage Engines
- An Introduction to Stored Programs
- How to Write Procedural Code
- How to Work With Transactions
- How to Work With Concurrency and Locking
- Coding Stored Procedures
- Coding Stored Functions
- How to Use Workbench With Procedures and Functions