SQL Queries For Beginners

Syed Shanu

This book discusses the Basic SQL Queries for Beginners.

  • Published on Jun 24 2016
  • Pages 48
  • Downloaded 18.3k
  • Type PDF
Download
    • Like
    • Love It
    • Awesome
    • Interesting
    • It's Okay
    • Thumbs Down
  • 58k
  • 0

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