| C |
| Introduction |
- Introduction
- Importance and need
|
| DATABASE AND NORMALIZATION MODELS |
- Hierachical
- Network
- Relational
- Objects
- Normalization techniques
|
| INTRODUCTION TO RDBMS |
- Concepts of RDBMS
- Concepts of ORDBMS and OODBMS
- Introduction of ORDBMS
|
| Writing Basic SQL Select Statements |
| Restricting and Sorting Date |
| Single Row Functions |
| Displaying Date From Multiple Tables |
| Aggregating Data Using Group Functions |
| Sub Queiries |
| Producing Readable Output With Isql *Plus |
| Manipulating Data |
| Creating and Managing Tables |
| Including Constraints |
| Creating Views |
| Creating Other Database Objects |
| Controlling User Access |
| Transaction Control Language |
| Lock and SQL Plus Editor Command |