Course Description:-

INTRODUCTION:

In this course on Datetime functions, Advances DML Operations and Hierarchical Queries, you will learn about Oracle9i Datetime Functions, Enhancements and group By Clause, Advanced Sub queries, Hierarchical Retrieval, Oracle9i Extensions to DML and DDL Statements etc.

In this course you will be learning in detail about the following topics:

Oracle9i Datetime Functions

• Objectives
• TIME ZONES
• Oracle9i Datetime Support
• TZ_OFFSET
• CURRENT_DATE
• CURRENT_TIMESTAMP
• LOCALTIMESTAMP
• DBTIMEZONE and SESSIONTIMEZONE
• EXTRACT
• TIMESTAMP Conversion Using FROM_TZ
• STRING To TIMESTAMP Conversion Using TO_TIMESTAMP and TO_TIMESTAMP_TZ
• Time Interval Conversion with TO_YMINTERVAL
• Summary
• Practical Examples
• Additional Examples

Enhancements to the GROUP BY Clause

• Objectives
• Review of Group Functions
• Review of the HAVING Clause
• GROUP BY with ROLLUP and CUBE Operators
• ROLLUP Operator
• ROLLUP Operator Example
• CUBE Operator
• GROUPING Function
• GROUPING SETS
• Composite Columns
• Concatenated Groupings

What are the requirements?

• Knowledge of SQL
• Passion to learn

What am I going to get from this course?

• Hours of content!

What is the target audience?

• Engineering and Management students can take this course
• Anyone who wants to learn about SQL 

Benefits of online course:

• High Quality Content
• Learn Anywhere Anytime & at Your Pace
• 24X7 Customer Support
• Complete Student Support Throughout The Program
• Course Completion Certificate 
• Lifetime course access

CURRICULUM

Section 1: Oracle9i Datetime Functions

1. Tz_ offset, Current_ date, Current_ timestamp, Local time stamp
2. Extract and Other timestamp data types
3. Extract and Other timestamp data types summary
4. Oracle9i Datetime Functions-Practical Examples 01
5. Oracle9i Datetime Functions-Practical Examples 02
6. Oracle9i Datetime Functions-Additional Practice

Section 2: Enhancements to the GROUP BY Clause

1. Group, Having, Group by, Rollup and Cube
2. Grouping Functions, Grouping Set
3. Grouping Functions, Grouping Set, Composite columns and Concatenated grouping summary
4. Enhancements to the GROUP BY Clause 01
5. Enhancements to the GROUP BY Clause 02
6. Enhancements to the GROUP BY Clause-Additional Examples Manipulating Data-Additional Examples 02

Section 3: Advanced Sub queries

1. Multiple-Column Subqueries
2. Column Comparisons
3. Correlated Subqueries
4. Correlated UPDATE
5. summary
6. Advanced Subqueries-Practical Examples 01
7. Advanced Subqueries-Practical Examples 02
8. Advanced Subqueries-Additional Example 01
9. Advanced Subqueries-Additional Example 02

Section 4: Hierarchical Retrieval

1. Hierarchical Queries
2. Walking the Tree From the Bottom Up
3. Hierarchical Queries_summary
4. Hierarchical Retrieval-Practical Examples
5. Hierarchical Retrieval-Additional Examples

Section 5: Oracle9i Extensions to DML and DDL Statements

1. Review of the UPDATE Statement
2. Ranking Rows With the Level
3. Pivoting Insert, External Tables
4. Creating an External Table
5. create table summary

For any query feel free to call

Mob - +918587999769