Oracle Database 11g: SQL Fundamentals II

This course is designed for application developers with basic SQL language skills. In this course, students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn to create and query external tables and use the advanced features of SQL to query and manipulate data within the database.

Students learn to use the dictionary views to retrieve metadata and create reports about their schema objects. Students learn some of the date time functions available in the Oracle 11g Database and use the regular expression support in SQL.

In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

Doelgroep

• Database Beheerder
• Applicatie Ontwikkelaar met PL/SQL

Voorkennis

• ORSQL1102: Oracle Database 11g: SQL Fundamentals I
• Basic Knowledge of SQL
• Familiarity with Oracle SQL Developer and SQL*Plus

Inhoud

• Introduction
• Controlling User Access
• Managing Schema Objects
• Managing Objects with Data Dictionary Views
• Manipulating Large Data Sets
• Managing Data in Different Time Zones
• Retrieving Data Using Subqueries
• Regular Expression Support

• Gratis brochure aanvragen
• Contact opnemen