I am Nikita Shadija Currently pursuing Btech degree IT from Medicaps University Indore. I did my schooling from St. Raphaels H.S school.  

Nikita Shadija

Nikita Shadija in this course is going to teach about database management system . In dbms we are going to learn about how data is related to each other. A database management system is basically collection of interrelated data. we are also going to learn about different types of models from which we will mainly focus on ER model and relational model. we are going to learn about transactions and few sql commands

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

DBMS for 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

Introduction to dbms- what is dbms, dbms applications, data abstraction, database languages and functions of database administrator

Introduction to Database Management Systems

This lesson include data model , different types of data model and some of the concepts of ER model- entity , entity set , attributes, types of attributes, relationship, relationships sets , mapping cardanilities and ER notations

Data Models-ER Model

This lesson include some of the ER concepts like keys, degree of relationship, participation  constraints, types of entity sets and extended ER functions

Some for concepts ER Model

This lesson include extended features of ER model like specialization , Generalization, Aggreagtion  and Attribute Inheritance and an Example of ER model

Extended ER Functions

This lesson includes introduction to relational model , concepts of relational model and constraints related to relational model

Relational Model

This lesson include relational algebra which contains  various operations like select, project, union , intersection etc and various join operations

Relational Algebra

This lesson include differnet type of keys , relational calculus and the two different types of relational calculus- tuple relational calculus and domain relational calculus

Relational Model- relational calculus

This lesson include the steps of how to covert an Er model into a relational model. It's a seven step process.

Mapping ER model into Relational Model

This lesson include functional dependency and its types, Attribute closure,  prime and non prime attributes, rules and canonical cover.

Database design-functional dependencies

This lesson include  Normalization, different types of anomalies, Decomposition and its types and normal forms

Database design- Normalization

This particular lesson explains SQl that is structured query language. It main focuses on ddl command of SQl . Ddl commands of sql are create, drop and alter. There are many more but these three are the most  important ddl commands of sql.

Sql-part 1

This lesson include DML (data manipulation language) commands of sql .  They are select/from/where , insert into/values ,  update/set/where and delete from/where comand.

Sql - part 2

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

12 lessons • 1h 59m

Invalid Date

NaN

Introduction to Database Management Systems

Invalid Date

NaN

Data Models-ER Model

Invalid Date

NaN

Some for concepts ER Model

Invalid Date

NaN

Extended ER Functions

Invalid Date

NaN

Relational Model

Invalid Date

NaN

Relational Algebra

Invalid Date

NaN

Relational Model- relational calculus

Invalid Date

NaN

Mapping ER model into Relational Model

Invalid Date

NaN

Database design-functional dependencies

Invalid Date

NaN

Database design- Normalization

+ See all lessons