Topics

• Common String Operations
• Basic Control Structures
• Getting started with MySQL
• GROUP BY
• Filter results using WHERE and HAVING
• Error codes
• Functions (Aggregate)
• Stored routines (procedures and functions)
• Reserved Words
• String operations
• IN clause
• GROUP BY
• Data Types

Examples

• Getting Started
• Error code 1064: Syntax error
• Conditional aggregation
• Break
• Create a Function
• Errors due to reserved words
• Find element in comma separated list
• Use HAVING to check for multiple conditions in a group
• Splitting a String by another string
• Simple IN clause
• Simple Grouping