Skip to content

← Back to Overview

BCA - Semester 2 - RDBMS (Code 205)

Comprehensive checklist for Concepts of Relational Database Management System course.

✅ UNIT-1: Introduction to Relational Model

🔹 1.1 Codd's Rules

  • ⬜ Understanding Codd's 12 rules
  • ⬜ Rule 0: Foundation Rule
  • ⬜ Rule 1: Information Rule
  • ⬜ Rule 2: Guaranteed Access Rule
  • ⬜ Rule 3: Systematic Treatment of NULL Values
  • ⬜ Rule 4: Active Online Catalog
  • ⬜ Rule 5: Comprehensive Data Sublanguage Rule
  • ⬜ Rule 6: View Updating Rule
  • ⬜ Rule 7: High-Level Insert, Update, Delete
  • ⬜ Rule 8: Physical Data Independence
  • ⬜ Rule 9: Logical Data Independence
  • ⬜ Rule 10: Integrity Independence
  • ⬜ Rule 11: Distribution Independence
  • ⬜ Rule 12: Nonsubversion Rule

🔹 1.2 Relational Operations Algebra

  • ⬜ SELECT operation (σ)
  • ⬜ PROJECT operation (π)
  • ⬜ UNION operation (∪)
  • ⬜ INTERSECTION operation (∩)
  • ⬜ RENAME operation (ρ)
  • ⬜ Set Difference operation (-)
  • ⬜ Cartesian Product (×)
  • ⬜ Natural Join (⋈)

🔹 1.3 Transaction Control Language

  • ⬜ COMMIT statement
  • ⬜ SAVEPOINT statement
  • ⬜ ROLLBACK statement
  • ⬜ Transaction concepts (ACID properties)

🔹 1.4 Data Control Language

  • ⬜ GRANT statement
  • ⬜ REVOKE statement
  • ⬜ Privilege types (SELECT, INSERT, UPDATE, DELETE, ALL)
  • ⬜ Role-based access control

✅ UNIT-2: Advanced SQL

🔹 2.1 Data Types

  • ⬜ NUMBER data type
  • ⬜ CHAR data type
  • ⬜ VARCHAR data type
  • ⬜ VARCHAR2 data type
  • ⬜ CLOB data type
  • ⬜ NCLOB data type
  • ⬜ LONG data type
  • ⬜ DATE data type
  • ⬜ RAW data type
  • ⬜ LONGRAW data type

🔹 2.2 ROWID Pseudo Column & DUAL Table

  • ⬜ Understanding ROWID
  • ⬜ ROWID usage in queries
  • ⬜ DUAL table concept
  • ⬜ Using DUAL for calculations

🔹 2.3 DATE Functions

  • ⬜ SYSDATE function
  • ⬜ SYSTIMESTAMP function
  • ⬜ TO_CHAR function
  • ⬜ TRUNC function
  • ⬜ ROUND function
  • ⬜ NEXT_DAY function
  • ⬜ LAST_DAY function
  • ⬜ MONTHS_BETWEEN function
  • ⬜ ADD_MONTHS function

🔹 2.4 Concepts of Index

  • ⬜ Creating indexes (CREATE INDEX)
  • ⬜ Dropping indexes (DROP INDEX)
  • ⬜ Types of indexes
  • ⬜ Index advantages and disadvantages
  • ⬜ When to use indexes

🔹 2.5 Join Queries

  • ⬜ 2.5.1 Inner Join
  • ⬜ 2.5.2 Outer Join:
  • ⬜ Left Outer Join
  • ⬜ Right Outer Join
  • ⬜ Full Outer Join
  • ⬜ 2.5.3 Cross Join
  • ⬜ Self Join
  • ⬜ Join conditions

🔹 2.6 Sub Queries

  • ⬜ Subquery with INSERT
  • ⬜ Subquery with UPDATE
  • ⬜ Subquery with DELETE
  • ⬜ Single-row subqueries
  • ⬜ Multiple-row subqueries
  • ⬜ Correlated subqueries

🔹 2.7 Nested Queries

  • ⬜ Understanding nested queries
  • ⬜ Multi-level nesting
  • ⬜ Performance considerations
  • ⬜ Alternative approaches

✅ UNIT-3: PL/SQL and Conditional Statements

🔹 3.1 Introduction to PL/SQL

  • ⬜ Definition of PL/SQL
  • ⬜ Block Structure:
  • ⬜ Declaration section
  • ⬜ Executable section
  • ⬜ Exception section

🔹 3.2 Variables, Constants and Data Types

  • ⬜ Variable declaration
  • ⬜ Constant declaration
  • ⬜ PL/SQL data types
  • ⬜ Anchored data types (%TYPE)
  • ⬜ Row data types (%ROWTYPE)

🔹 3.3 Assigning Values to Variables

  • ⬜ Assignment operator (:=)
  • ⬜ SELECT INTO statement
  • ⬜ Variable initialization

🔹 3.4 User Defined Record

  • ⬜ RECORD type declaration
  • ⬜ Creating record variables
  • ⬜ Accessing record fields
  • ⬜ Record operations

🔹 3.5 Conditional Statements

  • ⬜ 3.5.1 IF...THEN statement
  • ⬜ 3.5.2 IF...ELSE statement
  • ⬜ 3.5.3 Multiple conditions (ELSIF)
  • ⬜ 3.5.4 Nested IF statements
  • ⬜ 3.5.5 CASE statements
  • ⬜ Simple CASE
  • ⬜ Searched CASE

✅ UNIT-4: Iterative Statements

🔹 4.1 Iterative Statements

  • ⬜ 4.1.1 LOOP...END LOOP
  • ⬜ 4.1.2 FOR LOOP
  • ⬜ Numeric FOR loop
  • ⬜ Cursor FOR loop
  • ⬜ 4.1.3 WHILE LOOP
  • ⬜ 4.1.4 EXIT statement
  • ⬜ 4.1.5 CONTINUE statement
  • ⬜ Loop nesting
  • ⬜ Loop labels

✅ UNIT-5: Cursors and Exception Handling

🔹 5.1 Concepts of Cursors

  • ⬜ 5.1.1 Types of cursors:
  • ⬜ Implicit cursors
  • ⬜ Explicit cursors
  • ⬜ 5.1.2 Cursor operations:
  • ⬜ DECLARE cursor
  • ⬜ OPEN cursor
  • ⬜ FETCH cursor
  • ⬜ CLOSE cursor

🔹 5.2 Cursor Attributes

  • ⬜ %FOUND attribute
  • ⬜ %NOTFOUND attribute
  • ⬜ %ISOPEN attribute
  • ⬜ %ROWCOUNT attribute

🔹 5.3 Exception Handling in PL/SQL

  • ⬜ 5.3.1 Types of Exceptions:
  • ⬜ 5.3.1.1 Named System Exceptions
  • ⬜ 5.3.1.2 Unnamed System Exceptions
  • ⬜ 5.3.1.3 User-defined Exceptions
  • ⬜ 5.3.1.4 User Defined Exceptions (duplicate - consolidate)
  • ⬜ 5.3.2 Exception Handling:
  • ⬜ EXCEPTION block
  • ⬜ WHEN OTHERS
  • ⬜ SQLCODE and SQLERRM
  • ⬜ RAISE statement
  • ⬜ Custom exception messages

📚 Additional Resources

Practical Exercises

  • ⬜ SQL query practice
  • ⬜ PL/SQL block writing
  • ⬜ Cursor implementation
  • ⬜ Exception handling scenarios

Exam Preparation

  • ⬜ Review all SQL functions
  • ⬜ Practice join queries
  • ⬜ Write sample PL/SQL programs
  • ⬜ Understand transaction concepts
  • ⬜ Master exception types

Subjects

Topics