Aptech Computer Education - Introduction to Oracle 9i

Introduction to Oracle 9i - SQL (Paper 1)

SQL*Plus, the primary interface to the Oracle database server, provides a powerful yet easy-to-use environment for querying, defining, and controlling data. Oracle 9i SQL delivers the fundamentals of relational and object-relational databases and the powerful SQL programming language. Paper 1 makes the student strong in Oracle SQL statements, and iSQL*Plus, which is used for executing SQL and for formatting and reporting purposes

Who will the course benefit?

Students and working professionals wishing to gain expertise in SQL

What skills will the student gain?


Prerequisites
Prior knowledge of data processing concepts and techniques

Duration
40 hours

Certification
Certificate of participation (Additionally, students can appear for Oracle 9i SQL vendor certification)

After the completion of this course, the student will be able to:

Define database

Explain basic SQL statements

Describe the various types of functions available in SQL

Describe and use the different types of joins

Describe subqueries

Describe the process of producing readable output with iSQL*Plus

Explain data manipulation using SQL statements

Describe constraints and views

Describe the various database objects

List and explain Oracle 9i extensions to DML and DDL statements

> Back