MySQL Advanced Topics

MySQL Advanced Topics
MySQL Advanced Topics
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 19m | 167 MB

Get more out to 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.

Topics include:

  • Creating, showing, and dropping indexes
  • Creating subselects
  • Creating joined views
  • Creating stored functions and procedures
  • Implementing MySQL transactions
  • Updating with triggers
  • Creating foreign key constraints
Table of Contents

1 Take MySQL to the next level
2 Exercise files
3 Why index
4 Creating an index
5 Showing indexes
6 Dropping indexes
7 Multicolumn indexes
8 Creating a subselect
9 Searching within a result set
10 Creating a view
11 Creating a joined view
12 About stored routines in MySQL
13 Creating a stored function
14 Creating a stored procedure
15 Language extensions
16 What are transactions
17 Data integrity
18 Performance
19 Updating with triggers
20 Preventing updates
21 Exmple Timestamps
22 About foreign keys
23 Creating foreign key constraints
24 Deleting and changing foreign keys
25 Thank you