- What is DBMS
- Relational data models
- Data Integrity rules
- Normalization
- Introduction to data processing methods-Client/Server
- Oracle Architecture
- What is cloud? What does 12c mean?
SQL
- Creating Tables
- Identify columns
- Inetgrity Constraints
- Adding,updating and dropping columns
- Transaction and locking
- Functions
- Grouping data
- Using ROLLUP and CUBE
- Query Row Limits and Row Offsets
- Joining tables
- ANSI join
- Sub queries
- Working with TOPn analysis
- Views
- Materialized Views
- Using indexes
- Security
- External table
- Flashback query
- MERGE statement
- Multi table insert
- Using Regular Expressions
- Fine Grained Dependency tracking
PL/SQL Programming
- What is PL/SQL
- Structure of PL/SQL block
- Control statement
- CASE expression
- Creating and using Records
- Working with Collections
- Exception handling
- Cursor handling
- Writing stored procedures and functions
- Definer rights vs Invokers rights
- Packages
- Autonomous transactions
- Database triggers
- Compound Triggers
- Dynamic SQL with Native dynamic SQL
Object features
- Object types
- Object Inheritance
- Varrays
- Nested tables
- Object views
