In this course on Datetime functions, Advances DML Operations and Hirarchical Queries, you will learn about Oracle9i Datetime Functions, Enhancements and group By Clause, Advanced Subqueries, 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
Oracle9i Datetime Support
DBTIMEZONE and SESSIONTIMEZONE
TIMESTAMP Conversion Using FROM_TZ
STRING To TIMESTAMP Conversion Using TO_TIMESTAMP and TO_TIMESTAMP_TZ
Time Interval Conversion with TO_YMINTERVAL
• Enhancements to the GROUP BY Clause
Review of Group Functions
Review of the HAVING Clause
GROUP BY with ROLLUP and CUBE Operators
ROLLUP Operator Example
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