|
Database & Reporting Training
/
Oracle 11g R2 Training
Introduction to Oracle 11g R2 SQL Programming40%Lecture/Demo 60%Lab 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. Course Number:ORC-230Duration:5Location and PricingMost 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
Oracle SQL Training OutlineRelational Databases & SQL Choosing A SQL & PL/SQL Interface Building A Select Statement Restricting Data With the Where Clause Sorting Data With the Order By Clause Using the Set Operators Summary Functions Using Sub-Queries Aggregating Data Within Groups Build Simple SQL*Plus Reports Use Data Definition Language To Create & Manage Tables Use Data Manipulation Language To Manipulate Data SQL99 Join Techniques Enhancing Groups With Rollup & Cube Using the Case Expression SQL Functions SQL Functions: Numeric SQL Functions: Date Database Objects: Relational Views Database Objects: Data Dictionary Storage Database Objects: Indexes Database Objects: Other Objects Database Objects: Security Data Integrity Using Constraints Managing Constraint Definitions Advanced SQL*Plus Reports Building SQL*Plus Scripts SQL*Plus Session Control Conclusion Prerequisites:No prior Oracle SQL experience is presumed. Training Materials:All students receive comprehensive courseware and a related textbook. Software needed for each student PC:
Related Courses: |