Upon completion of this course, the student will be able to: Identify the two types of functions in SQL. Use the single row (or scalar) function types. Use the join statements to display data from multiple tables. Operate on sets of rows to derive a summary result using the group (or aggregate) functions.
Unit 1: Single Row Functions
- Character Functions
- Number Functions
- Date Functions
- Nested Single Row Functions
Unit 2: Conversion Functions
- TO_CHAR function
- TO_NUMBER Function
- TO_DATE Function
Unit 3: Display Data From Multiple Tables
- Join Types
- Simple Join Statements
- Non-Equijoin
- Self Joins
Unit 4: Working With Groups
- Group Functions
- GROUP BY Clause
- Groups Within Groups
- Invalid Queries
- HAVING Clause