Top
Email
Bottom
Using SQL with Oracle SQL Developer 23.1 Part I
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

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

Pages
400No 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
400
None
Using SQL with Oracle SQL Developer 23.1 Part II
Contact us for the latest pricing

Index of Oracle SQL with SQL Developer 23.1 Part I

Section
Section Name
Page

Part I
 
 


One
Introduction to SQL
2

 
- Usage of SQL
3

 
- Definition of a Database
5

 
- What is SQL Developer ?
6

Two
The SQL Developer Interface
7

 
- Introduction
8

 
- SQL Developer Connections
10

 
- Connections
12

 
- Worksheet
13

 
- Toolbar and Menus
14

Three
Connections
15

 
- Viewing Objects
16

 
- Viewing Object Structure
17

 
- Table Structure
18

 
- Column Structure
20

 
- Mandatory Columns
24

 
- Data Default
25

 
- The Number Datatype
26

 
- The Varchar2 Datatype
27

 
- The Date Datatype
28

 
- Large Objects
29

 
- The BLOB Datatype
32

 
- The CLOB Datatype
31

 
- Object Details Dialog
32

Four
Object Details Dialog
33

 
- Introduction
34

 
- Columns Tab
35

 
- Columns Tab (Resizing columns)
36

 
- Columns Tab (Moving columns)
37

 
- Columns Tab (Sorting columns)
38

 
- Columns Tab (Filter)
39

 
- Columns Tab (Icons)
40

 
- Columns Tab (Right Click)
41

 
- Data Tab
42

 
- Data Tab (Single Record View)
43

 
- Data Tab (Count Rows)
45

 
- Data Tab (Viewing Blobs and Clobs)
46

 
- Data Tab (Viewing Blobs)
47

 
- Model Tab
49

 
- Constraints Tab
52

 
- Grants Tab
53

 
- Statistics Tab
54

 
- Triggers Tab
55

 
- Flashback Tab
56

 
- Dependencies Tab
57

 
- Details Tab
58

 
- Partitions Tab
59

 
- Indexes Tab
60

 
- SQL Tab
61

 
- Exercise One
62

Five
Limiting Records in the Data Tab
73

 
- Introduction
74

 
- Usage
75

 
- Using Varchar2 and Dates
76

 
- Case Sensitivity
77

 
- Limiting Dates
78

 
- Invalid Identifier
79

 
- Invalid Number
80

 
- Direct Comparison
81

 
- Value Comparison
83

 
- Column Comparison
85

 
- Range Comparison
86

 
- List Comparison
89

 
- Wildcard Comparison
92

 
- Null Values
96

 
- Combining Filters
97

 
- AND Filters
98

 
- OR Filters
99

 
- Complex Filters
100

 
- Exercise Two
101

Six
Ordering Records in the Data Tab
111

 
- Ordering Records in the Data Tab – Introduction
112

 
- Ordering Records in the Data Tab – Examples
113

Seven
SQL Worksheet
114

 
- Introduction
115

 
- Opening in SQL Developer
116

 
- Creating an SQL Statement
117

 
- Executing an SQL Statement
119

 
- Formatting the SQL Statement
120

 
- SQL Syntax
121

 
- Labelling Selected Columns (Column Aliases)
127

 
- Using Literals
130

 
- Database Variables and Sys.DUAL
128

 
- Saving the SQL to a File
130

 
- Opening and Executing a File
132

 
- Commenting Out Lines
133

 
- Identifying Amended Files
135

 
- SQL History
136

 
- Miscellaneous Commands
137

 
- Query Result Buttons
138

 
- Find / Highlight
143

 
- Searching the Output
144

 
- Exercise Three
146

Eight
Manipulating SQL Output
151

 
- Introduction
152

 
- Functions
153

 
- Upper and Lower
156

 
- Round
157

 
- Ceil and Floor
159

 
- Count
160

 
- Using '*' in Selections
161

 
- Sum
162

 
- To_Char
163

 
- To_Char (Number Examples)
164

 
- To_Char (Date Examples)
166

 
- Substr
168

 
- Substr Examples
169

 
- Decode
170

 
- Combining Functions
172

 
- Concatenating Columns
173

 
- Performing Mathematics
175

Nine
Snippets
177

 
- Introduction
178

 
- Topography
179

 
- Using Snippets with the SQL Worksheet
180

 
- Adding User Defined Snippets
183

 
- Editing User Defined Category
185

 
- Editing User Defined Snippets
187

 
- Exercise Four
188

Ten
Limiting Data in the SQL Worksheet
197

 
- The Where Clause
198

 
- Using Functions within the Where Clause
200

 
- Using Lower with a Where Clause
201

 
- Using Substr with a Where Clause
202

 
- Using NVL with a Where Clause
203

 
- Using To_Date with a Where Clause
204

 
- Using Trunc with a Where Clause
207

 
- Using Trunc with a Number
208

 
- Using Trunc with a Date
209

 
- Sub-Queries with a Where Clause
210

 
- Exists with a Where Clause
212

 
- Correlated Sub-Queries
214

 
- Table Aliases
215

 
- Advanced IN Sub-Queries
216

Eleven
Ordering Data in the SQL Worksheet
218

 
- Introduction
219

 
- Advanced Techniques
220

 
- Using Decode in Order By
222

 
- Exercise Five
224

Twelve
Aggregating Values in SQL Worksheet
229

 
- Introduction
230

 
- ORA-00937: Not a single-group function
231

 
- Using Group By
232

 
- Using Where with Group By
234

 
- Using Having with Group By
236

 
- Using Rollup to Total Grouping
238

 
- Exercise Six
243

Thirteen
Joining Tables in an SQL Statement
246

 
- Introduction
247

 
- Linking Tables in an SQL Statement
249

 
- Linking Tables using ANSI SQL/86
253

 
- Linking Tables in an SQL Statement
254

 
- Cartesian Products in an SQL Statement
255

 
- Problems with Joining Tables in SQL
257

 
- Linking Tables using ANSI SQL/99
260

 
- Natural Join using ANSI SQL/99
261

 
- Cross Join using ANSI SQL/99
263

 
- Join using ANSI SQL/99
264

 
- Join On using ANSI SQL/99
265

 
- Outer Joins using ANSI SQL/99
266

 
- Left Outer Join using ANSI SQL/99
267

 
- Right Outer Join using ANSI SQL/99
268

 
- Full Outer Join using ANSI SQL/99
269

 
- Multiple Joins using ANSI SQL/99
270

 
- Exercise Seven
271

Fourteen
Query Builder in the SQL Worksheet
274

 
- Introduction
275

 
- Invoking Query Builder
276

 
- Query Builder Topography
278

 
- Selecting Tables
282

 
- Checking Links
283

Fifteen
Using Views
284

 
- Using Views – Database Views
285

 
- Using Views – Materialized Views
286

Sixteen
Merging Tables in an SQL Statement
287

 
- Creating Table Sets in SQL
288

 
- Using the Merge / Set Syntax in SQL
289

 
- Using Union to Merge Tables in SQL
291

 
- Using Union All to Merge Tables in SQL
292

 
- Using Intersect to Merge Tables in SQL
293

 
- Using Intersect All to Merge Tables in SQL
294

 
- Using Minus to Merge Tables in SQL
295

 
- Using Minus All to Merge Tables in SQL
296

 
- Using Except to Merge Tables in SQL
297

 
- Using Except All to Merge Tables in SQL
298

 
- Using the Merge Syntax in SQL
299

Seventeen
Regular Expressions in Oracle SQL
300

 
- Introduction
301

 
- Using REGEXP_LIKE in Where Clauses
304

 
- Case Sensitivity
306

 
- Line Anchors
308

 
- Using the Dot (Any Character)
310

 
- Counting Characters {Intervals}
314

 
- Character Lists
318

 
- Excluding Character Lists
324

 
- Alternatives to Character Lists
325

 
- Class Shorthands
328

 
- Or Patterns (Alternatives)
329

 
- Or Patterns with Character Lists
330

 
- Using the Question Mark (Optional)
331

 
- Using the Plus sign (Mandatory)
334

 
- Using the Star sign (Optional)
337

 
- Backreferencing
338

 
- POSIX
340

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

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

 
- Using POSIX in Oracle – Character equivalents
344

 
- Using Regexp_count in SQL
345

 
- Using Regexp_replace in SQL
349

 
- Using Regexp_instr in SQL
351

 
- Using Regexp_substr in SQL
353

 
- Using Regular Expressions in Oracle
355

Eighteen
Exporting Data in SQL Developer
356

 
- Introduction
357

 
- File Types
359

 
- Exporting to CSV
360

 
- Exporting to Delimited
362

 
- Exporting to Excel
363

 
- Exporting to Excel.xml
365

 
- Exporting to Fixed
367

 
- Exporting to HTML
369

 
- Insert
372

 
- Json
374

 
- Insert
375

 
- Loader
376

 
- Loader (ldr)
377

 
- Loader (ctl)
378

 
- PDF
379

 
- Text
381

 
- XML
383

Nineteen
SQL Developer Help Facility
385

 
- Introduction
386

 
- Search and Table of Contents
387

 
- Start Page
388

 
- Data Miner
389

 
- Check for Updates
390

 
- About
391

 
- Exercise Eight
392

Sections of Oracle SQL with SQL Developer 23.1 Part I

Section
Section Name

1
Introduction to SQL

2
The SQL Developer Interface

3
Connections

4
Object Details Dialog

5
Limiting Records in the Data Tab

6
Ordering Records in the Data Tab

7
SQL Worksheet

8
Manipulating SQL Output

9
Snippets

10
Limiting Data in the SQL Worksheet

12
Ordering Data in the SQL Worksheet

12
Aggregating Values in SQL Worksheet

13
Joining Tables in an SQL Statement

14
Query Builder in the SQL Worksheet

15
Using Views

16
Merging Tables in an SQL Statement

17
Regular Expressions in Oracle SQL

18
Exporting Data in SQL Developer

19
SQL Developer Help Facility

Synopsis for Oracle SQL with SQL Developer 23.1 Part I

One of the things other Course providers miss is that they are training people to use a product which they may only ever occasionally use, as a working IT Consultancy we appreciate that Delegates will not be 100% using a product but it is merely a tool amongst many that they will need to pick up and use maybe intensely for an hour or so in the week and then return to their other duties, our comprehensive manuals are designed therefore specifically so that using the index the Delegates can go straight to the topic in hand and get the task done quickly and efficiently.

Case in point is the SQL Developers training course, Part 1 (there is a Part 2 part as well if you see what we mean), the majority of Delegates attending this course will use the SQL Developer product to access the Oracle Database to extract information which they will use to produce reports or answer queries from Senior Managers, they do not need to, or wish to, know how to create tables, indexes or insert data (that's part 2 of the SQL Developer course, did we mention we have that available too ?), therefore they are more concerned with the extraction and manipulation of data using the SQL Developer product, and that’s what this two day course does, it concentrates on the key areas of using Oracle SQL for data extraction, that is, selection, ordering, linking tables (or views), filtering and manipulation, all within the latest version of Oracle SQL Developer.

Of course SQL Developer isn’t only just for selecting records from an Oracle Database, but this course primarily concentrates on that, we also look at exporting records from SQL Developer into comma separated files etc, in fact, all the things an occasional User of SQL Developer will need, take a look at the index of this course and review the contents, the part 2 course concentrates on what more power Users might want to use SQL Developer for, creating tables, indexing, updating records etc, we've combined both courses into a single four day training course which we put on around the UK and Ireland all times of the year but each of these courses is also available onsite.

On site courses are ideal for Companies who have a few Delegates who need the same training, we come to you, we bring our equipment and materials and we set up in a room for the Delegates to come and learn the SQL Developer product, we do the travelling, we do the overnight stays and you have the bonus of being able to get at your colleagues throughout the day in case of emergency. It’s a lot easier to arrange a course at your place of work and to get the diaries aligned with each member of the team, in fact, we will start the course at whatever time suits you, we can even finish at a set time as long as we have the time to get all of our words of wisdom in and the Delegates have the time to go through the exercises ably supported by our very experienced Training Consultants.

Contact us for an obligation free quotation, all of our quotations are valid for six months so if you are just looking for pricing at the moment, no worries, but we guarantee the price won't change once you are ready to book the course, unless of course the Government decide to change the vat rate, this we would have to pass on to you and don’t worry about us being around when you decide you want the training, if the retirement age goes up to 75 we are going to be here for a very very long time … in fact we've already been around for 20 years, lets aim for the golden anniversary !
Request for detailsClick for the contact form for the Using SQL with Oracle SQL Developer 23.1 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