Database access in SQL

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
11
Level: 
II
  • SQL (Structured Query Language)
    • Structure
    • Principle
    • Operation specifications
    • Types
    • Features.
  • Creation of tables
    • Data type specification
    • Handling of NULL
    • Specifying procedures of primary key and foreign key.
  • Data retrieval and query processing
    • SELECT statements
      • Processing of data
        • Expressions
        • Numerical values
        • Character strings
        • Dates
      • Operations using WHERE clauses
      • Set functions.
  • Joins of tables
    • Outer joins
    • Self joins
    • Sub query
  • Various table handling
    • Complicated retrieval/inquiry procedures
    • Updating/deleting of tables