Curriculum
5 Sections
22 Lessons
10 Weeks
Expand all sections
Collapse all sections
Module 1: Introduction to Databases
4
1.1
What is a database?
1.2
Types of databases (Relational, NoSQL, In-Memory, Cloud)
1.3
Relational Database Management Systems (RDBMS) overview
1.4
Popular database systems (MySQL, PostgreSQL, SQL Server, Oracle)
Module 2: Database Design & Data Modeling
5
2.1
Database design principles
2.2
Understanding Entities, Attributes, and Relationships
2.3
Introduction to Entity-Relationship (ER) Diagrams
2.4
Normalization (1NF, 2NF, 3NF, BCNF) and denormalization
2.5
Database schema creation
Module 3: SQL Basics – Querying Databases
5
3.1
Introduction to Structured Query Language (SQL)
3.2
Writing SELECT statements to retrieve data
3.3
Filtering data with WHERE, ORDER BY, and LIMIT
3.4
Using JOINs (INNER, LEFT, RIGHT, FULL) to combine tables
3.5
Grouping and aggregating data (GROUP BY, HAVING)
Module 4: Data Manipulation & Transactions
4
4.1
INSERT, UPDATE, DELETE – Modifying data
4.2
Understanding ACID properties (Atomicity, Consistency, Isolation, Durability)
4.3
Transactions and rollback mechanisms
4.4
Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL)
Module 5: Indexing & Query Optimization
4
5.1
Understanding indexes and how they improve performance
5.2
Creating indexes on tables
5.3
Optimizing queries using EXPLAIN ANALYZE
5.4
Avoiding common performance bottlenecks
Database Design & Development – Beginner
Search
This content is protected, please
login
and enroll in the course to view this content!
WhatsApp us
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content