×
Using SQL with Oracle SQL Developer 18.1 Part II
 
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.1 Part II course at a glance ...

Pages
480
No of slides in the Manual
Exercises
10
Total No of Exercises
Sections
18
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.1 Part II

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
18
10
480
Using SQL with Oracle SQL Developer 18.1 Part I
Oracle Essential PLSQL 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

Request for details
Click for the contact form for the Using SQL with Oracle SQL Developer 18.1 Part II training course

Synopsis for Oracle SQL with SQL Developer 18.1 Part II

SQL is the foundation of all Oracle database actions. The 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 aspects of using SQL Developer such as advanced query techniques, using the interface to amend and update information, creating Oracle Database objects etc ...

Please refer to either Part I of this course or the four day 'Using SQL with SQL Developer 18.1' if there is no previous knowledge of SQL.
This course is designed for Users of SQL who now need to create Objects etc using SQL Developer. The latest version of this product is 18.2, which we have a course for.

Index of Oracle SQL with SQL Developer 18.1 Part II

Section
Section Name
Page

Part II
 
 


One
Data Manipulation in SQL Developer
2

 
- Introduction
3

 
- Updating a record in Data
4

 
- Updating a Primary Key in Data
6

 
- Reverting Changes using Refresh
7

 
- Updating a table with a trigger in Data
8

 
- Deleting a record in Data
10

 
- Deleting a record which has children
11

 
- Inserting a record in Data
12

 
- Problems manipulating data
14

Two
Data Manipulation in SQL Worksheet
15

 
- Introduction
16

 
- Inserting Records using SQL Worksheet
17

 
- Rules When Populating Tables
18

 
- SQL Syntax for Populating Tables
19

 
- Using Sysdate To Populate Tables
24

 
- General Comments
25

 
- Inserting Data using the SQL Worksheet
26

 
- Saving the Insert statement
32

 
- Updating Data in SQL Worksheet
33

 
- Deleting Records using Truncate
40

 
- Exercise One
42

Three
Importing External Data
52

 
- Introduction
53

 
- Beginning the Import
54

 
- Import method
57

 
- Choose Columns
58

 
- Column Definition
60

 
- Finish
62

 
- Importing xls files (Insert Script)
64

 
- Importing xls files (Targeting Columns)
65

 
- Cutting and pasting xls files
66

 
- Importing csv files
67

 
- Exercise Two
68

Four
Table Manipulation in SQL Developer
69

 
- Creating Columns for Tables
70

 
- Naming Tables and Columns
71

 
- Creating Tables
73

 
- Creating Columns
76

 
- Column Datatypes
77

 
- Creating Mandatory Columns
79

 
- Creating Indexes for Tables
80

 
- Default
82

 
- Table Creation DDL
85

 
- Creation Syntax for Tables
86

 
- Comments for Columns
87

 
- Comments for Tables
91

 
- Renaming a Table
94

 
- Copying Tables SQL Syntax
97

 
- Creating a Table by copying an existing one
98

 
- Copying Tables SQL Syntax
99

 
- Dropping Tables
101

 
- Dropping Tables (Cascade Constraints)
103

 
- Dropping Tables (Purge)
104

 
- Dropping Tables (Flashback to Before Drop)
107

 
- Dropping Tables SQL Syntax
109

 
- Restoring Tables from Recycle SQL Syntax
110

 
- Altering Columns
111

 
- Renaming Columns
113

 
- Renaming Columns Syntax
115

 
- ORA-00957: Duplicate Column Name
116

 
- Adding Columns
117

 
- ORA-00910: specified length too long for its datetype
118

 
- Adding Columns SQL Syntax
119

 
- Dropping Columns
121

 
- ORA-12992: Cannot drop parent key column
122

 
- Dropping Columns Syntax
123

 
- Modifying Columns Syntax
124

 
- Rules for Modifying Columns
125

 
- Multiple Column Modification
126

 
- Normalizing Columns
127

Five
Table Constraints and Indexes
130

 
- Introduction
131

 
- Creating Indexes in SQL
134

 
- Primary Key Creation in SQL
137

 
- Add Primary Key
139

 
- ORA-02260: Table can have only one primary key
141

 
- Unique Key Creation in SQL
142

 
- Add Unique Key
144

 
- Add Foreign Key
146

 
- ORA-02270: no matching unique or primary key
149

 
- Non-Unique Index
150

 
- Disabling Indexes in SQL
153

 
- Check Constraints
154

 
- ORA-02293: cannot validate – check constraint
155

 
- Check Constraint Syntax
156

 
- Add Check
157

 
- Drop
158

 
- Other options
160

 
- Enable / Disable Related Foreign Keys / All / Single
161

 
- Rename Single
162

 
- Exercise Three
163

Six
Accessing Objects
175

 
- Introduction
176

 
- Privileges
177

 
- Granting Privileges Syntax
178

 
- Privileges
180

 
- Granting Privileges
181

 
- Revoking Privileges Syntax
182

 
- Revoking Privileges
183

 
- Viewing Privileges
184

 
- Accessing other Schemas
185

 
- ORA-01031: Insufficient Privileges
187

 
- Accessing other Schemas with SQL Worksheet
188

 
- Accessing other Schemas with Synonyms
189

 
- Synonym SQL Syntax
193

 
- ORA-00955: Name is already used
194

 
- Dropping Synonyms
195

 
- Dropping Synonyms Syntax
196

 
- Public Synonyms
197

 
- ORA-01031: Insufficient Privileges
198

 
- Exercise Four
199

Seven
Virtual Columns
201

 
- Introduction
202

 
- Creating Virtual Columns with new Table
203

 
- Specifying Virtual Column Datatype and Size
204

 
- Adding Virtual Columns to Existing Table
205

 
- Using Virtual Columns in SQL …
206

 
- Using Virtual Columns with Functions
208

 
- ORA-54012: virtual column is referenced in a column
209

 
- ORA-54015: Duplicate column expression specified
210

 
- ORA-54013: INSERT disallowed on virtual columns
211

 
- ORA-54017: UPDATE disallowed on virtual columns
212

Eight
Invisible Columns in Oracle 12c
213

 
- Exercise Five
218

Nine
Views
220

 
- Introduction
221

 
- Creating Views Syntax
223

 
- Create (simple)
226

 
- Creating Views
228

 
- ORA-00936: Missing expression
230

 
- Properties
231

 
- Force on Create
232

 
- Query Restriction
233

 
- Updating using Views
235

 
- ORA-42399: Cannot perform a DML on a read-only
236

 
- Renaming Views SQL Syntax
237

 
- Renaming Views
238

 
- Dropping a View SQL Syntax
239

 
- Dropping a View
240

 
- Exercise Six
241

Ten
Materialized Views
245

 
- Introduction
246

 
- Creating Simple Materialized Views
248

 
- Refreshing Materialized Views
252

 
- New Materialized View
253

 
- New Materialized View
254

 
- Refresh Options
255

 
- Materialized Refresh Options
256

 
- Time Interval
257

 
- Materialized Time Interval
258

 
- Fast Refresh and Materialized View Logs
259

 
- Key Type
264

 
- Editing Materialized Views
265

 
- Viewing Materialized Views
268

 
- Dropping Materialized Views
269

 
- Synchronizing Materialized Views
270

 
- Exercise Seven
271

Eleven
Sequences
274

 
- Introduction
275

 
- Creating Sequences
276

 
- Viewing Sequences
278

 
- Editing Sequences
279

 
- Using Sequences
280

 
- Dropping Sequences
281

Twelve
Tree Walking Tables in SQL Worksheet
282

 
- Introduction
283

 
- Syntax for Tree Walking
286

 
- Example of Tree Walking
287

 
- Using LPAD with Tree Walking
290

 
- Using Order Siblings By in Tree Walks
292

 
- Using Sys_Connect_By_Path in Tree Walks
293

 
- Exercise Eight
295

Thirteen
Sub-Queries in Oracle SQL
299

 
- Introduction
300

 
- Using Equals
301

 
- In and Not In
304

 
- Exists
306

 
- Any
307

 
- Some
308

 
- All
309

 
- Correlated Queries
310

 
- Correlated Updates and Deletes
311

 
- Inline Views
312

 
- Inline View Example
313

 
- Sub-Queries in a Select Statement
314

 
- Sub-Query Factoring (Using With)
315

 
- Sub-Query Factoring Example with Aliases
317

 
- Sub-Query Factoring Example with Joins
318

Fourteen
Advanced SQL Query Techniques
319

 
- Introduction
320

 
- Using First_Value/Last_Value
321

 
- Window Specification
323

 
- Breakdown of Window Specification
324

 
- Window Specification - The Arguments
326

 
- Window Specification - Query Partition
327

 
- Window Specification - The Order By
329

 
- Window Specification - The Windowing
331

 
- Window Specification - Rows between
333

 
- Window Specification - Shortcuts
337

 
- Difference between Range and Rows
338

 
- Using Lead and Lag
341

 
- Using Case Function
343

 
- Nesting the Case Function
346

 
- Subqueries in the Case Function
347

 
- Using the Rank Function
348

 
- Using the Ntile Function
351

 
- Using Width_Bucket Function
352

 
- Using Width_Bucket Function in SQL Worksheet
353

 
- Pivot
354

 
- Adding a Total to a Pivot
358

 
- Changing the Pivot Headings of X Axis
359

 
- Rotating the Axis of the Pivot
360

 
- Unpivot
361

 
- Unpivot and Null values
364

 
- Using Listagg Function in SQL
365

 
- Exercise Nine
367

Fifteen
Using Merge Into
375

 
- Introduction
376

 
- SQL Syntax
377

Sixteen
Export DDL (and Data)
380

 
- Introduction
381

 
- Object by Object
382

 
- Exporting DDL and DML
383

 
- Export Wizard (Step One)
385

 
- Pretty Print
386

 
- Show Schema / Grants
387

 
- Byte
388

 
- Terminator
389

 
- Force to Views
391

 
- Drops
392

 
- Cascade Drops
393

 
- Storage
394

 
- Dependents
395

 
- Compatible
397

Seventeen
SQL Developer Reports
398

 
- Introduction
399

 
- User Defined Reports
401

 
- Creating User Defined Reports
402

 
- New Folder
403

 
- New Report
404

 
- Master Report
405

 
- Table
407

 
- Editing / Advanced Options
408

 
- SQL Query
409

 
- Binds
410

 
- Refreshing
415

 
- Child Reports
416

 
- Multiple Child Reports
421

 
- Drill Down
422

 
- PDF
426

 
- PDF (Binary Large Object)
428

 
- PDF (Cell Layout)
430

 
- PDF (Column Layout)
431

 
- PDF (Table Layout)
432

 
- PDF (Header and Footer)
433

 
- PDF (Page Layout)
434

 
- Styles
435

 
- Chart
436

 
- Bar
438

 
- Properties
440

 
- Pie
444

 
- Line
446

 
- Area
448

 
- Combination
449

 
- Scatter
450

 
- Bubble
451

 
- Stock
452

 
- Polar
453

 
- Pareto
454

 
- Funnel
455

 
- 3D
456

 
- Gauge
457

 
- Script
459

 
- Child Reports with Charts
460

 
- Refresh
462

Eighteen
SQL Developer Help Facility
463

 
- Introduction
464

 
- Search and Table of Contents
465

 
- Start Page
466

 
- Data Miner
467

 
- Check for Updates
468

 
- About
469

 
- Exercise Ten
470

Request for details
Click for the contact form for the Using SQL with Oracle SQL Developer 18.1 Part II training course


Oracle SQL with SQL Developer 18.1 Part II

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.1 Part II
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

Using SQL with Oracle SQL Developer 18.1 Part II 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: 480
Sections: 18
No of exercises: 10
Pre-Requisite course(s):
Using SQL with Oracle SQL Developer 18.1 Part I
Suggested further course(s):
Oracle Essential PLSQL 12c

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.1 Part II training course
SQL is the foundation of all Oracle database actions. The 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 aspects of using SQL Developer such as advanced query techniques, using the interface to amend and update information, creating Oracle Database objects etc ...

Please refer to either Part I of this course or the four day 'Using SQL with SQL Developer 18.1' if there is no previous knowledge of SQL.
This course is designed for Users of SQL who now need to create Objects etc using SQL Developer.
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.1 Part II

Section
Section Name

One
Data Manipulation in SQL Developer

Two
Data Manipulation in SQL Worksheet

Three
Importing External Data

Four
Table Manipulation in SQL Developer

Five
Table Constraints and Indexes

Six
Accessing Objects

Seven
Virtual Columns

Eight
Invisible Columns in Oracle 12c

Nine
Views

Ten
Materialized Views

Eleven
Sequences

Twelve
Tree Walking Tables in SQL Worksheet

Thirteen
Sub-Queries in Oracle SQL

Fourteen
Advanced SQL Query Techniques

Fifteen
Using Merge Into

Sixteen
Export DDL (and Data)

Seventeen
SQL Developer Reports

Eighteen
SQL Developer Help Facility

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


Additional Information
 

Using SQL with Oracle SQL Developer 18.1 Part II 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: 480
Sections: 18
No of exercises: 10
Pre-Requisite course(s):
Using SQL with Oracle SQL Developer 18.1 Part I
Suggested further course(s):
Oracle Essential PLSQL 12c

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.1 Part II training course

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