This book gives you an overview of how to create and insert Query, simple SQL Select query, aggregate and scalar function, date Function, where Clause. It also familiarizes you with Group BY clause, joins, view, pivot and the stored procedures, functions and SQL Server coding standards.
Table of Content
  • Create and Insert Query
  • Simple SQL Select Query
  • Aggregate and Scalar Function
  • Date Function
  • Other Select Function
  • Where
  • Group BY and Having Clause
  • Sub Query
  • Joins
  • UNION and UNION ALL.
  • Common Table Expressions(CTE) - With
  • View
  • Pivot
  • Stored Procedure (SP)
  • Functions
  • SQL Server Coding Standards
  • Few Worked Examples