• No products in the cart.

0

Application software requires data to be stored permanently. Databases provide the facility to store data permanently.
The module is designed to equip a learner to acquire knowledge of the current trend and technologies of Databases.

COMING SOON
Introduction

Application software requires data to be stored permanently. Databases provide the facility to store data permanently. Further, databases provide the functionality to maintain and retrieve data. Depending upon different types of data storage, retrieval, and processing, different types of databases are required. This module is designed with a view to equipping the learner with two types of databases, RDBMS and NoSQL databases.

Objective

The module is designed to equip a learner to acquire knowledge of the current trend and technologies of Databases. It provides a theoretical background as well as in-depth knowledge of Software/ packages. After completing the module, the incumbent will be able to:

  • Understand Database design using Normalization and E-R modeling
  • Use Standard Query Language and its various versions.
  • Understand the importance of backup and recovery techniques.
  • Develop Database System to handle real-world problems.
  • Understand to use Maria DB
  • Learn concept of JSON Object & NoSQL Database
Duration 120 Hours – (Theory: 48 hrs + Practical: 72 hrs) Detailed Syllabus (i) An Overview of the Database Management System

What is the database? Why database? Database system, database management system (DBMS), advantages of DBMS.

(ii) An Architecture of the Database system

Three levels of architecture, Logical View, Physical View, Conceptual View, Logical data independence, Physical Data Independence

(iii) Relational Database Management System (RDBMS)

Introduction, RDBMS terminology, relational model, base tables, keys, primary key, foreign key, constraints, Codd Rules.

(iv) Database Design

Normalization, Normal forms-1NF, 2NF, 3NF, BCNF 4NF and 5NF, E-R Diagram. Mapping ER-diagram to database tables.

(v) Maria DB

Introduction to Maria DB, Data Types, SQL Commands, Create, insert, update, delete, drop, alter, SQL functions (String functions, date functions), indexing, key, primary key, foreign key

(vi) Manipulating Data with Maria DB

SQL Statements, Select, like clause, group by, order by, joins-left join, natural join, right join, union. Correlated and nested queries. Backup and restore commands

(vii) NoSQL Database Technology

Introduction to NoSQL Databases, Difference between relational and NoSQL databases. NoSQL features, types, advantages, Architecture of MongoDB, Documents, Collections, Dynamic Schemas, Mongo Shell, Mongo Server and Client, Data Types, Embedded Documents, Creating Configuration file for Mongo, JSON File format for storing documents, Inserting and Saving Documents, Batch Insert, Insert Validation, Removing Documents, Updating Documents, Document Replacement, Using Modifiers, Updating Multiple Documents, Returning Updated Documents, Introduction to Indexing, Introduction to Compound Indexes, Using Compound Indexes, Indexing Objects and Arrays, Aggregation Framework, Pipeline Operations- $match, $project, $group, $unwind, $sort, $limit, $skip, Using Pipelines, MongoDB and MapReduce, Aggregation Commands, Introduction to Replication, configuring a Replica Set, Member Configuration Options

(viii) Selecting the Right Database

Selection of right databases, RDBMS or NoSQL, selection of database based on performance, data size, type of data, frequency of accessing data, business needs, type of application.

Course Currilcum

    • What is database? 00:00:00
    • Why database? 00:00:00
    • Database system, database management system (DBMS) 00:00:00
    • Advantages of DBMS 00:00:00
    • Three levels of architecture, Logical View, Physical View, Conceptual View 00:00:00
    • Logical data independence, Physical Data Independence 00:00:00
    • Introduction 00:00:00
    • RDBMS terminology, relational model 00:00:00
    • Base tables, Keys, Primary key, Foreign key 00:00:00
    • Constraints, Codd Rules 00:00:00
    • Normalization 00:00:00
    • Normal forms-1NF, 2NF, 3NF, BCNF 4NF and 5NF, E-R Diagram 00:00:00
    • Mapping ER-diagram to database tables 00:00:00
    • Introduction to Maria DB, Data Types 00:00:00
    • SQL Commands, Create, insert, update, delete, drop, alter 00:00:00
    • SQL functions (String functions, date functions) 00:00:00
    • Indexing, key, primary key, foreign key 00:00:00
    • SQL Statements, Select, like clause, group by, order by 00:00:00
    • Joins-left join, natural join, right join, union 00:00:00
    • Correlated and nested queries. Backup and restore commands 00:00:00
    • Introduction to NoSQL Databases, Difference between relational and NoSQL databases 00:00:00
    • NoSQL features, types, advantages, Architecture of MongoDB, Documents, Collections, Dynamic Schemas, Mongo Shell, Mongo Server 00:00:00
    • Client, Data Types, Embedded Documents, Creating Configuration file for Mongo 00:00:00
    • JSON File format for storing documents, Inserting and Saving Documents 00:00:00
    • Batch Insert, Insert Validation 00:00:00
    • Removing Documents, Updating Documents, Document Replacement 00:00:00
    • Using Modifiers, Updating Multiple Documents, Returning Updated Documents 00:00:00
    • Introduction to Indexing, Compound Indexes 00:00:00
    • Using Compound Indexes, Indexing Objects and Arrays 00:00:00
    • Aggregation Framework, Pipeline Operations- $match, $project, $group, $unwind, $sort, $limit, $skip 00:00:00
    • Using Pipelines, MongoDB and MapReduce, Aggregation Commands 00:00:00
    • Introduction to Replication, configuring a Replica Set, Member Configuration Options 00:00:00
    • Selection of right databases, RDBMS or NoSQL 00:00:00
    • Selection of database based on performance, data size, type of data, frequency of accessing data 00:00:00
    • Business needs, Type of application 00:00:00
© All rights reserved
Open chat