Download our latest
Android and iPhone apps ...
At a glance ...
Pages
158
Exercises
9
Sections
10
Public
On-Site
Level
1
Days
1

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

Synopsis for 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.

Exercise highlights

Creating queries
Formatting results
Modifying table data
Query parameters

Course Contents

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