This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to implementing a database.
This course is intended for DBAs and developers who administer and develop SQL Server databases.


Objetivos:

_ Understand the product, its components, and basic configuration.
_ Work with the data types supported by SQL Server.
_ Design and implement tables and work with schemas.
_ Design and implement views and partitioned views.
_ Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
_ Identify the appropriate table structures and implement clustered indexes and heaps.
_ Describe and capture execution plans.
_ Design and implement non-clustered indexes, covering indexes, and included columns.
_ Design and implement stored procedures.
_ Implement table types, table valued parameters, and the MERGE statement.
_ Describe transactions, transaction isolation levels, and application design patterns for highly-concurrent applications.
_ Design and implement T-SQL error handling and structured exception handling.
_ Design and implement scalar and table-valued functions.
_ Design and implement constraints.
_ Design and implement triggers.
_ Describe and implement target use cases of SQL CLR integration.
_ Describe and implement XML data and schema in SQL Server.
_ Use FOR XML and XPath queries.
_ Describe and use spatial data types in SQL Server.
_ Implement and query full-text indexes.


Conteúdo Programático:

_ Module 1: Introduction to SQL Server and its Toolset
_ Module 2: Working with Data Types
_ Module 3: Designing and Implementing Tables
_ Module 4: Designing and Implementing Views
_ Module 5: Planning for SQL Server Indexing
_ Module 6: Implementing Table Structures in SQL Server
_ Module 7: Reading SQL Server Execution Plans
_ Module 8: Improving Performance through Nonclustered Indexes
_ Module 9: Designing and Implementing Stored Procedures
_ Module 10: Merging Data and Passing Tables
_ Module 11: Creating Highly Concurrent SQL Server Applications
_ Module 12: Handling Errors in T-SQL Code
_ Module 13: Designing and Implementing User-Defined Functions
_ Module 14: Ensuring Data Integrity through Constraints
_ Module 15: Responding to Data Manipulation via Triggers
_ Module 16: Implementing Managed Code in SQL Server
_ Module 17: Storing XML Data in SQL Server
_ Module 18: Querying XML Data in SQL Server
_ Module 19: Working with SQL Server Spatial Data
_ Module 20: Working with Full-Text Indexes and Queries


Pré Requisitos:

_ Working knowledge of Transact-SQL.
_ Working knowledge of Relational databases.
_ Core Windows Server skills.
_ Database design skills.
_ SQL Server skills - ability to write Transact-SQL queries or completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.


Duração: 30 Horas / 5 Dias

Solicite mais informação

Inscreva-se neste curso