Home / Semester 1 / CAP570
Back to Subjects

CAP570 — Advanced Database Techniques

Course Overview

CAP570 4 Credits L:2 T:0 P:3
Download Syllabus

This course covers the basic concepts of DBMS and RDBMS, normalization, SQL and PL-SQL, and advanced databases including Big Data, OLAP, Cloud Databases, NewSQL, and NoSQL.

Unit 1

Basics of Database

Unit 2

E-R Modeling

Unit 3

Database Normalisation

Unit 4

Database Joins

Unit 5

Pl-SQL

Unit 6

Advance Databases

Continuous Assessment

4 components

Best 3 of 4 CAs will be considered for evaluation.
BYOD-Practical 1 33.33%

Basics and Fundamentals of DBMS and RDBMS including its operations with scenario based questions

Week 3 / 3

Rubric
To understand the basic concepts of DBMS and RDBMS and the evolution of database and perform normalization

BYOD-Practical 2 33.33%

Scenario based questions based upon languages and concept of normalization

Week 5 / 5

Rubric
To implement normalization and its concepts to the any database along with SQL commands

BYOD-Practical 3 33.33%

To use database solutions based upon bigdata or other solutions

Week 9 / 9

Rubric
To understand and apply the concepts PL-SQL and analyze various advanced databases used in todays industry

BYOD-Practical 4 33.33%

Project based upon all the outcomes and usage of all commands

Week 12 / 12

Rubric
Project

Exams & Practice

Mid Term Examination

Mid-semester comprehensive evaluation

25%

End Term Examination

Final semester comprehensive evaluation

50%

Type: Examination and Practical

ETT: 50% MCQ - 50% Theory; ETP: Practical Course

CAP570 - FAQs

How many units are in CAP570?

CAP570 has 6 units. Each unit includes detailed notes and MCQ practice questions.

What exam resources are available for CAP570?

Unit-wise notes and MCQ practice are available. Exam resources coming soon.

How to prepare for CAP570 exams?

Study each unit's notes thoroughly, practice MCQs to test understanding, and attempt mock tests before exams. Focus on important topics and previous year questions.