SQL Books



Bookstore > Books > SQL

Refactoring Legacy T-SQL for Improved Performance

Refactoring Legacy T-SQL for Improved Performance

by Lisa Bohm

Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported in current versions of SQL Server, including SQL Server 2019. The focus moves through the diffe...

Price:  $26.92  |  Publisher:  Apress  |  Release:  2020

Pro T-SQL 2019

Pro T-SQL 2019

by Elizabeth Noble

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

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

PolyBase Revealed

PolyBase Revealed

by Kevin Feasel

Harness the power of PolyBase data virtualization software to make data from a variety of sources easily accessible through SQL queries while using the T-SQL skills you already know and have mastered.PolyBase Revealed shows you how to use the PolyBase feature of SQL Server 2019 to integrate SQL Server with Azure Blob Storage, Apache Hadoop, other SQL Server instances, Oracle, Cosmos DB, Apache Spark, and mo...

Price:  $21.73  |  Publisher:  Apress  |  Release:  2020

Hands On Google Cloud SQL and Cloud Spanner

Hands On Google Cloud SQL and Cloud Spanner

by Navin Sabharwal, Shakuntala Gupta Edward

Discover the methodologies and best practices for getting started with Google Cloud Platform relational services - CloudSQL and CloudSpanner.The book begins with the basics of working with the Google Cloud Platform along with an introduction to the database technologies available for developers from Google Cloud. You'll then take an in-depth hands on journey into Google CloudSQL and CloudSpanner, including ...

Price:  $30.23  |  Publisher:  Apress  |  Release:  2020

Practical Oracle SQL

Practical Oracle SQL

by Kim Berg Hansen

Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92.Both standard SQL and Oracle's own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit sometimes complex, SQL statement. If you already know the basics of SQL, th...

Price:  $29.12  |  Publisher:  Apress  |  Release:  2020

Essential ASP.NET Web Forms Development

Essential ASP.NET Web Forms Development

by Robert E. Beasley

Go from beginner to pro using one of the most effective and widely used technology stacks, Microsoft ASP.NET. Beginning with the basics, you will learn how to create interactive, professional-grade, database-driven web applications in no time, using ASP.NET, C#, SQL, Ajax, and JavaScript.Essential ASP.NET Web Forms Development is divided into six learning modules and will take you from soup to nuts with ASP...

Price:  $31.72  |  Publisher:  Apress  |  Release:  2020

Learning SQL, 3rd Edition

Learning SQL, 3rd Edition

by Alan Beaulieu

As data floods into your company, you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'll find new chapters on SQL and big data, analytic functions, and working ...

Price:  $29.99  |  Publisher:  O'Reilly Media  |  Release:  2020

PowerShell for Sysadmins

PowerShell for Sysadmins

by Adam Bertram

PowerShell is both a scripting language and an administrative shell that lets you control and automate nearly every aspect of IT. In PowerShell for Sysadmins, five-time Microsoft MVP "Adam the Automator" Bertram shows you how to use PowerShell to manage and automate your desktop and server environments so that you can head out for an early lunch.You'll learn how to: Combine commands, control flow,...

Price:  $19.39  |  Publisher:  No Starch Press  |  Release:  2020

Dynamic SQL, 2nd Edition

Dynamic SQL, 2nd Edition

by Edward Pollack

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to improve efficiency and maintainability.Executing dynamic SQL is key to larg...

Price:  $30.40  |  Publisher:  Apress  |  Release:  2019

T-SQL Window Functions, 2nd Edition

T-SQL Window Functions, 2nd Edition

by Itzik Ben-Gan

Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides...

Price:  $26.99  |  Publisher:  Microsoft Press  |  Release:  2019

Pages: 1, 2, 3 ... 35 | Next→

Subscribe to Newsletter

Be the first to know about new IT books, upcoming releases, exclusive offers and more.