Executive Programs

Workshops

Projects

Blogs

Careers

Student Reviews

For Business

Academic Training

Informative Articles

Find Jobs

We are Hiring!

All Courses

Choose a category

All Courses

Everything about Database 2.0

A comprehensive course on SQL and MongoDB using practical and real-world examples. This course is highly suited for beginners

RELATED RECENT PLACEMENTS

DHIRAJ KADAM

Tech Mahindra

MIT Group of Institutions Aurangabad

Mukesh Kanna S

Tech Mahindra

Panimalar Engineering College

SATHIYA MOORTHY A

Tech Mahindra

Apollo Engineering College

G Harish Jairaj

IIT Madras

Velammal Engineering College

Gorle Balaram

Relaince Jio

Sri Venkateswara College Of Engineering & Technology

Prakash Shukla

Escorts

Kamla Nehru Institute of Technology, Sultanpur (U.P.)

Gunashekar Srinivas

Equilibrium Solutions

Vellore Institute of Technology - VIT Chennai

Durga Varaprasad

Tata Elxsi

Osmania University Hyderabad

& 1200+ more

Syllabus

This course is full of best-in-class content by leading faculty and industry experts in the form of videos and projects

Course Overview

This course is designed for absolute beginners who don’t have any prior experience with database management.
From the very basic topics like creating your first database to the most advanced topics like query implementation, everything is covered in this course.
Through this course, the students will learn to create databases in a systematic way.
Students will gain exposure to databases and their implementation using SQL and MongoDB.
Through this course, students will learn to
- Design
- Create
- Manage
- Extract information
Also, the students will be doing multiple projects on real-world problems, which will strengthen their base as professional database administrators.

Course Syllabus

On a daily basis we talk to companies in the likes of Tata Elxsi and Mahindra to fine tune our curriculum.

Week 01 - Introduction to Databases

Introduction to databases
Downloading XAMPP and creating the first table
Components of DBMS
Characteristics of DBMS, ACID properties
Databases vs File system
Types of DB
SQL vs NoSQL
CRUD operations example in MySQL, OLTP, and OLAP

Week 02 - Creating Database Tables

Database design
ER model
Entity and attributes
Entity relationships
Cardinality ratio
Generalization, specialization, and aggregation
Case study of Ecommerce website

Week 03 - Introduction to RDBMS

RDBMS
Converting ER diagram to table
Properties of relational model
Primary key and foreign key
Relational model
E-commerce use case
Codd's rules
Data integrity in RDBMS

Week 04 - Database Design

Database design
Redundancy
Insertion anomaly
Functional dependencies
Closure set of attributes
Lossy decomposition
Dependency preserving
Normalization
Transitive dependency
3NF
BCNF
Multivalued dependency
5NF
Comparison between Normal forms, OLTP, and OLAP

Week 05 - SQL (Part 1)

Discrete maths
Relational Algebra and null values
Relational calculus
Characteristics of SQL
Create a DB (example)
SQL Constraints
Foreign key
SQL SELECT statement
INSERT, DELETE statements
Scalar and Aggregate functions
HAVING clause
SQL Aliases
IN, BETWEEN operators
EXISTS, ANY, ALL operator
Auto increment
MySQL best practices

Week 06 - SQL (Part 2)

JOIN-types
JOIN examples
String operators
Compound queries
SQL index
SQL views
Query optimization
Security Risks

Week 07 - NoSQL

Introduction to NoSQL
ACID
Key value pair-based databases
Search DB and Graph DB
Advantages of NoSQL
Introduction to MongoDB

Week 08 - MongoBD Basics

Working with MongoDB
CRUD Operations with examples
Data Modelling in NoSQL
One to One and One to Many relationships
Advanced MongoDB queries
- Join, sort, group, and index

Week 09 - Redis

In memory DB
Redis
Key value store
Cashing layer
Datatypes
Transaction
Backup of data from Redis

Week 10 - PL/SQL

PL/SQL Basics
Operators
Record
Recursive Functions
Exception Handling
Triggers

Week 11 - More about Databases

Transactions
Concurrency control
Isolation
Consistency
ACID
Database lock
Database lock types
Lock Contention
Deadlock
Scaling the database
Storage systems
Database indexing
Index types
Distributed DB
DB Replication
Database sharding
DB on Cloud

Our courses have been designed by industry experts to help students achieve their dream careers

Industry Projects

Our projects are designed by experts in the industry to reflect industry standards. By working through our projects, Learners will gain a practical understanding of what they will take on at a larger-scale in the industry. In total, there are 2 Projects that are available in this program.

Designing an E-commerce Database

Databases are vital tools for storing, managing and retrieving information. They are also critical for building an e-commerce system. A well-structured database powers e-commerce and manages all the interactions within the system. In this project, you will be designing such databases.

Scaling and Designing E-commerce Database

Scalability is key when deciding on your eCommerce platform. Your e-commerce website needs to be able to change and grow in order to meet demand. One of the critical components that will directly affect your e-commerce platform’s scalability is its database. In this project, you will be scaling your e-commerce database.