Autore	Vieira Robert
Edizione	[1st edition]
Pubbl/distr/stampa	Indianapolis, IN, : Wiley Pub., 2008
Descrizione fisica	1 online resource (724 p.)
Disciplina	005.75/85
Collana	Wrox beginning guides.
Soggetto topico	Database management Relational databases
Soggetto genere / forma	Electronic books.
ISBN	1-118-05960-3 1-282-68296-2 9786612682964 0-470-42394-3
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Beginning Microsoft SQL Server 2008 Programming; About the Author; Credits; Acknowledgments; Contents; Introduction; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; Chapter 2: Tools of the Trade; Chapter 3: The Foundation Statements of T-SQL; Chapter 4: JOINs; Chapter 5: Creating and Altering Tables; Chapter 6: Constraints; Chapter 7: Adding More to Our Queries; Chapter 8: Being Normal: Normalization and Other Basic Design Issues; Chapter 9: SQL Server Storage and Index Structures; Chapter 10: Views; Chapter 11: Writing Scripts and Batches; Chapter 12: Stored Procedures Chapter 13: User-Defined FunctionsChapter 14: Transactions and Locks; Chapter 15: Triggers; Chapter 16: A Brief XML Primer; Chapter 17: Reporting for Duty, Sir! A Look At Reporting Services; Chapter 18: Getting Integrated with Integration Services; Chapter 19: Playing Administrator; Appendix A: System Functions; Appendix B: Very Simple Connectivity Examples; Index
Record Nr.	UNINA-9910454130303321

Autore	Aspin Adam
Edizione	[1st ed. 2015.]
Pubbl/distr/stampa	Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015
Descrizione fisica	1 online resource (413 p.)
Disciplina	005.75 005.75/85
Collana	The expert's voice in SQL server
Soggetto topico	Database management Data structures (Computer science) Data mining Database Management Data Structures and Information Theory Data Mining and Knowledge Discovery
ISBN	1-4842-0532-4
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewers""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: SQL Server Reporting Services as a Business Intelligence Platform""; ""Business Intelligence Concepts""; ""Key Performance Indicators""; ""Scorecards""; ""Dashboards""; ""SSRS for Business Intelligence, Practically""; ""Getting the Data Right""; ""Prepare the Data""; ""Use Views and Stored Procedures""; ""Views""; ""Stored Procedures""; ""Some Ideas on Source Data Definition""; ""Real-World Data"" ""Designing SQL Server Reports for Business Intelligence""""Presentation""; ""Design""; ""Layout""; ""Interface and Interactivity""; ""Multi-Purposing""; ""The Sample Database""; ""Preparing Your Environment""; ""Creating an SSDT Project""; ""Adding a Shared Datasource""; ""Add Shared Datasets""; ""Configuring Parameters""; ""Code and Stored Procedures""; ""Reusability""; ""The CarSales_Reports Database""; ""Book Audience""; ""How Best to Use This Book""; ""Conclusion""; ""Chapter 2: KPIs and Scorecards""; ""What Are Key Performance Indicators?""; ""KPI Value""; ""KPI Goal""; ""KPI Status"" ""KPI Status Thresholds""""Threshold Flags""; ""KPI Trends""; ""KPI Trend Thresholds and Flags""; ""A Simple KPI""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""A More Complex KPI Using Sparklines""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""Gauge-Based KPIs""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge-Based KPI""; ""How It Works""; ""Hints and Tips""; ""Text-Based KPIs""; ""A Simple Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Text-Based KPI"" ""How It Works""""A Complex Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Complex Text-Based KPI""; ""How It Works""; ""Conclusion""; ""Chapter 3: Gauges for Business Intelligence""; ""Gauge Elements""; ""Data for Gauges""; ""Gauge Development""; ""Classic Gauges""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Using Multiple Pointers in Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating the Gauge""; ""How It Works""; ""Varying the Pointer Types and Assembling Gauges"" ""The Source Data""""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Gauges with Multiple Elements""; ""The Source Data""; ""Creating the Gauge""; ""How It Works""; ""Hints and Tips""; ""Less Traditional Gauges""; ""Thermometers""; ""The Source Data""; ""How the Code Works""; ""Building the Thermometer""; ""How It Works""; ""Hints and Tips""; ""Sub-Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating Gauges with Sub-Gauges""; ""How It Works""; ""Hints and Tips""; ""Interesting Tricks with Gauges""; ""The Source Data""; ""How the Code Works"" ""Creating and Assembling the Gauges""
Record Nr.	UNINA-9910300638303321

Autore	Lawson Susan
Edizione	[1st ed.]
Pubbl/distr/stampa	Ketchum, Idaho, : MC Press, 2006
Descrizione fisica	1 online resource (1009 p.)
Disciplina	005.75/85 005.7585
Altri autori (Persone)	LuksetichDan
Soggetto topico	Electronic data processing personnel - Certification Database management
Soggetto genere / forma	Electronic books.
ISBN	1-58347-645-8
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Cover; Acknowledgments; Copyright; Contents; Introduction IBM DB2 10 for z/OS Certified Database Administrator ; 1: DB2 Product Fundamentals; DB2 and the On Demand Business; The DB2 Product Family; DB2 Middleware and Connectivity; InfoSphere Optim Data Lifecycle Management for DB2; Additional DB2 Application Development and Administration; Summary and Resources; Practice Questions and Answers; 2: Environment; z/OS; DB2 for z/OS; DB2 and Security; Parallel Sysplex Support; Storage Management Subsystem; DB2 Interfaces; Installation, Migration, and Conversion; DSNZPARMs; Commands DB2 Utilities Catalog and Directory; Distributed Data; Memory Management; Summary and Resources; Practice Questions and Answers; 3: Access and Security; DB2 Subsystem Access; Data Set Protection; Encryption; DB2 Object Access; Multilevel Security; Auditing; Summary and Resources; Practice Questions and Answers; 4: Database Objects; Understanding Data Structures; Managing Database Objects; Data Types; Tables; Sequence Objects; Table Spaces; Views; Materialized Query Tables; Clone Tables; Temporal Tables; Hash Tables (Tables with Hash Access Enabled); Indexes; Databases; Storage Groups Database Design and Implementation Sample Implementation; Summary and Resources; Practice Questions and Answers; 5: Retrieving and Manipulating Database Objects; Data Retrieval; Data Modification; Summary and Resources; Practice Questions and Answers; 6: Advanced SQL Coding; Subqueries; Unions; Excepts; Intersects; Nested Table Expressions; Common Table Expressions; Data Change Tables; Joins; ORDER BY and FETCH FIRST in Subselects and Fullselects; CASE Expressions; Row Expressions; PureXML Usage; OLAP Specification; Predicates and Filtering; Summary and Resources Practice Questions and Answers 7: Maintaining Data; Data Movement; Data Maintenance; Rebuilding Indexes; Data Statistics; Real-Time Statistics; Data Maintenance Process; Diagnose Utility; Standalone Utilities; Displaying Utilities; Resolving Restrictive and Advisory States; Summary and Resources; Practice Questions and Answers; 8: Recovery and Restart; Database Recovery Concepts; Logging; Image Copies; Establishing a Point of Consistency; Recovery Concepts; System-Level Backup and Recovery; Backup and Recovery of the DB2 Catalog and Directory; Disaster Recovery; LOB and XML Recovery Tracker Site Recovery DB2 Restart; Data Sharing Recovery; Summary and Resources; Practice Questions and Answers; 9: Data Sharing; Data Sharing Benefits; Data Sharing Components; Shared Data; Maintaining Data Integrity; Performance; Processing Costs; Movement to Data Sharing; Workload Management and Affinity Processing; Submitting Work; Communicating with a Data Sharing Group; Sysplex Query Parallelism; Recovery Considerations; Summary and Resources; Practice Questions and Answers; 10: Using SQL in an Application Program; Delimiting SQL in a Program; Declaring Table and View Definitions SQL Execution Validation
Record Nr.	UNINA-9910453088703321