The delegate will learn and acquire skills as follows:
- Using advanced data types
- Writing complex SQL query statements
- Using advanced SQL expressions
- Performing advanced Insert, Update, Delete, Replace and Truncate Operations
- Using user variable syntax and properties
- Importing and exporting data from the command line
- Performing complex subqueries
- Creating, managing and using views
- Implementing a Common Table Expression ( CTE )
- Using Window functions
- Implementing Regular Expressions
- Using prepared statements
- Creating and using stored routines
- Creating and using triggers
- Obtaining database metadata
- Optimizing queries
- Working with the main storage engines
