There are no items in your cart
Add More
Add More
Item Details | Price |
---|
Learn, Understand, Discuss. "GO" for the Best.
star star star star star | 5.0 (12 ratings) |
Instructor: Deepak Poonia (MTech IISc Bangalore, GATE CSE AIR 53; 67; 107)
Language: English
Validity Period: 365 days
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
Module 1 - The Relational Model & Normalization | |||
About Lecture 1 | |||
Lecture 1 - Introduction to DBMS, Data Models, Design Process 104:00 | |||
Annotated Notes - Lecture 1 - Introduction to DBMS, Data Models (68 pages) | |||
Lecture 2A - The Relational Model - Concepts & Terminology 39:00 | |||
Lecture 2B - The Relational Model - Why Table is called Relation? 28:00 | |||
Lecture 2C - The Relational Model - Null Values 11:00 | |||
GATE 2023 Question | |||
Lecture 2D - The Relational Model - Keys - Candidate Key, Primary Key, Super Key 57:00 | |||
Annotated Notes - Lecture 2 - The Relational Model (111 pages) | |||
Lecture 2E - Practice Questions on Keys 21:00 | |||
Annotated Notes - Lecture 2E - Practice Questions on Keys (22 pages) | |||
(OPTIONAL) Lecture 3 - SQL - DDL & DML | |||
Annotated Notes - (OPTIONAL) Lecture 3 - SQL - DDL & DML (110 pages) | |||
Lecture 4A - Integrity Constraints in Relational Model 53:00 | |||
Lecture 4B - Referential Integrity Constraints - Foreign Key 72:00 | |||
Lecture 4C - Actions Taken by DBMS to Enforce Referential Integrity Constraints 52:00 | |||
Annotated Notes - Lecture 4A - Integrity Constraints in Relational Model (160 pages) | |||
Lecture 5A - Functional Dependency | |||
Annotated Notes - Lecture 5A - Functional Dependency (121 pages) | |||
Lecture 5B - Functional Dependency Laws, Closure of Attribute Set | |||
Annotated Notes - Lecture 5B - Functional Dependency Laws, Closure of Attribute Set (167 pages) | |||
Lecture 5C - Practice - Finding Candidate Keys | |||
Annotated Notes - Lecture 5C - Practice - Finding Candidate Keys (92 pages) | |||
Lecture 5D - Functional Dependency - Inference & Equivalence | |||
Annotated Notes - Lecture 5D - Functional Dependency - Inference & Equivalence (95 pages) | |||
Lecture 5E - Minimal Cover of Functional Dependencies | |||
Annotated Notes - Lecture 5E - Minimal Cover of Functional Dependencies (140 pages) | |||
Weekly Quiz 1 - Relational Model - ALL NIELIT Exam PYQs | |||
Weekly Quiz 2 - Functional Dependency | |||
Lecture 6A - Normal Forms - Partial Functional Dependency, Transitive FD 91:00 | |||
Annotated Notes - Lecture 6A - Normal Forms - Partial, Transitive FD (85 pages) | |||
Lecture 6B - Normal Forms - 1NF, 2NF 81:00 | |||
Annotated Notes - Lecture 6B - Normal Forms - 1NF, 2NF (109 pages) | |||
Lecture 6C - Normal Forms - 3NF Third Normal Form 33:00 | |||
Lecture 6D - Normal Forms - Practice Questions 3NF 29:00 | |||
Annotated Notes - Lecture 6C-6D - Normal Forms - 3NF (65 pages) | |||
Lecture 6E - Normal Forms - BCNF 14:00 | |||
GATE IT 2005 - Normalization Question | |||
GATE CSE 1987 - Functional Dependency Question | |||
GATE CSE 2020 Question - 3NF But Not BCNF | |||
GATE CSE 2007, 1990 - Normal Forms Questions | |||
GATE CSE 2012 - 3NF, BCNF Question | |||
Annotated Notes - Lecture 6E - Normal Forms - BCNF (64 pages) | |||
Lecture 7A - Normalization & Decomposition - Lossless, Lossy 119:00 | |||
Lecture 7B - Practice Questions - Decomposition - Lossless, Lossy 17:00 | |||
Lecture 7C - Decomposition - Dependency Preservation 81:00 | |||
Annotated Notes - Lecture 7A-7C - Decomposition (201 pages) | |||
Lecture 7D - Non-Binary Decomposition & Chase Test | |||
Annotated Notes - Lecture 7D - Non-Binary Decomposition & Chase Test (185 pages) | |||
Lecture 8A - 2NF Decomposition 35:00 | |||
Annotated Notes - Lecture 8A - 2NF Decomposition (36 pages) | |||
Lecture 8B - Understanding Redundancies - Due to FDs & MVDs 71:00 | |||
Lecture 8C - 3NF, BCNF Decomposition 173:00 | |||
Annotated Notes - Lecture 8B-8C - Understanding Redundancies, 3NF, BCNF Decomposition (239 pages) | |||
Lecture 8D - GATE PYQs on 3NF, BCNF Decomposition 112:00 | |||
Annotated Notes - Lecture 8D - GATE PYQs on 3NF, BCNF Decomposition (117 pages) | |||
About Lecture 9 | |||
(OPTIONAL) Lecture 9 - Physical, Logical Data Independence 133:00 | |||
Annotated Notes - Lecture 9 - Physical, Logical Data Independence (88 pages) | |||
GATE PYQs & Standard Practice Questions | |||
Weekly Quiz 3 - Normalization & Relational Model | |||
Weekly Quiz 4 - Normal Forms | |||
Weekly Quiz 5 - Normalization | |||
Weekly Quiz 6 - Normalization | |||
Module 2 - Queries - Relational Algebra | |||
Lecture 1 - Relational Algebra - Selection, Projection 149:00 | |||
Lecture 2 - Relational Algebra - Set Operations 100:00 | |||
Annotated Notes - Lecture 1,2 - Relational Algebra (248 pages) | |||
Lecture 3 - Relational Algebra - Inner Join Operations 137:00 | |||
Lecture 4 - Relational Algebra - Division Operation 104:00 | |||
Annotated Notes - Lecture 3,4 - Relational Algebra - Join, Division (208 pages) | |||
Lecture 5 - Division Operation, Outer Join in Relational Algebra 120:00 | |||
Annotated Notes - Lecture 5 - Division Operation, Outer Join in Relational Algebra (124 pages) | |||
Lecture 6 - Practice - Relational Algebra Operators 101:00 | |||
Lecture 7 - Writing & Understanding Relational Algebra Queries 128:00 | |||
Lecture 8 - GATE PYQs - Relational Algebra | |||
Annotated Notes - Lecture 6,7,8 - Relational Algebra Queries (276 pages) | |||
Weekly Quiz 1 - Relational Algebra | |||
Weekly Quiz 2 - Relational Algebra | |||
Module 3 - Queries - Tuple Relational Calculus TRC | |||
Lecture 1 - Tuple Relational Calculus TRC 65:00 | |||
Lecture 2 - Tuple Relational Calculus TRC 94:00 | |||
Lecture 3 - Tuple Relational Calculus TRC 92:00 | |||
Annotated Notes - Lecture 1-3 - Tuple Relational Calculus TRC (183 pages) | |||
Lecture 4 - TRC Practice Questions 146:00 | |||
Annotated Notes - Lecture 4 - TRC Practice Questions (132 pages) | |||
GATE CSE 1999 - Tuple Relational Expression Question 26:00 | |||
GATE CSE 2002 - Tuple Relational Calculus Question 3:00 | |||
GATE CSE 2007 - Tuple Relational Calculus Question 11:00 | |||
GATE CSE 2008 - Tuple Relational Calculus Question 4:00 | |||
GATE IT 2006 - TRC Question | |||
Module 4 - Queries - SQL | |||
SQL - Complete Summary & GATE PYQs | |||
Lecture 1 - SQL Basics 119:00 | |||
Lecture 2 - Writing SQL Queries, Union, Except 87:00 | |||
Annotated Notes - Lecture 1-2 - SQL Basics (223 pages) | |||
Lecture 3 - SQL Queries using Union, Except, Intersect 117:00 | |||
Annotated Notes - Lecture 3 - SQL Queries using Union, Except, Intersect (116 pages) | |||
Lecture 4 - Some Notes on Select, Where Clause 76:00 | |||
Weekly Quiz 1 - SQL Basics | |||
Lecture 5 - Aggregate Operators 56:00 | |||
Lecture 6 - Null Values in SQL 113:00 | |||
Annotated Notes - Lecture 4-6 - Aggregate Operators (208 pages) | |||
Lecture 7 - Group By, Having, Order By Clauses 210:00 | |||
Annotated Notes - Lecture 7 - Group By, Having, Order By Clauses (182 pages) | |||
Lecture 8 - Nested Queries 107:00 | |||
Lecture 9 - Correlated Nested Queries in SQL 112:00 | |||
Annotated Notes - Lecture 8-9 - Nested Queries (222 pages) | |||
SQL - Summary & GATE PYQs - Complete Analysis | |||
Weekly Quiz 2 - SQL | |||
Weekly Quiz 3 - SQL | |||
Module 5 - Magnetic Disk | |||
Lecture 1 - Disk Structure & Performance 169:00 | |||
Lecture 2 - Disk Addressing 119:00 | |||
Annotated Notes - Lecture 1,2 - Disk Structure, Performance, Addressing (172 pages) | |||
Lecture 3 - Disk Scheduling Algorithms 92:00 | |||
Lecture 4 - Disk Scheduling Algorithms Part 2 95:00 | |||
Annotated Notes - Lecture 3,4 - Disk Scheduling Algorithms (133 pages) | |||
Module 6 - File Organization & Indexing | |||
Lecture 1 - File Organization 163:00 | |||
Lecture 2 - Practice Questions - File Organization 124:00 | |||
Annotated Notes - Lecture 1,2 - File Organization (188 pages) | |||
Lecture 3 - Free Disk Space Management 135:00 | |||
Lecture 3 Annotated Notes | |||
Slides - Lecture 3 - Disk Free Space Management (64 pages) | |||
Lecture 4 - Indexing - Ordered Indexes 71:00 | |||
Lecture 5 - Primary Index 106:00 | |||
Lecture 6 - Clustering Index 63:00 | |||
Annotated Notes - Lecture 4 ,5,6- Indexing - Ordered Indexes (177 pages) | |||
Lecture 7 - Secondary Index 136:00 | |||
Lecture 8 - Practice Questions on Indexes 104:00 | |||
Annotated Notes - Lecture 7,8 - Secondary Index (191 pages) | |||
Lecture 9 - Multilevel Index & ISAM 147:00 | |||
Lecture 10 - GATE Questions on Indexing 76:00 | |||
Annotated Notes - Lecture 9,10 - Multilevel Index & ISAM (134 pages) | |||
Lecture 11 - B Tree 117:00 | |||
Lecture 12 - B Tree Insertion 144:00 | |||
Lecture 13 - B Tree Order Questions 70:00 | |||
Lecture 14 - B Tree Structure Questions 81:00 | |||
Lecture 15 - B Tree More Questions 34:00 | |||
Annotated Notes - Lecture 11-15 - B Tree (287 pages) | |||
Lecture 16 - B+ Tree 59:00 | |||
Annotated Notes - Lecture 16 - B+ Tree (52 pages) | |||
Lecture 17 - B+ Tree Range Search 97:00 | |||
Lecture 18 - B+ Tree Insertion 52:00 | |||
Lecture 19 - B+ Tree Questions 125:00 | |||
Annotated Notes - Lecture 17-19 - B+ Tree (219 pages) | |||
Module 7 - Transaction Management & Recovery | |||
About this Module | |||
Lecture 1 - Transaction, Database Consistency 111:00 | |||
Lecture 2 - Transaction, Read Write Operations 114:00 | |||
Lecture 3 - ACID Properties 86:00 | |||
Annotated Notes - Lecture 1-3 - Transaction, ACID Properties, Database Consistency (238 pages) | |||
Lecture 4 - Practice ACID Properties, Database Consistency 151:00 | |||
Annotated Notes - Lecture 4 - Practice ACID Properties, Database Consistency (92 pages) | |||
Lecture 5 - Serializability Introduction 101:00 | |||
Annotated Notes - Lecture 5 - Serializability Introduction (66 pages) | |||
Lecture 6 - Serializability In General 119:00 | |||
Annotated Notes - Lecture 6 - Serializability In General (103 pages) | |||
Lecture 7 - Conflict Serializability 148:00 | |||
Annotated Notes - Lecture 7 - Conflict Serializability (144 pages) | |||
Lecture 8 - View Serializability 182:00 | |||
Annotated Notes - Lecture 8 - View Serializability (150 pages) | |||
Lecture 9 - Recoverability 145:00 | |||
Annotated Notes - Lecture 9 - Recoverability (116 pages) | |||
Lecture 10 - General Locking Protocol for Concurrency Control 109:00 | |||
Annotated Notes - Lecture 10 - General Locking Protocol for Concurrency Control (100 pages) | |||
Lecture 11 - Two Phase Locking Protocol 123:00 | |||
Annotated Notes - Lecture 11 - Two Phase Locking Protocol (106 pages) | |||
Lecture 12 - Two Phase Locking Protocol Variations 90:00 | |||
Lecture 13 - Deadlock Handling 74:00 | |||
Annotated Notes - Lecture 12,13 - Two Phase Locking Variations, Deadlock Handling (158 pages) | |||
Lecture 14 - Timestamp Based Protocols for Concurrency Control 147:00 | |||
Annotated Notes - Lecture 14 - Timestamp Based Protocols for Concurrency Control (142 pages) | |||
Lecture 15 - 50 Questions on Timestamp Protocol 180:00 | |||
Annotated Notes - Lecture 15 - Timestamp Protocol 50 Questions (240 pages) | |||
Module 8 - ER Model | |||
Lecture 1 - ER Model 182:00 | |||
Lecture 2 - Weak Entity Set in ER Model 103:00 | |||
Annotated Notes - Lecture 1,2 - ER Model (216 pages) | |||
Lecture 3 - ER Model to Relational Model Conversion 258:00 | |||
Annotated Notes - Lecture 3 - ER Model (251 pages) | |||
Students' Hand Written Notes | |||
Handwritten Notes by Karan Agrawal (AIR 102 GATE CS 2024) - Databases | |||
Notes by Quantum City (AIR 107, GATE CS 2024, Shreyas Rathod) - DBMS Notes (79 pages) |
After successful purchase, this item would be added to your courses.
You can access your courses in the following ways :