Introduction to Databases

Module 1: Relational Databases

Lesson 1: Introduction to SQL

  • What is SQL?
  • SQL Syntax and Queries
  • Database Design Basics

Lesson 2: MySQL and PostgreSQL

  • Installation and Setup
  • Data Types and Constraints
  • Transactions and ACID Properties

Module 2: NoSQL Databases

Lesson 1: Introduction to NoSQL

  • Types of NoSQL Databases
  • Document Stores (MongoDB)
  • Key-Value Stores (Redis)

Lesson 2: Using MongoDB

  • Installation and Setup
  • CRUD Operations
  • Indexes and Aggregation