2_1b oracle 11g sql fundamentals ii
Post on 13-Apr-2016
227 Views
Preview:
DESCRIPTION
TRANSCRIPT
Oracle University | Contact Us: +632 9768896, +632 9768600 Ð
Oracle Database 11g: SQL Fundamentals II Self-Study Course
Duration: 0 Days
What you will learn
The advanced features of SQL allow database users to query and manipulate relational database data. This course is
designed to teach you about advanced SQL features, querying techniques, and reporting. This course demonstrates
how to control privileges at the object and system level, use group operations to create reports, and manage schema
objects. Searching data using advanced subqueries, retrieving hierarchical data, manipulating data with subqueries, and
regular expression support are also covered here.
AudienceDatabase AdministratorsDatabase DesignersSupport EngineerTechnical Administrator
Prerequisites
Suggested PrerequisitesAbility to use a graphical user interface (GUI)Familiarity with data processing concepts and techniques
Course ObjectivesIdentify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using date-time functionsRecognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace stringsRecognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexesRecognize the steps for querying data dictionary views to view schema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables
Course Topics
Oracle Database 11g: Controlling User Access and Managing Schema ObjectsControlling User AccessManaging Schema Objects
Oracle Database 11g: Data Dictionary Views and Large Data SetsManaging Objects with Data Dictionary ViewsManipulating Large Data Sets
Oracle Database 11g: Managing Data in Different Time ZonesUsing Time Zones and Datetime Functions
Oracle Database 11g: Using Subqueries and Regular ExpressionsRetrieving Data Using SubqueriesUsing Regular Expressions
Copyright © 2012, Oracle. All rights reserved. Page 1
top related