Beginning T-SQL, 4th Edition

A Step-by-Step Approach



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

Price$27.69 - $41.40
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 6

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 Linux Programming, 4th Edition

Beginning Linux Programming, 4th Edition

by Richard Stones, Neil Matthew

Building on the success of its previous editions, this must-have guide continues its popular tutorial approach and brings you a straightforward introduction to developing programs for Linux and other UNIX-style operating systems. The author duo of experienced Linux programmers covers a wide range of topics to help you learn more about wha...

Price:  $22.00  |  Publisher:  Wrox  |  Release:  2011

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. Begin...

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

Introduction to Android Application Development, 4th Edition

Introduction to Android Application Development, 4th Edition

by Joseph Annuzzi, Lauren Darcey, Shane Conder

This fully reworked edition of a proven title is the most useful real-world guide to building robust, commercial-grade Androidâ„¢ apps. The content is revised and updated for the latest Android 4.3 SDK and the newest development best practices. Introduction to Androidâ„¢ Application Development: Android Essentials, Fourth Edition,covers a...

Price:  $25.00  |  Publisher:  Addison-Wesley  |  Release:  2013

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition

by Ben Forta

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Microsoft SQL Server's T-SQL language.This handy pocket guide starts with ...

Price:  $17.59  |  Publisher:  SAMS Publishing  |  Release:  2017

Beginning Ubuntu Linux, 5th Edition

Beginning Ubuntu Linux, 5th Edition

by Emilio Raggi, Keir Thomas, Andy Channelle, Trevor Parsons, Sander van Vugt

Ubuntu Linux is the fastest growing Linux - based operating system, and Beginning Ubuntu Linux, Fifth Edition teaches all of us - including those who have never used Linux - how to use it productively, whether you come from Windows or the Mac or the world of open source.Beginning Ubuntu Linux, Fifth Edition shows you how to take advantage...

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

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...

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