Table of Contents:
  • Understanding SQL
  • Introducing SQL Server
  • Working with SQL Server
  • Retrieving Data
  • Sorting Retrieved Data
  • Filtering Data
  • Advanced Data Filtering
  • Using Wildcard Filtering
  • Creating Calculated Fields
  • Using Data Manipulation Functions
  • Summarizing Data
  • Grouping Data
  • Working with Subqueries
  • Joining Tables
  • Creating Advanced Joins
  • Combining Queries
  • Full-Text Searching
  • Inserting Data19 Updating and Deleting Data
  • Creating and Manipulating Tables
  • Using Views
  • Programming with T-SQL
  • Working with Stored Procedures
  • Using Cursors
  • Using Triggers
  • Managing Transaction Processing
  • Working with XML and JSON
  • Globalization and Localization
  • Managing Security
  • Improving Performance
  • The Example Tables
  • T-SQL Statement Syntax
  • T-SQL Datatypes
  • T-SQL Reserved Words