MySQL Advanced Topics

[mitsumi]

MySQL Advanced Topics
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 1h 19m | 165 MB
Instructor: Bill Weinman

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
             

               

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction