Database Management Systems

This collection of resources is designed to enhance learning material to enhance your knowledge of SQL and relational databases.

 Table Creation

    Table Creation

 Table Deletion and Alteration

    Table Drop

    Column Addition

    Column Drop

 Key Constraints

    Primary Key (1)

    Primary Key and Unique Key

    Foriegn Key

    Primary Key (2)

 General Constraints

    Assertion Creation (1)

    Assertion Creation (2)

    Check Constraint (1)

    Check Constraint (2)

 Tuple Insertion

    Inserting Data (1)

    Inserting Data (2)

    Inserting Data (3)

    Inserting Data (4)

 Tuple Deletion

    Deleting Data

    Deleting with Condition (1)

    Deleting with Condition (2)

 Tuple Update

    Updating Data (1)

    Updating Data (2)

    Updating Data (3)

    Updating with condition

    Updating with subquery

 SELECT FROM

    SELECT-FROM question1

    SELECT-FROM question2

    SELECT-FROM question3

    SELECT-FROM question4

    SELECT-FROM question5

    SELECT-DISTINCT question6

    Selecting One Attribute

    Selecting Multiple Attributes

    Selecting All Attributes

    Skipping Duplicates

    SELECT-FROM (1)

    SELECT-FROM (152)

    SELECT-FROM (168)

    SELECT-FROM (237)

    SELECT-FROM (59)

    SELECT-FROM (97)

    SELECT-FROM (99)

 Arithmetic Expressions

    Arithmetic Expressions question1

    Arithmetic Expressions question2

    Arithmetic Expressions question3

    Arithmetic Expressions question4

    Arithmetic Expressions question5

    Arithmetic Expression

    Arithmetic Expressions (245)

    Arithmetic Expressions (277)

    Arithmetic Expressions (33)

 SELECT-FROM-WHERE

    SELECT-FROM-WHERE question1

    SELECT-FROM-WHERE question2

    SELECT-FROM-WHERE question3

    SELECT-FROM-WHERE question4

    SELECT-FROM-WHERE question5

    Selection Condition

    Comparison Condition (1)

    Comparison Condition (2)

    Comparison Condition (3)

    Multiple Comparisons (1)

    Multiple Comparisons (2)

    Range Test (1)

    Range Test (2)

    SELECT-FROM-WHERE (106)

    SELECT-FROM-WHERE (239)

    SELECT-FROM-WHERE (28)

    SELECT-FROM-WHERE (31)

    SELECT-FROM-WHERE (38)

    SELECT-FROM-WHERE (36)

    SELECT-FROM-WHERE (71)

 Pattern Matching

    Pattern Matching question1

    Pattern Matching question2

    Pattern Matching question3

    Pattern Matching question4

    Pattern Matching question5

    String Operation

    Pattern Matching (16)

    Pattern Matching (37)

 Multiple Table Queries

    Multiple Table question1

    Multiple Table question2

    Multiple Table question3

    Multiple Table question4

    Multiple Table question5

    Multiple Table Selection (1)

    Multiple Table Selection (2)

    Multiple Table Queries (153)

    Multiple Table Queries (170)

    Multiple Table Queries (254)

    Multiple Table Queries (272)

    Multiple Table Queries (63)

    Multiple Table Queries (81)

 ORDER-BY

    Order-By question1

    Order-By question2

    Order-By question3

    Order-By question4

    Alphabetic Order

    ORDER-BY (113)

    ORDER-BY (148)

    ORDER-BY (154)

    ORDER-BY (169)

    ORDER-BY (249)

    ORDER-BY (41)

 Set Operations

    Set Operations question1

    Combining Query Results (1)

    Combining Query Results (2)

    Combining Query Results (3)

    Comparing Subquery Results (1)

    Comparing Subquery Results (2)

 Aggregate Functions

    Aggregate Functions question1

    Aggregate Functions question2

    Aggregate Functions question3

    Aggregate Functions question4

    Aggregate Functions question5

    Aggregate Functions (1)

    Aggregate Functions (2)

    Aggregate Functions (3)

    Aggregate Functions (4)

    Aggregate Functions (146)

    Aggregate Functions (266)

    Aggregate Functions (42)

    Aggregate Functions (43)

 GROUP-BY and HAVING

    Group-By & Having question1

    Group-By & Having question2

    Group-By & Having question3

    Group-By & Having question4

    Group-By & Having question5

    Grouped Queries

    Grouped Queries with Condition

    Aggregating Subquery

    Grouping and aggregating (1)

    Grouping and aggregating (2)

    Grouping and aggregating (3)

    GROUP-BY and HAVING (171)

    GROUP-BY and HAVING (173)

    GROUP-BY and HAVING (174)

    GROUP-BY and HAVING (24)

    GROUP-BY and HAVING (253)

    GROUP-BY and HAVING (44)

    GROUP-BY and HAVING (58)

    GROUP-BY and HAVING (62)

    GROUP-BY and HAVING (64)

    GROUP-BY and HAVING (84)

 Sub-Queries

    Sub-Queries question1

    Sub-Queries question2

    Sub-Queries question3

    Sub-Queries question4

    Sub-Queries question5

    Nested Subqueries (1)

    Nested Subqueries (2)

    Sub-Queries (105)

    Sub-Queries (180)

    Sub-Queries (190)

    Sub-Queries (242)

    Sub-Queries (46)

    Sub-Queries (278)

 NULL-Values

    Checking Null Values

    NULL-Values (14)

    NULL-Values (39)

    NULL-Values (56)

 Derived Relations and Views

    Derived Relations

    View Creation (1)

    View Creation (2)

    Retrieving data from view

    Aggregating Derived Relations