- MySQL adavance practical knowledge.
This course provides an exhaustive coverage of SQL, MySQL Advance Certification course is valuable for freshers, begineers, those who want to work in databse.
- Database Administrators.
- Database Designers.
- Data Warehouse Administrators .
- Support Engineers.
- Getting Started with Stored Procedures.
- Changing MySQL Delimiter.
- Creating Stored Procedures.
- Removing Stored Procedures.
- Modifying Stored Procedures.
- Listing Stored Procedures.
- Variables.
- Parameters.
- IF THEN.
- CASE Statement.
- LOOP.
- WHILE.
- REPEAT.
- LEAVE.
- Cursors.
- Handling Errors.
- Raising Errors.
- Stored Procedures that Return Multiple Values.
- Creating Stored Function.
- Removing Stored Functions.
- Listing Stored Functions.
- MySQL Triggers.
- Create Trigger in MySQL.
- Drop a Trigger.
- Create a BEFORE INSERT Trigger.
- Create an AFTER INSERT Trigger.
- Create a BEFORE UPDATE Trigger.
- Create a AFTER UPDATE Trigger.
- Create a BEFORE DELETE Trigger.
- Create an AFTER DELETE Trigge.
- Create Multiple Triggers.
- Show Triggers.
- Working with MySQL Scheduled Event.
- Modifying MySQL Events.
- MySQL CREATE VIEW.
- MySQL View Processing Algorithms.
- MySQL Updatable Views.
- MySQL Rename View.
- MySQL Show View.
- MySQL DROP View.
- MySQL View WITH CHECK OPTION.
- MySQL View LOCAL & CASCADED.
- MySQL CREATE INDEX.
- MySQL DROP INDEX.
- MySQL SHOW INDEXES.
- UNIQUE Index.
- Prefix Index
- Composite Index.
- Clustered Index.
- Descending Index.
- Invisible Index.
- Index Cardinality.
- USE INDEX Hint.
- MySQL FORCE INDEX Hint.
- Creating Full-Text Indexe.
