1. Creating Database
- Creating a Database
- Creating a Table
- Specifying Relational Data Types
- Specifying Constraints
- Creating Indexes
2. Table and Record Handling
- INSERT statement
- Using SELECT and INSERT together
- DELETE, UPDATE, TRUNCATE statements
- DROP, ALTER statements
3. Retrieving Data from a Database
- The SELECT statement
- Using the WHERE clause
- Using Logical Operators in the WHERE clause
- Using IN, BETWEEN, LIKE , ORDER BY, GROUP BY and HAVING
Clause
- Using Aggregate Functions
- Combining Tables Using JOINS
- Subqueries
4. Database Management
- Creating Views
- Creating Column Aliases
- Creating Database Users
- Using GRANT and REVOKE
Cursors in Oracle PL / SQL
Writing Oracle PL / SQL Stored Procedures