Pre-requisite :
- Introduction to Programming
Contents :
- Fundamentals of Database
- Concept of data Integrity, Normalization
- Understanding SQL: DDL, DML, DCL
- Understanding PL-SQL
- Views and Cursors
- Stored Procedures
- Functions
- Triggers
- Indexes
- Clusters, Packages, Exceptions
- Database backup and Recovery
Key Learnings :
- Sound understanding of concepts of database systems.
- Skills for designing, creating and
managing database for a system.
-
Basic database administration
capabilities.
- Industry practices for accelerating data
access.
Recommended Next Course :
- Advanced Technologies like .Net or Java
