Rs. 499

Career Builder: Fundamentals of Database Management Systems

Learn how to handle Database Management Systems (DBMS) and build a strong foundation to your career as a software professional.

03h:50m
Lifetime access

About the Topic:

Man has already entered into an age where information greatly influences consumerism and hence businesses. With such emphasis on information, it is not surprising to note that many consider data to be the new fuel. With extremely large quantities of data generated every minute, efficiently managing this data in order to derive vital information becomes critical. This is where Database Management Systems (DBMSs) come into the picture. A DBMS is essentially a collection of programs that enables one to store, modify, and extract information from a database.

Read more

Course Objectives

In this tutorial, you will learn about Database Management Systems from scratch.

  • The first two sections of this course will introduce you to file systems, databases and database design.
  • In section three, you will learn to work with MySQL in order to create and work with a database. The final section deals with Normalization and Decomposition in Database Systems.
  • By subscribing to this course, you are sure to develop a competitive edge over others. This would also help you eventually in your role as a software engineer.

Read more

Pre-requisites and Target Audience:

There are no prerequisites to take this course. T This beginner's course is suitable for anyone who wants to learn to handle Database Management System and thereby enhance their career prospects in the software industry.

Course Plan


1. Intro to File System and Databases
5 videos  · 1 test
File system processing 03:08

Databases and DBMS 02:00

DBMS Architecture and Features 05:03

ER Model and Notations 15:14

Test 10:00
2. Database Design
6 videos  · 1 test
Design Issues 05:06

Types of keys 03:26

Tabular representation of ER -1 04:55

Tabular representation of ER -2 09:08

Tabular representation of ER -3 07:58

Test 15:00
3. SQL
8 videos  · 1 test
Intro to MySQL 02:28

Basic Querying-1 12:49

Basic Querying-2 11:08

Taking Input in Query 02:19

Order By and group by 05:18

Sql Functions-1 07:25

Joins 14:22

Test 10:00
4. Decomposition and Normalization
4 videos  · 1 test
Anomalies 04:07

Functional dependency 03:02

2NF 3NF and BCNF 04:50

Test 15:00
5. Advanced SQL
5 videos  · 1 test
Procedures 01:49

Cursors 05:46

Transactions 08:19

Concurrency Control 05:25

Test 12:00