Top
Email
Bottom
Oracle 12c SQL with PHP
 
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 12c SQL with PHP course at a glance

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

Oracle SQL 12c using PHP course
Exercise highlights

Connecting to an Oracle Database
Selecting and displaying records from an Oracle database
Inserting data into the Database via PHP
Outputting Dates

Index of Oracle SQL 12c with PHP training course

Oracle 12c
 
 

Section
Section Name
Page

One
Introduction to Oracle
2
 
- What is SQL used for ?
3
 
- Why use Oracle with PHP ?
4
 
- Definition of a Database
5
 
- Using Oracle with PHP
6
Two
Oracle Database Objects
7
 
- Introduction
8
 
- Tables
9
 
- Views
10
 
- Materialized Views
11
 
- Indexes
12
 
- Sequences
13
 
- Packages, Functions and Procedures
14
 
- Schemas
15
Three
Connecting to Oracle via PHP
16
 
- Introduction
17
 
- Using oci_connect
18
Four
Querying from Oracle
19
 
- Introduction
20
 
- oci_parse and oci_execute
22
 
- oci_fetch_row
25
 
- oci_num_rows and oci_num_fields
26
 
- Detecting Oracle errors
30
 
- oci_error
34
 
- Detecting a Parse error
36
 
- Detecting an Execution error
38
 
- Oracle Metadata
40
 
- User_tables
43
 
- What columns are in a table
45
 
- Using OCI_DESCRIBE_ONLY
46
 
- User_tab_columns
51
 
- Exercise One
57
Five
Simple Oracle Queries
61
 
- Introduction
62
 
- Selecting more than one column
64
 
- Counting Records in an Oracle Table
65
 
- Displaying Literals in a Select statement
67
 
- Using Associative Arrays with oci_fetch
71
 
- Column Aliases
74
 
- Column Manipulation with SQL Functions
77
 
- Concatenating Columns in SQL
83
 
- Performing Calculations in SQL
84
 
- Ordering Data in SQL
85
 
- Ordering more than one Column
87
 
- Ordering with nulls first / nulls last
88
 
- Manipulating Dates in SQL
89
 
- Displaying Dates in SQL
90
 
- Using user_tab_columns with functions
91
 
- Exercise Two
93
Six
Limiting Data Selected with a Where Clause
101
 
- Limiting Data in SQL
102
 
- Structure of an SQL Where Clause
103
 
- Different types of SQL Where Clauses
104
 
- Handling Nulls in Where Clauses
112
 
- Case Restrictions in SQL Where Clauses
113
 
- Using Functions in Where Clauses
114
 
- Using PHP Variables in Where clauses
117
 
- Using PHP oci_bind_by_name in Where clauses
118
 
- Rownum in SQL Tables
120
 
- Using Rowid in SQL Tables
122
 
- Fetch first rows of a Table in Oracle 12c (Top-N)
124
 
- Using Percent with Fetch in Oracle 12c
125
 
- Using Offset with Fetch in Oracle 12c
126
 
- Using With Ties with Fetch in Oracle 12c
127
 
- Exercise Three
128
Seven
Oracle Datatypes
134
 
- Introduction
135
 
- Varchar2
136
 
- ORA-00910: specified length too long for its datatype
138
 
- Varchar2 and Char
139
 
- Number
140
 
- Date
141
 
- Float
142
 
- Long
143
 
- Large Objects
144
 
- Bfile
148
Eight
Aggregating Values
149
 
- Introduction
150
 
- Using Group By
151
 
- Using Having with Group By
154
 
- Using With Rollup to Total Grouping
156
Nine
Tree Walking Tables in SQL
157
 
- Introduction
158
 
- Syntax for Tree Walking in SQL
160
 
- Example of Tree Walking in SQL
162
 
- Advanced Ordering of Siblings in Tree Walks
163
 
- Sys_Connect_By_Path
165
 
- Exercise Four
167
Ten
Joining Tables in an SQL Statement
171
 
- Using Table Aliases in SQL
172
 
- Linking Tables in an SQL Statement
174
 
- Problems with Joining Tables in SQL
179
 
- Methods of Joining Tables in SQL
181
 
- Using Ansi SQL/86 to join Tables
182
 
- Ansi SQL/86 and Outer Joins
183
 
- Ansi SQL/99 Standards (Natural Joins)
186
 
- Ansi SQL/99 Standards (Cross Joins)
187
 
- Ansi SQL/99 Standards (Joins/Using)
188
 
- Ansi SQL/99 Standards (On)
189
 
- Ansi SQL/99 Standards (Multiple On)
190
 
- Ansi SQL/99 Standards (Left Outer Joins)
191
 
- Ansi SQL/99 Standards (Right Outer Joins)
192
 
- Ansi SQL/99 Standards (Full Outer Joins)
193
 
- Merging Tables in SQL
194
 
- Using Union to Merge Tables
195
 
- Using Union All to Merge Tables
196
 
- Using Intersect to Merge Tables
197
 
- Using Minus to Merge Tables
198
 
- Knowledge Check
199
 
- Using the Merge Syntax
204
 
- Exercise Five
206
Eleven
Advanced Queries
210
 
- Introduction
211
 
- Pivot
212
 
- Changing the Pivot Headings of X Axis
218
 
- Unpivot
224
 
- Unpivot and Null values
228
 
- First/Last_Value functions
229
 
- Lead and Lag Functions
234
 
- Window Specification
237
 
- Breakdown of Window Specification
238
 
- Window Specification – The Arguments
240
 
- Window Specification – The Order By
243
 
- Window Specification – The Windowing
245
 
- Window Specification – Rows between
246
 
- Window Specification – current row
247
 
- Window Specification – unbounded preceding
250
 
- Window Specification – bounded preceding
251
 
- Window Specification – between
253
 
- Window Specification – current row
247
 
- Difference between Range and Rows
255
 
- Ranking functions
256
 
- Using Ntile Function in SQL
265
 
- Using Listagg function
267
 
- Using Case in Select statements
271
 
- Using Searched Case Function
276
 
- Using Searched Case Function with Sub-queries
278
 
- Using Sample in SQL
279
 
- Using Width_Bucket
281
 
- Exercise Six
284
Twelve
Creating Database Objects
288
 
- Creating Tables
289
 
- Mandatory Columns in SQL Tables
291
 
- Creation Syntax for Tables
292
 
- Virtual Columns
294
 
- Creating Virtual Columns with new Table
295
 
- Specifying Virtual Column Datatype and Size
296
 
- Adding Virtual Columns to Existing Table
297
 
- Using Virtual Columns
298
 
- Using Virtual Columns with Functions
300
 
- Limitations of Virtual Columns (ORA-54012)
301
 
- Limitations of Virtual Columns (ORA-54013)
303
 
- Viewing Virtual Columns in user_tab_columns
304
 
- Invisible Columns in Oracle 12c
305
 
- Commenting on Tables in SQL
308
 
- Commenting on Columns in SQL
309
 
- Creating Indexes in SQL
310
 
- Index Creation
313
 
- Disabling Indexes
315
 
- Creating Views
316
 
- Creating Sequences
318
 
- Using Sequences
319
 
- Altering Sequences
321
 
- Using Default Value in SQL Tables
322
 
- Using Default Value in Oracle 12c
323
 
- Using Identity in Oracle 12c
324
 
- Renaming Objects in an Oracle Database
325
 
- Dropping Objects from an Oracle Database
328
 
- Granting Access to other Schemas
329
 
- Accessing other Schemas
332
 
- Creating Synonyms
333
 
- Exercise Seven
334
Thirteen
Altering and Populating Oracle Tables
340
 
- Some Rules when altering Tables
341
 
- Syntax for Altering Tables
342
 
- Rules when populating Tables in SQL
343
 
- Syntax for populating Tables
344
 
- Using Variables to Populate Tables
349
 
- General Comments
350
 
- Updating Data
351
 
- Deleting Data
353
 
- Handling Large Objects in SQL Plus
354
 
- Handling Bfiles in SQL Plus
356
Fourteen
Committing Records
357
 
- The difference between DDL and DML
358
 
- Committing and Rollback in PHP
361
 
- Loading XML file naming Columns
292
 
- Loading XML file using Set
293
Fifteen
Materialized Views
362
 
- Introduction
363
 
- Syntax for Creating Materialized Views
365
 
- Refreshing Materialized Views
367
 
- Building Materialized Views
373
 
- Miscellaneous
375
Sixteen
Miscellaneous
376
 
- Introduction
377
 
- Changing Passwords with oci_password_change
378
 
- Oracle Database Version (oci_server_version)
379
 
- Setting timeout with oci_set_call_timeout
380
 
- Exercise Eight
381

Sections of Oracle 12c

Oracle 12c

1
Introduction to Oracle
2
Oracle Database Objects
3
Connecting to Oracle via PHP
4
Querying from Oracle
5
Simple Oracle Queries
6
Limiting Data Selected with a Where Clause
7
Oracle Datatypes
8
Aggregating Values
9
Tree Walking Tables in SQL
10
Joining Tables in an SQL Statement
11
Advanced Queries
12
Creating Database Objects
13
Altering and Populating Oracle Tables
14
Committing Records
15
Materialized Views
16
Miscellaneous


Synopsis for Oracle SQL 12c using PHP training course

Sometimes a client asks how long a course lasts per day and our honest answer is that each course is measured to last for six and a half hours per, therefore each day a 9am start with an hours break for lunch finishes at around 4.30pm. We say around 4.30pm because we don’t have an agenda to finish dead on time, we do start at exactly 9am providing all the Delegates are in attendance but we have been performing training and consultancy for over 20 years so we know not everything runs as smoothly as the Swiss Federal Railways; For a start, Delegates have family commitments, dropping off kids to school, maybe car sharing issues or maybe there is an office meeting called for that morning at 8.30am and its running over. Basically we flex our times according to the needs of the Client, some want to start earlier than 9am, others need a later start, whatever the requirement we fit in with your needs.

This Oracle SQL 12c using PHP course is available on-site at your venue, that means we come to you, we bring all equipment needed for the course, that includes the Database, individual machines for each Delegate and of course the very comprehensive course manuals (which the Delegates get to keep). We don’t require anything from you other than a suitable room to perform the training, we are totally self-sufficient other than needing to plug into the electric, and we don’t plug into your Wi-Fi, network or Database, no worries about viruses or anything like that. All times we guarantee our professionalism from punctuality, knowledge and experience, to friendly and approachable Consultants.

This course is aimed at seasoned PHP Developers who need to interface their website with an Oracle Database, it concentrates on using PHP to extract from Oracle Database objects such as Tables and Views and to create the same on the second day. Delegates will learn how to insert and update data via PHP and also routine maintenance of the Database schema.

This page contains the index of the two day course, a brief pen picture of the course flow and various links to more contemporary versions of the course, Oracle 12c was replaced by 18c in 2018 and that again was replaced by 19c in 2019, when you speak to our training guide, they will advise you of the best course for your people.

All 140+ courses that we provide will be quoted for with a 6 month no change guarantee, we won't alter the original quotation and guarantee the price, also there are no hidden extras, and all costs are in the quotation, no expenses to add on and certainly no materials to be added at a later date. The only time we change the quotation is when you ask for a different configuration, such as adding more Delegates etc., although we always provide a matrix to cover additional people anyway.

Payment cannot be simpler, we accept BACS, cheques and credit cards (with a 4% surcharge), and with on-site training we cut down on your travel and subsistence for your staff, it’s a win win

Request for detailsClick for the contact form for the Oracle 12c SQL with PHP training course
Public Courses
Oracle Essential SQL 19c
Days
2
Pages
340
Exercises
8
Sections
15
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 19c
Days
3
Pages
384
Exercises
13
Sections
25
Public
Yes
On-Site
Yes
Public Courses
Using SQL with Oracle SQL Developer 19.2
Days
4
Pages
884
Exercises
18
Sections
37
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 7.4 and Oracle 19c
Days
5
Pages
917
Exercises
21
Sections
38
Public
Yes
On-Site
Yes
Public Courses
Java 14 Programming with Eclipse 2020-03
Days
5
Pages
788
Exercises
23
Sections
44
Public
Yes
On-Site
Yes
Public Courses
Java 14 Swing with Eclipse 2020-03
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