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


Name:
Company:
Email:
Telephone:
Training type:
No of delegates:
Additional Information
 

Query Builder course at a glance ...

Pages
158
No of slides in the Manual
Exercises
9
Total No of Exercises
Sections
10
No of main topics, see index below
Public
Public course in the UK and Ireland
On-Site
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: Query Builder

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
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

Click for the contact form for the Query Builder training course

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.

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