Duration : 20 DAYS (30 hours) [one & half hour per day]
Training Mode : Online
Course material : only softcopy (in the form of pdf)
Software : Oracle 11g
COURSE CONTENT
Part 1:- Introduction to DBMS
Part 2:- Introduction to RDBMS
Part 3:- Sub-Language Commands
Part 4:- Introduction to SQL Database Objects
Part 5:- Built-in Functions
Part 6:- Grouping the Result of a query
Part 7:- Working with integrity constraints
Part 8:- Joins
Part 9:- Working with Sub-queries
Part 10:- Working with DCL,TCL commands
Part 11:- Maintaining Database Objects
1. Views
2. Sequence
3. Synonyms
4. clusters
Part 12:- Pseudo columns in Oracle
Part 13:- Locks
Procedure Language- SQL( PL/SQL)
1. Introduction and Advantages PL/SQL
2. Data types
3. Conditional Statements
4. Loops
5. Exceptions
6. Cursors
7. Functions
8. Procedures
9. Triggers
10. Collections
11. Packages