Top
Email
Bottom
Oracle Essential SQL 12c
 
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

Oracle Essential SQL 12c course at a glance

Pages
338No 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
338
None
Oracle Essential PLSQL 12c
Contact us for the latest pricing

Oracle 12c Essential SQL training course
Exercise highlights
(Plenty of time to practice what you have learnt)

Selecting from Oracle Tables
Using Ansi/99 joins between tables
Limiting records with where clauses and fetch
Creating Oracle Database Tables, Views, Sequences etc

Index of Oracle 12c 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
19

 
- ORA-12560: TNS:protocol adapter error
20

 
- ORA-12545: Connect failed
21

 
- Exiting an SQL Plus Session
22

 
- Using the DOS Window
23

 
- Copying and Pasting
24

 
- Using the Function Keys
27

 
- Using the Line Editor in SQL Plus
28

 
- Using the Editor in SQL Plus
29

 
- SQL Plus Environment Settings
30

 
- File Manipulation in SQL Plus
31

 
- Spooling Results in SQL Plus
32

 
- Changing Passwords / Clearing the Screen
33

Four
SQL Scripts
34

 
- Commenting SQL Scripts
38

 
- Running SQL in Batch Scripts
40

 
- Passing Parameters with SQL Scripts
42

Five
Simple Queries
44

 
- Introduction
45

 
- Oracle Metadata
46

 
- SQL Syntax
51

 
- Counting Records in an Oracle Table
54

 
- Displaying Literals in a Select statement
56

 
- Displaying Variables in a Select statement
59

 
- Exercise One
60

 
- Column Aliases
64

 
- Column Manipulation with SQL Functions
67

 
- Concatenating Columns in SQL
73

 
- Performing Calculations in SQL
74

 
- Ordering Data in SQL
75

 
- Ordering More than One Column
77

 
- Manipulating Dates in SQL
78

 
- Displaying Dates in SQL
79

 
- Exercise Two
80

Six
Limiting Data Selected with a Where Clause
85

 
- Limiting Data in SQL
86

 
- Structure of an SQL Where Clause
87

 
- Different types of SQL Where Clauses
88

 
- Handling Nulls in Where Clauses
96

 
- Case Restrictions in SQL Where Clauses
97

 
- Using Functions in Where Clauses
98

 
- Rownum in SQL Tables
101

 
- Using Rowid in SQL Tables
103

 
- Fetch first rows of a Table in Oracle 12c (Top-N)
105

 
- Using Percent with Fetch in Oracle 12c
106

 
- Using Offset with Fetch in Oracle 12c
107

 
- Using With Ties with Fetch in Oracle 12c
108

 
- Exercise Three
109

Seven
Oracle Datatypes
114

 
- Introduction
115

 
- Varchar2
116

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

 
- Varchar2 and Char
119

 
- Number
120

 
- Date
121

 
- Float
122

 
- Long
123

 
- Large Objects
124

 
- Bfile
128

Eight
Aggregating Values
129

 
- Introduction
130

 
- Using Group By
131

 
- Using Having with Group By
134

 
- Using Rollup to Total Grouping
136

Nine
Tree Walking Tables in SQL
137

 
- Introduction
138

 
- Syntax for Tree Walking in SQL
140

 
- Example of Tree Walking in SQL
141

 
- Advanced Ordering of Siblings in Tree Walks
142

 
- Sys_Connect_By_Path
144

 
- Exercise Four
146

Ten
Joining Tables in an SQL Statement
149

 
- Using Table Aliases in SQL
150

 
- Linking Tables in an SQL statement
152

 
- Problems with Joining Tables in SQL
157

 
- Methods of Joining Tables in SQL
159

 
- Using Ansi SQL/86 to Join Tables
160

 
- Ansi SQL/86 and Outer Joins
161

 
- Ansi SQL/99 Standards (Natural Joins)
164

 
- Ansi SQL/99 Standards (Cross Joins)
165

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

 
- Ansi SQL/99 Standards (On)
167

 
- Ansi SQL/99 Standards (Multiple On)
168

 
- Ansi SQL/99 Standards (Left Outer Join)
169

 
- Ansi SQL/99 Standards (Right Outer Join)
170

 
- Ansi SQL/99 Standards (Full Outer Join)
171

 
- Merging Tables in SQL
172

 
- Using Union to Merge Tables in SQL
173

 
- Using Union All to Merge Tables in SQL
174

 
- Using Intersect to Merge Tables in SQL
175

 
- Using Minus to Merge Tables in SQL
176

 
- Knowledge Check
177

 
- Using the Merge Syntax in SQL
182

 
- Exercise Five
183

Eleven
Advanced SQL Query Techniques
187

 
- Introduction
188

 
- Pivot
189

 
- Adding a Total to a Pivot
194

 
- Changing the Pivot Headings of X Axis
195

 
- Rotating the Axis of the Pivot
197

 
- Unpivot
198

 
- Unpivot and Null values
201

 
- Using First_Value/Last_Value in SQL
202

 
- Ignoring Nulls with First/Last_Value
204

 
- Window Specification
205

 
- Breakdown of Window Specification
206

 
- Window Specification – The Arguments
208

 
- Window Specification – Query Partition
209

 
- Window Specification – The Order By
211

 
- Window Specification – The Windowing
213

 
- Window Specification – Rows between
215

 
- Window Specification – Shortcuts
219

 
- Difference between Range and Rows
220

 
- Using Lead and Lag in SQL
223

 
- Using Rank Function in SQL
227

 
- Using Ntile Function in SQL
234

 
- Using Width_Bucket Function in SQL
236

 
- Using Listagg Function in SQL
239

 
- Using Case Function in SQL
241

 
- Exercise Six
245

Twelve
Creating Database Objects in SQL
249

 
- Creating Tables in SQL
250

 
- Mandatory Columns in SQL Tables
252

 
- Creating Syntax for Tables in SQL
253

 
- Virtual Columns
255

 
- Creating Virtual Columns with new Table
256

 
- Specifying Virtual Column Datatype and Size
257

 
- Adding Virtual Columns to Existing Table
258

 
- Using Virtual Columns in SQL …
259

 
- Using Virtual Columns with Functions
261

 
- Limitations of Virtual Columns (ORA-54012)
262

 
- Limitations of Virtual Columns (ORA-54015)
263

 
- Limitations of Virtual Columns (ORA-54013)
264

 
- Viewing Virtual Columns in USER_TAB_COLS
265

 
- Invisible Columns in Oracle 12c
266

 
- Commenting on Tables in SQL
269

 
- Commenting on Columns in SQL
270

 
- Creating Indexes in SQL
271

 
- Disabling Indexes in SQL
276

 
- Creating Views in SQL
277

 
- Creating Sequences in SQL
279

 
- Using Sequences in SQL
280

 
- Altering Sequences in SQL
282

 
- Using Default Value in SQL Tables
283

 
- Using Default Value in Oracle 12c
284

 
- Using Identity in Oracle 12c
285

 
- Renaming Objects in an Oracle Database
286

 
- Dropping Objects from an Oracle Database
289

 
- Granting Access in other Schemas
290

 
- Accessing other Schemas
293

 
- Creating Synonyms in Oracle
294

 
- Exercise Seven
295

Thirteen
Altering and Populating Oracle Tables
297

 
- Some Rules when Altering Tables
298

 
- Syntax for Altering Tables
299

 
- Rules When Populating Tables in SQL
300

 
- Syntax for Populating Tables
301

 
- Using Variables to Populate Tables
306

 
- General Comments
307

 
- Updating Data in Oracle Tables
308

 
- Deleting Data from Oracle Tables
310

 
- Handling Large Objects in SQL Plus
311

 
- Handling BFiles in SQL Plus
313

Fourteen
Committing Records
314

 
- The Difference Between DDL and DML
315

 
- Using Autocommit in SQL Plus
318

Fifteen
Materialized Views
319

 
- Introduction
320

 
- Syntax for Creating Materialized Views
322

 
- Refreshing Materialized Views
324

 
- Building Materialized Views
330

 
- Miscellaneous
332

 
- Exercise Eight
333

 
 
 

Sections of Essential Oracle 12c 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 12c Essential SQL training course

Do you sometimes wonder … what came first SQL or the Database? We have sleepless nights wondering about that … anyway the bottom line is, if you have a Database you need to know SQL, it’s the main communication language between you and the Database.

Who are you? Are you a User just interested in getting out information as fast as possible? Are you a Developer needing to create front ends to make access to the Database easier? Or are you a Database Administrator needing to keep the Database wheels oiled and running smoothly?

This two day Oracle SQL 12c course is ideal for anyone needing to learn SQL, we start right at the beginning, the simple ABC of SQL, learning how to construct simple queries to return data, before we do that, we look at how to view the tables in the Database are organised, we'll worry about indexing strategy later in the course. Once we have simple queries under our belt we move onto applying functions to the columns returned following this we look at limiting the data returned using the 'where' clause, at the same time we talk about the SQL syntax style, making sure Delegates develop a 'readable' style of writing so that their SQL is portable, easy to read and maintain, yes we want to produce the best SQL practitioners we can.

If you need a course at a public venue take a look at our Oracle SQL 18c course, we give that course from Belfast to Edinburgh, London to Manchester, these are held throughout the year, check out the individual webpages for the location to view the dates, we perform ten different courses publically throughout the year, this represents only 10% of all of our courses, they are all on the website, use the menu system to navigate to the training course you are interested in.

This Essential Oracle SQL 12c course is still available as an onsite course at your venue, what this means is that we come to you, we bring all the equipment we need to give you the best SQL course available, you just need a room which have sufficient chairs and tables for the delegates to work comfortably in, that means, good elbow room, plenty of space to have our comprehensive manual open and of course because they will all have individual workstations enough room to move their mouse around. When we come to you, you can choose the start date, it could even be a weekend course, we are very flexible because we know in this day and age although training is vital it is very difficult to fit it in with other schedules, that why we give you the best and most flexible training available.

Look at our other training course, we've been around for twenty years, we offer not only excellent training courses but consultancy as well, heck we even have an Oracle SQL Functions App which is chock full of useful code and information for SQL Users and Developers alike.

Get in touch, our contact details are plastered at the header and footer of this and every webpage, there's even a training enquiry form on this page which will ask the right questions, contact our Training Advisors, they will be courteous, helpful and unlike some Companies, polite and non-pushy.

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