Oracle SQL @ ISI

1. Course Outline:

1.1. Database Design

1.2. Oracle Standard Interfaces

1.3. The Sample Database

1.4. Data Definition Language

1.5. Data Manipulation Language

1.6. Transaction Control

1.7. SQL Operators

1.8. Groups

2. Benefits of Attendance:

2.1. Write basic SQL queries to retrieve desired data

2.2. Use DML statements (insert, update, and delete).

2.3. DDL statements (create, alter, and drop

2.4. Use transaction control statements to commit, rollback, and create savepoints

2.5. create savepoints. Write advanced queries.

2.6. Control access to your database objects

3. Who Should Attend

3.1. Application designers and developers, database administrators and operators, and end users should attend this course

4. Course Description:

4.1. This course is designed to give users an understanding of Oracle SQL and Oracle PL/SQL languages using Oracle’s SQL*Plus and iSQL*Plus tools. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations.

5. Prerequisites:

5.1. There are no prerequisites for this course