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