Download our latest
Android and iPhone apps ...
At a glance ...
Pages
145
Exercises
6
Sections
9
Public
On-Site
Level
1
Days
1

Course Name: Oracle SQL for Users I

Duration:
Minimum skill level required:
On-Site course:
Public course:
Sections:
No of exercises:
No of pages in the manual:
Pre-Requisite course(s):
Suggested further course(s):
Price guide:
1 days
1 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
9
6
145
None
Oracle SQL for Users II
Contact us for the latest pricing

Synopsis for course

This course concentrates purely on data extraction and manipulation and is ideal for users who will not have permission to do anything other than create select statements.

Course Contents

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