Top
Email
Bottom
Oracle Essential SQL 19c
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

Oracle Essential SQL 19c course at a glance

Pages
340No of slides in the Manual
Exercises
8Total No of Exercises
Sections
15No 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
15
8
340
None
Oracle Essential PLSQL 19c
Contact us for the latest pricing

Index of Oracle 19c Essential SQL training course

Section
Contents
Page

One
Introduction to SQL
2

 
- Definition of SQL
3

 
- Definition of a Database
4

Two
Database Objects
5

 
- Introduction
6

 
- Tables
7

 
- Views
8

 
- Materialized Views
9

 
- Indexes
10

 
- Sequences
11

 
- Packages, Functions and Procedures
12

 
- Synonyms and Schemas
13

Three
The SQL Plus Interface
14

 
- Introduction
15

 
- Anatomy of SQL Plus
20

 
- ORA-01017: invalid username/password; logon denied
21

 
- ORA-12154: TNS:could not resolve connect identifier
22

 
- Exiting an SQL Plus Session
23

 
- Using the DOS Window
24

 
- Copying and Pasting
25

 
- Using the Function Keys
28

 
- Using the Line Editor in SQL Plus
29

 
- Using the Editor in SQL Plus
30

 
- SQL Plus Environment Settings
31

 
- File Manipulation in SQL Plus
32

 
- Spooling Results in SQL Plus
33

 
- Changing Passwords / Clearing the Screen in SQL
34

Four
SQL Scripts
35

 
- Commenting SQL Scripts
39

 
- Running SQL in Batch Scripts
41

 
- Passing Parameters with SQL Scripts
43

Five
Simple Queries
45

 
- Introduction
46

 
- Oracle Metadata
47

 
- SQL Syntax
52

 
- Counting Records in an Oracle Table
55

 
- Displaying Literals in a Select statement
57

 
- Displaying Variables in a Select statement
60

 
- Exercise One
61

 
- Column Aliases
65

 
- Column Manipulation with SQL Functions
68

 
- Concatenating Columns in SQL
74

 
- Performing Calculations in SQL
75

 
- Ordering Data in SQL
76

 
- Ordering More than One Column
78

 
- Ordering with nulls first / nulls last
79

 
- Manipulating Dates in SQL
80

 
- Displaying Dates in SQL
81

 
- Exercise Two
82

Six
Limiting Data Selected with a Where Clause
87

 
- Limiting Data in SQL
88

 
- Structure of an SQL Where Clause
89

 
- Different types of SQL Where Clauses
90

 
- Handling Nulls in Where Clauses
98

 
- Case Restrictions in SQL Where Clauses
99

 
- Using Functions in Where Clauses
100

 
- Rownum in SQL Tables
103

 
- Using Rowid in SQL Tables
105

 
- Fetch first rows of a Table in Oracle 19c (Top-N)
107

 
- Using Percent with Fetch in Oracle 19c
108

 
- Using Offset with Fetch in Oracle 19c
109

 
- Using With Ties with Fetch in Oracle 19c
110

 
- Exercise Three
111

Seven
Oracle Datatypes
116

 
- Introduction
117

 
- Varchar2
118

 
- ORA-00910: specified length too long for its datatype
120

 
- Varchar2 and Char
121

 
- Number
122

 
- Date
123

 
- Float
124

 
- Long
125

 
- Large Objects
126

 
- Bfile
130

Eight
Aggregating Values
131

 
- Introduction
132

 
- Using Group By
133

 
- Using Having with Group By
136

 
- Using Rollup to Total Grouping
138

Nine
Tree Walking Tables in SQL
139

 
- Introduction
140

 
- Syntax for Tree Walking in SQL
142

 
- Example of Tree Walking in SQL
143

 
- Advanced Ordering of Siblings in Tree Walks
144

 
- Sys_Connect_By_Path
146

 
- Exercise Four
148

Ten
Joining Tables in an SQL Statement
151

 
- Using Table Aliases in SQL
152

 
- Linking Tables in an SQL statement
154

 
- Problems with Joining Tables in SQL
159

 
- Problems with Joining Tables in SQL
160

 
- Methods of Joining Tables in SQL
161

 
- Using Ansi SQL/86 to Join Tables
162

 
- Ansi SQL/86 and Outer Joins
163

 
- Ansi SQL/99 Standards (Natural Joins)
166

 
- Ansi SQL/99 Standards (Cross Joins)
167

 
- Ansi SQL/99 Standards (Joins/Using)
168

 
- Ansi SQL/99 Standards (On)
169

 
- Ansi SQL/99 Standards (Multiple On)
170

 
- Ansi SQL/99 Standards (Left Outer Joins)
171

 
- Ansi SQL/99 Standards (Right Outer Joins)
172

 
- Ansi SQL/99 Standards (Full Outer Joins)
173

 
- Merging Tables in SQL
174

 
- Using Union to Merge Tables in SQL
175

 
- Using Union All to Merge Tables in SQL
176

 
- Using Intersect to Merge Tables in SQL
177

 
- Using Minus to Merge Tables in SQL
178

 
- Knowledge Check
179

 
- Union
180

 
- Union All
181

 
- Intersect
182

 
- Minus
183

 
- Using the Merge Syntax in SQL
184

 
- Exercise Five
185

Eleven
Advanced SQL Query Techniques
189

 
- Introduction
190

 
- Pivot
191

 
- Adding a Total to a Pivot
196

 
- Changing the Pivot Headings of X Axis
197

 
- Rotating the Axis of the Pivot
199

 
- Unpivot
200

 
- Unpivot and Null values
203

 
- Using First_Value/Last_Value in SQL
204

 
- Using First_Value/Last_Value in SQL
205

 
- Ignoring Nulls with First/Last_Value
206

 
- Window Specification
207

 
- Breakdown of Window Specification
208

 
- The Arguments
210

 
- Query Partition
211

 
- The Order By
213

 
- The Windowing
215

 
- Rows between
217

 
- Shortcuts
221

 
- Difference between Range and Rows
222

 
- Using Lead and Lag in SQL
225

 
- Using Rank Function in SQL
229

 
- Using Ntile Function in SQL
236

 
- Using Width_Bucket Function in SQL
238

 
- Using Listagg Function in SQL
241

 
- Using Case Function in SQL
243

 
- Exercise Six
247

Twelve
Creating Database Objects in SQL
251

 
- Creating Tables in SQL
252

 
- Mandatory Columns in SQL Tables
254

 
- Creation Syntax for Tables in SQL
255

 
- Virtual Columns
257

 
- Creating Virtual Columns with new Table
258

 
- Specifying Virtual Column Datatype and Size
259

 
- Adding Virtual Columns to Existing Table
260

 
- Using Virtual Columns in SQL
261

 
- Using Virtual Columns with Functions
263

 
- Limitations of Virtual Columns (ORA-54012)
264

 
- Limitations of Virtual Columns (ORA-54015)
265

 
- Limitations of Virtual Columns (ORA-54013)
266

 
- Viewing Virtual Columns in USER_TAB_COLS
267

 
- Invisible Columns in Oracle 19c
268

 
- Commenting on Tables in SQL
271

 
- Commenting on Columns in SQL
272

 
- Creating Indexes in SQL
273

 
- Index Creation in SQL
276

 
- Index Creation in SQL
277

 
- Disabling Indexes in SQL
278

 
- Creating Views in SQL
279

 
- Creating Sequences in SQL
281

 
- Using Sequences in SQL
282

 
- Altering Sequences in SQL
284

 
- Using Default Value in SQL Tables
285

 
- Using Default Value in Oracle 19c
286

 
- Using Identity in Oracle 19c
287

 
- Renaming Objects in an Oracle Database
288

 
- Dropping Objects from an Oracle Database
291

 
- Granting Access to other Schemas
292

 
- Accessing other Schemas
295

 
- Creating Synonyms in Oracle
296

 
- Exercise Seven
297

Thirteen
Altering and Populating Oracle Tables
299

 
- Altering Tables - Some Rules When Altering Tables
300

 
- Altering Tables - Syntax for Altering Tables
301

 
- Rules When Populating Tables in SQL
302

 
- Syntax for Populating Tables
303

 
- Using Variables To Populate Tables
308

 
- General Comments
309

 
- Updating Data in Oracle Tables
310

 
- Deleting Data from Oracle Tables
312

 
- Handling Large Objects in SQL Plus
313

 
- Handling BFiles in SQL Plus
315

Fourteen
Committing Records
316

 
- The Difference Between DDL & DML
317

 
- Using Autocommit in SQL Plus
320

Fifteen
Materialized Views
321

 
- Introduction
322

 
- Syntax for Creating Materialized Views
324

 
- Refreshing Materialized Views
326

 
- Building Materialized Views
332

 
- Miscellaneous
334

 
- Exercise Eight
335

Sections of Essential Oracle 19c SQL

One
Introduction to SQL

Two
Database Objects

Three
The SQL Plus Interface

Four
SQL Scripts

Five
Simple Queries

Six
Limiting Data Selected with a Where Clause

Seven
Oracle Datatypes

Eight
Aggregating Values

Nine
Tree Walking Tables in SQL

Ten
Joining Tables in an SQL Statement

Eleven
Advanced SQL Query Techniques

Twelve
Creating Database Objects in SQL

Thirteen
Altering and Populating Oracle Tables

Fourteen
Committing Records

Fifteen
Materialized Views

Synopsis for Oracle 19c Essential SQL training course

There are a number of ways to learn SQL, one is over a series of one hour lectures spread over a year in College, this way by the time you get to use it in the real world you will have forgotten what was said on that miserable Friday morning in February when you hadn’t got hot water in the student accommodation and you are not concentrating because your teeth are chattering.

Sometimes SQL courses are tiring in University ...



Another way is on line when you have five minutes in the evening between switching on the kettle and waiting for the microwave to ping because you haven’t the time in the day to learn the language but it's needed for your work.

How about picking up some SQL written by your colleagues, only trouble is they may not have written it themselves and have only amended the code to suit the new requirement or legislation and to be honest, Dave in Accounts is the only one who know exactly how it works but he's left on long term sick because of stress …

Trying to learn SQL without a training course ?



Perhaps the most effective and stress free way to learn SQL and PLSQL is to use Seer Computing, we can provide you or your team over 140+ courses, they range from Oracle SQL to Java Programming, all are available onsite at your venue and some of the most popular (including this one) are performed up and down the UK and Ireland throughout the year at a variety of conference centres.

We supply all the machines necessary for the courses, no need to bring your laptops unless you want to check your mail, no need to bring paper, our manuals are very comprehensive plus they can be written on because they are yours to take away … oh and we have some really nice pens which we supply too … we also supply an Oracle Consultant who is there 100% of the time for you, focussing you on the course, encouraging you to understand and get to grips with the language, to present the course in an interesting and entertaining way and most importantly support you when you are working through the course work.

Some other course providers use different methods to train you ...



Read our reviews of our courses, all of our courses have been written in house by the people who present the courses and importantly use the languages in their every-day work. If you have specific requirements we can tailor these courses to suit you, they are our own work, we own the copyright so we can change them according to your request, we can even give them over weekends if that fits in with your work needs.

This Oracle SQL course is two days duration, it uses the Oracle 19c database which was released in April 2019, the thing is the Database for Users hasn’t changed much since Oracle 12c was released, this means if you have had training in one of the earlier versions you probably won't need it again, speak to one of our training advisers if you want to clarify the position, it maybe that you could benefit from an SQL Developer course, we give those too so you might give that some thought or speak to us about it.

When we present public courses we use central to the area based conference centres, lunch is provided and there is parking and nearby transport systems, when we come to you at your venue all we need is a room with enough tables and chairs for the Delegates to be able to work comfortably in, this means with our individual laptops in front of them, the A4 manuals we bring opened out for them to do the training and most importantly somewhere for them to put their coffees, teas and Mars bars … We break regularly during the course so it gives them plenty of time to return to their desks to read emails, have loo breaks and even have a vape if they need them.

We fit with your timings so Delegates can't make it in until after 9.30am then we will start at that point, if needed our Consultant will suspend the training until staff meetings are complete … we are that flexible

Contact one of our training advisers, we will advise and quote for any training course you require, we'll fit in with your schedule and we'll even give you really good training !!

Request for detailsClick for the contact form for the Oracle Essential SQL 19c 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