A7-R5.1

Databases Technologies

A7-R5.1
Course Description

This batch includes

  • Chapterwise PDF Notes
  • Chapterwise Classes
  • Objective (MCQs) Classes
  • Objective (MCQs) PDF
  • Old Solved Paper PDF
  • Old Solved Paper Videos
  • One Liner Points PDF
  • Guess Paper

Note: Some Notes PDF are not be downloadable or printable.

Syllabus

Detailed Syllabus of NIELIT A Level A7-R5

Chapter -1: An Overview of the Database Management System

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

 

Chapter -2: An Architecture of the Database system

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

 

Chapter -3: Relational Database Management System (RDBMS)

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

 

Chapter -4: Database Design

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

 

Chapter -5: 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

 

Chapter -6: 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

 

Chapter -7: 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

 

Chapter -8: 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.

Download PDF

₹299.00 ₹1199.00


This course includes
  • Lectures 70
  • Duration 19hr
  • Language Hinglish
  • Validity 25 Aug 2024

Course Popularity
  • Rating 4.7
  • Last updated 3 months ago

avatar
By NewideasYT

India's No 1 Channel

  • 4.9/5.0