SQL Server 2005 (Yukon)
Computer
Training
Provided by Microsys Technologies and Solutions Pvt. Ltd.,
.NET CLR Integration
Creating Stored procedures, user-defined functions, triggers using .NET
The SQL Server programming models
.Net user-defined types (UDT)
User Defined Aggregates (UDA)
Security Improvements
New Database Engine Features
New Transact SQL Features
XML Data Types
XQuery
HTTP Endpoints and Web Services
Service Broker
Client Libraries and enhancements
|
|
||||||||||||
SQL Server 2005 (Yukon)
Day 1
.NET CLR Integration
CLR Hosting
Using .NET inside SQL Server
Creating Stored procedures, user-defined functions, triggers using .NET
Cataloging .Net Assemblies in SQL Server 2005
Cataloging SP, UDF and Triggers
Using Visual Studio .Net 2005 to create and test SP, UDF, Triggers
The SQL Server programming models
The new System.Data.SqlServer provider
Using .NET SQL Server data provider inside the DB
Using the SqlContext, SqlPipe, SqlDefinition classes
.Net user-defined types (UDT)
Why UDT s?
Creating and cataloging User Defined Types
NULL values and comparison
Conversion to string and XML
Adding Accessors and Mutators to UDT
Serialization choices
Customizing serialization for the UDT
User Defined Aggregates (UDA)
Creating and cataloging UDA
Usage of UDA
Day 2
Security Improvements
New login functions and policies
Logins
Roles
Password policy application
Separating schemas from users
Permissions
All permissions grantable
Permissions and .Net objects
Execution context for procedural code
Execution context and ownership chains
Using Execute As
New Database Engine Features
New Data Types
Varchar(MAX), NVarchar(MAX), VarBinary(MAX)
Snapshot Isolation Level
Transaction Isolation and Versioning
Transaction Level Snapshot
Statement Level Snapshot
Extended Triggers and Notifications
DDL Triggers
Triggers on System events
EventData() function
Event Notifications
New Transact SQL Features
Exception Handling
Common Table Expressions
Used for hierarchical queries
Used for recursive queries
PIVOT / UNPIVOT operators
Ranking Functions and Partitioning
Cross-Outer Apply
TOP enhancements
Using Output clause on action statements
XML Data Types
XML as a native data type
Using the XML type in Tables, Variables, and Parameters
Creating and using Schema Collection
Schema validated and untyped xml
XML type indexes
FOR XML and OpenXML enhancements
XQuery
Introduction to XQuery
Using XQuery with the XML data type
Methods on XML Type
Using FLWOR expressions
Updating the XML data type with XQuery DML
Day 3
HTTP Endpoints and Web Services
Architecture
WebService Hosting
Managing WebServices
Declaring HTTP endpoints
WSDL generation
XML input and output in web services
message headers
Accessing HTTP endpoints in .NET clients
Service Broker
Architecture
SQL Server Broker objects
Message Types / Contract / Services
Messaging extensions in Transact-SQL
Service Broker SQL Server Usage
Client Libraries and enhancements
SNAC (SQL Native Client)
Multiple Active Resultsets (MARS)
Dependencies and Notifications on the client
Snapshot isolation support
Asynchronous Support
About The Training Provider: Microsys Technologies and Solutions Pvt. Ltd.,
Microsys Technologies and Solutions Pvt. Ltd., - Microsys Technologies & Solutions Pvt. Ltd is a proactive organization headquartered in Pune with its branches across Mumbai & Bangalore. In the last few years of our existence we have successfully offered value propositions to our clientele across the country and overseas.
Customized Software Development
Corporate Training & IT Education
leadership and management skill programs
...
