Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
T-SQL Fundamentals (3rd Edition)

Buy

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
(HTML tags aren't allowed.)

JavaScript: Novice to Ninja
JavaScript: Novice to Ninja

JavaScript is a must-have skill for all web developers. JavaScript: Novice to Ninja is a fun, practical, and comprehensive guide to the modern usage of this deceptively powerful language. Comprehensively updated to cover ECMAScript 6 and modern JavaScript development, the second edition of this step-by-step introduction to...

UNIX and Linux System Administration Handbook (5th Edition)
UNIX and Linux System Administration Handbook (5th Edition)

UNIX® and Linux® System Administration Handbook, Fifth Edition, is today’s definitive guide to installing, configuring, and maintaining any UNIX or Linux system, including systems that supply core Internet and cloud infrastructure.

 

...
Hacking the Hacker: Learn From the Experts Who Take Down Hackers
Hacking the Hacker: Learn From the Experts Who Take Down Hackers

Meet the world's top ethical hackers and explore the tools of the trade

Hacking the Hacker takes you inside the world of cybersecurity to show you what goes on behind the scenes, and introduces you to the men and women on the front lines of this technological arms race. Twenty-six of the world's top white hat...


JavaScript: Object-Oriented Programming
JavaScript: Object-Oriented Programming
It may seem that everything that needs to be written about JavaScript has already been written. However, JavaScript is changing rapidly. ECMAScript 6 has the potential to transform the language and how we code in it. Node.js has changed the way we write servers in JavaScript. Newer ideas such as React and Flux will drive the next...
Mastering Windows Server 2016 Hyper-V
Mastering Windows Server 2016 Hyper-V

Build a seamless, flexible, full-service datacenter solution

Microsoft Windows Server 2016 Hyper-V is the IT administrator's guide to this rising datacenter solution. Hyper-V has already surpassed VMWare in datacenter management, identity service for multiple devices, and more; this book shows you how to harness...

Probability and Statistics for Computer Scientists
Probability and Statistics for Computer Scientists

Student-Friendly Coverage of Probability, Statistical Methods, Simulation, and Modeling Tools
Incorporating feedback from instructors and researchers who used the previous edition, Probability and Statistics for Computer Scientists, Second Edition helps students understand general methods of stochastic
...

©2018 LearnIT (support@pdfchm.net) - Privacy Policy