The real MCTS SQL Server 2008 exam 70-433 prep kit database design
SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the largest update since SQL Server 2005, and it brings increased ability to deliver data across more platforms, and thus many different types of devices. New functionality also allows for easy stor...
| Otros Autores: | , , , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Burlington, Mass. :
Syngress Pub
c2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627543806719 |
Tabla de Contenidos:
- Front Cover; The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit: Database Design; Copyright Page; Technical Authors; Lead Authors; Contributing Authors; Contents; Chapter 1: New Features inSQL Server 2008; Introduction; A Word About the Test; New Feature Overview; Installation; Compressed Backups; Enhanced Configuration and Management of Audits; New Table Value Parameter; FileStream Data Types; Sparse Column Support; Encryption Enhancements; Key Management and Encryption; High Availability; Performance; Performance Data Management; Resource Governor (Similar to Query Governor); Freeze Plan
- SQL Server 2008 Declarative Management FrameworkDevelopment Improvements; LINQ Support; MERGE Statement; Spatial Data Type; Analysis Services Improvements; ETL/SSIS Enhancements; Reporting Services; No Longer Requires IIS; Better Graphing; Export to Word Support; Deprecated Features; Discontinued Features; Summary of Exam Objectives; Exam Objectives Fast Track; New Feature Overview; Reporting Services; Exam Objectives Frequently Asked Questions; Self Test; Self Test Quick Answer Key; Chapter 2: Implementing Objects; Introduction; Understanding DDLand DML Language Elements
- Performing a Conditional DropWorking with Tables,Constraints, and Indexes; Working with Tables and Views; Creating Tables; Computed Columns; Creating User-Defined Data Types; Working with Constraints; Enforcing Referential Integritythrough FOREIGN KEY Constraints; Creating Indexes; Working with Full-Text Indexes; Partitioning Data; Horizontal Partitioning; Vertical Partitioning; Viewing and Modifying Data; Creating Views; Creating Stored Procedures; Creating Functions; Creating Triggers; Summary of Exam Objectives; Exam Objectives Fast Track; Understanding DDL and DML Language Elements
- Working with Tables, Constraints, and IndexesViewing and Modifying Data; Exam ObjectivesFrequently Asked Questions; Self Test; Self Test Quick Answer Key; Chapter 3: Programming Objects; Introduction; Implementing Functions; Advantages and Limitations of UDFs; Scalar Functions; Example: Creating and Consuming a Scalar Function; Table-Valued Functions; Example: Creating and Consuming a Table-Valued Function and an Inline UDF; Managing User-Defined Functions; Managing User-Defined Function Security; Working with Deterministic and Nondeterministic Functions; Implementing Stored Procedures
- Creating Stored ProceduresExample: Creating and Consuming a Stored Procedure; Managing Stored Procedures; Managing Stored Procedure Security; Adjusting Transaction Isolation Levels; Implementing Triggers; Creating DML Triggers; Example: Creating and Consuming a DML Trigger; Creating DDL Triggers; Example: Creating and Consuming a DDL Trigger; Creating Logon Triggers; Example: Creating and Consuming a Logon Trigger; Using Recursive and Nested Triggers; Managing Triggers; Summary of Exam Objectives; Exam Objectives Fast Track; Implementing Functions; Implementing Stored Procedures
- Implementing Triggers
