MySQL Advanced Topics

Go to class
Write Review

Free Online Course: MySQL Advanced Topics provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. MySQL Advanced Topics is taught by Bill Weinman.

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
    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