DBMS & SQL Tutorial
Learn DBMS and SQL through easy explanations, practical examples, and useful queries. Understand database concepts and improve your SQL skills with hands-on learning.
Start Learning43 sections186 topics
Chapter 1: Database Foundations
Chapter 2: DBMS Architecture
Chapter 3: Data Models
- Hierarchical Model
- Network Model
- Relational Model
- Object-Oriented Model
- Object-Relational Model
- Document Model
- Key Value Model
- Column Family Model
- Graph Model
- Relational vs NoSQL
- Polyglot Persistence
Chapter 4: Relational Model
- Relation
- Tuple
- Attribute
- Domain
- Relation Schema
- Database Schema
- Database Instance
- Degree
- Cardinality
- Null Values
- Relational Integrity
- Relational Model Rules
- Keys in the Relational Model
Chapter 5: Keys and Integrity
- Super Key
- Candidate Key
- Primary Key
- Alternate Key
- Foreign Key
- Composite Key
- Natural Key
- Surrogate Key
- Unique Constraint
- Entity Integrity
- Referential Integrity
- Cascading Actions
- Business Constraints
Chapter 6: ER and EER Modeling
- Entity
- Entity Set
- Strong Entity
- Weak Entity
- Attributes
- Simple Attribute
- Composite Attribute
- Single Valued Attribute
- Multi Valued Attribute
- Derived Attribute
- Relationship
- Relationship Degree
- Cardinality
- Participation
- Recursive Relationship
- Identifying Relationship
- Generalization
- Specialization
- Aggregation
- EER Diagram
- ER to Relational Mapping
Chapter 7: Relational Algebra
- Selection
- Projection
- Rename
- Union
- Intersection
- Difference
- Cartesian Product
- Theta Join
- Equi Join
- Natural Join
- Outer Join
- Division
- Relational Algebra Expressions
- Relational Algebra Practice
Chapter 8: SQL Fundamentals
- SQL Overview
- SQL Standards
- SQL Dialects
- SQL Statement Structure
- Identifiers
- Literals
- Comments
- Data Types
- NULL Semantics
- DDL
- DML
- DQL
- DCL
- TCL
Chapter 9: DDL and Schema Design
- CREATE DATABASE
- CREATE SCHEMA
- CREATE TABLE
- ALTER TABLE
- DROP TABLE
- TRUNCATE TABLE
- RENAME
- Generated Columns
- Identity Columns
- Sequences
- Temporary Tables
- Schema Evolution
Chapter 10: SQL Constraints
- NOT NULL
- UNIQUE
- PRIMARY KEY
- FOREIGN KEY
- CHECK
- DEFAULT
- Named Constraints
- Column Constraints
- Table Constraints
- Constraint Validation
- Deferred Constraint Concepts
Chapter 11: DML and Data Modification
- INSERT
- Multi Row INSERT
- INSERT SELECT
- UPDATE
- DELETE
- MERGE Concept
- Upsert Patterns
- Safe Updates
- Bulk Loading
- Data Validation
- Data Modification Transactions
Chapter 12: SELECT and Filtering
- SELECT
- DISTINCT
- WHERE
- Comparison Operators
- Logical Operators
- BETWEEN
- IN
- LIKE
- Pattern Matching
- IS NULL
- IS NOT NULL
- CASE
- COALESCE
- NULLIF
- Operator Precedence
Chapter 13: Sorting and Pagination
- ORDER BY
- Multiple Sort Keys
- NULL Ordering
- LIMIT
- OFFSET
- Keyset Pagination
- Top N Queries
- Pagination Performance
- Stable Sorting
Chapter 14: SQL Functions
- Aggregate Functions
- COUNT
- SUM
- AVG
- MIN
- MAX
- String Functions
- Numeric Functions
- Date Functions
- Time Functions
- Conversion Functions
- Conditional Functions
- NULL Functions
Chapter 15: GROUP BY and Aggregation
No topics published yet.
Chapter 16: Joins
No topics published yet.
Chapter 17: Subqueries
No topics published yet.
Chapter 18: Set Operations
No topics published yet.
Chapter 19: Views
No topics published yet.
Chapter 20: Indexes and Access Paths
No topics published yet.
Chapter 21: Normalization and Functional Dependencies
No topics published yet.
Chapter 22: Transactions
No topics published yet.
Chapter 23: Concurrency Control
No topics published yet.
Chapter 24: Locking Protocols
No topics published yet.
Chapter 25: Isolation Levels
No topics published yet.
Chapter 26: Recovery and Logging
No topics published yet.
Chapter 27: Database Security
No topics published yet.
Chapter 28: Stored Procedures
No topics published yet.
Chapter 29: Stored Functions
No topics published yet.
Chapter 30: Triggers
No topics published yet.
Chapter 31: Cursors
No topics published yet.
Chapter 32: Advanced SQL: CTE
No topics published yet.
Chapter 33: Advanced SQL: Window Functions
No topics published yet.
Chapter 34: Advanced SQL Patterns
No topics published yet.
Chapter 35: Query Processing and Optimization
No topics published yet.
Chapter 36: Physical Storage
No topics published yet.
Chapter 37: Advanced Index Structures
No topics published yet.
Chapter 38: Distributed Databases
No topics published yet.
Chapter 39: NoSQL Databases
No topics published yet.
Chapter 40: Database Scaling
No topics published yet.
Chapter 41: Data Warehousing
No topics published yet.
Chapter 42: Database Design Projects
No topics published yet.
Chapter 43: Interview and Placement Preparation
No topics published yet.