brag, brag, brag.. love lines Public Workshops
.NET BizTalk Commerce Server Dynamics CRM PerformancePoint Server Sharepoint Silverlight SQL Server SSAS SSIS SSRS VSTS WCF WF WPF
what others say feedback Achievements nauzad's schedule Photo Gallery
Programming in SQL Server using T-SQL (3 days)
New features in SQL Server 2005 for developers (5 days)
SQL Server 2005 Analysis Services (SSAS) ...
SQL Server 2005 Reporting Services ...
SQL Server 2005 Service Broker (1 day)
SQL Server 2005 Notification Services (1 day)
Databases
Files and Filegroups Database Design Considerations Database options Removable databases Attaching and Detaching databases
Tables
Column Datatypes Primary and Foreign key constraints Unique constraints Check constraints Default constraints
Indexes
Clustered and non clustered indexes Fill Factor Index Tuning Wizard Indexes on computed columns Indexes on views Rebuilding Indexes
Views
Creating views Indexing views Partitioning views
Stored Procedures
Creating Stored Procedures Working with parameters Returning data from stored procedures Extended stored procedures (concepts)
Triggers
Creating Triggers Instead of triggers Interted and deleted tables Multirow considerations First and Last triggers Nested Triggers
UDFs
Creating UDFs
Full Text Indexes
Administering Full Text Indexes Maintaining FTIs Transact SQL (T-SQL) System Functions Invoking UDFs Using Options Using Joins Aggregate Functions Group By clause UNION keyword Sub queries Conditional processing Error handling DML statements Transactions Implicit and Explicit Transactions Distributed Transactions Savepoints Isolation Levels Locking Issues Understanding Locking Displaying Locking Infomation Ending deadlocks Cursors Introduction to Cursors Scrolling thru Cursors Cursor types and behaviours
Transact SQL (T-SQL)
System Functions Invoking UDFs Using Options Using Joins Aggregate Functions Group By clause UNION keyword Sub queries Conditional processing Error handling DML statements
Transactions
Implicit and Explicit Transactions Distributed Transactions Savepoints Isolation Levels
Locking Issues
Understanding Locking Displaying Locking Infomation Ending deadlocks
Cursors
Introduction to Cursors Scrolling thru Cursors Cursor types and behaviours
Windows 2000/2003 Server or Windows 2000 Professional or Windows XP Professional SQL Server 2000 / 2005 with Sample Databases
Pre-Requisites
Knowledge of RDBMS concepts
New features in SQL 2005 for developers (5 days)
CLR Integration
Introduction to CLR Integration features Understand limitations of CLR Integration Cataloging Assemblies and Functions Debugging .net Assemblies Creating Stored Procedures, Triggers and UDFs in C#/VB.NET Working with SQLContext Class Using SQLTypes Creating UDTs (User Defined Types) Creating UDAs (User Defined Aggregates) Permission Sets
Security Enhancements
Understanding Logins, Users and Roles Integrating with OS Password Policies Credentials Object and accessing external resources User-Schema seperation Execution context
SQL Server Engine Enhancements
New max data types Snapshot Isolation Extended Triggers and Notifications Revised BULK INSERT syntax
T-SQL Enhancements
Exception handling using try-catch blocks Common Table Expressions (CTEs) Writing Recursive queries using CTEs PIVOT and UNPIVOT Ranking functions CROSS and OUTER APPLY Top (n) enhancements
XML Features
XML Datatype Typed and Untyped XML Columns XML Indexes Considerations for using XML Datatype columns FOR XML enhancements XQuery and XPath Support FLWOR Expressions Modifying XML Values using XQuery
XML Web Services
Declaring HTTP Endpoints Endpoint Authentication Message Formats WSDL Configuration parameters Output formats
Lab Setup
Windows 2000/2003 Server or Windows XP Professional with IIS .NET Framework 2.0 SQL Server 2005 with Sample Databases Visual Studio.NET 2005
.NET Framework Programming T-SQL Knowledge Knowledge of SQL Server 2000 / 7XML and XSD
Introduction to Service Broker
Usage Scenerious Architecture
Service Broker Concepts
Messages Message Types Dialogs Conversation Groups Contracts Queues Services Routes Endpoints
Building a Sample application using Service Broker
Security Considerations
Certificates Mapping Remote principals to local principals Transport Security User level permissions
Administering Service Broker
Managing Applications
Windows 2003 Server with IIS .NET Framework 2.0 SQL Server 2005 with SQL Reporting Services and Business Intellegince Development Studio