Overview
-
Learn the fundamentals of structured query language (SQL) in Oracle Live SQL in this approachable, beginner-friendly course.
Syllabus
-
Introduction
- Introduction to RDBMS and SQL
- How to use the exercise files
- Basic select statements
- Operators
- Data types
- Comparison conditions
- Logical conditions
- Order of precedence
- Sorting data
- Types of functions and number functions
- Character functions
- Date functions
- Data type conversion functions
- Conditional expressions
- Types of group functions
- Creating groups and nested groups
- Filtering group results
- Types of joins
- Uses of subqueries
- Types of subqueries
- Next steps
