Index of Oracle SQL 18c with PHP training course
Oracle 18c
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 18c (Top-N)
124
- Using Percent with Fetch in Oracle 18c
125
- Using Offset with Fetch in Oracle 18c
126
- Using With Ties with Fetch in Oracle 18c
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 18c
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 18c
323
- Using Identity in Oracle 18c
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