LIN | MySQL Advanced Topics (2019 EN)

Discussion in 'Information Technology' started by Kanka, Nov 24, 2019.

  1. Kanka

    Kanka Well-Known Member Loyal User

    Likes Received:
    Trophy Points:

    Company: Linkedin Learning
    Author: Bill Weinman
    Full Title: MySQL Advanced Topics
    Year: 2019
    Language: English
    Genre: Educational: Databases
    Skill Level: Advanced
    Price: -
    Files: MP4 (+ Exercise Files, Subtitles .SRT)
    Time: 01:19:52
    Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 200 kbps
    Audio: AAC at 128 Kbps, 2 channels, 48.0 KHz

    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.

    This course was created by Bill Weinman. We are pleased to host this training in our library.

    Topics include:
    01. Creating, showing, and dropping indexes
    02. Creating subselects
    03. Creating joined views
    04. Creating stored functions and procedures
    05. Implementing MySQL transactions
    06. Updating with triggers
    07. Creating foreign key constraints