Relational Algebra Guide: Operations & Examples
Detailed reference for Relational Algebra operations including Sigma, Pi, Joins, and Set theory with practical database examples.
DBMS
SQL DDL Commands: Create, Alter & Drop
Master DDL commands in SQL. Covers database creation, schema modification, data types, and implementing primary/foreign key constraints.
SQL DML Commands: Insert, Update & Delete
A complete reference for DML commands. Learn how to safely Insert, Update, and Delete records in your relational database.
SQL DQL Commands: Select, Joins & Subqueries
The ultimate guide to querying databases. Covers simple SELECTs, complex JOINS, Grouping, Aggregation, and advanced Subquery techniques.
Theory of an ER Diagram and Hands-on Example
Understand the theory behind ER Diagrams with simple explanations and a complete hands-on example. Covers entities, attributes, relationships, and cardinality.
ER Diagram to Relational Database Conversion
Learn the rules of mapping ER models to relational schemas. Includes practical SQL code for implementing One-to-One, One-to-Many, and Many-to-Many relationships.