Oracle Database 11g A Beginner's Guide

CHAPTER 4 SQL: Structured Query Language

CRITICAL SKILLS

4.1 Learn the SQL Statement Components

4.2 Use Basic Insert and Select Statements

4.3 Use Simple Where Clauses

4.4 Use Basic Update and Delete Statements

4.5 Order Data

4.6 Employ Functions: String, Numeric, Aggregate (No Grouping)

4.7 Use Dates and Data Functions (Formatting and Chronological)

4.8 Employ Joins (ANSI vs. Oracle): Inner, Outer, Self

4.9 Learn the Group By and Having Clauses

4.10 Learn Subqueries: Simple and Correlated Comparison with Joins

4.11 Use Set Operators: Union, Intersect, Minus

4.12 Use Views

4.13 Learn Sequences: Just Simple Stuff

4.14 Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering Exceptions

4.15 Format Your Output with SQL*Plus ...