MySQL Advanced Topics

Learn to take full advantage of some of the more advanced features in MySQL, including views, transactions, triggers, and stored procedures.

Introduction

• Take MySQL to the next level
• Exercise files

1. Indexes

• Why index?
• Creating an index
• Showing indexes
• Dropping indexes
• Multicolumn indexes

2. Views and Subselects

• Creating a subselect
• Searching within a result set
• Creating a view
• Creating a joined view

3. Stored Routines

• About stored routines in MySQL
• Creating a stored function
• Creating a stored procedure
• Language extensions

4. Transactions

• What are transactions?
• Data integrity
• Performance

5. Triggers

• Updating with triggers
• Preventing updates
• Exmple: Timestamps

6. Foreign Keys

• About foreign keys
• Creating foreign key constraints
• Deleting and changing foreign keys

Conclusion

• Thank you