Database Technology (SQL/ MYSQL/ MONGODB/ FIREBASE)

CONSTRAINTS and KEYS
JOINS & SUB QUERIES
VIEWS, FUNCTIONS, SUB QUERIES
STORED PROCEDURES, Triggers, transactions
SQL Server Architechture
DB Backups , Recovery and Restorations
JOBS, SQL SERVER AGENT
Performance Tuning
DB health checks
PATCHES, SERVER UPGRADES
Clustering
Manintenance
Study Materials/Workshops/Home work /Assignments

MySQL Course Overview
MySQL Community Edition vs. MySQL Enterprise Edition
MySQL Product Releases
My SQL Architecture Overview
Storage Engine Concept
Locks
MySQL Architecure Summary
MySQL and Windows
MySQL and Linux
Improve MySQL Installation Security
Database Modeling,Normalization,Denormalization,Data Types Partitioning
Metadata Access Methods
The INFORMATION_SCHEMA and MySQLDatabases
New PERFORMANCE_Schema
Using SHOW and DESCRIBE
Backup, Recovery and replications

Design Goals, Requirement of NoSQL/MongoDB, Architecture of mongoDB® etc
CRUD Operations
Schema Design and Data Modelling in mongoDB®
MongoDB® Administration
Scalability and Availability
Indexing and Aggregation Framework
MongoDB integration, Hadoop and MongoDB integration
Project, Additional concepts, case studies.
Study Materials/Workshops/Home work /Assignments

Getting Started with Firebase
CRUD Your Data in Real-time
Adding User Accounts
Structuring Your Data in a Scalable Way
Structuring Your Data in a Scalable Way
Authorization and Validation
Ordering, Paginating, and Querying Firebase Data
Managing Connectivity, Latency, and Presence
Deploying a Firebase Application
Study Materials/Workshops/Home work /Assignments"