Pro T-SQL 2019

Toward Speed, Scalability, and Standardization for SQL Server Developers

Elizabeth Noble

PDF
ca. 46,99
Amazon iTunes Thalia.de Weltbild.de Hugendubel Bücher.de ebook.de kobo Osiander Google Books Barnes&Noble bol.com Legimi yourbook.shop Kulturkaufhaus ebooks-center.de
* Affiliatelinks/Werbelinks
Hinweis: Affiliatelinks/Werbelinks
Links auf reinlesen.de sind sogenannte Affiliate-Links. Wenn du auf so einen Affiliate-Link klickst und über diesen Link einkaufst, bekommt reinlesen.de von dem betreffenden Online-Shop oder Anbieter eine Provision. Für dich verändert sich der Preis nicht.

Apress img Link Publisher

Naturwissenschaften, Medizin, Informatik, Technik / Informatik

Beschreibung

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. 


What You Will Learn
  • 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

Who This Book Is For

Database developers who want to improve the efficiency of their applications, and developers who want to solve complex query and data problems more easily by writing T-SQL that performs well, brings back correct results, and is easy for other developers to understand and maintain

Weitere Titel in dieser Kategorie
Cover Cyber Operations
Jerry M. Couretas
Cover Cyber Operations
Jerry M. Couretas

Kundenbewertungen

Schlagwörter

Structured Query Language, T-SQL Querying, Stored Procedures, Transact-SQL, Integration Testing, Database Development, Advanced SQL Programming, Unit Testing, SQL, Security, Thinking in Sets, Execution Plans, Joe Celko's SQL for Smarties, Indexing, Database Tuning, Relational Database, SQL Server