Bundle
Full stack python
Full stack python course for beginners
Database
Master database fundamentals from beginner to advanced. Learn about relational databases, SQL, database design, normalization, transactions, indexing, performance optimization, security, and modern NoSQL databases. This comprehensive course covers everything from basic database concepts to advanced SQL and database administration.
- 3 Months Duration
- 10 Modules
- Paid Access
Course fee
₹3000.00
Login to enroll and access modules, quizzes, and AI tutoring.
Save with a package
Get this course in a bundle
Unlock this course and the rest of a curated learning package with one purchase.
Learning path
Course Modules
Work through each module and pass quizzes to unlock the next step in your journey.
Database Fundamentals
Introduction to databases and database management systems. Learn what data and databases are, understand different types of databases, and explore DBMS functions and popular tools.
Enroll in this course to access modules.
Learning objectives
- Understand what data and databases are
- Learn about different types of databases (RDBMS, NoSQL)
- Understand Database Management System (DBMS) functions
- Explore popular DBMS tools (MySQL, PostgreSQL, MariaDB, Oracle)
- Compare file systems vs databases
Relational Database Concepts
Learn fundamental relational database concepts including terminology, relational model basics, and data types used in databases.
Enroll in this course to access modules.
Learning objectives
- Understand basic database terminology (Table, Row, Column, Record, Field, Schema)
- Learn about Primary Key and Foreign Key
- Understand the relational model
- Learn about tables and relationships
- Understand ER diagrams (basic idea)
- Master different data types (Numeric, String, Date & Time, Boolean, NULL)
SQL Basics
Master the fundamentals of SQL. Learn about SQL categories (DDL, DML, DCL, TCL), create databases and tables, perform basic data manipulation, and write simple queries.
Enroll in this course to access modules.
Learning objectives
- Understand what SQL is and its categories
- Master Data Definition Language (DDL): CREATE, DROP, ALTER, TRUNCATE
- Master Data Manipulation Language (DML): INSERT, SELECT, UPDATE, DELETE
- Write basic SQL queries with WHERE clause
- Use AND/OR/NOT operators
- Apply DISTINCT and LIMIT clauses
SQL Intermediate Concepts
Learn intermediate SQL concepts including constraints, advanced filtering, aggregate functions, and joins. Master sorting, grouping, and combining data from multiple tables.
Enroll in this course to access modules.
Learning objectives
- Understand and apply constraints (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT)
- Master sorting and filtering with ORDER BY, BETWEEN, IN, LIKE, IS NULL
- Use aggregate functions (COUNT, SUM, AVG, MIN, MAX)
- Apply GROUP BY and HAVING clauses
- Master different types of joins (INNER, LEFT, RIGHT, FULL, Self, Cross)
Database Design
Learn database design principles, normalization forms, and Entity-Relationship diagrams. Understand how to design efficient and normalized databases.
Enroll in this course to access modules.
Learning objectives
- Understand why database design matters
- Learn about problems with poor design
- Master normalization (1NF, 2NF, 3NF, BCNF)
- Understand when and why to denormalize
- Create ER diagrams
- Understand entities, attributes, relationships, and cardinality
- Learn about weak entities
Transactions & Indexing
Master database transactions and indexing. Learn about ACID properties, transaction control, and how indexes improve query performance.
Enroll in this course to access modules.
Learning objectives
- Understand what transactions are
- Master ACID properties (Atomicity, Consistency, Isolation, Durability)
- Use COMMIT, ROLLBACK, and SAVEPOINT
- Understand what indexing is and its types
- Learn advantages and disadvantages of indexes
- Know when not to use indexes
Advanced SQL
Explore advanced SQL features including subqueries, views, stored procedures, functions, and triggers. Learn to write complex queries and automate database operations.
Enroll in this course to access modules.
Learning objectives
- Master subqueries (single-row, multi-row, correlated)
- Create and use views
- Understand updatable views and views vs tables
- Create stored procedures with parameters
- Understand benefits and use cases of stored procedures
- Use built-in and user-defined functions
- Create triggers (BEFORE/AFTER, INSERT/UPDATE/DELETE)
Performance & Optimization
Learn to optimize database performance. Understand query execution, explain plans, index optimization, and database tuning techniques.
Enroll in this course to access modules.
Learning objectives
- Understand how SQL queries are executed
- Use EXPLAIN plan to analyze queries
- Identify common performance mistakes
- Optimize indexes (composite indexes, index selectivity)
- Understand index vs full table scan
- Learn database performance tuning techniques
- Use slow query logs
- Understand caching basics
- Learn about connection pooling
Security & Backup
Master database security and backup strategies. Learn about user management, access control, SQL injection prevention, and disaster recovery.
Enroll in this course to access modules.
Learning objectives
- Understand database security principles
- Manage users and roles
- Use GRANT and REVOKE for access control
- Understand SQL injection concepts and prevention
- Learn best security practices
- Understand types of backups
- Use mysqldump for backups
- Learn restore processes
- Understand disaster recovery basics
NoSQL & Modern Databases
Explore NoSQL databases and modern database technologies. Learn about different NoSQL types, CAP theorem, and when to use SQL vs NoSQL.
Enroll in this course to access modules.
Learning objectives
- Understand why NoSQL databases exist
- Learn about CAP theorem
- Compare SQL vs NoSQL
- Understand different types of NoSQL databases
- Learn about Document-based databases (MongoDB)
- Understand Key-Value stores
- Learn about Column-based databases
- Explore Graph databases