Upon completion of this course, the student will be able to: Create, maintain, and use the sequences using the SQL command. Create and maintain indexes using the SQL command. Describe database objects and their uses. Create public and private synonyms. Create users and grant and revoke privileges. Describe the benefits of PL/SQL. Describe the basic PL/SQL block, its sections and nested blocks. Create PL/SQL records, tables and table of records. Declare variables in PL/SQL and use them. Describe the significance of the executable section in PL/SQL block and writing statements into it.
Unit 1: Sequences
- Creating a Sequence
- Referencing Sequence Values
- Altering a Sequence
Unit 2: Indexes
- Indexes: Types
- Creating an Index
- Removing an Index
- Other Database Objects
Unit 3: Controlling User Access
- Creating a Synonym
- Creating a User
- System Privileges
- Object Privileges
Unit 4: PL/SQL An Introduction
- PL/SQL Benefits
- Using the PL/SQL Block Structure
- Using PL/SQL Records
- Using PL/SQL Tables
Unit 5: Datatypes and Variables
- Declaring Variables
- Declaring Datatypes
- Assigning Values to Variables
- Executable Statements