SQL Server

TRANSACT-SQL ONLINE TRAINING

TRANSACT-SQL COURSE CONTENT

  • RELATIONAL DATABASE BASICS

  • Brief History of SQL
  • Relational Databases [may be compressed due to attendee experience]
    • Tables
    • Rows
    • Columns
    • Relationships
    • Datatypes
    • Primary Keys
    • Foreign Keys
    • Relational Database Management System
  • SQL Server Objects
    • Valid Object References
  • SQL Statements
    • Database Manipulation Language (DML)
    • Database Definition Language (DDL)
    • Database Control Language (DCL)
  • SIMPLE SELECTS WITH SQL SERVER

  • Introduction to the Northwind Database
  • Some Basics
    • Comments
    • Whitespace and Semi-colons
    • Case Sensitivity
  • SELECTing All Columns in All Rows
  • Exploring the Tables
  • SELECTing Specific Columns
  • Sorting Records
    • Sorting By a Single Column
    • Sorting By Multiple Columns
    • Sorting By Column Position
    • Ascending and Descending Sorts
  • The WHERE Clause and Operator Symbols
    • Checking for Equality
    • Checking for Inequality
    • Checking for Greater or Less Than
    • Checking for NULL
    • WHERE and ORDER BY
  • The WHERE Clause and Operator Words
    • The BETWEEN Operator
    • The IN Operator
    • The LIKE Operator
    • The NOT Operator
  • Checking Multiple Conditions
    • AND
    • OR
    • Order of Evaluation
  • Writing SELECTs with Multiple Conditions
  • ADVANCED SELECTS WITH SQL SERVER

  • Calculated Fields
    • Concatenation
    • Mathematical Calculations
    • Aliases
  • Aggregate Functions and Grouping
    • Aggregate Functions
    • Grouping Data
  • Built-in Data Manipulation Functions
    • Common Math Functions
    • Common String Functions
    • Common Date Functions

    SUBQUERIES, JOINS, AND UNIONS WITH SQL SERVER

  • Subqueries
  • Joins
    • Table Aliases
    • Multi-table Joins
  • Outer Joins
  • Unions
    • UNION ALL
    • UNION Rules

    INSERTING, UPDATING AND DELETING RECORDS WITH SQL SERVER

  • INSERT
  • UPDATE
  • DELETE
  • CREATING AND MODIFYING TABLES WITH SQL SERVER

  • Creating Tables
  • Datatypes
  • Altering Tables
    • Adding a Column
    • Dropping a Column
  • Renaming Tables
  • Dropping Tables
  • VIEWS AND STORED PROCEDURES IN SQL SERVER

  • Creating Views
  • Dropping Views
  • Creating Stored Procedures
    • Designing a stored procedure
    • Specifying input parameters
    • Returning a recordset
    • Returning output parameters
  • Testing stored procedures
  • CONCLUSION