Home Courses Database Management and Warehousing

Database Management and Warehousing

Category: Gate DA

Database Management and Warehousing

Category: Gate DA

₹4,000.00 ₹5,000.00

Instructor

Chekuri Srikanth Varma

E-R Model and Relational model
Chapters : 3 Assignments : 0 Completed :

Databases: introduction

1.1

Applied overview

27 mins

1.2

Why not simply use files: Files vs DBMS

30 mins

1.3

Tables and Keys

35 mins

1.4

Integrity Constraints

23 mins

1.5

Solved problems

17 mins

Entity Relationship (ER) Models & Diagrams.

2.1

Introduction to ER diagrams

37 mins

2.2

Cardinality of relationships and constructing minimal tables

60 mins

2.3

Weak and Strong Entities, Self-refernrtial Relationships and constructing Tables

19 mins

2.4

Solved Problems

17 mins

Introduction to Relational models

3.1

Mathematical model of Tables

27 mins

3.2

ER-Relational Model, Constraints and Keys (recap)

11 mins

3.3

Solved Problems

16 mins

Relational Algebra and Tuple Relation Calculus
Chapters : 4 Assignments : 1 Completed :

Relational Algebra

4.1

Introduction to Relational Algebra and Basic Operators

42 mins

4.2

Joins and Division Operators

41 mins

4.3

Solved Problems

23 mins

Tuple Relational Calculus

5.1

Tuple Relational Calculus-I

50 mins

5.2

Safe queries & Domain Relational Calculus

24 mins

5.3

Solved Problems

16 mins

Interactive problem solving session on DBMS-1 (2022)

6.1

Interactive problem solving session on DBMS PART 1 | GATE CS 2022

78 mins

Practice Test 1: Solutions

7.1

Solutions-1

17 mins

7.2

Solutions-2

20 mins

7.3

Solutions-3

12 mins

DBMS Practice Test-1

Structured Query Language( SQL)
Chapters : 10 Assignments : 0 Completed :

SQL: introduction

8.1

[Optional] Overview of Databases for learning SQL.

21 mins

8.2

Why learn SQL?

14 mins

8.3

Execution of an SQL statement.

7 mins

8.4

IMDB dataset

12 mins

8.5

[Optional] Installing MySQL

11 mins

8.6

Load IMDB data

3 mins

SQL Commands

9.1

USE, DESCRIBE, SHOW TABLES

15 mins

9.2

SELECT

19 mins

9.3

LIMIT, OFFSET

10 mins

9.4

ORDER BY

6 mins

9.5

DISTINCT

10 mins

9.6

WHERE, Comparison operators, NULL

13 mins

9.7

Logical Operators

27 mins

9.8

Aggregate Functions: COUNT, MIN, MAX, AVG, SUM

8 mins

9.9

GROUP BY

13 mins

9.10

HAVING

13 mins

9.11

Order of keywords.

4 mins

JOINs

10.1

Join and Natural Join

12 mins

10.2

Inner, Left, Right and Outer joins.

23 mins

Sub Queries/Nested Queries/Inner Queries

11.1

Sub Queries/Nested Queries/Inner Queries

24 mins

Data Manipulation language

12.1

INSERT

6 mins

12.2

UPDATE , DELETE

5 mins

Data definition language

13.1

CREATE TABLE

11 mins

13.2

ALTER: ADD, MODIFY, DROP

4 mins

13.3

DROP TABLE, TRUNCATE, DELETE

3 mins

Data Control Language: GRANT, REVOKE

14.1

Data Control Language: GRANT, REVOKE

10 mins

Additional Learning resources For SQL

15.1

Learning resources

3 mins

SQL: more examples and solved problems

16.1

Solved problems-1

26 mins

16.2

Solved Problems-2

13 mins

16.3

Solved Problems-3

15 mins

Interactive Problem Solving DBMS Part 1

17.1

Interactive Problem Solving DBMS Part 1

63 mins

Functional dependencies, Decomposition and Normalization
Chapters : 5 Assignments : 1 Completed :

Functional Dependencies and Decomposition

18.1

Designing tables in a DB

9 mins

18.2

Functional Dependencies

35 mins

18.3

Attribute Closure, Keys and Solved problems

45 mins

18.4

Functional Dependency Sets and Properties + Solved examples

34 mins

18.5

Minimal/Canonical Covers of FDs + solved problems

40 mins

18.6

Decompositions with solved problems

48 mins

18.7

Dependency preserving decomposition + solved examples

36 mins

Interactive problem solving session on DBMS-2 (2022)

19.1

Interactive problem solving session on DBMS PART 2 | GATE CS 2022

78 mins

Practice Test-2 Solutions

DBMS Practice Test-2

Normalization

21.1

Introduction to Normalisation + 1NF and 2NF +examples

40 mins

21.2

3NF and BCNF

30 mins

21.3

Solved problems + Properties of Normal Forms

44 mins

21.4

Multi-Valued Dependencies and 4NF

34 mins

Interactive Problem Solving DBMS Part 2

22.1

Interactive Problem Solving DBMS Part 2

53 mins

File Structure ( B and B+ trees)
Chapters : 4 Assignments : 1 Completed :

File structures (sequential files, indexing, B and B+ trees)

23.1

Files and Indexing: introduction

46 mins

23.2

B-Trees and B+ Trees with examples

58 mins

23.3

Course Features

Lectures

Duration

Skill level

Language

Assessments

Chekuri Srikanth Varma

QUALIFICATION: Masters from IISC Bangalore PROFESSIONAL EXPIERENCE: 9+ years of Experience( Yahoo Labs, Matherix Labs Co-founder and Amazon)

Database Management and Warehousing

Category: Gate DA

₹4,000.00 ₹5,000.00

Instructor

Chekuri Srikanth Varma

8 Comment(s)
Loading...

TESTIMONIAL'S

Team
Contact Us
Terms & Conditions
Privacy Policy

Youtube
Facebook
Linkedin

Buy Gate CS
Free Videos
Practice Tests
Forum

FAQ'S
Team
Contact Us
Terms & Conditions
Privacy Policy

Youtube
Facebook
Linkedin

Database Management and Warehousing

Database Management and Warehousing

₹4,000.00 ₹5,000.00

Course Features

Database Management and Warehousing

₹4,000.00 ₹5,000.00

8 Comment(s) Loading... Search

Restricted Sessions

8 Comment(s)
Loading...