Solutions

SQL Server

  • Basics

    1. Introduction
    • a) What are Tables?
    • b) What is a Database?
    • c) Creating a Database
    • d) Creating a Table
    2. Single Table Queries
    • a) Select
    • b) From
    • c) Where
    • d) Group BY
    • e) Having Clause
    • f) Top
    3. Tables\Columns
    • a) Different data types to columns
    • b) Auto numbering and Identifier Columns
    • c) Computed Columns
    4. DML Statements
    • a) Insert
    • b) Update
    • c) Delete
    5. Programming
    • a) Joins
      • i.Inner Joins
      • ii. Outer Joins
      • iii.Cross Joins
      • iv. Self-Joins
      • v.Joining Three or More Tables
    • b) Operators
      • i.Airtmetic
      • ii. Assignment
      • iii. Bitwise
      • iv.Comparison
      • v.Compound
      • vi.Logical
      • vii. Set
      • viii. String Concatenation
      • ix. Unary
      • x.Operator Precedence
    • c) Temporary Tables
      • i.Local
      • ii.Global
      • iii.Table Variables
  • Advanced

    1. Advanced DML Statements 2. Merge 3. DML statements on a JOIN 4. Stored Procedures
    • a) Output Parameters
    • b) Dealing with Errors
    • Table Valued Parameters
    5. Transactions
    • a) Begin Tran
    • b) Commit Tran
    • c) Rollback Tran
    • d) Save Tran
    6. Advanced Querying Techniques
    • a) Derived Tables
    • b) CTE
    • c) Sub queries
    7. Dare to Design a Database
    • a) Logical versus Physical Design
    • b) Purpose of a Logical Model
    • c) Relationship Types
    8. Other Advanced Concepts
    • a) User Defined Functions
    • b) Truncate and Delete
    • c) Indexes
    • d) Different Indexes types
    • e) Uses of Index
    • f) Pros and Cons of an Index
    • g) SQL Server Scheduling
    9. ON Job Lessons
    • a) SQL Server Database Diagrams
    • b) Getting Hold of related tales
    • c) Getting Hold of a database structure.
    • d) Troubleshooting different queries in a stored procedure.