MySQL Advanced Topics

1h 10mAdvanced2024-03-11

Authors

Bill Weinman

Tech Advocate, Entrepreneur, Programming Expert

Course details

Get more out of the world’s most popular RDMS. Learn to take full advantage of some of the more advanced features in MySQL, including views, transactions, triggers, and stored procedures. In this course, Bill Weinman helps you take your MySQL skills to the next level. Discover how to facilitate rapid lookups with indexes, search for data in a result set provided by another select statement with subselects, and put database-intensive operations into stored functions and procedures for faster, more modular, and more efficient programming. Plus, learn how to ensure data integrity with transactions and cross-reference distributed data with foreign key constraints. These techniques allow you to create more performant and stable databases for all your development projects, from web applications to data warehouses.

Skills covered

MySQLAdvancedDatabase DevelopmentDatabase ManagementOpen SourceSoftware Development

Concepts

0. Introduction

01 - Take MySQL to the next level
02 - Exercise files

1. Indexes

03 - Why index
04 - Creating an index
05 - Showing indexes
06 - Dropping indexes
07 - Multi-column indexes

2. Views and Subqueries

08 - Creating a subquery
09 - Searching within a result set
10 - Creating a view
11 - Creating a joined view

3. Stored Routines

12 - About stored routines in MySQL
13 - Creating a stored function
14 - Creating a stored procedure
15 - Language extensions

4. Transactions

16 - What are transactions
17 - Data integrity
18 - Performance

5. Triggers

19 - Updating with triggers
20 - Preventing updates
21 - Example - Timestamps

6. Foreign Keys

22 - About foreign keys
23 - Creating foreign key constraints
24 - Deleting and changing foreign keys

Conclusion

25 - Thank you