Microsoft SQL Server 2012 T-SQL (Book 16)
- 1h 57m
- Debra Aaron, Tom Coffing
- Coffing Data Warehousing
- 2015
One of the most popular databases worldwide is the Microsoft’s SQL Server. The Microsoft Azure Cloud is rapidly making T-SQL one of the standards of SQL among millions of companies. The Microsoft SQL Server 2012 T-SQL book is your key to mastering T-SQL. With easy to use sample tables, and 700 pages of real-world example’s and explanations, this book is your perfect reference guide. Each chapter in this book starts with simple examples and continues to use a building block approach to teach both the new user and the advanced user. Pleasing to the eye, and stimulating to the mind, makes this book a worldwide masterpiece where all can learn.
About the Authors
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 20 years. Tom has written over 50 books on all aspects of Teradata, Netezza, Kognitio, Redshift, ParAccel, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 Teradata classes in places such as India, Africa, Europe, China, Malaysia, and throughout North America.
Debra Aaron’s professional life has centered around data. She started as a Certified Public Accountant and transitioned to working in Information Technology shortly before Y2K. Debra is passionate about technical training and the impact it can have on individual’s careers. She believes that most technical documentation is to too hard to understand.
In this Book
-
Microsoft SQL Server 2012 T-SQL (Book 16)
-
Introduction
-
The Basics of SQL
-
The WHERE Clause
-
Distinct, Group By and TOP
-
Aggregation
-
Join Functions
-
Date Function
-
Temporary Tables
-
Sub-query Functions
-
Window Functions OLAP
-
Working with Strings
-
Interrogating the Data
-
Table Create and Data Types
-
View Functions
-
Data Manipulation Language (DML)
-
Set Operators Functions
-
Stored Procedures
-
Statistical Aggregate Functions
-
Nexus
