Course structure
MySQL overview
- Overview of the MySQL database system
- The installation procedure
- MySQL Tools
Advanced techniques with the SELECT statement
- Advanced operators
- Regular Expressions
- LIMIT
- Practical examples
Subqueries
- Reason for using subqueries
- Stand-alone subqueries
- Correlated subqueries
- Subquery Operators (EXISTS, IN, ANY, ALL)
Overview and use the advanced features
- Functions for working with different data types
- Conversion of data types
- Metadata function
- Working with XML
- Advanced aggregation techniques
Advanced techniques of SQL language
- Working with hierarchical data structures and recursion
- Advanced techniques of joining data sources
- Action queries
- Advanced subqueries and operators
