Simplified Approach to DBMS: The Complete Package

Simplified Approach to DBMS: The Complete Package, available at $39.99, has an average rating of 4.45, with 90 lectures, 4 quizzes, based on 426 reviews, and has 3047 subscribers.

You will learn about 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 This course is ideal for individuals who are Student taking DBMS Course or BE, BTech, MTech, MCA, BCA, MSc Students or Students preparing for placements and interviews or Students preparing for GATE, UGC and other competitive exams It is particularly useful for Student taking DBMS Course or BE, BTech, MTech, MCA, BCA, MSc Students or Students preparing for placements and interviews or Students preparing for GATE, UGC and other competitive exams.

Enroll now: Simplified Approach to DBMS: The Complete Package

Summary

Title: Simplified Approach to DBMS: The Complete Package

Price: $39.99

Average Rating: 4.45

Number of Lectures: 90

Number of Quizzes: 4

Number of Published Lectures: 90

Number of Published Quizzes: 4

Number of Curriculum Items: 94

Number of Published Curriculum Objects: 94

Original Price: ₹799

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Student taking DBMS Course
BE, BTech, MTech, MCA, BCA, MSc Students
Students preparing for placements and interviews
Students preparing for GATE, UGC and other competitive exams

Target Audiences

Student taking DBMS Course
BE, BTech, MTech, MCA, BCA, MSc Students
Students preparing for placements and interviews
Students preparing for GATE, UGC and other competitive exams

Databases are the spine of all major applications today! Whether internet-based, financial, social, administrative or intranet applications, without databases they all are namesake! Oracle, Microsoft SQL Server, have emerged as leading commercial systems whereas MySQL, PostgreSQL have led the open-source.

While DBMSs differ profoundly, they resemble a common set of models, design paradigms and a Structured Query Language (SQL). With this course, our main intention is to cover these details.

Who is the course for?

This course is designed for learners who are:

beginners in this field
want to prepare for University examinations
want to prepare for placement interviews
software professionals who want to quick start there carrier as a Database expert

in a short time span.

What topics will this course cover?

Basics of DBMSs
Comparison of DBMS with File Based System
Three Level Architecture of DBMS
Different models of DBMS- Relational, Hierarchical, Network Data models with Data operations on them.
Understanding Primary, Foreign Key, Super Key, Candidate key and Artificial key
Designing ER Model
Concept of Entity, Entity Set, Strong and weak entity, Total and Partial Dependence
Conversion of ER Model to Tables
Learn Normalization from scratch.
Concept of Functional Dependence, Fully Functional Dependence, Transitive Dependence and Multi Value Dependence
Transaction Management
Full SQL: Creation of Tables
Insertion, Updation and Deletion of Data
Alter Table
Joining of Tables
Cartesian Product, Inner Join, Outer Join and Self Join
Grouping of Data in SQL

Course Curriculum

Chapter 1: Introduction to DBMS

Lecture 1: Introduction

Lecture 2: File based system versus Centralized database approach

Lecture 3: Advantages and Disadvantages of DBMS

Lecture 4: Reading Material for DBMS

Chapter 2: Three level architecture of DBMS

Lecture 1: Three level architecture of DBMS

Lecture 2: Data Independence

Lecture 3: Mapping between the views

Lecture 4: Reading material for three level architecture

Chapter 3: Data Models

Lecture 1: Data Models: Hierarchical Data Model Part I

Lecture 2: Hierarchical Data Model Operations

Lecture 3: Reading Material for Data Models

Chapter 4: Data Model – Network Data Model

Lecture 1: Introduction to Network Data Model

Lecture 2: Network Data Model – Insert Operation

Lecture 3: Network Data Model – Update Operation

Lecture 4: Network Data Model – Delete Operation

Lecture 5: Network Data Model – Retrieve Operation

Lecture 6: Reading Material for Data Model – Network Data Model

Chapter 5: Relational Data Model

Lecture 1: Relational Data Model – Insert Operation

Lecture 2: Relational Data Model – Update Operation

Lecture 3: Relational Data Model – Delete Operation

Lecture 4: Relational Data Model – Retrieve Operation

Lecture 5: Reading Material for Relational Data Model

Chapter 6: ER Model

Lecture 1: Need of ER

Lecture 2: Basics Constructs of ER

Lecture 3: Types of Attributes

Lecture 4: Symbols used in ER Model

Lecture 5: Degree of Relationship

Lecture 6: How to Design ER Model: Part-1

Lecture 7: How to Design ER Model: Part-2

Lecture 8: How to Design ER Model: Part-3

Lecture 9: Strong and Weak Entity Set: Part-1

Lecture 10: Strong and Weak Entity Set: Part-2

Lecture 11: Total and Partial Partcipation

Lecture 12: Cardinality of a Relationship

Lecture 13: Cardinality and Participation of a Relationship

Chapter 7: Conversion of ER Diagram to Relational Tables

Lecture 1: Handling of Entity Sets

Lecture 2: Handling of Composite Attribute

Lecture 3: Handling of Multi-Value Attributes

Lecture 4: Handling of Derived Attribute

Lecture 5: Handling of Many to Many of Relationships

Lecture 6: Handling of Many to One Type of Relationship

Lecture 7: Handling of One to Many Type of Relationship

Lecture 8: Handling of One to One Type of Relationship

Chapter 8: Normalization for Refinement of Database

Lecture 1: Normalization Process

Lecture 2: Objectives of Normalization

Lecture 3: Concept of Functional Dependence

Lecture 4: Concept of Fully Functional Dependence

Lecture 5: Understanding the Dataset

Lecture 6: First Normal Form: Part-1

Lecture 7: First Normal Form: Part-2

Lecture 8: Anomalies of First Normal Form

Lecture 9: Second Normal Form

Lecture 10: Second Normal Form: Rule of Decomposition

Lecture 11: Assignment Based on Anomalies of Second Normal Form

Lecture 12: Anomalies of Second Normal Form

Lecture 13: Third Normal Form

Lecture 14: BCNF Normal Form

Lecture 15: Fourth Normal Form

Chapter 9: Transaction Management

Lecture 1: Concept of Transaction

Lecture 2: Operations of a Transaction

Lecture 3: Properties of a Transaction

Lecture 4: States of a Transaction

Lecture 5: Conflicting Operations

Chapter 10: SQL – Basics of SQL

Lecture 1: Introduction to SQL

Lecture 2: Performing Basic Operations with SQL

Lecture 3: Live SQL: Working on Oracle without installing it

Lecture 4: More on SELECT Statement

Lecture 5: Inbuilt Functions of SQL

Lecture 6: Lab Assignment-1

Lecture 7: Lab Assignment-2

Lecture 8: Concept of Recovery Managment

Lecture 9: Concept of Log Based Recovery

Lecture 10: Immediate Database Modification: Part-1

Lecture 11: Immediate Database Modification: Part-2

Chapter 11: Creation of Tables with Constraints

Lecture 1: Need of Constraints

Lecture 2: Not Null, Unique and Primary Key Constraint

Lecture 3: CHECK constraints

Lecture 4: FOREIGN KEY constraints

Lecture 5: Demonstration of Foreign Key constraints

Lecture 6: DEFAULT Constraint and Accessing Constraint information

Lecture 7: Lab Assignment-3

Chapter 12: SQL – Alteration of Tables

Lecture 1: Alter Table – Add option

Lecture 2: Alter Table – Modify and Drop Option

Chapter 13: SQL – Joins

Lecture 1: Joining of tables and its types

Lecture 2: OUTER join

Instructors

Parteek Bhatia
Professor, CSED, TIET, Patiala, India

Rating Distribution

1 stars: 9 votes
2 stars: 5 votes
3 stars: 41 votes
4 stars: 123 votes
5 stars: 248 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu