Course Name: SQL & NOSQL Databases
Completion Progress: 0%
Section 1: MYSQL & SQL RDBMS
- Introduction
- SQL Data Types
- DML,DCL, DDL ,DQL & TCL Staements
- Primary key and Foreign Keys
- Expressions and functions
- Joins and Nested Queries
- View commands & Check Options
- User access and Profiles
- Grant and Revoke Statements
- Rollback, commit & save point
- Using Union, Intersect and Minus
- Data Dictionary
- Indexing and Clustering
- image
- Best Practices
Section 2: NOSQL MongoDB
- Introduction
- MongoDB Architecture
- Installation & Get Started
- Databases
- Collections & Documents
- Crud Operations
- Data Types
- Query operators & building queries
- Grouping & Aggregation
- Regular Expressions & Indexing
- Full text Search
- Batch & Bulk Operations
- Best Practices
- image