Simplified Approach To Dbms

  1. Home
  2. Database-management
  3. Simplified Approach To Dbms

Tags: Database Management

Simplified way to learn DBMS

Last updated 2022-01-10 | 4.4

- Understanding the meaning of term DBMS
- File Based System Vs. Data Base Management System
- Hierarchical
- Network and Relational Data Models

What you'll learn

Understanding the meaning of term DBMS
File Based System Vs. Data Base Management System
Hierarchical
Network and Relational Data Models
Concept of different types of keys like Super Key
Candidate Key
Primary Key and Foreign Key
Designing of Entity Relation Model
Conversion of ER Model to Tables
Normalization of Database
Transaction Management
Concurrency Control
SQL: Creation of Tables
SQL: Alteration of Tables
SQL: Insertion
Updation
Deletion and Retrieval of Data
SQL: Joining of Tables
SQL: Grouping of Data
PL/SQL:: Get chance to enroll in PL/SQL Course completely free after completion of this course

* Requirements

* Zero prior technical experience is required!
* All you need is a computer/Mobile Phone with good Internet connectivity!

Description

  • Understanding the meaning of term DBMS
  • File Based System Vs. Data Base Management System
  • Hierarchical, Network and Relational Data Models
  • Concept of different types of keys like Super Key, Candidate Key, Primary Key and Foreign Key
  • Designing of Entity Relation Model
  • Conversion of ER Model to Tables
  • Normalization of Database
  • Transaction Management
  • Concurrency Control
  • SQL: Creation of Tables
  • SQL: Alteration of Tables
  • SQL: Insertion, Updation, Deletion and Retrieval of Data
  • SQL: Joining of Tables
  • SQL: Grouping of Data
  • PL/SQL:: Get chance to enroll in PL/SQL Course completely free after completion of this course

Course content

15 sections • 93 lectures

Introduction to DBMS 4 lectures

Introduction Preview 08:59

File based system versus Centralized database approach Preview 11:47

Advantages and Disadvantages of DBMS Preview 09:58

Reading Material for DBMS Preview 21:24

Three level architecture of DBMS 4 lectures

Three level architecture of DBMS Preview 10:33

Data Independence Preview 07:49

Mapping between the views Preview 05:48

Reading material for three level architecture Preview 08:54

Data Models 3 lectures

Data Models: Hierarchical Data Model Part I Preview 15:42

Hierarchical Data Model Operations Preview 24:01

Reading Material for Data Models Preview 07:04

Data Model - Network Data Model 6 lectures

Introduction to Network Data Model Preview 16:44

Network Data Model - Insert Operation Preview 07:13

Network Data Model - Update Operation Preview 03:58

Network Data Model - Delete Operation Preview 06:09

Network Data Model - Retrieve Operation Preview 10:40

Reading Material for Data Model - Network Data Model Preview 04:15

Relational Data Model 5 lectures

Relational Data Model - Insert Operation Preview 07:54

Relational Data Model - Update Operation Preview 03:15

Relational Data Model - Delete Operation Preview 05:16

Relational Data Model - Retrieve Operation Preview 06:18

Reading Material for Relational Data Model Preview 06:59

ER Model 12 lectures

Need of ER Preview 05:25

Basics Constructs of ER Preview 07:44

Types of Attributes Preview 08:11

Degree of Relationship Preview 02:19

How to Design ER Model: Part-1 Preview 11:00

How to Design ER Model: Part-2 Preview 12:57

How to Design ER Model: Part-3 Preview 07:45

Strong and Weak Entity Set: Part-1 Preview 08:13

Strong and Weak Entity Set: Part-2 Preview 06:15

Total and Partial Partcipation Preview 05:17

Cardinality of a Relationship Preview 08:23

Cardinality and Participation of a Relationship Preview 18:50

Conversion of ER Diagram to Relational Tables 8 lectures

Handling of Entity Sets Preview 04:11

Handling of Composite Attribute Preview 07:15

Handling of Multi-Value Attributes Preview 13:58

Handling of Derived Attribute Preview 08:36

Handling of Many to Many of Relationships Preview 12:40

Handling of Many to One Type of Relationship Preview 09:44

Handling of One to Many Type of Relationship Preview 07:06

Handling of One to One Type of Relationship Preview 13:58

Normalization for Refinement of Database 15 lectures

Normalization Process Preview 07:25

Objectives of Normalization Preview 04:27

Concept of Functional Dependence Preview 14:40

Concept of Fully Functional Dependence Preview 14:10

Understanding the Dataset Preview 14:26

First Normal Form: Part-1 Preview 11:59

First Normal Form: Part-2 Preview 09:53

Anomalies of First Normal Form Preview 14:08

Second Normal Form Preview 14:24

Second Normal Form: Rule of Decomposition Preview 11:10

Assignment Based on Anomalies of Second Normal Form Preview 02:33

Anomalies of Second Normal Form Preview 05:37

Third Normal Form Preview 16:50

BCNF Normal Form Preview 34:49

Fourth Normal Form Preview 19:06

Transaction Management 5 lectures

Concept of Transaction Preview 04:01

Operations of a Transaction Preview 16:08

Properties of a Transaction Preview 23:08

States of a Transaction Preview 10:05

Conflicting Operations Preview 18:38

Recovery Management 4 lectures

Concept of Recovery Managment Preview 10:02

Concept of Log Based Recovery Preview 07:33

Immediate Database Modification: Part-1 Preview 13:16

Immediate Database Modification: Part-2 Preview 17:12

SQL - Basics of SQL 8 lectures

Introduction to SQL Preview 07:14

Performing Basic Operations with SQL Preview 12:59

Live SQL: Working on Oracle without installing it Preview 04:03

More on SELECT Statement Preview 20:49

Inbuilt Functions of SQL Preview 04:40

Lab Assignment-1 Preview 00:20

Lab Assignment-2 Preview 00:41

Quiz 1

Creation of Tables with Constraints 8 lectures

Need of Constraints Preview 04:43

Not Null, Unique and Primary Key Constraint Preview 11:04

CHECK constraints Preview 06:37

FOREIGN KEY constraints Preview 07:21

Demonstration of Foreign Key constraints Preview 09:34

DEFAULT Constraint and Accessing Constraint information Preview 05:16

Lab Assignment-3 Preview 00:55

Quiz 2

SQL - Alteration of Tables 2 lectures

Alter Table - Add option Preview 06:56

Alter Table - Modify and Drop Option Preview 07:39

SQL - Joins 5 lectures

Joining of tables and its types Preview 09:12

OUTER join Preview 06:26

SELF join Preview 10:20

Practicing Join Queries based on Supplier-Part Database Preview 27:45

Quiz 3

SQL- Grouping of Data 4 lectures

Need of Grouping of Data Preview 11:29

Grouping on More than one column Preview 13:12

Having Clause of Group By Statement Preview 12:24

Quiz 4