Top
Email
Bottom
Query Builder
 
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

Query Builder course at a glance

Pages
158No of slides in the Manual
Exercises
9Total No of Exercises
Sections
10No 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
10
9
158
None
Oracle Essential SQL 12c
Contact us for the latest pricing

Oracle Query Builder training course
Exercise highlights

Creating queries
Formatting results
Modifying table data
Query parameters

Index of Oracle Query Builder training course

Section
Contents
Page

One
Background Information 
2

 
- Databases 
3

 
- Tables 
4

 
- Table Pseudo Columns 
5

 
- Views 
6

 
- Indexes and Relationships 
7

 
- SQL Commands 
8

Two
Introduction to Query Builder 
9

 
- Introduction 
10

 
- Logging on 
12

 
- Successful Logon 
14

 
- Unsuccessful Logon 
15

 
- Table Problem 
17

 
- Exercise One 
19

Three
Interface Components  
21

 
- Introduction 
22

 
- Menu Bar 
23

 
- Shortcut Bar 
24

 
- Windows 
30

 
- DataSource Window 
31

 
- Conditions Window 
32

 
- Results Window 
33

Four
Simple Queries 
34

 
- Creating a New Query 
35

 
- Adding Tables 
36

 
- Table Relationships 
38

 
- Column Datatypes 
39

 
- Selecting Columns 
41

 
- Executing a Query 
42

 
- Counting Rows 
43

 
- Exercise Two 
44

Five
Complex Queries 
52

 
- Applying Conditions 
53

 
- Functions 
56

 
- Group Functions 
57

 
- Defining Columns 
58

 
- Exercise Three 
61

Six
Formatting  
67

 
- Columns 
68

 
- Positioning Columns 
72

 
- Exercise Four 
74

 
- Sorting 
76

 
- Break Example 
80

 
- Exercise Five 
83

 
- Totals 
85

 
- Exercise Six 
89

Seven
The Data Editor 
93

 
- Introduction 
94

 
- Updating 
95

 
- Inserting 
97

 
- Deleting 
100

 
- Amending 
102

 
- Commit 
103

 
- Exceptions 
105

 
- Exceptions to Update 
106

 
- Exceptions to Insert 
108

 
- Exceptions to Delete 
109

 
- Record Locking 
110

 
- Exercise Seven 
111

Eight
Printing Options 
113

 
- Page Setup 
114

 
- Margins 
115

 
- Page Justification 
117

 
- Headers and Footers 
119

 
- Exporting to a File 
123

 
- Exercise Eight 
124

Nine
Miscellaneous 
125

 
- Setting Preferences 
126

 
- Setting Table Relationships 
129

 
- Importing SQL 
133

 
- Exporting SQL 
134

 
- Query Parameters 
135

 
- Query Builder Tables 
138

 
- Subqueries 
139

 
- Granting Access 
140

 
- Revoking Access 
141

 
- DDE (Dynamic) Links 
142

 
- The Command Line 
145

 
- The Command File 
147

 
- Query Naming Conventions 
148

 
- Query Builder Restrictions 
149

Ten
Help Facility 
150

 
- Exercise Nine 
154

 
 
 

Index of Oracle Query Builder training course

Section
Contents
One
Background Information 
Two
Introduction to Query Builder 
Three
Interface Components  
Four
Simple Queries 
Five
Complex Queries 
Six
Formatting  
Seven
The Data Editor 
Eight
Printing Options 
Nine
Miscellaneous 
Ten
Help Facility 

Synopsis for Oracle Query Builder training course

Oracle Query Builder is an ad-hoc query tool designed for analysts and other business professionals to be able to quickly and easily retrieve information from a Database.

Query Builder utilises an intuitive graphical environment that enables end users with no SQL knowledge to create database queries. The query results can be formatted to produce a professional report output.
Request for detailsClick for the contact form for the Query Builder 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