This collection of resources is designed to enhance learning material to enhance your knowledge of SQL and relational databases.
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