SQL server 2005 bible
Use this comprehensive tutorial and reference to increase productivity and write stored procedures using the language with which you're most familiar. The revised content covers new features such as XML integration, Web services, the .NET Common Language Runtime (CLR), and security updates, mak...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley
c2007.
|
| Edición: | 1st edition |
| Colección: | Bible
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626872106719 |
Tabla de Contenidos:
- SQL Server 2005 Bible; Credits; About the Author; About the Co-Authors and Contributors; Contents at a Glance; Contents; Foreword; Acknowledgments; Introduction; Who Should Read This Book; How This Book Is Organized; How to Use This Book; What's on the Companion Website; Where to Go from Here; Part I: Laying the Foundation Beginning; Chapter 1: The Information Architecture Principle; Simplicity vs. Complexity; The Usability Objective; Data Integrity; Performance; Availability; Extensibility; Security; Optimization Theory and SQL Server; Summary; Chapter 2: Relational Database Modeling
- Modeling RealityVisible Entities; Identifying Multiple Entities; Relational Patterns; Normalization; Relational Algebra; Summary; Chapter 3: Exploring SQL Server 2005 Architecture; Data Access Architectures; SQL Server Services; Business Intelligence Services; SQL Server 2005 Editions; SQL Server Tools and Components; SQL Server 2005 Feature Pack; AdventureWorks; Exploring the Metadata; Summary; Chapter 4: Installing SQL Server 2005; Planning Your Installation; Hardware Recommendations; Performing the Installation; Upgrading from Previous Versions; Migrating to SQL Server
- Configuring the Surface Area of SQL ServerRemoving SQL Server; Summary; Chapter 5: Client Software Connectivity; Enabling Server Connectivity; SQL Server Native Client Features; Summary; Chapter 6: Using Management Studio; Organizing the Interface; Registered Servers; Object Explorer; Using the Query Editor; Using the Solution Explorer; Introducing the Templates; Summary; Part II: Manipulating Data with Select; Chapter 7: Understanding Basic Query Flow; Understanding Query Flow; From Clause Data Sources; Where Conditions; Ordering the Result Set; Select Distinct; Ranking; Summary
- Chapter 8: Using Expressions and Scalar FunctionsBuilding Expressions; Case Expressions; Working with Nulls; Scalar Functions; Summary; Chapter 9: Merging Data with Joins and Unions; Using Joins; Inner Joins; Outer Joins; Self-Joins; Cross (Unrestricted) Joins; Exotic Joins; Set Difference; Using Unions; Summary; Chapter 10: Including Data with Subqueries and CTEs; Methods and Locations; Simple Subqueries; Correlated Subqueries; Relational Division; Summary; Chapter 11: Aggregating Data; Simple Aggregations; Grouping within a Result Set; Generating Totals; Building Crosstab Queries; Summary
- Chapter 12: Navigating Hierarchical DataAdjacency List Schema Patterns; Navigating the Adjacency List; Summary; Chapter 13: Using Full-Text Search; Configuring Full-Text Search Catalogs; Word Searches; Advanced Search Options; Fuzzy Searches; Binary Object Indexing; Performance; Summary; Chapter 14: Creating Views; Why Use Views?; Working with Views; Locking Down the View; Updating through Views; Nesting Views; Using Synonyms; Summary; Chapter 15: Working with Distributed Queries; Distributed Query Concepts; Accessing a Local SQL Server Database; Linking to External Data Sources
- Developing Distributed Queries
