×
Oracle SQL for Users I
 
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 I course at a glance ...

Pages
145
No of slides in the Manual
Exercises
6
Total No of Exercises
Sections
9
No of main topics, see index below
Public
No
Public course in the UK and Ireland
On-Site
Yes
We can come to your venue
Level
1
1 - Beginners
2 - Intermediate
3 - Advanced
Days
1
Week days but we can put on weekend courses

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
PDF - Course IndexClick to view the PDF index for the course

PDF - Exercise ExampleClick to view the PDF sample exercise

PDF - Sample PagesClick to view the PDF sample course pages

Request for details
Click for the contact form for the Oracle SQL for Users I training course

Synopsis for Oracle SQL for Users Part One training 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.

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

Request for details
Click for the contact form for the Oracle SQL for Users I training course


Oracle SQL for Users Part One training course

Download our latest
Android and iOS apps ...

Papers and Periodicals App
Download A-Z Yoga app
Download SQL app
Download PHP app
Download MySQL app
Download MariaDB app
Click on whichever one of our Apps you are interested in
×
Oracle SQL for Users I
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

Oracle SQL for Users I course at a glance ...

Duration: 1 days
Minimum skill level required: 1
(1 - Beginner, 2 - Experienced
3 - Advanced)
On-Site course:
Yes

Public course: No
No of pages in the manual: 145
Sections: 9
No of exercises: 6
Pre-Requisite course(s):
None
Suggested further course(s):
Oracle SQL for Users II

Price guide: Contact us for the latest pricing

enquiries@seercomputing.com
or call us on +44 (0) 800 157 7519.

PDF - Course Index

PDF - Exercise Example

PDF - Sample Pages

Request for details
Click for the contact form for the Oracle SQL for Users I training 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.
Scroll through these locations and find the one nearest to you.

Click on the location of your choice and that will take you to the dates for each course

Select the location and then click on the image to view the dates

Sections of Oracle SQL with SQL for Users Part I

One
Introduction to SQL

Two
Oracle Tables

Three
The SQL Plus Interface

Four
SQL Scripts

Five
Simple SQL Queries

Six
Manipulating SQL Queries

Seven
Limiting SQL Queries with Where

Eight
Aggregating Values in SQL

Nine
Joining Tables in an SQL Query


Request for details
Click for the contact form for the Oracle SQL for Users I training course
×
Oracle SQL for Users I
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

Oracle SQL for Users I course at a glance ...

Duration: 1 days
Minimum skill level required: 1
(1 - Beginner, 2 - Experienced
3 - Advanced)
On-Site course:
Yes

Public course: No
No of pages in the manual: 145
Sections: 9
No of exercises: 6
Pre-Requisite course(s):
None
Suggested further course(s):
Oracle SQL for Users II

Price guide: Contact us for the latest pricing

enquiries@seercomputing.com
or call us on +44 (0) 800 157 7519.

PDF - Course Index

PDF - Exercise Example

PDF - Sample Pages

Request for details
Click for the contact form for the Oracle SQL for Users I training course

Scroll left/right and then click on the course to view the details