Index of Oracle SQL for Users Part One training course
Section
Section Name
Page
One
Introduction to SQL
2
- Usage of SQL in an Oracle Database
3
- Definition of an Oracle Database
4
Two
Oracle Tables
5
- Introduction
6
- Views
7
- Varchar2 Datatype
8
- Number Datatype
9
- Date Datatype
10
- Blob, Clob and Bfilename Datatypes
11
- Rownum
12
- Rowid
14
Three
The SQL Plus Interface
15
- Introduction to SQL Plus
16
- Key Areas of SQL Plus Interface
17
- ORA-01017 Logon Denied
18
- ORA-12154 TNS Problem
19
- Exiting SQL Plus
20
- Invoking the Editor
21
- Environment Settings in SQL Plus
22
- File Manipulation in SQL Plus
24
- Spooling Results in SQL Plus
25
Four
SQL Scripts
26
- Saving SQL in SQL Scripts
27
- Commenting SQL Scripts
30
- Exercise One
32
Five
Simple SQL Queries
36
- Creating SQL Queries in Oracle
37
- Structure of a Simple SQL Query
38
- Selecting all columns
39
- Metadata Files in Oracle
40
- Using Describe on Tables (Desc)
42
- Counting Records using Count(*)
43
- Displaying Literals in SQL Plus
45
- Displaying Variables using Sys.Dual
46
- Calculating using Sys.Dual
47
- Session Variables using Sys.Dual
48
- Exercise Two
49
Six
Manipulating SQL Queries
50
- Using Aliases
51
- Using As with Aliases
54
- Using Table Aliases
55
- Column Mathematics
57
- Date Mathematics
58
- Joining Columns and Data
59
- Ordering Records
60
- Using Oracle Functions
63
- Using Initcap Function
65
- Using Length Function
66
- Using Ceil and Floor Functions
67
- Using Round Function
68
- Using Substr Function
70
- Using To_char with Numbers
71
- Using To_char with Dates
72
- Using Decode Function
73
- Nesting Functions
74
- Exercise Three
75
Seven
Limiting SQL Queries with Where
80
- Introduction
81
- Equality Checks
82
- Range Checks
84
- List Checks
88
- Wildcards in Where clauses (Like)
90
- Truncating Dates in Where Clauses
93
- Case Sensitivity
94
- Combining Where Tests
95
- Null values in Where Clauses
97
- Using Functions in Where Clauses
98
- Exercise Four
101
Eight
Aggregating Values in SQL
106
- Introduction
107
- Using Group By to Sub-Total
109
- Limiting Sub-Totals with Having
111
- Using Rollup to Display Grand Totals
112
- Exercise Five
113
Nine
Joining Tables in an SQL Query
116
- Linking Tables in an SQL Statement
117
- Cartesian Products in an SQL Statement
122
- Problems with Joining Tables in SQL
123
- Methods of Joining Tables in SQL
125
- Ansi SQL/86 Using a Where Clause
126
- Ansi SQL/85 and Outer Joins
127
- Ansi SQL/99 Standards (Natural Joins)
128
- Ansi SQL/99 Standards (Cross Joins)
129
- Ansi SQL/99 Standards (Joins/Using)
130
- Ansi SQL/99 Standards (On)
131
- Ansi SQL/99 Standards (Multiple On)
132
- Ansi SQL/99 Standards (Left Outer Join)
133
- Ansi SQL/99 Standards (Right Outer Join)
134
- Ansi SQL/99 Standards (Full Outer Join)
135
- Exercise Six
136
- Whats in the SQL for Users Part II Course
144
