UTU 3rd Year UTU All Course

DATABASE MANAGEMENT SYSTEMS (CST-011) UTU

"Database Management Systems (DBMS)" involves the study and use of software to manage and organize data in databases, ensuring efficient storage, retrieval, and manipulation of data while maintaining data integrity and security.

5.0

(1)

19 Enrolled

40 hours

RajKumar

Level Intermediate
Total Enrolled 19
Duration 40 hours
Last Updated January 4, 2025
Certificate Certificate of completion

About Course

Course Content:- DATABASE MANAGEMENT SYSTEMS

Unit 1-Introduction:

Data Abstraction, Data Independence, Data Definition Language(DDL), Data Manipulation Language(DML), 3-level Database System Architecture.

Database models: Entity-relationship model, network model, relational and object-oriented data models, integrity constraints, data manipulation operations.

Unit 2-Relational Model:

Structure of relational database, Relational Algebra: Fundamental operations, Additional Operations, Extended Relational-Algebra operations, Tuple Relational Calculus – Domain Relational Calculus. SQL: Basic structure, Set operations, Aggregate functions, Null Values, Nested subqueries, Views, Data Definition Language, Embedded SQL, Dynamic SQL, Domain Constraints, Referential Integrity and Triggers.

Unit 3-Relational database design:

Functional Dependencies, First, Second, Third Normal Forms, Closure, Armstrong’s Axioms, Canonical cover, Decomposition, Properties of Decomposition, Dependency Preservation, Boyce-Codd Normal Form, Fourth Normal Form, Fifth Normal Form.

Unit 4-Transaction processing:

Transaction Concepts, ACID Properties, Two-Phase Commit, Save Points, Concurrency Control Techniques: Locking Protocols, Two Phase Locking, timestamp-based protocol, Multi-version and optimistic Concurrency Control schemes, Database recovery.

Unit 5-Storage Structure, Query Processing, and Advanced Database:

Storage structures: RAID. File Organization: Organization of Records, Indexing, Ordered Indices, B+ tree Index Files, B tree Index Files.

Query Processing: Overview, Measures of Query Cost, Query Optimization.

Advanced Database: Object-oriented and object-relational databases, logical databases, web databases, distributed databases, data warehousing, and data mining.

Course Content

Unit 1-Introduction To DBMS

What is a Database?
Introduction To DBMS
Key Features of DBMS
Advantages and Disadvantages of DBMS
Data Abstraction
Data Independence
What is Data Definition Language (DDL)?
What is Data Manipulation Language(DML)?
Types of Database System Architecture
1-Tier Database System Architecture
2-Tier Database System Architecture
3-level Database System Architecture
How Database System Architecture work?
Database models
Entity-relationship model
Network Model
Relational Models
Object-oriented Data Model
Integrity constraints
Data Manipulation operations

Unit 2-Relational Model

Relational Model introduction
Structure of Relational Database
Relational Algebra:
Basic set operation
Relational operations
Extended Relational (Join)
Tuple Relational Calculus – Domain Relational Calculus.
SQL: Basic structure
Set operations
Aggregate functions, Null Values, Nested subqueries and Views
Data Definition Language
Embedded SQL And Dynamic SQL
Domain Constraints
Referential Integrity and Triggers

Unit 3-Relational database design

Relational database design
Functional Dependencies
First, Second, Third Normal Forms, Closure,
Armstrong’s Axioms
Canonical cover
Decomposition
Properties of Decomposition
Dependency Preservation
Boyce-Codd Normal Form
Fourth Normal Form
Fifth Normal Form

Unit 4-Transaction processing

Unit 5-Storage Structure

5.1 Query Processing

5.2 Advanced Database

Practicle File

Instructors

RajKumar

Front End Developer🧑‍💻.

4.4

85 Students

10 Courses

Feedback

5.0

Total 1 Rating

100%

Review (1)

PM

Prajapati Manish

1 month ago

must enroll .

AKTU

UTU

Popular Categories

Dashboard Pages

Join more than

10k learners

worldwide

DATABASE MANAGEMENT SYSTEMS (CST-011) UTU

About Course

Course Content:- DATABASE MANAGEMENT SYSTEMS

What Will You Learn?

Course Content

Unit 1-Introduction To DBMS

What is a Database?

Introduction To DBMS

Key Features of DBMS

Advantages and Disadvantages of DBMS

Data Abstraction

Data Independence

What is Data Definition Language (DDL)?

What is Data Manipulation Language(DML)?

Types of Database System Architecture

1-Tier Database System Architecture

2-Tier Database System Architecture

3-level Database System Architecture

How Database System Architecture work?

Database models

Entity-relationship model

Network Model

Relational Models

Object-oriented Data Model

Integrity constraints

Data Manipulation operations

Unit 2-Relational Model

Relational Model introduction

Structure of Relational Database

Relational Algebra:

Basic set operation

Relational operations

Extended Relational (Join)

Tuple Relational Calculus – Domain Relational Calculus.

SQL: Basic structure

Set operations

Aggregate functions, Null Values, Nested subqueries and Views

Data Definition Language

Embedded SQL And Dynamic SQL

Domain Constraints

Referential Integrity and Triggers

Unit 3-Relational database design

Relational database design

Functional Dependencies

First, Second, Third Normal Forms, Closure,

Armstrong’s Axioms

Canonical cover

Decomposition

Properties of Decomposition

Dependency Preservation

Boyce-Codd Normal Form

Fourth Normal Form

Fifth Normal Form

Unit 4-Transaction processing

Transaction processing

Transaction Concepts

ACID Properties

Two-Phase Commit And Save Points,

Concurrency Control Techniques:

Locking Protocols, Two Phase Locking,

Timestamp-based protocol

Multi-version and optimistic Concurrency Control schemes

Database recovery

Unit 5-Storage Structure

Query Processing

Advanced Database

Storage structures: RAID

File Organization:

Organization of Records, Indexing

Ordered Indices

B+ Tree Index Files

B Tree Index Files

5.1 Query Processing