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
()
Ex_Files_Quick_Start_Guide_to_SQL.zip
(7 KB)