STRUCTURED QUERY LANGUAGE
- Introduction-Explaining the brief history of SQL
- The SELECT Statement
- The SELECT Statement
- Functions
- SQL Clauses
- SQL Joins
- SQL Joins in detail with Examples
- Sub Queries
- Data manipulation
- Creating and Managing Tables)
- Creating Views and Indexes
- Transactions Controlling
- DB Security
- Advanced topics in SQL
- SQL and its Dynamic Uses
- Improving Performance-Streamlining SQL Statements
- Use Views and Retrieve information from the Data Dictionary
- Generate SQL Statements
- PL/SQL:An Introduction
- Transact-SQL:An Introduction
- SQL*Plus
- Common SQL Mistakes/Errors and Resolutions
PLSQL
- Introduction.
- Conventions
- PLSQL fundamentals
- Variables/Program Data
- SConditional control and Sequential Control
- Loops
- DB Interaction
- Cursors in PL/SQL
- Named Program Units
- Triggers
- Packages
- Calling PL/SQL Functions in SQL
- Oracle’s Object Oriented Features
- Collections
- External Procedures
- Java Language Integration