Pro T-SQL 2019
Toward Speed, Scalability, and Standardization for SQL Server Developers
| Price | $24.62 - $41.42
|
| Rating |   |
| Author | Elizabeth Noble |
| Publisher | Apress |
| Published | 2020 |
| Pages | 406 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484255895 |
| ISBN-13 | 9781484255896 |
Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies.
Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward.
- Choose correct data types and database objects when designing T-SQL
- Write T-SQL that searches data efficiently and uses hardware effectively
- Implement source control and testing methods to streamline the deployment process
- Design T-SQL that can be enhanced or modified with less effort
- Plan for long-term data management and storage
- Elizabeth Noble
3 5 2
Similar Books
Pro T-SQL 2012 Programmer's Guide, 3rd Edition
by Jay Natarajan, Scott Shaw, Rudi Bruchez, Michael Coles
Pro T-SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built-in Transact-SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact-SQL functionality. Fully functioning examples and downloadable source code bring technical...
Price: $49.99 | Publisher: Apress | Release: 2012
Pro T-SQL Programmer's Guide, 4th Edition
by Miguel Cebollero, Michael Coles, Jay Natarajan
Pro T-SQL Programmer's Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on...
Price: $45.64 | Publisher: Apress | Release: 2015
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
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
by Itzik Ben-Gan
Optimize your queries - and obtain simple and elegant solutions to a variety of problems - using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you're a database administrator or developer, ...
Price: $26.72 | Publisher: Microsoft Press | Release: 2012
Exam Ref 70-761 Querying Data with Transact-SQL
by Itzik Ben-Gan
Prepare for Microsoft Exam 70-761 - and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA le...
Price: $34.25 | Publisher: Microsoft Press | Release: 2017
Programming the Microsoft Bot Framework
by Joe Mayo
This is the only comprehensive, authoritative guide to building Conversational User Interfaces (CUI, a.k.a. bots, chatbots, or chatterbots) with the Microsoft Bot Framework. Reflecting the next radical revolution in human-computer interaction, it will help you leverage advanced artificial intelligence (AI) and natural language processing ...
Price: $33.86 | Publisher: Microsoft Press | Release: 2017
Arduino Projects to Save the World
by Emery Premeaux, Brian Evans
Arduino Projects to Save the World shows that it takes little more than a few tools, a few wires and sensors, an Arduino board, and a bit of gumption to build devices that lower energy bills, help you grow our own food, monitor pollution in the air and in the ground, even warn you about earth tremors.Arduino Projects to Save the World int...
Price: $27.69 | Publisher: Apress | Release: 2011
by Mathias Olausson, Joachim Rossberg, Jakob Ehn, Mattias Skold
Pro Team Foundation Service gives you a jump-start into Microsoft's cloud-based Application Lifecycle Management platform, taking you through the different stages of software development. Every project needs to plan, develop, test and release software and with agile practices often at a higher pace than ever before.Microsoft's T...
Price: $39.99 | Publisher: Apress | Release: 2013