RDBMS syllabus for BCA | Relational Database Management System

In this article RDBMS syllabus for BCA we give the information about RDBMS Notes and RDBMS related BCA Syllabus points and simple notes.

RDBMS syllabus for BCA

Unit –1: Introduction to RDBMS

1.1 Concept of RDBMS, Difference between DBMS and RDBMS, Features of RDBMS.

1.2 Introduction of Oracle

1.3 Role and responsibilities of DBA.

1.3 RDBMS Terminology- Relation, Tuple, Cardinality, Attribute, Degree, Primary Key, Domain

1.4 Codd’s Rules

1.5 Entity relationship model

1.6 Relational Model: Structure of Relational Database

1.6 Normalization and its types.

1.7 Concept of Relational Algebra

1.8 Database Protection: Security Issues, Threats to Databases, Security Mechanisms

Unit –2: INTRODUCTION TO SQL

Basics of MySQL
2.1 Difference between SQL and MySQL

2.2 Creating a Database and Tables

2.3 DDL,DML,DCL,TCL Commands

2.4 Clauses- Order by, where and group by

2.5 Functions in MySQL

  • Aggregate functions(avg, count, min, max, sum)
  • String Functions(concat, instr, mid, length, strcmp, trim, ltrim, rtrim)
  • Math Functions(abs, ceil, floor, mod, pow, sqrt)
  • Date and Time Functions( adddate, datediff, day, month, year, hour, min, sec)

Unit – 3: Subqueries and Joins in MySQL

3.1 Subqueries

  • Concepts of Sub queries
  • sub queries with IN, EXISTS,NOT EXISTS
  • subqueries restrictions
  • Nested subqueries
  • ANY/ALL clause
  • correlated sub queries
  • Group by and Having clause

3.2 Concepts of Join

Types of Join

  • Inner Join
  • Outer Join
  • Left Join
  • Right Join
  • Cross Join

3.3 Views (creating, altering dropping, renaming and manipulating
views)

Unit – 4: MySQL control statements and stored procedures:

  • Control Statements- If, case and loop
  • Stored procedures – Creating and executing procedures with and without parameters
  • Cursors- Declare, open, fetch, close
  • Triggers- Create, show and drop trigger, Types of trigger

Some More: DBMS/ WT/ DMDW