Introduction to Database Systems

Introduction to Database Systems

@VTU COE

0.0
(0) 0 Students
Download Brochure

What you will learn

  • none

Databases are the backbone of almost all the digital services and e-governance solutions. Modern businesses and financial systems heavily depend on databases systems and transaction processing for their successful operation. This course introduces the students to the various theoretical and practical principles involved in the design and use of databases systems with the help of database management systems (DBMS) and the SQL Standard.

play
Introduction
Preview 42:53
play
Database Architecture
Preview 48:29
play
RDBMS Architecture
Preview 41:38

play
Introduction to ER Model
Preview 41:29
play
Entities and Relationships
Preview 39:54
play
Modelling Weak Entities and Design Choices
Preview 42:17

play
Relational Data Model and Notion of Keys
Preview 48:59
play
Introduction to Relational Algebra
Preview 43:48
play
Operators in Relational Model
Preview 39:56
play
Uses of Renaming, Join and Division in Relation Algebra
Preview 42:25

play
Example Queries in Relation Model and Outer Join Operation
Preview 38:56
play
Convert ER-Model to a Relational Model
Preview 45:08
play
Introduction to tuple relational calculus
Preview 44:43
play
Example TRC queries
Preview 42:42

play
Data definition using SQL
Preview 42:42
play
Basic SQL query block and subqueries
Preview 44:26
play
Correlated subqueries
Preview 41:13

play
Aggregate functions
Preview 43:02
play
Views
Preview 43:16
play
Programmatic access of SQLProgrammatic access of SQL
Preview 48:54

play
Normal forms - Introduction
Preview 42:26
play
Deriving new functional dependencies
Preview 41:59
play
Proving soundness and completeness of Armstrong's Axioms
Preview 49:46

play
Normal forms - 2 NF, 3NF, BCNF
Preview 41:07
play
Properties of decompositions
Preview 45:35
play
Normal forms - 4NF, 5NF
Preview 31:44

play
Introduction to file orgranization
Preview 44:32
play
File orgranization methods
Preview 47:05
play
Dynamic File orgranization using Hashing
Preview 41:39
play
Index structures
Preview 50:03

play
B+ trees on Disks
Preview 49:53
play
Performance and Reliability of Multiple Disks
Preview 42:25
play
Relational Query Evaluation
Preview 47:53

play
Join operator processing algorithms
Preview 42:58
play
Query optimization
Preview 33:04
play
ACID properties and operations in transactions
Preview 46:59
play
Schdeules
Preview 52:47

play
Concurrency control using Locks
Preview 31:51
play
Recovery using undo logging method
Preview 48:16
play
Recovery using Redo and Undo-Redo logging methods
Preview 39:35
play
Recoverable schdeules and transaction isolation levels
Preview 24:06

play
Live Session 11-04-2022
Preview 36:50
play
Live Session 18-04-2022
Preview 55:25
img
No Discussion Found

0.0

0 Reviews

5
0
4
0
3
0
2
0
1
0
Meet Your Instructor
@VTU COE
img

Instructor
3.3 Rating
8558 Students
802 Courses
About Instructor

VTU is one of the largest Technological Universities in India with 24 years of Tradition of excellence in Engineering & Technical Education, Research and Innovations. It came into existence in the year 1998 to cater the needs of Indian industries for trained technical manpower with practical experience and sound theoretical knowledge.

video

Free

  • Course Duration
    30 h 58 m 48 s
  • Course Level
    Intermediate
  • Student Enrolled
    0
  • Language
    English
This Course Includes
  • 30 h 58 m 48 s Video Lectures
  • 2 Quizzes
  • 0 Assignments
  • 0 Downloadable Resources
  • Full Lifetime Access
  • Certificate of Completion