O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 2

SQL: Structured Query Language

CRITICAL SKILLS

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required