Name: Oracle Database 10g: Introduction to SQL
Course Code: OR17216
Duration: 5
Scheduled Dates for OR17216
This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users.
This course introduces Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language. This course provides the learners with the essential SQL skills of querying the database, the meta data and creating database objects. In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones.
Target Audience
Database Administrators
PL/SQL Developer
Forms Developer
System Analysts
Technical Consultant
Key Topics
- Introduction
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single Row Functions to Customize Reports
- Reporting Aggregated Data Using the Group Functions
- Displaying Data From Multiple Tables
- Using Sub queries to Solve Queries
- Using the SET Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Managing Objects with Data Dictionary Views
- Controlling User Access
- Manage Schema Objects
- Manipulating Large Data Sets
- Generating Reports by Grouping Related Data
- Managing Data in Different Time Zones
- Searching Data Using Advanced Sub queries
- Hierarchical Data Retrieval
- Performing Regular Expression Support and Case Insensitive
Objectives
- Search data using advanced sub queries
- Retrieve row and column data from tables with the SELECT statement
- Employ SQL functions to generate and retrieve customized data
- Run data manipulation statements (DML) to update data in the Oracle Database 10g
- Control user access and manage schema objects
Suggested Next Course(s)
- OracleAS Portal 10g: Build Corporate Portals
- Oracle Discoverer Administrator 10g: Develop an EUL
- Oracle Database 10g: Program with PL/SQL
Fee: $3,000.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
