At the end of this course, you will get the knowledge of... How to write SQL queries to access data stored in an Oracle Database schema. Learn to manipulate data and use various types of functions for customizing data output. You will learn Oracle SQL 11g advance concepts like General functions,Views,Database Objects,Controlling User Access, Set Operators, Adv Date Time Functions,Group By Clause, Sub-queries, Hierarchical Retrieval,Oracle Extensions to DML and DDL Statements.

Topics Covered

General Functions DURATION – 45 Minutes Views DURATION – 60 Minutes Other Database Objects DURATION – 60 Minutes Controlling User Access DURATION – 60 Minutes Set Operators DURATION – 15 Minutes Advanced Date Time Functions DURATION – 30 Minutes Enhancements to Group BY Clause DURATION – 30 Minutes Advanced Subqueries DURATION – 30 Minutes Hierarchical Retrieval DURATION – 15 Minutes Oracle 9i Extensions to DML and DDL Statements DURATION – 30 Minutes

Who should attend

Beginners. Fresh Graduates.

Pre-requisites

Windows PC, Good Internet Connectivity and Basic database knowledge

Key Takeaways

Highly interactive self paced course contents supplemented with demonstrations Designed and developed by Oracle PL/SQL Developer Certified Expert