Beginning Transact-SQL with SQL Server 2000 and 2005
Beginning Transact-SQL with SQL Server 2000 and 2005 Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive in...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley Pub
c2006.
|
| Edición: | 1st edition |
| Colección: | Wrox beginning guides.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627179606719 |
Tabla de Contenidos:
- Beginning Transact-SQL with SQL Server 2000 and 2005; About the Authors; Credits; Contents; Acknowledgments; Foreword; Chapter 1: Introducing Transact-SQL and Data Management Systems; Transact-Structured Query Language; SQL Server as a Relational Database Management System; SQL Server and Other Products; Summary; Chapter 2: SQL Server Fundamentals; Who Uses SQL Server?; SQL Server Editions and Features; Semantics; Normalization Rules; Applying Normalization Rules; Client/Server Processes; The Mechanics of Query Processing; The Adventure Works Cycles Database; Summary
- Chapter 3: Tools for Accessing SQL ServerTools for SQL Server 2000; Tools for SQL Server 2005; Summary; Exercises; Chapter 4: Introducing Transact-SQL Language; The Nature of SQL; Where to Begin; Data Manipulation Language ( DML); Data Definition Language; Data Control Language; Summary; Exercises; Chapter 5: Data Retrieval; Storage and Retrieval; The SELECT Statement; Summary; Exercises; Chapter 6: SQL Functions; The Anatomy of a Function; Aggregate Functions; Configuration Variables; Conversion Functions; Summary; Exercises; Chapter 7: Aggregation and Grouping; Using Aggregate Functions
- Understanding Statistical FunctionsGrouping Data; Summary; Exercises; Chapter 8: Multi-Table Queries; Understanding Subqueries and Joins; Summary; Exercises; Chapter 9: Data Transactions; Introducing Transactions; Let's Do CRUD with Data; Explicit Transactions; Summary; Exercises; Chapter 10: Advanced Queries and Scripting; Subqueries; Cursors; Summary; Exercises; Chapter 11: Full-Text Index Queries; Microsoft Search Service; Managing and Populating Catalogs; Summary; Chapter 12: Creating and Managing Database Objects; Data Definition Language; Securing Database Objects; Summary; Exercises
- Chapter 13: Transact-SQL Programming ObjectsViews; Stored Procedures; User-Defined Functions; Transaction Management; Summary; Exercises; Chapter 14: Transact-SQL in Applications and Reporting; Application Programming Models; Selecting a Model; SQL Server Reporting Services; Summary; Appendix A: Command Syntax Reference; Transact-SQL Commands, Clauses, and Predicates; Appendix B: System Variables and Functions Reference; System Global Variables; Appendix C: System Stored Procedure Reference; Appendix D: Information Schema Views Reference; Answers to Exercises; Index
