SQL Server
  • SQL Server Setup & Configuration (covered in C#)
  • Using Professional Tool - SQL Server Management Studio
  • Design Database
    • Create Tables
    • Create Index
    • Implementing Foreign Keys
    • Using Auto Increment
  • Index & Constraints
    • Foreign Keys
    • Primary key & index
    • Unique key & index
    • Not null constraint
  • CRUD Operations
    • Create / Insert
    • Read
    • Update
    • Delete
  • Select Queries
    • Basic Queries
    • Using AND conditions
    • Using OR conditions
    • Using in, between, distinct and like keywords
    • Sorting in ascending and descending order
  • Functions
    • Trim
    • Uppercase
    • Lowercase
    • LengthPosition
    • Left
    • Ifnul
    • Substring
    • Substringindex
    • Date
    • Numbers
    • Convert
    • Cast etc.
  • Groups
    • Understanding Grouping Columns Usage - Dos & Don’ts
    • Grouping Functions o Min | Max | Sum | Count | Average | Distinct Count
    • Using Having Clause
    • Filtering on grouing functions
    • Multi column groups
  • Joins
    • Creating Foreign Keys and use them in Joins
    • Inner Join or Natural Join
    • Left Outer Join
    • Right Outer Join
    • Full Outer Joins
    • Complex Join Queries etc
  • Views, Inline Views & Joins
  • Sub query
  • Create Complex Queries
    • Using Joins, Groups, Views & Subquery all together
    • Creating tables using queries
    • Inserting, Update & Delete using Select Queries
  • Top n Analysis
  • SQL Server Routines
  • Cursors
  • Procedures
    • Programming in Procedures o If..elseif…else o while o For loops
    • IN & OUT parameters
    • Integrating SQL with Procedures
    • Using Grouping & Joins in Procedures
    • Returning Select Query Output from Procedures
    • Conditional Select & Query Output from Procedures
    • Condition Updates / Inserts / Deletes
    • Using Temporary Tables
    • Creating Dynamic & Runtime Queries in Procedures & Usage etc.
  • Cursors
  • Functions
    • Programming in Functions o If..elseif…else o while o For loops
    • IN & Return parameters
    • Basic and Advanced Functions with and without SQL Queries
  • Exception Handling
  • Triggers
  • Data Export & Import
  • Creating Professional ER Diagram in Management Studio
  • Integrating and Executing Routines with Dot Net Application