Top
Email
Bottom
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
145No of slides in the Manual
Exercises
6Total No of Exercises
Sections
9No 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
9
6
145
None
Oracle SQL for Users II
Contact us for the latest pricing

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

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


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.
Request for detailsClick for the contact form for the Oracle SQL for Users I 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 MySQL 8
Days
5
Pages
858
Exercises
23
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