| Team Fly | |
2.1 Learn the SQL Statement Components
2.2 Use Basic insert and select Statements
2.3 Use Simple where Clauses
2.4 Use Basic update and delete Statements
2.5 Order Data
2.6 Employ Functions: String, Numeric, Aggregate (No Grouping)
2.7 Use Dates and Data Functions (Formatting and Chronological)
2.8 Employ Joins (ANSI vs. Oracle): Inner, Outer, Self
2.9 Learn the group by and having Clauses
2.10 Learn Subqueries: Simple and Correlated Comparison with Joins
2.11 Use Set Operators: Union, Intersect, Minus
2.12 Use Views
2.13 Learn Sequences: Just Simple Stuff
2.14 Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering Exceptions
2.15 Format Your Output with SQL*Plus
| Team Fly | |