Advanced MySQL Topics
In this course, you’ll begin to push beyond simple SQL statements to actual functional database engineering with advanced concepts in MySQL.
By the end of this course, you’ll be able to:
- Add decision structures and functionality to a MySQL databases using SQL functions and operators on numbers and strings
- Demonstrate a working knowledge of the foundations of automation using conditionals and triggers
- Automate DBMS tasks with the use of store procedures
- Utilize subqueries and transactions to perform optimizations
- Optimize databases with the use of advanced database administration tasks
- Automate SQL by writing a stored procedure to solve real world problems
You’ll gain experience with the following tools and software:
- MySQL functions and operators
- Numeric functions and operators
- SQL statements
- Database optimization tools
- MySQL optimization tools
- SQL statements
- SQL automation
- DBMS tasks
- Database optimization
By the end of this course, you’ll be able to:
- Add decision structures and functionality to a MySQL databases using SQL functions and operators on numbers and strings
- Demonstrate a working knowledge of the foundations of automation using conditionals and triggers
- Automate DBMS tasks with the use of store procedures
- Utilize subqueries and transactions to perform optimizations
- Optimize databases with the use of advanced database administration tasks
- Automate SQL by writing a stored procedure to solve real world problems
You’ll gain experience with the following tools and software:
- MySQL functions and operators
- Numeric functions and operators
- SQL statements
- Database optimization tools
- MySQL optimization tools
- SQL statements
- SQL automation
- DBMS tasks
- Database optimization