2_1b oracle 11g sql fundamentals ii

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. Audience Database Administrators Database Designers Support Engineer Technical Administrator Prerequisites Suggested Prerequisites Ability to use a graphical user interface (GUI) Familiarity with data processing concepts and techniques Course Objectives Identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for u Recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace Recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns an Recognize the steps for querying data dictionary views to view schema objects, and for performing operations on large am Course Topics Oracle Database 11g: Controlling User Access and Managing Schema Objects Controlling User Access Managing Schema Objects Oracle Database 11g: Data Dictionary Views and Large Data Sets Managing Objects with Data Dictionary Views Manipulating Large Data Sets Oracle Database 11g: Managing Data in Different Time Zones Using Time Zones and Datetime Functions Oracle Database 11g: Using Subqueries and Regular Expressions Retrieving Data Using Subqueries Using Regular Expressions Copyright © 2012, Oracle. All rights reserved. Page 1

Upload: rian-mags

Post on 13-Apr-2016

227 views

Category:

Documents

0 download

Report

Download

Embed Size (px):

DESCRIPTION

Syllabus

TRANSCRIPT

Page 1: 2_1b Oracle 11g SQL Fundamentals II

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

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=3

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=225

Oracle Database 11g: SQL Oracle Internal & Oracle ... Database 11g: SQL Fundamentals I Volume II • Student Guide D49996GC11 Edition 1.1 April 2009 D59981 Oracle Internal & Oracle

Oracle Database 11g PL/SQL - dbmanagement.infodbmanagement.info/Books/MIX/D52601GC20_sg2_PLSQL.pdfOracle Database 11g: Advanced PL/SQL ... Oracle 11g SQL and PL/SQL Documentation 1-16

SQL Fundamentals Certification€¦ · · 2016-02-012016-02-01 · @ Ashik’s Edition Page 2 SQL Fundamentals Certification 1Z0-051 (Oracle Certified Oracle Database 11g Administrator)

Oracle Database 11g: SQL Fundamentals Idbmanagement.info/Books/MIX/Oracle_Database_11g_SQL_Fundame… · Oracle Database 11g: SQL Fundamentals I Index - 2 A Alias 1-17 ALL Operator

48742447 11g-sql-fundamentals-ii-additional-practices-and-solutions