Name: Introduction to Oracle Database 10g for Experienced SQL Users
Course Code: OR17325
Duration: 2
Scheduled Dates for OR17325
In this course, students who have experience with other ANSI SQL based databases, are introduced to Oracle Database 10g. They learn about the various Oracle Database extensions to the ANSI SQL standard. The course introduces and familiarizes the students with the Oracle Database environment and iSQL *Plus. The students are provided an overview of the basic elements of SQL and taught how to create, combine and manage tables and other database objects. An introduction to optimization of SQL is provided towards the end of the course. Demonstrations and hands-on practice reinforce all that has been taught.
Target Audience
Technical Consultant
PL/SQL Developer
Database Designers
Key Topics
- Understanding the Oracle Database Environment
- Working with iSQL*Plus
- Getting Started with Oracle SQL
- Combining Tables using Advanced Queries
- Creating and Managing Tables
- Creating and Managing Other Oracle Database Objects
- Controlling User Access
- Oracle Database Extensions to DML and DDL Statements
- Designing for Optimum SQL Performance
- Additional Practices and Solutions
Objectives
- Identify the major structural components of the Oracle Database 10g.
- Log in to iSQL* Plus and use its various features.
- Describe and work with the basic elements of Oracle SQL.
- Combine tables using joins and subqueries.
- Create and manage tables, synonyms, sequences, indexes, and views.
- Control user access by granting privileges and creating roles.
- Optimize SQL Statements.
Fee: $1,200.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
