Top
Email
Bottom
Using SQL with Oracle SQL Developer 18.2 Part 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

Using SQL with Oracle SQL Developer 18.2 Part I course at a glance

Pages
404No of slides in the Manual
Exercises
8Total No of Exercises
Sections
19No 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
2Week 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:
2 days
1 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
19
8
404
None
Using SQL with Oracle SQL Developer 18.2 Part II
Contact us for the latest pricing

Index of Oracle SQL with SQL Developer 18.2 Part I

Section
Section Name
Page

Part I
 
 


One
Introduction to SQL
2

 
- Definition
3

 
- Usage of SQL
4

 
- What is SQL used for ?
5

 
- Who uses SQL ?
6

 
- Definition of a Database
7

 
- What is SQL Developer ?
8

Two
The SQL Developer Interface
9

 
- Introduction
10

 
- SQL Developer Connections
12

 
- Connections
14

 
- Worksheet
15

 
- Toolbar and Menus
16

Three
Connections
17

 
- Viewing Objects
18

 
- Viewing Object Structure
19

 
- Table Structure
20

 
- Column Structure
22

 
- Data Default
27

 
- The Number Datatype
28

 
- The Varchar2 Datatype
29

 
- The Date Datatype
30

 
- Large Objects
31

 
- The BLOB Datatype
32

 
- The CLOB Datatype
33

 
- Object Details Dialog
34

Four
Object Details Dialog
35

 
- Introduction
36

 
- Columns Tab
37

 
- Columns Tab (Resizing columns)
38

 
- Columns Tab (Moving columns)
39

 
- Columns Tab (Sorting columns)
40

 
- Columns Tab (Filter)
41

 
- Columns Tab (Icons)
42

 
- Columns Tab (Right Click)
43

 
- Data Tab
44

 
- Data Tab (Single Record View)
45

 
- Data Tab (Count Rows)
47

 
- Data Tab (Viewing Blobs and Clobs)
48

 
- Data Tab (Viewing Blobs)
49

 
- Model Tab
51

 
- Constraints Tab
54

 
- Grants Tab
55

 
- Statistics Tab
56

 
- Triggers Tab
57

 
- Flashback Tab
58

 
- Dependencies Tab
59

 
- Details Tab
60

 
- Partitions Tab
61

 
- Indexes Tab
62

 
- SQL Tab
63

 
- Exercise One
65

Five
Limiting Records in the Data Tab
76

 
- Introduction
77

 
- Usage
78

 
- Using Varchar2 and Dates
79

 
- Case Sensitivity
80

 
- Limiting Dates
81

 
- Invalid Identifier
82

 
- Invalid Number
83

 
- Direct Comparison
84

 
- Value Comparison
86

 
- Column Comparison
88

 
- Range Comparison
89

 
- List Comparison
92

 
- Wildcard Comparison
95

 
- Null Values
99

 
- Combining Filters
100

 
- AND Filters
101

 
- OR Filters
102

 
- Complex Filters
103

 
- Exercise Two
104

Six
Ordering Records in the Data Tab
114

 
- Ordering Records in the Data Tab – Introduction
115

 
- Ordering Records in the Data Tab – Examples
116

Seven
SQL Worksheet
117

 
- Introduction
118

 
- Opening in SQL Developer
119

 
- Creating an SQL Statement
120

 
- Executing an SQL Statement
122

 
- Formatting the SQL Statement
123

 
- SQL Syntax
124

 
- Labelling Selected Columns (Column Aliases)
126

 
- Using Literals
130

 
- Database Variables and Sys.DUAL
131

 
- Saving the SQL to a File
133

 
- Opening and Executing a File
135

 
- Commenting Out Lines
136

 
- Identifying Amended Files
138

 
- SQL History
139

 
- Miscellaneous Commands
140

 
- Query Result Buttons
141

 
- Find / Highlight
146

 
- Searching the Output
147

 
- Searching the Output
148

 
- Exercise Three
149

Eight
Manipulating SQL Output
155

 
- Introduction
156

 
- Functions
157

 
- Upper and Lower
160

 
- Round
161

 
- Ceil and Floor
163

 
- Count
164

 
- Using '*' in Selections
165

 
- Sum
166

 
- To_Char
167

 
- To_Char (Number Examples)
168

 
- To_Char (Date Examples)
170

 
- Substr
172

 
- Substr Examples
173

 
- Decode
174

 
- Combining Functions
176

 
- Concatenating Columns
177

 
- Performing Mathematics
179

 
- Performing Mathematics
180

Nine
Snippets
181

 
- Introduction
182

 
- Topography
183

 
- Using Snippets with the SQL Worksheet
184

 
- Adding User Defined Snippets
187

 
- Editing User Defined Snippets
191

 
- Exercise Four
192

Ten
Limiting Data in the SQL Worksheet
201

 
- The Where Clause
202

 
- Using Functions within the Where Clause
204

 
- Using Lower with a Where Clause
205

 
- Using Substr with a Where Clause
206

 
- Using NVL with a Where Clause
207

 
- Using To_Date with a Where Clause
208

 
- Using Trunc with a Where Clause
211

 
- Using Trunc with a Number
212

 
- Using Trunc with a Date
213

 
- Sub-Queries with a Where Clause
214

 
- Exists with a Where Clause
216

 
- Correlated Sub-Queries
218

 
- Table Aliases
219

 
- Advanced IN Sub-Queries
220

Eleven
Ordering Data in the SQL Worksheet
222

 
- Introduction
223

 
- Advanced Techniques
224

 
- Advanced Techniques
225

 
- Using Decode in Order By
226

 
- Exercise Five
228

Twelve
Aggregating Values in SQL Worksheet
233

 
- Introduction
234

 
- Using Group By
236

 
- Using Where with Group By
238

 
- Using Having with Group By
240

 
- Using Rollup to Total Grouping
242

 
- Exercise Six
247

Thirteen
Joining Tables in an SQL Statement
250

 
- Introduction
251

 
- Linking Tables in an SQL Statement
253

 
- Linking Tables using ANSI SQL/86
257

 
- Linking Tables in an SQL Statement
258

 
- Cartesian Products in an SQL Statement
259

 
- Problems with Joining Tables in SQL
261

 
- Linking Tables using ANSI SQL/99
264

 
- Natural Join using ANSI SQL/99
265

 
- Cross Join using ANSI SQL/99
267

 
- Join using ANSI SQL/99
268

 
- Join On using ANSI SQL/99
269

 
- Outer Joins using ANSI SQL/99
270

 
- Left Outer Join using ANSI SQL/99
271

 
- Right Outer Join using ANSI SQL/99
272

 
- Full Outer Join using ANSI SQL/99
273

 
- Multiple Joins using ANSI SQL/99
274

 
- Exercise Seven
275

Fourteen
Query Builder in the SQL Worksheet
278

 
- Introduction
279

 
- Invoking Query Builder
280

 
- Query Builder Topography
282

 
- Selecting Tables
286

 
- Checking Links
287

Fifteen
Using Views
288

 
- Using Views – Database Views
289

 
- Using Views – Materialized Views
290

Sixteen
Merging Tables in an SQL Statement
291

 
- Merging Tables in SQL
292

 
- Using Union to Merge Tables in SQL
293

 
- Using Union All to Merge Tables in SQL
294

 
- Using Intersect to Merge Tables in SQL
295

 
- Using Minus to Merge Tables in SQL
296

 
- Knowledge Check
297

 
- Knowledge Check - Union
298

 
- Knowledge Check - Union All
299

 
- Knowledge Check - Intersect
300

 
- Knowledge Check - Minus
301

 
- Using the Merge Syntax in SQL
302

Seventeen
Regular Expressions in Oracle SQL
304

 
- Introduction
305

 
- Using REGEXP_LIKE in Where Clauses
308

 
- Case Sensitivity
310

 
- Line Anchors
312

 
- Using the Dot (Any Character)
314

 
- Counting Characters {Intervals}
318

 
- Character Lists
322

 
- Excluding Character Lists
328

 
- Alternatives to Character Lists
329

 
- Class Shorthands
332

 
- Or Patterns (Alternatives)
333

 
- Or Patterns with Character Lists
334

 
- Using the Question Mark (Optional)
335

 
- Using the Plus sign (Mandatory)
338

 
- Using the Star sign (Optional)
341

 
- Backreferencing
342

 
- POSIX
344

 
- Using POSIX in Oracle - [:upper] example
346

 
- Using POSIX in Oracle - [:digit] example
347

 
- Using POSIX in Oracle – Character equivalents
348

 
- Using Regexp_count in SQL
349

 
- Using Regexp_replace in SQL
353

 
- Using Regexp_instr in SQL
355

 
- Using Regexp_substr in SQL
357

 
- Using Regular Expressions in Oracle
359

Eighteen
Exporting Data in SQL Developer
360

 
- Introduction
361

 
- File Types
363

 
- Exporting to CSV
364

 
- Exporting to Delimited
366

 
- Exporting to Excel
367

 
- Exporting to Excel.xml
369

 
- Exporting to Fixed
371

 
- Exporting to HTML
373

 
- Insert
376

 
- Json
378

 
- Insert
379

 
- Loader
380

 
- Loader (ldr)
381

 
- Loader (ctl)
382

 
- PDF
383

 
- Text
385

 
- XML
387

Nineteen
SQL Developer Help Facility
389

 
- Introduction
390

 
- Search and Table of Contents
391

 
- Start Page
392

 
- Data Miner
393

 
- Check for Updates
394

 
- About
395

 
- Exercise Eight
396

Sections of Oracle SQL with SQL Developer 18.2 Part I

Section
Section Name

One
Introduction to SQL

Two
The SQL Developer Interface

Three
Connections

Four
Object Details Dialog

Five
Limiting Records in the Data Tab

Six
Ordering Records in the Data Tab

Seven
SQL Worksheet

Eight
Manipulating SQL Output

Nine
Snippets

Ten
Limiting Data in the SQL Worksheet

Eleven
Ordering Data in the SQL Worksheet

Twelve
Aggregating Values in SQL Worksheet

Thirteen
Joining Tables in an SQL Statement

Fourteen
Query Builder in the SQL Worksheet

Fifteen
Using Views

Sixteen
Merging Tables in an SQL Statement

Synopsis for Oracle SQL with SQL Developer 18.2 Part I

SQL the universal communication language between Databases and us humans is much easier to write as a User when a nice interface is provided, at one point the only software to use was Toad which is an expensive tool for occasional Users, there is also SQL*Plus but that tends to feel dated in the click and drag world we live in.

This SQL Developer 18.2 Part 1 course is essentially the four day SQL Developer 18.2 we give publically and on-site chopped in half … brutal you might say but also you may be looking for an introduction to SQL and SQL Developer without your delegates needing to know how to create Tables, know indexing strategies etc. on the other it may be you can only spare your staff for two days on the bounce without effecting your workloads, therefore you need the four day course presented in two chunks.

While the SQL Developer 18.2 course is available as a public and onsite course, this version is only available as onsite, this means we come to you on dates of your choosing, using our equipment and giving you ultimate flexibility. We can also arrange training at our offices in Swansea or at conference facilities close to you, you will need to talk to one of our course advisors for them to give you all the options we have available and to give breakdowns and pricings for each. If you don’t ask we will suggest options but it's good for you to know your requirements.

This Part one course of SQL Developer covers the User accessing the Oracle database and using the product to extract and manipulate Data from it, this means we show you the various ways to query and how to produce output etc., take a look at the index for this course, it's available on this page for you to review, there's even a printable PDF of it to review, we also send you a copy when you contact us for further details.

When we perform onsite training all we require is a suitable room, big enough for the Delegates to spread out their manuals (which we supply), type and use their individual laptops (which we supply) and write notes (they have to supply that themselves) !

Let's talk about getting in touch with us, our phone number (Freephone) is at the top and bottom of this page (header and footer) in addition we have an enquiry form which asks a couple of questions which help us work out the best way to help you. All of the quotations we give, and you may ask about a number of courses have a six month expiry which we believe is long enough for purchase orders to be arranged etc. after that time our charges may go up … who knows where Brexit will lead us. All quotations include vat and have no hidden charges, that is the price is inclusive we cover the travelling and accommodation costs so you will get no shocks for travel and subsistence.

All quotations are obligation free, we operate a no nag policy so we will not pester you once the quotation is issued, let Seer Computing handle your IT training needs.

Request for detailsClick for the contact form for the Using SQL with Oracle SQL Developer 18.2 Part I training course
Public Courses
Oracle Essential SQL 23ai
Days
2
Pages
384
Exercises
8
Sections
17
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 23ai
Days
3
Pages
388
Exercises
13
Sections
25
Public
Yes
On-Site
Yes
Public Courses
Using SQL with Oracle SQL Developer 23.1
Days
5
Pages
1144
Exercises
16
Sections
41
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