Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

MySQL Advanced Topics

via LinkedIn Learning

Write review
Unihackers Ad

Launch Your Cybersecurity Career in 6 Months

Learn More → Simplilearn Ad

Pass the PMP® Exam on Your First Try — Expert-Led Training

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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

Taught by

Bill Weinman

Reviews

4.6 rating at LinkedIn Learning based on 347 ratings

Start your review of MySQL Advanced Topics

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.