RDBMS Syllabus for BCA
This page provides detailed information about the RDBMS Syllabus for BCA, covering SQL fundamentals, advanced queries, joins, constraints, aggregate functions, and PL/SQL programming, including cursors, triggers, stored procedures, and functions.
RDBMS Syllabus for BCA:
UNIT I: Introduction to RDBMS
- Introduction to RDBMS: Definition and basic concepts
- Constraints in RDBMS:
- Primary Key, Foreign Key, Unique Key, NOT NULL, CHECK
- SQL Basics:
- DDL (Data Definition Language)
- DML (Data Manipulation Language)
- DCL (Data Control Language)
- TCL (Transaction Control Language)
- DQL (Data Query Language)
UNIT II: Advanced SQL and PL/SQL
- Advanced SQL:
- Mathematical Functions
- String Functions
- Aggregate Functions:
- MIN(), MAX(), SUM(), AVG(), COUNT()
- Logical Operators: AND, OR, NOT
- Predicates: IN, LIKE, BETWEEN, ALIAS, DISTINCT
- Clauses: GROUP BY, HAVING, ORDER BY, TOP / LIMIT
- Joins:
- Inner Join, Natural Join, Full Outer Join, Left Outer Join, Right Outer Join, Equi Join
- Set Operations:
- UNION, INTERSECT, MINUS / EXCEPT
- Views (Creation and Management)
- Introduction to PL/SQL:
- Concept of PL/SQL
- Cursor
- Trigger
- Stored Procedure
- Functions
SOME MORE: