×
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
404
No of slides in the Manual
Exercises
8
Total No of Exercises
Sections
19
No of main topics, see index below
Public
No
Public course in the UK and Ireland
On-Site
Yes
We can come to your venue
Level
1
1 - Beginners
2 - Intermediate
3 - Advanced
Days
2
Week days but we can put on weekend courses

Course Name: Using SQL with Oracle SQL Developer 18.2 Part I

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

Request for details
Click for the contact form for the Using SQL with Oracle SQL Developer 18.2 Part I training course

Synopsis for Oracle SQL with SQL Developer 18.2 Part I

SQL is the foundation of all Oracle and other brand database actions.
The very powerful SQL Developer Interface offers a GUI front end for creating SQL statements and offers a valuable alternative to third party products such as Toad.

This course covers all aspects using SQL Developer for extracting Data, essentially it is a two day version of our main 'Using SQL with SQL Developer 18.2' and takes the User through selecting and manipulating data.

Part II covers the insertion, updating and deletion of data as well as the creation of Database Objects.

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

Request for details
Click for the contact form for the Using SQL with Oracle SQL Developer 18.2 Part I training course


Oracle SQL with SQL Developer 18.2 Part I

Download our latest
Android and iOS apps ...

Papers and Periodicals App
Download A-Z Yoga app
Download SQL app
Download PHP app
Download MySQL app
Download MariaDB app
Click on whichever one of our Apps you are interested in
×
Using SQL with Oracle SQL Developer 18.2 Part I
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

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

Duration: 2 days
Minimum skill level required: 1
(1 - Beginner, 2 - Experienced
3 - Advanced)
On-Site course:
Yes

Public course: No
No of pages in the manual: 404
Sections: 19
No of exercises: 8
Pre-Requisite course(s):
None
Suggested further course(s):
Using SQL with Oracle SQL Developer 18.2 Part II

Price guide: Contact us for the latest pricing

enquiries@seercomputing.com
or call us on +44 (0) 800 157 7519.

PDF - Course Index

PDF - Exercise Example

PDF - Sample Pages

Request for details
Click for the contact form for the Using SQL with Oracle SQL Developer 18.2 Part I training course
SQL is the foundation of all Oracle and other brand database actions.
The very powerful SQL Developer Interface offers a GUI front end for creating SQL statements and offers a valuable alternative to third party products such as Toad.

This course covers all aspects using SQL Developer for extracting Data, essentially it is a two day version of our main 'Using SQL with SQL Developer 18.2' and takes the User through selecting and manipulating data.

Part II covers the insertion, updating and deletion of data as well as the creation of Database Objects.
Scroll through these locations and find the one nearest to you.

Click on the location of your choice and that will take you to the dates for each course

Select the location and then click on the image to view the dates

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

Request for details
Click for the contact form for the Using SQL with Oracle SQL Developer 18.2 Part I training course
×
Using SQL with Oracle SQL Developer 18.2 Part I
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

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

Duration: 2 days
Minimum skill level required: 1
(1 - Beginner, 2 - Experienced
3 - Advanced)
On-Site course:
Yes

Public course: No
No of pages in the manual: 404
Sections: 19
No of exercises: 8
Pre-Requisite course(s):
None
Suggested further course(s):
Using SQL with Oracle SQL Developer 18.2 Part II

Price guide: Contact us for the latest pricing

enquiries@seercomputing.com
or call us on +44 (0) 800 157 7519.

PDF - Course Index

PDF - Exercise Example

PDF - Sample Pages

Request for details
Click for the contact form for the Using SQL with Oracle SQL Developer 18.2 Part I training course

Scroll left/right and then click on the course to view the details