Beginning T-SQL, 4th Edition

A Step-by-Step Approach



Bookstore > Books > Beginning T-SQL, 4th Edition

Price$44.99 - $55.32
Rating
AuthorsKathi Kellenberger, Lee Everest
PublisherApress
Published2021
Pages706
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484266056
ISBN-139781484266052
EBook Hardcover Paperback

Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now include the WideWorldImporters database, the newest sample database from Microsoft for SQL Server. Also new in this edition is coverage of JSON from T-SQL, news about performance enhancements called Intelligent Query Processing, and an appendix on running SQL Server in a container on macOS or Linux.

Beginning T-SQL starts you on the path to mastering T-SQL with an emphasis on best practices. Using the sound coding techniques taught in this book will lead to excellent performance in the queries that you write in your daily work. Important techniques such as windowing functions are covered to help you write fast-executing queries that solve real business problems.The book begins with an introduction to databases, normalization, and to setting up your learning environment. You will learn about the tools you need to use such as SQL Server Management Studio, Azure Data Studio, and SQL Notebooks. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in most chapters provide an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional.

A stand-out feature in this book is that most chapters end with a Thinking About Performance section. These sections cover aspects of query performance relative to the content just presented, including the new Intelligent Query Processing features that make queries faster without changing code. They will help you avoid beginner mistakes by knowing about and thinking about performance from day 1.


  1. (4 books)



5 5 2

Similar Books


Beginning T-SQL, 3rd Edition

Beginning T-SQL, 3rd Edition

by Kathi Kellenberger, Scott Shaw

Beginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning...

Price:  $44.48  |  Publisher:  Apress  |  Release:  2014

Beginning T-SQL 2012, 2nd Edition

Beginning T-SQL 2012, 2nd Edition

by Scott Shaw, Kathi Kellenberger

Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft's SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning ...

Price:  $35.10  |  Publisher:  Apress  |  Release:  2012

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

by Paul Turley, Dan Wood

Transact-SQL, or T-SQL, is Microsoft Corporation's powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational database management systems (RDBMS).You may already have a basic idea of what SQL is used for, but you may not have a good understanding of the ...

Price:  $21.96  |  Publisher:  Wrox  |  Release:  2008

Beginning Oracle SQL, 3rd Edition

Beginning Oracle SQL, 3rd Edition

by Lex deHaan, Tim Gorman, Inger Jorgensen, Melanie Caffrey

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQ...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2014

Anti-Hacker Tool Kit, 4th Edition

Anti-Hacker Tool Kit, 4th Edition

by Mike Shema

Fully revised to include cutting-edge new tools for your security arsenal, Anti-Hacker Tool Kit, Fourth Edition reveals how to protect your network from a wide range of nefarious exploits. You'll get detailed explanations of each tool's function along with best practices for configuration and implementation illustrated by code samples and...

Price:  $32.99  |  Publisher:  McGraw-Hill  |  Release:  2014

Beginning SQL Server for Developers, 4th Edition

Beginning SQL Server for Developers, 4th Edition

by Robin Dewson

Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft's market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL Server, including the in-memory fe...

Price:  $36.98  |  Publisher:  Apress  |  Release:  2014

Beginning Programming with Java For Dummies, 4th Edition

Beginning Programming with Java For Dummies, 4th Edition

by Barry Burd

Beginning Programming with Java For Dummies, 4th Edition is a comprehensive guide to learning one of the most popular programming languages worldwide. This book covers basic development concepts and techniques through a Java lens. You'll learn what goes into a program, how to put the pieces together, how to deal with challenges, and how t...

Price:  $9.99  |  Publisher:  Wiley  |  Release:  2014

Beginning PHP and MySQL, 4th Edition

Beginning PHP and MySQL, 4th Edition

by W. Jason Gilmore

Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmore's authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Work...

Price:  $29.00  |  Publisher:  Apress  |  Release:  2010