- Introduction of Database,
- Benefits of Database Approach
- Structure of the Database System,
- Types of Database Users
- Roles of Database Administrator
- Introduction to RDBMS.
- Codd’s rules for RDBMS,
- DBMS Vs. RDBMS
- Overview of Database System Architecture,
- Introduction to Distributed Database
- Database terms: Relation, Entity, Attribute, Attribute Value, Primary key, Candidate key, Alternate key
- Normal Forms:
- First Normal forms
- Second Normal forms
- Third Normal forms
- Boyce / Codd Normal Form
- Multi-valued dependencies and Fourth Normal Form
- Join Dependencies and Fifth Normal Form
- Transaction concepts,
- Properties of transactions
- Schedule and its types [Out of Syllabus]
- Serializability of transactions,
- Testing for serializability
- System recovery,
- Two-Phase Commit protocol
- Recovery and Atomicity,
- Log-based recovery,
- Concurrent executions of transactions and related problems.
Unit - 3 Interactive SQL Part – I
- Introduction to SQL,
- Logging into SQL * Plus,
- Naming Rules and Conventions,
- Data Types
- Creating a Table,
- Viewing data in the tables,
- Sorting data in a table,
- Delete operations,
- Updating contents of a table,
- Modifying the structure of tables,
- Renaming,
- Truncating and Destroying tables
- Examining objects created by a user
- Constraints (I/O and Business rule constraints)
- DDL, DML, DCL/TCL, DQL
- Select Clause
- Computations on table data (Range Searching Pattern Matching)
- User Management: Creating a new user in Oracle,
- Assigning rights to the user
- Changing the password of an existing user
- Security Management using SQL
- Security using Grant and Revoke Statements
Unit - 4 Interactive SQL Part – II
- Oracle Built-in Functions:
- Single row Functions
- Group Functions
- Set Operators,
- Subquery,
- Group by Clause,
- Having Clause,
- Group by using ROLLUP and CUBE operator,
- EXISTS/ NOT EXISTS operator
- Different Types of Joins
- Index
- View
- Sequence
- Setting environment using SET command
- Advance features in SQL * Plus
- Code a tree-structured Query,
- Code a Matrix Report in SQL,
- Dump function