Top
Email
Bottom
Oracle 19c 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 19c 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 19c 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 19c with PHP training course

Oracle 19c
 
 

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 19c (Top-N)
124
 
- Using Percent with Fetch in Oracle 19c
125
 
- Using Offset with Fetch in Oracle 19c
126
 
- Using With Ties with Fetch in Oracle 19c
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 19c
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 19c
323
 
- Using Identity in Oracle 19c
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 19c

Oracle 19c

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 19c with PHP training course

This course has been designed for Developers who need to use PHP to query, interrogate, work with the Oracle 19c Database. All examples and exercises use PHP with Oracle so it is expected that the Developer will have already attended one of our other PHP courses such as PHP 7.4 and MySQL 8 course or have the relevant experience already in the language. As an alternative we have combined PHP with Oracle in the PHP 7.4 and Oracle 19c course which is available as a five day event.

If you look through our menu system you will notice that we have a number of Oracle training courses, if you need advice drop us an email and we can give you a no nonsense, no obligation guide to the course or courses which would best suit your Delegates. This course for example is available without the PHP part using SQL*Plus, there is also a five day SQL course as well as courses following that such as PLSQL, we really are a one stop shop for Oracle training and consultancy in the UK and Ireland.

We have over 150 courses available on-site with a select number also available as scheduled public course around the UK and Ireland, but the on-site courses are what we specialise in. We come to you, we turn up at the agreed time, set up using our equipment, give the best training to your Delegates then offer follow up consultancy if you need further advice and guidance, we've been doing it for twenty years so we know what we are doing.

On-site courses just needs a suitable room, we provide all the equipment, all you supply is the electricity and the Delegates. If you don’t have a suitable room we can arrange a course close to your location at a Conference centre, just book with us and we take care of the rest.

All of our courses are written in house and the Consultant who comes to you will have been involved in the authoring of the course and running through our comprehensive testing before it is released live.

Each course has a number of exercises dotted around the duration so that the Delegates can practice what we have already documented and demonstrated and with our Consultant on hand they get all the support they need to complete the exercises and gain a great understanding of the topic. The Consultant can cope with Delegates with a variety of skill sets, if someone is shooting ahead of others they will be given more exercise to do to keep them busy while the others are completing the exercises, also the Consultant will stay late to assist any who need just that little more time to finish.

All of our course web-pages have the index of contents for you to review; this can be downloaded in pdf form or searched on-line. There are over 150 courses to choose from, a select number are available across the UK and Ireland throughout the year, check out the location nearest to you.

All of our courses are available on-site at your venue and of course at our offices in Swansea, a delightful place to spend a week learning new skills.

Request for detailsClick for the contact form for the Oracle 19c SQL with PHP training course
Public Courses
Oracle Essential SQL 21c
Days
2
Pages
340
Exercises
8
Sections
15
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 21c
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 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