Overview
-
Learn to take full advantage of some of the more advanced features in MySQL, including views, transactions, triggers, and stored procedures.
Syllabus
-
Introduction
- Take MySQL to the next level
- Exercise files
- Why index?
- Creating an index
- Showing indexes
- Dropping indexes
- Multicolumn indexes
- Creating a subselect
- Searching within a result set
- Creating a view
- Creating a joined view
- About stored routines in MySQL
- Creating a stored function
- Creating a stored procedure
- Language extensions
- What are transactions?
- Data integrity
- Performance
- Updating with triggers
- Preventing updates
- Exmple: Timestamps
- About foreign keys
- Creating foreign key constraints
- Deleting and changing foreign keys
- Thank you
