Share this link via
Or copy link
Trainer Details:
1. History of Database.
2. Difference between file system & DB.
3. DDL, DML, DCL & TCL commands.
4. Table/object Naming rules.
5. Data Types.
6. Constraints.
7. Operators.
8. Clauses.
9. Functions.
10. Joins.
11. sub queries.
12. Views.
13. Sequences.
14. Indexes.
15. Synonyms.
16. Partitions.
17. Locks.
1. Introduction & Advantages.
2. Data types.
3. Variables & Blocks.
4. Control structures.
5. Loops.
6. CURSOR.
7. Collections.
8. Records
9. Exception handling.
10. Functions.
11. Procedures/stored procedures.
12. Triggers.
13. Packages.
14. Performance improvement techniques with BULK COLLECT & FOR ALL
15. Dynamic SQL.