Duration
4 days
Course Outline
- Advanced Table Join &Subqueries
- Normalization Overview
- Inner Join
- Outer Join
- Self Join
- Subqueries in Where clause
- Subqueries in From clause
- Subqueries with Join
- Exercise
- Advanced Aggregations & Functions
- Where VS Having
- Group set with cube
- Over Partition By function
- Exercise
- Pivoting Data
- Transform data using Pivoting
- Transform data using Unpivoting
- Exercise
- Stored Procedure
- Create stored procedure
- Calling stored procedure
- Stored procedure with parameters
- Output parameter
- Exercise
- Programming with SQL
- Conditional statement
- Looping in SQL
- Cursors
- Exercise
- Error Handling in SQL
- Error types in SQL
- Handlining errors in oracle
- Transactions
- Transaction behaviour
- Transaction Statement
- Transaction save point
- Transaction Error Handling
- Concurrency Problems
- Isolation Level
- Deadlocks problem
- Triggers
- Insert Trigger
- Update Trigger
- Delete Trigger
- Trigger for reporting automation
Programme scope, delivery arrangements and suitability are confirmed during enquiry.