RDBMS Syllabus for BCA

RDBMS Syllabus for BCA:

Unit 1: Introduction to RDBMS

Concept of RDBMS, Features of RDBMS

Difference between DBMS and RDBMS

Terminologies: Relation, attribute, domain, Tuple, Entities, Degree

Codd’s Rules

Relational Model: Structure of Relational Database

Concept of Relational Algebra

Role and Responsibilities of DBA

Unit 2:  Basics of MySQL

Features of MySQL, Data types

Difference between SQL and MySQL

Integrity Constraints-(Primary key, Foreign key, unique key, not Null, default, check)

DDL, DML, DCL, TCL Commands

Select Statement with Clauses-Where, Having, Orderby, groupby

SQL Operators- Arithmetic, Relational, Logical, Like, Between, IN operator

Functions in MySQL

Aggregate functions: avg, count, min, max, sum

String Functions: concat, instr, mid, length, strcmp, trim, ltrim, rtrim

MathFunctions: abs, ceil, floor, mod, pow, sqrt

Date and Time Functions: adddate, datediff, day, month, year, hour, min, sec

Unit 3:  Joins and Sub queries in MySQL

Join types – Inner Join, Outer Join, and Cross Join and self-Join

Sub-queries, Multiple sub queries, nesting of sub queries, sub queries in DML commands, correlated sub queries

Create Indexes, Sequences

Views: creating, altering dropping, renaming and manipulating views

Unit 4: MySQL control statements and stored procedures

Introduction to PL/SQL Block Structure

Control Structures- Branching statements, Iterative Control statements.

Stored procedures– Creating and executing procedures with and without parameters

Cursors – Concept, Types- Implicit, Explicit, Procedure to create explicit cursors

TRIGGERS: Concept and types.