Effectively query and modify data using Transact-SQL
Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL’s roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects.
Microsoft Data Platform MVP Itzik Ben-Gan shows you how to:
Review core SQL concepts and its mathematical roots
Create tables and enforce data integrity
Perform effective single-table queries by using the SELECT statement
Query multiple tables by using joins, subqueries, table expressions, and set operators
Use advanced query techniques such as window functions, pivoting, and grouping sets
Insert, update, delete, and merge data
Use transactions in a concurrent environment
Get started with programmable objects–from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL
Themes of the American Civil War: The War Between the States
Themes of the American Civil War offers a timely and useful guide to this vast topic for a new generation of students. The volume provides a broad-ranging assessment of the causes, complexities, and consequences of America’s most destructive conflict to date. The essays, written by top scholars in the field, and reworked for this...
30 Minutes to Master the Internet The Internet; the World-Wide Web – or sometimes, just `the Net'.
Business cards now all seem to carry electronic mail – or even `home page' – addresses; newspaper and TV adverts quote complex Web addresses, pointing the interested user into that cyberspace of multi-media, interconnected pages. Shop for PCs or software...
iCloud: Visual QuickStart Guide
Learn how to use Apple's iCloud service to share your content across all your Apple devices. This indispensable guide to Apple's iCloud service walks readers how to share their iTunes songs, photos, books, apps, files, email, contacts, and calendars across their PC, Mac, and iOS devices. Readers will learn how to create documents in...
How to Wow : Photoshop for the Web (How to Wow) A gaming site, a portfolio site, an information site: Each requires a home page, but each of those home pages requires disparate elements and approaches. How to Wow: Photoshop for the Web walks you through the process of designing each, plus 15 other navigation, animation, and automation projects that show you how to add wow to your Web pages... A Laboratory Course in C++ Data Structures, Second Edition
With a dynamic learn-by-doing focus, this laboratory manual encourages students to explore data structures by implementing them, a process through which students discover how data structures work and how they can be applied.
We have used James Robergé’s laboratory manual for three years at Taylor University. The...
Microsoft Dynamics CRM API Development for Online and On-Premise Environments
I have had the pleasure to work with Dynamics CRM since its 1.1 version. I can be honest—I didn’t feel cheated when Microsoft skipped the 2.0 release, and although it has been a late bloomer in the CRM market, it has gained significant traction over the last few releases and manages to land in the right (top right, to be specific)...