Undergrad @ IIIT Gwalior. Machine Learning enthusiast. Qualified JEE Mains and Advanced. Gate Aspirant.
Excellent orator.

Surya Pratap Singh

It is about the basics of DBMS. It contains everything one needs to know before moving on to other topics of this subject. It is part 1 of my course series. Part 2 contains relational algebra. It is important for the learners to complete part 1 before moving on to part 2.

GATE (Graduate Aptitude Test in Engineering) 2020 & 2021 complete preparation with best educators. Know about the detailed syllabus, best books, exam pattern and dates, previous year question papers a

GATE - Iconic Pro

English

Introduction to DBMS: GATE

Introduction to DBMS

Database Management System

CS & IT

GATE - CSIT, DSAI & Interview Preparation

GATE, ESE and IIT-JAM

Ace the toughest competitive and government exams in India 

Test Preparation

This course is part 1 of my course series. Part 2 contains relational algebra and is in the Relational Algebra category. The first video for this course contains:

Topics that we'll study in this course; Importance of DBMS for GATE aspirants and for placements; Why you should choose this course of all the courses in this category ;)

Introduction

Definition of DBMS; It's primary functions and facilities; goals of DBMS; And it's place in the overall structure of a system.

Defining DBMS

Various objectives of DBMS; Features it provides; It's advantages over Traditional File System (TFS); Note that we'll study about 'views' in a separate video titled 'views of data and abstraction'.

Objective of DBMS

Concept of views; Schema and Sub-schema; Diagrammatic representation of Abstraction in DBMS.

Views of Data and Abstraction

Concept of Schema and Data Independence; (Note that in the last example, many more constraints can be inferred like age can be a positive non-zero integer and less than 100 years, etc.)

Schema & Data Independence

Types of DBMS languages; types of users of DBMS; concept of data dictionary.

Database Languages; Database Users; Data Dictionary

Description of the entire structure of DBMS in a simple way (NOTE: the first slide is not of this course so please skip that one.)

Overall structure of DBMS

What is DATABASE MANAGER and what are it's functions; Steps taken to access the Database (NOTE: the first slide is not of this course so plz skip that one)

Database Manager & Database access steps

Concept of tables and relations with example; Characteristics of a relation.

Tables and Relations

Concept of super key, candidate key, primary key and alternate key with examples.

Concept of Keys

Key constraint; Entity Integrity constraint; Referential Integrity constraint with the types of deletion to protect Referential Integrity; Attribute Integrity constraint. All are explained with suitable examples.

Integrity Constraint Rule

Important previous year's GATE questions based on whatever is taught previously.

Important GATE questions

We will talk about how to prepare for this subject in order to score full marks in GATE exam. ( Note: the first slide is not of this course so please skip that one.)

What to study after this course.

Code HELLOSONU01 | 8+ Years Teaching Exp. in GATE CS IT & GATE DS AI on Unacademy | Mentored 2 Lakh+ Students | Produced Rankers Under 500

Sweta Kumari

This course discusses Database Management System for GATE examination.

(Hindi) MCQs on Database Management System for GATE 2018

This course will cover NOSQL Databases in 60 Minutes.

(Hindi) Learn NOSQL Databases in 60 Minutes

This course will cover Big Data Tutorial in 60 Minutes. The course will be GATE Aspirants.

(Hindi) Big Data 60 Minutes Tutorial

I am grace.I am an MTECH Degree holder in computer and  IT. UGCNET qualified. I am having a teaching experience of 10 yrs.

Grace Maickel

This Course covers to discuss DBMS in detail for GATE 2020.

Database Management System: GATE 2020

This course will cover complete Concepts of ER Model with relevant PYQs.

(Hindi) ER Model Concepts With PYQs - GATE (CS and IT)

In this course, Sweta Kumari will cover 25 Awesome Tricks for Finding Keys in Databases.

Lessons

13 lessons • 1h 36m

Invalid Date

NaN

Introduction

Invalid Date

NaN

Defining DBMS

Invalid Date

NaN

Objective of DBMS

Invalid Date

NaN

Views of Data and Abstraction

Invalid Date

NaN

Schema & Data Independence

Invalid Date

NaN

Database Languages; Database Users; Data Dictionary

Invalid Date

NaN

Overall structure of DBMS

Invalid Date

NaN

Database Manager & Database access steps

Invalid Date

NaN

Tables and Relations

Invalid Date

NaN

Concept of Keys

+ See all lessons