Top
Email
Bottom
Oracle Essential SQL 9i
 
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 Essential SQL 9i course at a glance

Pages
298No of slides in the Manual
Exercises
8Total No of Exercises
Sections
15No 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
2Week 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:
2 days
1 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
15
8
298
None
Oracle Essential PLSQL 9i Advanced Oracle SQL 11g
Contact us for the latest pricing

Index of Oracle 9i Essential SQL training course

Section
Contents
Page

One
Introduction to SQL
2

 
- Definition of SQL
3

 
- Definition of a Database
4

Two
Database Objects
5

 
- Introduction
6

 
- Tables
7

 
- Views
8

 
- Materialized Views
9

 
- Indexes
10

 
- Sequences
11

 
- Packages, Functions and Procedures
12

 
- Synonyms and Schemas
13

Three
The SQL Plus Interface
14

 
- Introduction
15

 
- Logging on
17

 
- Anatomy of SQL Plus
20

 
- ORA-12154: TNS:could not resolve the connect identifier
21

 
- ORA-01017: invalid username/password
22

 
- Exiting an SQL Plus Session
23

 
- Using the Line Editor in SQL Plus
24

 
- Using the Editor in SQL Plus
25

 
- SQL Plus Environment Settings
26

 
- File Manipulation in SQL Plus
28

 
- Spooling Results in SQL Plus
29

 
- Changing Passwords / Clearing the Screen
30

Four
SQL Scripts
31

 
- Commenting SQL Scripts
35

 
- Running SQL in Batch Scripts
37

 
- Passing Parameters with SQL Scripts
39

Five
Simple Queries
41

 
- Introduction
42

 
- Oracle Metadata
43

 
- SQL Syntax
48

 
- Counting Records in an Oracle Table
51

 
- Displaying Literals in a Select statement
53

 
- Displaying Variables in a Select statement
56

 
- Exercise One
57

 
- Column Aliases
61

 
- Column Manipulation with SQL Functions
64

 
- Concatenating Columns in SQL
70

 
- Performing Calculations in SQL
71

 
- Ordering Data in SQL
72

 
- Ordering More than One Column
74

 
- Manipulating Dates in SQL
75

 
- Displaying Dates in SQL
76

 
- Exercise Two
77

Six
Limiting Data Selected with a Where Clause
82

 
- Limiting Data in SQL
83

 
- Structure of an SQL Where Clause
84

 
- Different types of SQL Where Clauses
85

 
- Handling Nulls in Where Clauses
93

 
- Case Restrictions in SQL Where Clauses
94

 
- Using Functions in Where Clauses
95

 
- Rownum in SQL Tables
98

 
- Using Rowid in SQL Tables
100

 
- Exercise Three
102

Seven
Oracle Datatypes
106

 
- Introduction
107

 
- Varchar2
108

 
- Varchar2 and Char
110

 
- Number
111

 
- Date
112

 
- Float
113

 
- Long
114

 
- Large Objects
115

 
- Bfile
119

Eight
Aggregating Values
120

 
- Introduction
121

 
- Using Group By
122

 
- Using Having with Group By
125

 
- Using Rollup to Total Grouping
127

Nine
Tree Walking Tables in SQL
128

 
- Introduction
129

 
- Syntax for Tree Walking in SQL
131

 
- Example of Tree Walking in SQL
132

 
- Advanced Ordering of Siblings in Tree Walks
133

 
- Sys_Connect_By_Path
135

 
- Exercise Four
137

Ten
Joining Tables in an SQL Statement
140

 
- Using Table Aliases in SQL
141

 
- Linking Tables in an SQL statement
143

 
- Problems with Joining Tables in SQL
148

 
- Methods of Joining Tables in SQL
150

 
- Using Ansi SQL/86 to Join Tables
151

 
- Ansi SQL/86 and Outer Joins
152

 
- Ansi SQL/99 Standards (Natural Joins)
155

 
- Ansi SQL/99 Standards (Cross Joins)
156

 
- Ansi SQL/99 Standards (Joins/Using)
157

 
- Ansi SQL/99 Standards (On)
158

 
- Ansi SQL/99 Standards (Multiple On)
159

 
- Ansi SQL/99 Standards (Left Outer Join)
160

 
- Ansi SQL/99 Standards (Right Outer Join)
161

 
- Ansi SQL/99 Standards (Full Outer Join)
162

 
- Merging Tables in SQL
163

 
- Using Union to Merge Tables in SQL
164

 
- Using Union All to Merge Tables in SQL
165

 
- Using Intersect to Merge Tables in SQL
166

 
- Using Minus to Merge Tables in SQL
167

 
- Knowledge Check
168

 
- Using the Merge Syntax in SQL
173

 
- Exercise Five
174

Eleven
Advanced SQL Query Techniques
178

 
- Introduction
179

 
- Pivot
180

 
- Using First_Value/Last_Value in SQL
182

 
- Window Specification
184

 
- Breakdown of Window Specification
185

 
- Window Specification - The Arguments
187

 
- Window Specification - Query Partition
188

 
- Window Specification - The Order By
190

 
- Window Specification - The Windowing
192

 
- Window Specification - Rows between
194

 
- Window Specification - Shortcuts
198

 
- Difference between Range and Rows
199

 
- Using Lead and Lag in SQL
202

 
- Using Rank Function in SQL
206

 
- Using Ntile Function in SQL
213

 
- Using Width_Bucket Function in SQL
215

 
- Using Case Function in SQL
218

 
- Exercise Six
222

Twelve
Creating Database Objects in SQL
226

 
- Creating Tables in SQL
227

 
- Mandatory Columns in SQL Tables
229

 
- Creation Syntax for Tables in SQL
230

 
- Commenting on Tables in SQL
232

 
- Commenting on Columns in SQL
233

 
- Creating Indexes in SQL
234

 
- Index Creation in SQL
237

 
- Disabling Indexes in SQL
239

 
- Creating Views in SQL
240

 
- Creating Sequences in SQL
242

 
- Using Sequences in SQL
243

 
- Altering Sequences in SQL
245

 
- Using Default Value in SQL Tables
246

 
- Renaming Objects in an Oracle Database
247

 
- Dropping Objects from an Oracle Database
250

 
- Granting Access in other Schemas
251

 
- Accessing other Schemas
254

 
- Creating Synonyms in Oracle
255

 
- Exercise Seven
256

Thirteen
Altering and Populating Oracle Tables
258

 
- Some Rules when Altering Tables
259

 
- Syntax for Altering Tables
260

 
- Rules When Populating Tables in SQL
261

 
- Syntax for Populating Tables
262

 
- Using Variables to Populate Tables
267

 
- General Comments
268

 
- Updating Data in Oracle Tables
269

 
- Deleting Data from Oracle Tables
271

 
- Handling Large Objects in SQL Plus
272

 
- Handling BFiles in SQL Plus
274

Fourteen
Committing Records
275

 
- The Difference Between DDL and DML
276

 
- Using Autocommit in SQL Plus
279

Fifteen
Materialized Views
280

 
- Introduction
281

 
- Syntax for Creating Materialized Views
283

 
- Refreshing Materialized Views
285

 
- Building Materialized Views
291

 
- Miscellaneous
293

 
- Exercise Eight
294

 
 
 

Sections of Oracle SQL with Essential SQL 9i

One
Introduction to SQL

Two
Database Objects

Three
The SQL Plus Interface

Four
SQL Scripts

Five
Simple Queries

Six
Limiting Data Selected with a Where Clause

Seven
Oracle Datatypes

Eight
Aggregating Values

Nine
Tree Walking Tables in SQL

Ten
Joining Tables in an SQL Statement

Eleven
Advanced SQL Query Techniques

Twelve
Creating Database Objects in SQL

Thirteen
Altering and Populating Oracle Tables

Fourteen
Committing Records

Fifteen
Materialized Views


Synopsis for Oracle 9i Essential SQL training course

The Oracle 9i Database is quite an old version of the Database system, it was released in 2001 and replaced by the Oracle 10g version of the Database in 2004, in reality, Oracle has released a new version of their Database every three years or so, from an SQL perspective there have been some additions each release but Oracle never seem to deprecate functionality, therefore it is quite feasible for a person to attend the SQL 9i version of our training course and still be a very strong member of a team which uses Oracle 18c.

We do however recommend you at least take a look at the Essential Oracle SQL 18c course we give, if nothing else to compare the content, you will see several pages have been added and in addition the course is available as a public course around the UK and Ireland on at least 26 occasions a year.

Booking our courses cannot be easier, simple send us an email and we will confirm the availability, price and will send you a booking form, you can then choose to pay us in a variety of ways, purchase order, BACS or cheque.

This SQL 9i course is only available onsite, we are happy to come to your venue, we take 30 minutes to setup and we bring all the equipment we need for the course, all you need to do is supply Delegates, tables and chairs, oh and a little bit of electricity! The course normally begins at 9am and finishes at around 4.15am each day, we say normally but when you book any of our hundred plus courses for onsite training you determine not only the start date but can also specify what time of the day you want the course to begin – ultimate flexibility – this means you can fit the training in to your Delegate's work and personal needs, maybe they have children to drop off to school, maybe there is a daily office meeting at 8.30am, you tell us and we will adjust accordingly.

When we quote for any of our quotes we can if asked give a number of different scenario pricing, for example four delegates or ten delegates or a range in between, once a course is booked we don’t mind you adding or removing Delegates, we always finalise the numbers the week before the training commences at the same time make sure all the arrangements are in place.

Sometimes a Company doesn’t have a room available to train in, in these cases we will book a conference facility close to your offices, we will make sure catering is provided and all that will be our responsibility.

Final words … each and every course that we provide has its own webpage, however they all have downloadable pdfs of the course index, example exercises and example pages from the comprehensive manuals which the Delegates get to use and keep.

Did we say final words? Sorry, one last thing we know SQL so well we have created an SQL Functions App for reference when your delegates are back at their desks … how cool is that ?

Request for detailsClick for the contact form for the Oracle Essential SQL 9i training course
Public Courses
Oracle Essential SQL 21c
Days
2
Pages
340
Exercises
8
Sections
15
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 21c
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
Oracle Application Express 20
Days
0
Pages
0
Exercises
0
Sections
0
Public
Yes
On-Site
Yes
Public Courses
PHP 8 and MySQL 8
Days
5
Pages
870
Exercises
23
Sections
38
Public
Yes
On-Site
Yes
Public Courses
Java 17 Programming with Eclipse 2021-12
Days
5
Pages
788
Exercises
23
Sections
44
Public
Yes
On-Site
Yes
Public Courses
Java 17 Swing with Eclipse 2021-12
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