21CS34P | Database System Concepts and PL/SQL - 20CS34P | Third Semester |DTE



Database System Concepts and PL/SQL - 20CS34P
SYLLABUS COPY - 21CS34P

Database System Concepts and PL/SQL

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-01

Introduction Overview of DB: why a database? Purpose of database;

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-02

Database design Data model; types; importance of data modeling;

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-03

Relational model: Overview; characteristics; Constraints: types; Operations;

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-04

Functional dependency: overview, rules, types; Normalization:

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-05

database languages: types, commands/tasks in each type; Integrity constraints;

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-06

Defining Data: DDL CREATE, ALTER, DROP different DB objects; Temporary tables:

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-07

Insert, delete and update data Modifying data: UPDATE and DELETE Update anomalies;

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-08

filtering data: WHERE, AND, OR, row limiting clause, IN, BETWEEN, LIKE;

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-09

Grouping data: Aggregate functions, GROUP BY, HAVING; Set operators: UNION, INTERSECT, MINUS;

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-10

Subqueries: Comparator operators; subqueries: Single Row Subqueries;

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-11

Views: create, drop and update; realization of views based on single and multiple tables;

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-12

PL/SQL: variables, datatypes; control statements (decision making); URL

Open and Download
Few Seconds ago Updated


Database System Concepts and PL/SQL - 20CS34P
Week-13

Managing and controlling transactions: Introduction of transaction, ACID properties;

Open and Download
Few Seconds ago Updated


Useful Links

Database System Concepts and PL/SQL - 20CS34P
All Year Question Papers

2021 , 2022

Open and Download
Few Seconds ago Updated