- No products in the cart.
Database Management Systems
Twenty 19
In this course you will learn about the concepts of DBMS, RDBMS, NoSQL, OLAP & OLTP with Real World Examples. You will do hands on SQL on your onw installed SQLITE system, you will create your own playground on MongoDB. You will also learn the tips and tricks on SQL tuning and performance tuning.
This course would help build concept clarity using REAL WORLD EXAMPLES and foundation for strong programming skills
- Fee Details : 2999
- PROVIDER : Twenty 19
₹ 2,999.00
Product Description
Whatever Programming language or platform you may be working on, a sound database knowledge is what you always need. Database as a technology is high in demand technology with exciting new products being launched rapidly along with good job prospects. In this course you will learn about Databases, RDBMS – SQL, NoSQL, OLAP Databases, MongoDB!
Chapter 1
- 1.1 – Database Characteristics and Data Models
- 1.2 – Database Career Options
Chapter 2
- 2.1 – CORE concepts of RDBMS
- 2.2 – Introduction to SQL
- 2.3 – SQLite Installation and Setup
- 2.4 – Database Normalization
- Quiz 1
Chapter 3
- 3.1 – Joins
- 3.2 – SQL Functions and Views
Chapter 4
- 4.1 – NoSQL Overview
- 4.2 – NoSQL Categories
- 4.3 – No SQL Categories continued
- 4.4 – Benefits of NoSQL, Scaling, Sharding, Replication
- 4.5 – OLAP and OLTP
- Quiz 2
Chapter 5
- 5.1 – Introduction to MongoDB, Features
- 5.2 – Installation and Setup
- 5.3 – MongoDB explained
- 5.4 – Project – CRUD Operations
- 5.5 – CREAT CRUD operations on a MongoDB installation
- 5.6 – Data Insert Using CSV file
- Quiz 3
Chapter 6
- 6.1 – Commercially Successful RDBMS
- 6.2 – Criteria For RDBMS Selection
- 6.3 – RDBMS vs. NoSQL Summary
- Quiz 4
Reviews
There are no reviews yet.