Deze website maakt gebruik van cookies. Klik hier voor meer informatie.X sluit
Uitgebreid zoeken
Boek

SQL Server 2012 T-SQL Programming Unleashed

Vooraankondiging
SQL Server 2012 T-SQL Programming Unleashed - Solomon, David - ISBN: 9780672336201
Prijs: € 40,25 (onder voorbehoud)
Beschikbaarheid: Nog niet verschenen.
Bindwijze: Boek, Paperback (22-06-2018)
Genre: Databases
Boekenliefde.nl:
Add to cart

Beschrijving

In SQL Server 2012 T-SQL Programming Unleashed, leading SQL Server consultant David Solomon shows database programmers how to take full advantage of it. This comprehensive how-to guide integrates exceptionally useful examples with detailed discussions of the underlying database behavior they illustrate. It provides self-contained modular coverage of each topic for rapid reference, and is organized intelligently to help readers build their knowledge incrementally as they proceed through the book. Solomon illuminates both the fundamental characteristics of T-SQL processing and the relationship between T-SQL code style and performance. Coverage includes: * T-SQL basics: how T-SQL and SQL Server interact * Data manipulation: database objects, DML, selection, complex queries, data modification, loading, and merge * Batch programming: transactions, logging, locking, temporary storage, Dynamic SQL, server-side cursors, and error handling * Creating SQL programming objects: views, stored procedures, UDFs, and triggers * Using CLR to integrate non-SQL programs * And much more

Details

Titel: SQL Server 2012 T-SQL Programming Unleashed
auteur: Solomon, David
Mediatype: Boek
Bindwijze: Paperback
Taal: Engels
Druk: 1
Aantal pagina's: 850
Uitgever: Sams
Plaats van publicatie: 01
Publicatiedatum: 22-06-2018
NUR: Databases
ISBN/ISBN13: 9780672336201
Intern nummer: 21354267

Inhoudsopgave

Part I. Overview of SQL Server and Transact-SQL
1. Understanding Transact-SQL and SQL Server
2. Connecting to SQL Server with Management Studio

Part II. Manipulating Data with T-SQL Commands
3. Understanding SQL Databases and Database Objects
4. Using Data Manipulation Language (DML)
5. Selecting Data In Depth
6. Writing Complex Queries
7. Modifying Data with Insert, Update, Delete
8. Loading Data with Bulk Insert
9. Using Merge to Build Complex Updates

Part III. Programming with T-SQL Batches
10. Programming with T-SQL Batches
11. Understanding Transactions, Logging, and Locking
12. Handling Complex Cases with Temporary Storage
13. How to Use Dynamic SQL, and When Not
14. Using Server-Side Cursors in T-SQL
15. Handling Errors in Transact-SQL

Part IV. Creating SQL Programming Objects
16. Creating and Managing Views
17. Creating and Managing Stored Procedures
18. Building Application-Ready Stored Procedures
19. Using CLR to Integrate Non-SQL Programs
20. Using User-Defined Functions
21. Creating and Managing Triggers

 

Winkelvoorraad

Dit product is op dit moment niet op voorraad in een van onze vestigingen.