Database Management Systems

Learn, Understand, Discuss. "GO" for the Best.

5.0 (1 ratings)

Instructor: Deepak Poonia (MTech IISc Bangalore, GATE CSE AIR 53; 67)

Language: English

Valid Till: 2024-02-15

₹5900 including 18% GST

Description
Course Content
How to Use

Features of the course:
1. Quality Content: No Rote-learning. No poor understadning. No By-hearting of formulas, tables or theorems. Understand everything with proofs-intuitions-ideas.
2. No Prerequisites: Every concept is taught from basics, without assuming any prior knowledge whatsoever.
3. Daily Homeworks: Practice material, with solutions, for Every Lecture to test your understanding of concepts of respective lecture.
4. Summary Lectures: Short videos which summarises every concept and detail of the course. Helps in quick revision.
5. Quality Practice Sets: Practice Sets from standard resources, with solutions, containing a lot of quality questions for practice.
6. Weekly Quizzes: Every week, there will be a Live Quiz, containing 15-20 questions, to evaluate your understanding of concepts taught in the previous week. The Quiz questions can be seen, solved even after tha live quiz is over.
7. Doubt Resolution: All your doubts will be resolved directly by the faculty. There is a dedicated Telegram group for Enrolled Students of Goclasses where our faculties resolve students' doubts. So, our students don't have to go anywhere else for asking doubts.

Enroll Now.

Enroll here for Goclasses GATE CSE 2023 Complete Course

Enroll here for GO+Goclasses Test Series

Join GOclasses public Telegram Group for Doubt Discussions

Reviews

5.0

1 total


5		1
4		0
3		0
2		0
1		0

Load More Reviews

Other Courses


	Module 1 - The Relational Model & Normalization
		Mod 1 - Lecture 1 - Introduction to DBMS and Relational Model
		Notes - Mod 1 Lecture 1 - Introduction to DBMS and Relational Model Annotated Notes (68 pages)
		Mod 1 - Lecture 2 - The Relational Model
		Notes - Mod 1 Lecture 2 - The Relational Model Annotated Notes (120 pages)
		Mod 1 - Lecture 3 - Questions Candidate Keys, Super Keys 27:00
		Mod 1 - Lecture 4 - Integrity Constraints in Relational Model, Foreign Key 27:00
		Notes - Mod 1 Lecture 4 - Integrity Constraints in Relational Model Annotated Notes (161 pages)
		Mod 1 - Lecture 5 - Functional Dependency 234:00
		Notes - Mod 1 Lecture 5 - Functional Dependency Annotated Notes (154 pages)
		Mod 1 - Lecture 6 - Normal Forms 1NF, 2NF
		Mod 1 - Lecture 7 - Normal Forms 3NF 130:00
		Mod 1 - Lecture 8 - BCNF Normal Forms & Practice Questions 105:00
		Notes 6,7,8 - Mod 1 - Lecture 6,7,8 - Normal Forms Annotated Notes (340 pages)
		Mod 1 - Lecture 9 - Decomposition and Normalization
		Mod 1 - Lecture 10 - Decomposition and Normalization Part 2
		Notes 9,10 - Mod1 - Lecture 9,10 - Decomposition, Normalization Annotated Notes (201 pages)
		Non-Binary Decomposition Complete Playlist
		Notes - Complete Decomposition, Non-Binary Decomposition Annotated Notes (185 pages)
		Normalization Revision Playlist
		Mod 1 - Lecture 11 - Practice Questions
		Mod 1 - Lecture 12 - Minimal FD Cover and Practice Questions
		Notes 11,12 - Lecture 11,12 - Minimal FD Cover and Practice Questions Annotated Notes
		Mod 1 - Lecture 13 - Data Independence 133:00
		Mod 1 - Lecture 14 - Practice Questions 129:00
		Notes 13,14 - Lecture 13,14 - Data Independence, Practice Questions Annotated Notes (196 pages)
		Mod 1 - Lecture 15 - Understanding Redundancies
		Mod 1 - Lecture 16 - 3NF, BCNF Decomposition
		Notes - Mod 1 - Lecture 15,16 - Understanding Redundancies, 3NF, BCNF Decomposition Annotated Notes (239 pages)
	Module 2 - Queries
		Mod 2 - Lecture 1 - Relational Algebra
		Mod 2 - Lecture 2 - Relational Algebra Set Operations
		Notes - Mod 2 - Lecture 1,2 - Relational Algebra Annotated Notes (248 pages)
		Mod 2 - Lecture 3 - Inner Join Operations in Relational Algebra
		Mod 2 - Lecture 4 - Division Operation in Relational Algebra
		Notes - Mod2 - Lecture 3,4 - Relational Algebra Join, Division, Queries Annotated Notes (208 pages)
		Mod 2 - Lecture 5 - Division Operation, Outer Join in Relational Algebra
		Notes - Mod 2 - Lecture 5 - Division Operation, Outer Join in Relational Algebra Annotated Notes (124 pages)
		Mod 2 - Lecture 6 - Practice Relational Algebra Operators
		Mod 2 - Lecture 7 - Writing & Understanding Relational Algebra Queries
		Mod 2 - Lecture 8 - GATE Questions Relational Algebra
		Notes - Mod 2 - Lecture 6,7,8 Relational Algebra Queries Annotated Notes (276 pages)
		Mod 2 - Lecture 9 - Tuple Relational Calculus TRC
		Mod 2 - Lecture 10 - Tuple Relational Calculus TRC
		Mod 2 - Lecture 11 - Tuple Relational Calculus TRC
		Notes - Mod 2 - Lecture 9,10,11 - Tuple Relational Calculus TRC Annotated Notes (183 pages)
		Mod 2 - Lecture 12 - TRC Practice Questions
		Notes - Mod 2 - Lecture 12 - TRC Practice Questions Annotated Notes (132 pages)
		Mod 2 - Lecture 13 - TRC GATE Questions
		Notes - Mod 2 - Lecture 13 - TRC GATE Questions Annotated Notes (81 pages)
		Mod 2 - Lecture 14 - SQL Basics
		Mod 2 - Lecture 15 - Writing SQL Queries, Union, Except
		Notes - Mod 2 - Lecture 14,15 - SQL Basics Annotated Notes (223 pages)
		Mod 2 - Lecture 16 - SQL Queries using Union, Except, Intersect
		Notes - Mod 2 - Lecture 16 - SQL Queries using Union, Except, Intersect Annotated Notes (116 pages)
		Mod 2 - Lecture 17 - Some Notes on Select, Where Clause
		Mod 2 - Lecture 18 - Aggregate Operators
		Mod 2 - Lecture 19 - Null Values in SQL
		Notes - Mod 2 - Lecture 17,18,19 - Aggregate Operators Annotated Notes (208 pages)
		Mod 2 - Lecture 20 - Group By, Having, Order By Clauses
		Notes - Mod 2 - Lecture 20 - Group By, Having, Order By Clauses Annotated Notes (182 pages)
		Mod 2 - Lecture 21 - SQL Practice Questions 145:00
		Notes - Mod 2 - Lecture 21 - SQL Practice Questions Annotated Notes (108 pages)
		Mod 2 - Lecture 22 - Nested Queries
		Mod 2 - Lecture 23 - Correlated Nested Queries in SQL
		Notes - Mod 2 - Lecture 22,23 - Nested Queries Annotated Notes (222 pages)
		Mod 2 - Lecture 24 - SQL GATE Questions 120:00
		Notes - Mod 2 - Lecture 24 - SQL GATE Questions Annotated Notes (90 pages)
	Module 3 - ER Model
		Mod 3 - Lecture 1 - ER Model 182:00
		Mod 3 - Lecture 2 - Weak Entity Set in ER Model 103:00
		Notes - Mod 3 - Lecture 1,2 ER Model Annotated Notes (216 pages)
		Mod 3 - Lecture 3 - ER Model 261:00
		Notes - Mod 3 - Lecture 3 ER Model Annotated Notes (251 pages)
	Module 4 - Magnetic Disk
		Mod 4 - Lecture 1 - Disk Structure & Performance
		Mod 4 - Lecture 2 - Disk Addressing
		Mod4 - Lecture 1,2 - Disk Structure, Performance, Addressing Annotated Notes
		Mod 4 - Lecture 3 - Disk Scheduling Algorithms
		Mod 4 - Lecture 4 - Disk Scheduling Algorithms Part 2
		Notes - Mod 4 - Lecture 3,4 - Disk Scheduling Algorithms Annotated Notes (133 pages)
	Module 5 - File Organization & Indexing
		Mod 5 - Lecture 1 - File Organization
		Mod 5 - Lecture 2 - Practice File Organization
		Notes - Mod 5 - Lecture 1,2 - File Organization Annotated Notes (188 pages)
		Mod 5 - Lecture 3 - Free Disk Space Management
		Mod 5 - Lecture 3 Annotated Notes Lost
		Notes - Mod5 - Lecture 3 - Disk Free Space Management (64 pages)
		Mod 5 - Lecture 4 - Indexing - Ordered Indexes
		Mod 5 - Lecture 5 - Primary Index
		Mod 5 - Lecture 5 - Primary Index 100:00
		Mod 5 - Lecture 6 - Clustering Index
		Notes - Mod 5 - Lecture 4 ,5,6- Indexing - Ordered Indexes Annotated Notes (177 pages)
		Mod 5 - Lecture 7 - Secondary Index
		Mod 5 - Lecture 8 - Questions on Indexes
		Notes - Mod 5 - Lecture 7,8 - Secondary Index Annotated Notes (191 pages)
		Mod 5 - Lecture 9 - Multilevel Index & ISAM
		Mod 5 - Lecture 10 - GATE Questions on Indexing
		Notes - Mod 5 - Lecture 9,10 - Multilevel Index & ISAM Annotated Notes (134 pages)
		Mod 5 - Lecture 11 - B Tree
		Mod 5 - Lecture 12 - B Tree Insertion
		Mod 5 - Lecture 13 - B Tree Order Questions
		Mod 5 - Lecture 14 - B Tree Structure Questions
		Mod 5 - Lecture 15 - B Tree More Questions
		Notes - Mod 5 - Lecture 11,12,13,14,15 - B Tree Annotated Notes (287 pages)
		Mod 5 - Lecture 16 - B+ Tree
		Notes - Mod 5 - Lecture 16 - B+ Tree Annotated Notes (52 pages)
		Mod 5 - Lecture 17 - B+ Tree Range Search
		Mod 5 - Lecture 18 - B+ Tree Insertion
		Mod 5 - Lecture 19 - B+ Tree Questions
		Notes - Mod 5 - Lecture 17,18,19 - B+ Tree Annotated Notes (219 pages)
	Module 6 - Transaction Management & Recovery
		Mod 6 - Lecture 1 - Transaction, Database Consistency
		Mod 6 - Lecture 2 - Transaction, Read Write Operations
		Mod 6 - Lecture 3 - ACID Properties
		Notes - Mod 6 - Lecture 1,2,3 - Transaction, ACID Properties, Database Consistency Annotated Notes (238 pages)
		Mod 6 - Lecture 4 - Practice ACID Properties, Database Consistency
		Notes - Mod 6 - Lecture 4 - Practice ACID Properties, Database Consistency Annotated Notes (92 pages)
		Mod 6 - Lecture 5 - Serializability Introduction
		Notes - Mod 6 - Lecture 5 - Serializability Introduction Annotated Notes (66 pages)
		Mod 6 - Lecture 6 - Serializability In General
		Notes - Mod 6 - Lecture 6 - Serializability In General Annotated Notes (103 pages)
		Mod 6 - Lecture 7 - Conflict Serializability
		Notes - Mod 6 - Lecture 7 - Conflict Serializability Annotated Notes (144 pages)
		Mod 6 - Lecture 8 - View Serializability
		Notes - Mod 6 - Lecture 8 - View Serializability Annotated Notes (150 pages)
		Mod 6 - Lecture 9 - Recoverability
		Notes - Mod 6 - Lecture 9 - Recoverability Annotated Notes (116 pages)
		Mod 6 - Lecture 10 - General Locking Protocol for Concurrency Control
		Notes - Mod 6 - Lecture 10 - General Locking Protocol for Concurrency Control Annotated Notes (100 pages)
		Mod 6 - Lecture 11 - Two Phase Locking Protocol
		Notes - Mod 6 - Lecture 11 - Two Phase Locking Protocol Annotated Notes (106 pages)
		Mod 6 - Lecture 12 - Two Phase Locking Protocol Variations
		Mod 6 - Lecture 13 - Deadlock Handling
		Notes - Mod 6 - Lecture 12,13 - Two Phase Locking Variations, Deadlock Handling Annotated Notes (158 pages)
		Mod 6 - Lecture 14 - Timestamp Based Protocols for Concurrency Control
		Notes - Mod 6 - Lecture 14 - Timestamp Based Protocols for Concurrency Control Annotated Notes (142 pages)
		Mod 6 - Lecture 15 - Timestamp Protocol 50 Questions 180:00
		Notes - Mod 6 - Lecture 15 - Timestamp Protocol 50 Questions Annotated Notes (240 pages)
	Practice Sets
		Practice Set 1 - Normalization Ullman Questions (44 pages)
		Practice Set 1 - Normalization Live Discussion 120:00
		Practice Set 1 Solution Part 2 - Normalization 134:00
		Notes - Practice Set 1 - Normalization Ullman Questions Annotated Notes (154 pages)
		Practice Set 2 - NPTEL DBMS 2022 Assignment 1 - Normalization, Relational Algebra (11 pages)
		Practice Set 2 - NPTEL DBMS 2022 Assignment 1 - Normalization, Relational Algebra
		Notes - Practice Set 2 - NPTEL DBMS 2022 Assignment 1 - Normalization, Relational Algebra Annotated Notes (70 pages)
		Practice Set 3 - GATE PYQs Magnetic Disk & Disk Scheduling Algorithm (35 pages)

Sign Up Complete your profile

Log In

You may also be interested in

Database Management Systems

₹5900 including 18% GST