SQL and Data -- SQL: The Basics -- Character, Number, and Miscellaneous Single-Row Functions -- Date and Conversion Functions -- Aggregate Functions, Group By, And Having -- Equijoins -- Complex Joins -- Subqueries -- Set Operators -- Insert, Update, and Delete -- Create, Alter, and Drop Tables -- The Data Dictionary and Advanced SQL Scripts -- Security -- Regular Expressions and Hierarchical Queries -- Exploring Data Warehousing Features -- SQL Optimization -- Answers to Self-Review Questions -- SQL Formatting Guide -- SQL Plus Command Reference -- Student Database Schema -- Table and Column Descriptions -- Additional Example Tables -- Navigating through the Oracle Documentation -- Resources -- Oracle Datatypes.
|
