Addon : Adv. SQL Server
  • MySQL Basics
    • Database models
    • ER Model Overview
    • Data types
    • Understanding Test Database
    • Basics Queries
  • DDL
    • Tables - Create, Alter, Drop
    • Constraints - Not Null, Primary Key, Unique Key, Foreign Key
    • Indexes - Types, Create, Drop
  • DML operations - Insert, Update & Delete
    • Insert, Update, Delete & Truncate
    • Common Operations
  • Writing Queries
  • Filters
    • DISTINCT
    • BETWEEN
    • IN
    • LIKE
    • NOT
    • NULL
    • AND, OR, NOT etc
    • Using Complex Data Filtering Techniques
    • Limit, offset
  • Sorting
    • Ascending Order
    • Descending Order
    • Complex Sorting
  • Functions
    • String Functions - lower case, uppercase, substring, instring, trim, group_concat etc.
    • Number Functions - round and trunc
    • Date Functions - datepart etc
    • Null Value Functions - NULLIF
    • Conditional Expressions - Case
  • Groups
    • Basics
    • Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT etc
    • Grouping Filters - HAVING
    • Rollups & Cubes
  • Joins
    • Cartesian Product
    • Equi and Non-Equi Joins
    • Left Outer Join
    • Right Outer Join
    • Full Outer Join
    • Self Join
    • Complex Queries - Joins & Groups Integration
  • SET Operators
    • Union
    • Union All
    • Intersect
    • Minus
  • Subquery
    • Single Valued Sub Query
    • Multi Valued Sub Query
  • Views
  • Inline Views
  • TOP N Analysis
  • Bulk Operations
    • Required to create test data:
    • Creating Tables using queries
    • Bulk Data Inserts using Queries
    • Updating Data using Queries
    • Deleting Data using Queries
  • Transactions ( T SQL)
    • Commit
    • Rollback
    • Savepoint
  • Procedures and Functions
    • as required:
    • Programming basics
    • Cursors - create, use
    • Procedures - create, drop
    • Functions - create, drop
    • Trigger - create, drop
  • Project