Database I
Welcome to the Database I subject notes. This subject covers fundamental concepts of database systems, SQL, and data management.
Subject Overview
Section titled “Subject Overview”This subject is structured into three main sections:
Foundations
Section titled “Foundations”- Database Fundamentals
- Relational Database Concepts
- Entity Relationship Diagrams
- Data Normalization
SQL Basics
Section titled “SQL Basics”- SQL Basics
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Single-Row SQL Functions
Data Queries
Section titled “Data Queries”- Data Retrieval with SELECT
- Data Filtering and Sorting
- Data Grouping and Aggregation
- Multi-Table Queries (JOINs)
- Working with Views
Navigate through the sections using the sidebar to explore each topic in detail.