Introduction to Oracle 11g R2 SQL Programming

Oracle SQL Training Overview

Accelebrate's Introduction to Oracle 11g R2 SQL Programming training teaches students how to create, retrieve, and manipulate objects in Oracle 11g R2 Structured Query Language (SQL). Students will also be introduced to Oracle^® 11g R2 database features and tools.

Location and Pricing

Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.

Oracle SQL Training Objectives

• Use SQL Developer and other available SQL interfaces.
• Write simple SQL queries and format & sort the data as needed.
• Write moderately complex SQL queries using various join techniques.
• Supplement SQL code with references to pseudo columns and system functions.
• Summarize, group, and combine data to obtain more meaningful query results.
• Draw conclusions and make business decisions based upon the data processed.
• Learn advanced query techniques such as set operations, sub-queries, and summary functions.
• Create and maintain database tables using the SQL Data Definition Language (DDL).
• Manage data within tables using the SQL Data Manipulation Language (DML).
• Take advantage of regular expressions and support for international data and time zones.
• Learn to use the SQL99 join syntax.
• Perform advanced SQL queries using techniques e.g. CASE structures, rollup, and cube operations.
• Use advanced table definitions and the creation of indexes, sequences, and views.
• Use the powerful set of built-in SQL functions.
• Handle DML errors without application interruption.
• Obtain database object metadata from the data dictionary.
• Understand basic database security and object privileges.
• Protect database integrity and extend the conceptual data model using declarative constraints.
• Use SQL Developer and other available SQL interfaces.

Oracle SQL Training Outline

Expand All | Collapse All | Printer-Friendly