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