Animated Examples for SQL
Topics
Table Creation
Table Deletion and Alteration
Column Addition
Column Drop
Table Drop
Key Constraints
Primary Key-1
Primary Key-2
Primary Key and Unique Key
Foreign Key
General Constraints
Tuple Insertion
Inserting Data-1
Inserting Data-2
Inserting Data-3
Tuple Deletion
Deleting Data
Deleting with Conditon (1)
Deleting with Conditon (2)
Tuple Update
Updating Data (1)
Updating Data (2)
Updating Data (3)
Updating with Condition
Updating with Subquery
SELECT-FROM
Selecting One Attribute
Selecting Multiple Attributes
Selecting All Attributes
Skipping Dublicates
Arithmetic Expressions
SELECT-FROM-WHERE
Selection Condition
Comparison Condition (1)
Comparison Condition (2)
Comparison Condition (3)
Multiple Comparisons
Range Test (1)
Range Test (2)
Pattern Matching
Multiple Table Queries
Multiple Table Selection (1)
Multiple Table Selection (2)
ORDER-BY
Set Operations
Combining Query Result (1)
Combining Query Result (2)
Combining Query Result (3)
Comparing Subquery Results(1)
Comparing Subquery Results(2)
Aggregate Functions
Aggregate Functions (1)
Aggregate Functions (2)
Aggregate Functions (3)
Aggregate Functions (4)
GROUP-BY and HAVING
Groupes Queries
Group Queries with Condition
Aggregating Subquery
Grouping and Aggregating (1)
Grouping and Aggregating (2)
Sub-Queries
Nested Subqueries (1)
Nested Subqueries (2)
Checking Null Values
Derived Relations and Views
Derived Relations
View Creation (1)
View Creation (2)
Retrieving data from view
Aggregating Derived Relations