MySQL Advanced Topics
4.5 /5- Offered byLinkedin Learning
MySQL Advanced Topics at Linkedin Learning Overview
MySQL Advanced Topics
at Linkedin Learning
Duration | 2 hours |
Mode of learning | Online |
Difficulty level | Advanced |
Credential | Certificate |
MySQL Advanced Topics at Linkedin Learning Course details
MySQL Advanced Topics
at Linkedin Learning
Skills you will learn
More about this course
- In this course, Bill Weinman helps learner to take 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
- Learner will learn how to ensure data integrity with transactions and cross-reference distributed data with foreign key constraints
MySQL Advanced Topics at Linkedin Learning Curriculum
MySQL Advanced Topics
at Linkedin Learning
Introduction
Take MySQL to the next level
Exercise files
Indexes
Why index?
Creating an index
Showing indexes
Dropping indexes
Multicolumn indexes
Views and Subselects
Creating a subselect
Searching within a result set
Creating a view
Creating a joined view
Stored Routines
About stored routines in MySQL
Creating a stored function
Creating a stored procedure
Language extensions
Transactions
What are transactions?
Data integrity
Performance
Triggers
Updating with triggers
Preventing updates
Exmple: Timestamps
Foreign Keys
About foreign keys
Creating foreign key constraints
Deleting and changing foreign keys
Conclusion
Thank you
MySQL Advanced Topics at Linkedin Learning Faculty details
MySQL Advanced Topics
at Linkedin Learning
Bill weinman
Other courses offered by Linkedin Learning
₹899
1 hours
Intermediate
– / –
1 hours
Advanced
View Other 504 Courses
S
Siddharth Gupta
MySQL Advanced Topics
Offered by Linkedin Learning
5
Learning Experience: Great
Faculty: Faculty great
Course was good
Course Support: Excellent
Reviewed on 11 Feb 2023Read More
View 1 Review
MySQL Advanced Topics
at Linkedin Learning
Student Forum
Anything you would want to ask experts?