Advanced SQL in MySQL

• Developers and users who want to learn how to use advanced SQL techniques and methods

• MySQL overview
• Use advanced techniques with the SELECT statement  
• Use subqueries  
• Overview and use the advanced features  
• Advanced techniques of SQL language

• Basic knowledge of IT and PC  
• Knowledge of SQL in MySQL

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

Previous courses

Introduction to SQL in MySQL [GOC660]

Next courses

Optimizing SQL queries in MySQL [GOC664]

Related courses

MySQL administration [GOC661]