Beginning T-SQL, 4th Edition
A Step-by-Step Approach
| Price | $27.69 - $41.40
|
| Rating |  |
| Authors | Kathi Kellenberger, Lee Everest |
| Publisher | Apress |
| Published | 2021 |
| Pages | 706 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484266056 |
| ISBN-13 | 9781484266052 |
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.
- Kathi Kellenberger (4 books)
- Lee Everest
5 5 6
Similar Books
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 
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
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
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: $4.58 | Publisher: Addison-Wesley | Release: 2013
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
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: $1.95 | Publisher: Apress | Release: 2010
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
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: $8.38 | Publisher: Apress | Release: 2014