PL/SQL:
- Introduction to PL/SQL
- The Advantage of PL/SQL
- PL/SQL Block Structure
- PL/SQL Architecture
- Fundamentals of PL/SQL
- PL/SQL Data Types
- Variables and Constants
- Scope and Visibility of a Variable
- Assignments and Expressions
- Operator Precedence
- Conditional and Iterative Control
- Cursor Management in PL/SQL
- Implicit/explicit Cursor Attributes
- Exception Handling in PL/SQL
- Predefined Exceptions
- User Defined Exceptions
- Database Trigger
- types of triggers
- dropping triggers
- storage for triggers.
Understanding SQL-II:
- Querying Multiple Tables using Equi-Joins
- Cartesian Joins
- Outer Joins
- Self-Joins
- SET Operators:
- Union
- Intersect
- Minus
- Introduction to Nested Queries
Understanding SQL-1:
- Data Types
- Creating Tables
- Creating a Table with data from Another table.
- Inserting Values into a Table
- Updating Column(s) of a Table
- Deleting Row(s) from a Table
- Dropping a Column
- Querying database tables.
- Conditional retrieval of rows
- Working with Null Values
- Matching a pattern from a table.
- ordering the result of a Query Aggregate Functions.
- Grouping the Result of a Query
- creation and deletion of Views
- Managing privileges with Grant and Revoke Command
- COMMIT and ROLLBACK
- Functions:
- Character Functions,
- Date Functions,
- Group Functions
RDBMS:
- Terminology
- The 12 Rules (Codd’s Rule) for an RDBMS.
Relational Data Base Design:
- Functional Dependencies.
- Decomposition.
- Desirable properties of decomposition
- Normal forms based on primary keys (1 NF, 2 NF, 3 NF and BC NF).
Conventional Data Models:
- An overview of Network .
- Hierarchical Data Models.
Relational Data Model:
- Relational model concepts.
- Integrity constraints over Relations.
- Relational Algebra - Basic Operations.
Entity Relationship Model:
- Entity Types
- Entity Sets.
- Attributes & Keys
- Relationships.
- Relationship Types
- Roles and Structural Constraints
- Design issues.
- weak entity types.
- E-R Diagrams
- Design of an E-R Database Schema
- Reduction of an E-R Schema to Tables.
Data Base Systems Concepts and Architecture:
- Data Models
- Schemas and Instances
- DBMS architecture and Data Independence.
- Data base languages & Interfaces.
- DBMS functions and component modules.
Basic Concepts:
- A Historical perspective
- File Systems vs. DBMS
- Characteristics of the Data Base Approach.
- Abstraction and Data Integration
- Database users
- Advantages and Disadvantages of DBMS.
- Implication of Database approach.
