Quick Start Guide to SQL

Introduction

• Introduction to RDBMS and SQL
• How to use the exercise files

1. Fetch Data from Tables

• Basic select statements
• Operators
• Data types

2. Filtering Data

• Comparison conditions
• Logical conditions
• Order of precedence
• Sorting data

3. Single Row Functions

• Types of functions and number functions
• Character functions
• Date functions
• Data type conversion functions
• Conditional expressions

4. Multiple Row Functions/ Group Functions

• Types of group functions
• Creating groups and nested groups
• Filtering group results

5. Joins and Subqueries

• Types of joins
• Uses of subqueries
• Types of subqueries

Conclusion

• Next steps