Pro T-Sql 2019 - Noble Elizabeth | Libro Apress 02/2020 -

home libri books ebook dvd e film top ten sconti 0 Carrello

Torna Indietro

noble elizabeth - pro t-sql 2019

Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers

Disponibilità: solo 2 copie disponibili, compra subito!

Se ordini entro 36 minuti, consegna garantita in 48 ore lavorative
scegliendo le spedizioni Express

36,40 €
34,58 €

Questo prodotto usufruisce delle SPEDIZIONI GRATIS
selezionando l'opzione Corriere Veloce in fase di ordine.

Pagabile anche con App18 Bonus Cultura e Carta Docenti

Facebook Twitter Aggiungi commento

Spese Gratis


Lingua: Inglese


Pubblicazione: 02/2020
Edizione: 1st ed.



Part I. Building Understandable T-SQL
1. Data Types
2. Database Objects
3. Standardizing T-SQL
4. Designing T-SQL

Part II. Building Performant T-SQL
5. Set-Based Design
6. Hardware Usage
7. Execution Plans
8. Optimize T-SQL

Part III. Building Manageable T-SQL
9. Coding Standards
10. Source Control
11. Testing
12. Deployment

Part IV. Building Maintainable T-SQL
13. Functional Design
14. Logging
15. Managing Data Growth


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


Elizabeth Noble is a senior database administrator in the metro Atlanta area. It was love at first sight when she was introduced to her first database over 10 years ago. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.

Altre Informazioni



Condizione: Nuovo
Dimensioni: 254 x 178 mm Ø 802 gr
Formato: Brossura
Illustration Notes:138 Illustrations, black and white
Pagine Arabe: 406
Pagine Romane: xvii

Utilizziamo i cookie di profilazione, anche di terze parti, per migliorare la navigazione, per fornire servizi e proporti pubblicità in linea con le tue preferenze. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie clicca qui. Chiudendo questo banner o proseguendo nella navigazione acconsenti all’uso dei cookie.