SQL
  • Note: SQL CRUD by default covered in syllabus. Students interested to learn SQL in deep can add this course.
  • Database Installation
  • DDL & DML
    • Basics
    • Data types
    • Understanding Test Database
    • Create/Alter/Drop Tables
    • Foreign Keys
    • Primary Keys & Unique Keys
    • Index
    • DML Operations - Insert, Update and Delete
  • Writing SQL Queries
  • Filters
    • DISTINCT
    • BETWEEN
    • IN
    • LIKE
    • NOT
    • NULL
    • AND, OR, NOT etc
  • Sorting
    • Ascending Order
    • Descending Order
  • Functions
    • String
    • Date
    • Number
    • Null Values
    • Case statement
  • Groups
    • Basics
    • Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT etc
    • Grouping Filters - HAVING
  • Joins
    • Equi Join
    • Left Join
    • Right Join
    • Full Outer Join
  • Sub Query
  • Views
  • Top - N analysis
  • Transactions (T SQL)
    • Commit
    • Rollback