Top
Email
Bottom
Oracle SQL for Users III
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

Download our latest
Android and iPhone apps ...
Click on whichever one of our Apps you are interested in

Oracle SQL for Users III course at a glance

Pages
192No of slides in the Manual
Exercises
4Total No of Exercises
Sections
5No of main topics, see index below
Public
NoPublic course in the UK and Ireland
On-Site
YesWe can come to your venue
Level
11 - Beginners
2 - Intermediate
3 - Advanced
Days
1Week days but we can put on weekend courses
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
5
4
192
Oracle SQL for Users I Oracle SQL for Users II
None
Contact us for the latest pricing

Oracle SQL for Users Part Three training course
Exercise highlights

Using Union to merge data
Pivotting Data to form a cross table output
Using Timestamps in Oracle

Index of Oracle SQL for Users Part Three training course

Section
Section Name
Page

One
Joining Tables using Data Sets
2

 
- Creating Data Sets
3

 
- Union Syntax
4

 
- Union
5

 
- Union Example
6

 
- Join Rules
8

 
- Union All
9

 
- Intersect
12

 
- Minus
14

 
- Knowledge Check
16

 
- Tree Walks
21

 
- Tree Walking Syntax
23

 
- Use of Level
26

 
- Use of Nocycle (ORA-01436)
27

 
- Use of Connect_by_iscycle
29

 
- Advanced Ordering of Tree Walks using Siblings
30

 
- Output of Tree Walks using Sys_Connect_By_Path
31

 
- Limiting Records using Connect_by_isleaf
32

 
- Showing the Root using Connect_by_root
34

 
- Exercise One
36

Two
Advanced SQL Query Functions/Techniques
42

 
- Introduction
43

 
- Pivot
44

 
- Adding a Total to a Pivot
49

 
- Changing the Pivot Headings of the X Axis
50

 
- Rotating the Axis of the Pivot
52

 
- Unpivot
53

 
- Unpivot and Null values
56

 
- Using First_Value/Last_Value in SQL
57

 
- Ignoring Nulls with First/Last_Value
59

 
- Window Specification
60

 
- Breakdown of Window Specification
61

 
- Window Specification - The Arguments
63

 
- Window Specification - The Query Partition
64

 
- Window Specification - The Order By
66

 
- Window Specification - The Windowing
68

 
- Window Specification - Rows between
70

 
- Window Specification - Shortcuts
74

 
- Difference between Range and Rows
75

 
- Using Lead and Lag in SQL
78

 
- Using Rank Function in SQL
82

 
- Using Ntile Function in SQL
89

 
- Using Width_Bucket Function in SQL
91

 
- Using Listagg Function in SQL
94

 
- Exercise Two
96

Three
Advanced Date Datatypes
102

 
- Introduction
103

 
- Database Timezone
104

 
- Date Datatypes
106

 
- Timestamp
110

 
- Extract
115

 
- Timestamp with Time Zone
116

 
- Time Zone with Extract
117

 
- TZ_Offset
118

 
- Time Zones and UTC
119

 
- From_TZ
121

 
- Timestamp with Local Time Zone
122

 
- Intervals
123

 
- Using Intervals
126

 
- Intervals and Extract
129

 
- Exercise Three
130

Four
Aggregating Values in Oracle SQL 11g
134

 
- Introduction
135

 
- Using Distinct with other Aggregates
136

 
- Using Group By
137

 
- Using Group By with Aliases
140

 
- Using Group By with Many Columns
141

 
- Using Having with Group By
143

 
- Using Rollup to 'Sum' the Group By
145

 
- Using Partial Rollup with several non-aggregates
147

 
- Using Full Rollup with several non-aggregates
148

 
- Getting the Total to the Top
149

 
- Using Cube with Group By
150

 
- Using Grouping Sets with Group By
152

 
- Using Grouping ID with Grouping Sets
154

 
- Using Group ID with Group By
156

 
- Nesting Group Functions
158

Five
Flashback
161

 
- Introduction
162

 
- Flashback Query
163

 
- Using the Dbms_Flashback package
167

 
- Using Time Flashbacks
168

 
- Disabling Flashbacks
172

 
- Using SCN Flashbacks
173

 
- Implicit Flashback using AS OF
175

 
- Flashback using Versions Between
177

 
- Using Flashback_transaction_query View
182

 
- Exercise Four
185


Sections of Oracle SQL with SQL for Users Part III

One
Joining Tables using Data Sets

Two
Advanced SQL Query Functions/Techniques

Three
Advanced Date Datatypes

Four
Aggregating Values in Oracle SQL 11g

Five
Flashback


Synopsis for Oracle SQL for Users Part Three training course

This course concentrates on using Oracle's advanced SQL functions to produce output suitable for Data Warehousing and Management Information.
Request for detailsClick for the contact form for the Oracle SQL for Users III training course
Public Courses
Oracle Essential SQL 19c
Days
2
Pages
340
Exercises
8
Sections
15
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 19c
Days
3
Pages
384
Exercises
13
Sections
25
Public
Yes
On-Site
Yes
Public Courses
Using SQL with Oracle SQL Developer 19.2
Days
4
Pages
884
Exercises
18
Sections
37
Public
Yes
On-Site
Yes
Public Courses
Essential JavaScript
Days
4
Pages
660
Exercises
16
Sections
31
Public
Yes
On-Site
Yes
Public Courses
Essential CSS 3
Days
4
Pages
800
Exercises
15
Sections
30
Public
Yes
On-Site
Yes
Public Courses
Essential SQLite 3
Days
3
Pages
550
Exercises
12
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential MySQL 8
Days
4
Pages
533
Exercises
16
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential Python 3
Days
5
Pages
955
Exercises
17
Sections
41
Public
Yes
On-Site
Yes
Public Courses
PHP 7.4 and Oracle 19c
Days
5
Pages
917
Exercises
21
Sections
38
Public
Yes
On-Site
Yes
Public Courses
Java 14 Programming with Eclipse 2020-03
Days
5
Pages
788
Exercises
23
Sections
44
Public
Yes
On-Site
Yes
Public Courses
Java 14 Swing with Eclipse 2020-03
Days
5
Pages
756
Exercises
19
Sections
35
Public
Yes
On-Site
Yes
Click on the course name to see full details, left and right to view other courses