Master SQL, MongoDB & Redis | Complete Database Course
Educad Academy offers a complete database training program covering SQL, MongoDB, and Redis. This course is designed to give you practical, hands-on experience in relational, NoSQL, and in-memory databases. You will learn to design, secure, and integrate databases into real-world applications while building projects like an Employee Management System, Product Catalog, and Real-Time Analytics Dashboard.
Key Learning Outcomes:
- Build a solid foundation in SQL: relational databases, CRUD operations, joins, security, backup, and recovery
- Learn MongoDB essentials: documents, collections, indexing, aggregation, and cloud deployment with MongoDB Atlas
- Explore Redis in-memory databases: caching, session management, Pub/Sub, TTL, replication, and clustering
- Connect databases with applications using Python, Node.js, PHP, and C#
- Gain job-ready skills for roles in database administration, data engineering, and software development
This course is ideal for students, IT professionals, and developers who want to master databases and advance their careers with Educad Academy.
Course Content:
Part 1: SQL (Relational Database)
Module 1: Introduction to SQL & Relational Databases
- What is SQL & where it’s used
- Relational vs. Non-relational DB
- Basic SQL Server setup & tools (SSMS, Azure Data Studio)
Module 2: Database & Table Operations
- Creating databases & tables
- Data types in SQL
- Inserting, updating, deleting, querying data (CRUD)
- SELECT queries with WHERE, ORDER BY, JOIN
Module 3: Security & User Management
- Creating logins & users
- Assigning roles & permissions
- Basic data encryption concepts
Module 4: Backup & Recovery
- SQL Server recovery models (Simple vs Full)
- Taking database backups
- Restoring databases
Module 5: SQL for Applications
- Importing & exporting data
- Connecting SQL with applications (Python, C#, PHP)
- Example: Employee Management System database
Part 2: MongoDB (NoSQL Document Database)
Module 6: Introduction to MongoDB
- SQL vs NoSQL differences
- MongoDB documents & collections
Module 7: Setup & Tools
- Installing MongoDB (local & Atlas cloud)
- MongoDB Compass & Shell
Module 8: CRUD Operations
- Insert, find, update, delete documents
- Query operators & projections
Module 9: Indexing & Aggregation
- Indexes for performance
- Aggregation pipelines
Module 10: MongoDB in Applications
- Connecting MongoDB with Node.js/Python
- Using Mongoose ODM
- Example: Product Catalog application
Part 3: Redis (In-Memory Database)
Module 11: Introduction to Redis
- What is Redis & why use it
- Redis data types (strings, lists, sets, hashes)
Module 12: Setup & CLI
- Installing Redis on Windows/Linux
- Basic commands (SET, GET, DEL)
- Configuring persistence
Module 13: Data Operations
- CRUD on different data types
- Expiry & TTL
- Pub/Sub messaging
Module 14: Redis in Applications
- Using Redis for caching with SQL/MongoDB
- Session management with Redis
- Connecting Redis with Python/Node.js
Module 15: Redis for Enterprises
- Replication & high availability (intro)
- Redis cluster basics
- Example: Real-time analytics dashboard
Prerequisites:
- Basic knowledge of computers and operating systems (Windows/Linux)
- Familiarity with programming concepts (Python, Java, C#, or similar) is helpful but not mandatory
- No prior database experience required – beginners can start from scratch
- Internet connection and a personal computer (for installing SQL Server, MongoDB, and Redis tools)
Target Audience:
This course is for professionals who want to administer, manage, and maintain relational (SQL) and non-relational (MongoDB, Redis) databases. It is ideal for:
- IT staff and system administrators working with enterprise databases
- Software developers building applications that require secure and scalable databases
- Data engineers managing structured, unstructured, and real-time data
- Professionals in corporate environments who need hands-on expertise in database technologies
Flexible Class Options
- Corporate Group Training | Fast-Track
- Weekend Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training
