Introcuction to Database Systems

Duration : 12 Weeks

Sreenivasa Kumar

0.0
(0) 0 Students
Download Brochure

What you will learn

  • Computer Science and Engineering

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 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 41:13
play
Basic SQL query block and subqueries
Preview 44:26
play
Correlated subqueries
Preview 41:14

play
Aggregate functions
Preview 43:02
play
Views
Preview 43:12
play
Programmatic 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:49

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
img
No Discussion Found

0.0

0 Reviews

5
0
4
0
3
0
2
0
1
0
Meet Your Instructor
Sreenivasa Kumar
img

Instructor
0.0 Rating
0 Students
1 Courses
About Instructor

Prof. P Sreenivasa Kumar has been a member of the faculty of the CSE Dept for the past two decades. His research interests are: databases, semi-structured data and XML, theory and applications of ontologies. He completed his Masters and PhD from the Department of Computer Science and Automation of Indian Institute of Science, Bangalore.

video

Free

  • Course Duration
    29 h 21 m 3 s
  • Course Level
    Intermediate
  • Student Enrolled
    0
  • Language
    English
This Course Includes
  • 29 h 21 m 3 s Video Lectures
  • 0 Quizzes
  • 0 Assignments
  • 0 Downloadable Resources
  • Full Lifetime Access
  • Certificate of Completion