DBMS
53 articles in this topic
SQL WHERE Clause and Filtering: Syntax, Operators, and Worked Examples
Learn SQL filtering on one runnable eight-row orders table. Trace WHERE conditions row by row, combine Boolean operators, handle NULL, and check exact results.
Updated 18 Sep 20266 min readDBMS
SQL SELECT Basics: Syntax, Output, and Runnable Examples
Learn how SELECT shapes a result without changing stored data. Run one small table through column lists, aliases, arithmetic expressions, and DISTINCT.
Updated 16 Sep 20265 min readDBMS
RDBMS Concepts and SQL Basics: A Beginner Tutorial with Examples
Build a three-table college database in SQLite, then use exact rows and queries to understand relations, keys, constraints, joins and data anomalies.
Updated 15 Sep 20266 min readDBMS
SQL DML: INSERT, UPDATE, and DELETE with Transaction-Safe Examples
Follow one employees table through deliberate inserts, a calculated update, a targeted delete, and a savepoint rollback in PostgreSQL.
Updated 13 Sep 20265 min readDBMS
Serialization in Java: Object Streams, transient, serialVersionUID and Runnable Examples
Write and restore a complete Student object, trace every retained field, and learn how Java handles transient, static, shared and evolving state.
Updated 12 Sep 20266 min readDBMS
Join Operations in DBMS: Inner, Left, Right and Full Outer Joins Worked Step by Step
Trace one pair of small tables through INNER, LEFT, RIGHT and FULL OUTER JOIN. See which unmatched rows survive, where NULL appears and how duplicate keys change counts.
Updated 10 Sep 20266 min readDBMS
SQL Datatypes, Operators and NULL: Worked Examples and Three-Valued Logic
Use one four-row Employee table to master SQL type choices, operator precedence, NULL, three-valued logic, COALESCE and aggregate outputs step by step.
Updated 9 Sep 20265 min readDBMS
SQL Query Optimization Basics: EXPLAIN, Indexes, and Worked Examples
Learn to read row flow, choose composite index order, rewrite date predicates, and compare before and after plans on a deterministic PostgreSQL fixture.
Updated 7 Sep 20265 min readDBMS
DBMS for GATE CS: Syllabus Areas, Question Weightage and Prep Order
Learn the DBMS syllabus in dependency order, see which areas recur most in PYQs, and practise the exact reasoning used in normalization, schedules, indexing and SQL questions.
Updated 6 Sep 20265 min read80 viewsDBMS
Basics of DBMS: Full Concept Set with Worked Examples for GATE and Interviews
Connect the core DBMS ideas through concrete tables: why databases beat files, how keys and normalization work, how ER designs become relations, and how ACID protects a bank transfer.
Updated 4 Sep 20266 min readDBMS
Keys and Integrity Constraints in DBMS: Types, Rules and Worked Examples
Learn how superkeys, candidate keys, primary keys, foreign keys and integrity rules work together through one university database and a complete closure proof.
Updated 3 Sep 20266 min readDBMS
Concurrency Control in DBMS: Anomalies, Serializability, Locking and 2PL with Worked Examples
Connect the full DBMS concurrency-control chain through one precedence-graph schedule, strict 2PL examples, timestamp rules and recovery checks.
Updated 1 Sep 20266 min readDBMS