,MODULE 3: SQL DML (Data Manipulation
Language), Physical Data Organization
Downloaded from Ktunotes.in
,SYLLABUS
• SQL DML (Data Manipulation Language)
▫ SQL queries on single and multiple tables, Nested queries (correlated
and non-correlated), Aggregation and grouping, Views, assertions,
Triggers, SQL data types.
• Physical Data Organization
▫ Review of terms: physical and logical records, blocking factor, pinned
and unpinned organization. Heap files, Indexing, Singe level indices,
numerical examples, Multi-level-indices, numerical examples, B-Trees &
B+-Trees (structure only, algorithms not required), Extendible Hashing,
Indexing on multiple keys – grid files
Downloaded from Ktunotes.in
, Data-manipulation language(DML)
• The SQL DML provides the ability to query information
from the database and to insert tuples into, delete tuples
from, and modify tuples in the database.
▫ Integrity
The SQL DDL includes commands for specifying integrity
constraints that the data stored in the database must satisfy.
Updates that violate integrity constraints are disallowed.
▫ View definition
The SQL DDL includes commands for defining views.
▫ Transaction control
SQL includes commands for specifying the beginning
and ending of transactions.
Downloaded from Ktunotes.in
Language), Physical Data Organization
Downloaded from Ktunotes.in
,SYLLABUS
• SQL DML (Data Manipulation Language)
▫ SQL queries on single and multiple tables, Nested queries (correlated
and non-correlated), Aggregation and grouping, Views, assertions,
Triggers, SQL data types.
• Physical Data Organization
▫ Review of terms: physical and logical records, blocking factor, pinned
and unpinned organization. Heap files, Indexing, Singe level indices,
numerical examples, Multi-level-indices, numerical examples, B-Trees &
B+-Trees (structure only, algorithms not required), Extendible Hashing,
Indexing on multiple keys – grid files
Downloaded from Ktunotes.in
, Data-manipulation language(DML)
• The SQL DML provides the ability to query information
from the database and to insert tuples into, delete tuples
from, and modify tuples in the database.
▫ Integrity
The SQL DDL includes commands for specifying integrity
constraints that the data stored in the database must satisfy.
Updates that violate integrity constraints are disallowed.
▫ View definition
The SQL DDL includes commands for defining views.
▫ Transaction control
SQL includes commands for specifying the beginning
and ending of transactions.
Downloaded from Ktunotes.in
