Cantitate/Preț
Produs
Total produse
Vezi coșul
Transact-SQL Cookbook de Ales Spetic

Transact-SQL Cookbook

Autor Ales Spetic, Jonathan Gennick
en Limba Engleză Paperback – 23 apr 2002
This cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra.
Citește tot Restrânge

Preț: 23382 lei

Preț vechi: 29227 lei
-20%

Puncte Express: 351

Carte tipărită la comandă

Livrare economică 06-20 octombrie

Livrare prin curier în România Termenul estimat este afișat lângă disponibilitate.
Transport gratuit de la 40000 lei Plată online sau ramburs, în funcție de opțiunile comenzii.
Retur gratuit în 14 zile Comandă securizată și suport în română.
 Adaugă în coș

Wish list
Gift list
Am citit!
Adaugă în listă

Specificații

ISBN-13: 9781565927568
ISBN-10: 1565927567
Pagini: 302
Dimensiuni: 178 x 234 x 18 mm
Greutate: 0.5 kg
Editura: O'Reilly

Cuprins

Dedication;
Preface;
Why We Wrote This Book;
Audience for This Book;
Which Platform and Version?;
Structure of This Book;
Conventions Used in This Book;
About the Code;
Comments and Questions;
Acknowledgments;
Chapter 1: Pivot Tables;
1.1 Using a Pivot Table;
Chapter 2: Sets;
2.1 Introduction;
2.2 The Students Example;
2.3 Implementing Set Difference;
2.4 Comparing Two Sets for Equality;
2.5 Implementing Partial Intersection;
2.6 Implementing Full Intersection;
2.7 Classifying Subsets;
2.8 Summarizing Classes of Sets;
2.9 Aggregating Aggregates;
2.10 Summarizing Aggregated Classes;
2.11 Including Nonaggregated Columns;
2.12 Finding the Top N Values in a Set;
2.13 Reporting the Size of a Set's Complement;
2.14 Finding the Complement of a Set;
2.15 Finding the Complement of a Missing Set;
2.16 Finding Complements of Sets with Different Universes;
2.17 Comparing a Set with Its Universe;
2.18 Dynamic Classification System;
Chapter 3: Data Structures;
3.1 Types of Data Structures;
3.2 Working Example;
3.3 Finding Regions;
3.4 Reporting Region Boundaries;
3.5 Limiting Region Size;
3.6 Ranking Regions by Size;
3.7 Working with Sequences;
3.8 Working with Runs;
3.9 Cumulative Aggregates in Lists;
3.10 Implementing a Stack;
3.11 Implementing Queues;
3.12 Implementing Priority Queues;
3.13 Comparing Two Rows in an Array;
3.14 Printing Matrices and Arrays;
3.15 Transposing a Matrix;
3.16 Calculating a Matrix Trace;
3.17 Comparing Two Matrices for Size;
3.18 Adding and Subtracting Matrices;
3.19 Multiplying Matrices;
Chapter 4: Hierarchies in SQL;
4.1 Types of Hierarchies;
4.2 Creating a Permission Hierarchy;
4.3 Changing Individual Permissions;
4.4 Adding New Individual Permissions;
4.5 Centralizing Authorization Logic;
4.6 Implementing General Hierarchies;
4.7 Traversing Hierarchies Recursively;
4.8 Manipulating Hierarchies Recursively;
4.9 Aggregating Hierarchies;
4.10 Preparing Multilevel Operations;
4.11 Aggregating Hierarchies Revised;
Chapter 5: Temporal Data;
5.1 Introduction;
5.2 The Schedules Example;
5.3 Enforcing Granularity Rules;
5.4 Storing Out-of-Range Temporal Values;
5.5 Deriving the First and Last Dates of the Month;
5.6 Printing Calendars;
5.7 Calculating Durations;
5.8 Reporting Durations;
5.9 Querying Periods;
5.10 Querying Periods and Respecting Granularity;
5.11 Finding Available Periods;
5.12 Finding Common Available Periods;
5.13 Excluding Recurrent Events;
5.14 Excluding Nonrecurring Events;
5.15 Finding Continuous Periods;
5.16 Using Calendar Information with Periods;
5.17 Using Calendar Information with Durations;
Chapter 6: Audit Logging;
6.1 Audit Logs;
6.2 The Warehouse Example;
6.3 Row-Level Logging;
6.4 Reporting Log Events;
6.5 Generating Current Snapshots;
6.6 Generating Time-Restricted Snapshots;
6.7 Undoing Table Changes;
6.8 Minimizing Audit-Log Space Consumption;
6.9 Online Account Balancing;
6.10 Activity-Level Logging;
6.11 Partitioning Large Log Tables;
6.12 Server Push;
Chapter 7: Importing and Transforming Data;
7.1 Considerations When Importing Data;
7.2 Working Examples;
7.3 Importing External Data;
7.4 Importing Data into a Live System;
7.5 Importing with a Single Procedure;
7.6 Hiding the Import Procedure;
7.7 Folding Tables;
7.8 Pivoting Tables;
7.9 Joining Arrays with Tables;
7.10 Joining Arrays with Master Tables;
7.11 Joining Arrays with Multiple Master Records;
7.12 Extracting Master Records from Tables;
7.13 Generating Master Records Online;
7.14 Working with Duplicates;
Chapter 8: Statistics in SQL;
8.1 Statistical Concepts;
8.2 The Light-Bulb Factory Example;
8.3 Calculating a Mean;
8.4 Calculating a Mode;
8.5 Calculating a Median;
8.6 Calculating Standard Deviation, Variance, and Standard Error;
8.7 Building Confidence Intervals;
8.8 Calculating Correlation;
8.9 Exploring Patterns with Autocorrelation;
8.10 Using a Simple Moving Average;
8.11 Extending Moving Averages;
Appendix A: The T-Distribution Table;
Colophon;