|
Critical Skill 1.6 Become Familiar with Other Important Items in the Oracle Database 10g |
19 |
|
Indexes |
19 |
|
Users |
20 |
|
Tablespace Quotas |
20 |
|
Synonyms |
21 |
|
Roles |
22 |
|
Default User Environments |
22 |
|
Critical Skill 1.7 Work with Object and System Privileges |
23 |
|
Select |
23 |
|
Insert |
23 |
|
Update |
24 |
|
Delete |
24 |
|
System Privileges |
24 |
|
Critical Skill 1.8 Introduce Yourself to the Grid |
25 |
|
Critical Skill 1.9 Tie It All Together |
28 |
|
Chapter 1 Mastery Check |
30 |
|
2 SQL: Structured Query Language |
33 |
|
Critical Skill 2.1 Learn the SQL Statement Components |
34 |
|
DDL |
34 |
|
DML |
35 |
|
Critical Skill 2.2 Use Basic insert and select Statements |
36 |
|
insert |
36 |
|
select |
37 |
|
Critical Skill 2.3 Use Simple where Clauses |
39 |
|
The where Clause with NOT |
42 |
|
The where Clause with a Range Search |
42 |
|
The where Clause with a Search List |
43 |
|
The where Clause with a Pattern Search |
44 |
|
The where Clause: Common Operators |
44 |
|
Critical Skill 2.4 Use Basic update and delete Statements |
46 |
|
update |
46 |
|
delete |
48 |
|
Critical Skill 2.5 Order Data |
50 |
|
Critical Skill 2.6 Employ Functions: String, Numeric, Aggregate (No Grouping) |
51 |
|
String Functions |
51 |
|
Numeric Functions |
52 |
|
Aggregate Functions |
53 |
|
Critical Skill 2.7 Use Dates and Data Functions (Formatting and Chronological) |
54 |
|
Date Functions |
54 |
|
