Mensys Online Shop

Inside Microsoft SQL Server 2008: T-SQL Querying

Categorie:Algemeen - Boeken Van:Microsoft Press
Meer informatie:www.comcol.nl/micros...Auteur(s):Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Bladzijden:798Publicatie-jaar:2009

Delve into the internal architecture of T-SQL - and unveil the power of set-based querying - with reference & advice from a highly regarded T-SQL expert and members of Microsoft's SQL Server development team.Database developers and administrators will examine the best practices, advanced techniques, sample databases, and code needed to master the programming language built into SQL Server - solving complex problems with real-world solutions.- Understand logical & physical query processing;-  » Lees meer...

Inside Microsoft SQL Server 2008: T-SQL Querying

Selecteer een of meer artikelen en klik dan op Bestellen. Aantallen kunnen op de volgende blz. gewijzigd worden.
Partnr.OmschrijvingEuro *Euro incl. BTW 
A88223 Inside Microsoft SQL Server 2008: T-SQL Querying37.6439.90

Alle prijzen zijn in Euro excl. BTW (19%, voor boeken 6%) en excl. verzendkosten.
E-mail of bel 023 548 20 20 voor licenties, upgrades en andere vragen.

Delve into the internal architecture of T-SQL - and unveil the power of set-based querying - with reference & advice from a highly regarded T-SQL expert and members of Microsoft's SQL Server development team.Database developers and administrators will examine the best practices, advanced techniques, sample databases, and code needed to master the programming language built into SQL Server - solving complex problems with real-world solutions.- Understand logical & physical query processing;- Learn about set theory, predicate logic, and the relational model;- Apply a methodology to optimize query tuning;- Analyze the algorithmic complexity of your queries;- Solve relational division problems;- Use CTEs and ranking functions to simplify & optimize solutions;- Aggregate data with various techniques, including tiebreakers, pivoting, histograms, grouping factors, & grouping sets;- Use the TOP option to query and modify data;- Use the MERGE statement to modify data based on conditional logic;- Maintain & query graph structures with the HIERARCHYID datatype, recursive queries, and other solutions;- PLUS - Improve your logic & get to the heart of querying problems with logic puzzles.