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.
SOME MORE: