Bangkok--Feb 24--Software Park Thailand
This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, and application developers. The course is designed for people who want to learn about either the planning/ design phase of technology adoption, or the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities.
Objectives:
- Use the new features and enhancements in SQL Server 2005 and describe the new development tools.
- Use Transact-SQL enhancements to perform database development tasks.
- Develop XML-based Solutions using SQL Server 2005.
Prerequisites:
- Experience developing Microsoft SQL Server 7.0 or SQL Server 2000.
- Experience with Programming Languages such as Microsoft Visual C#, VB.NET or Microsoft ASP.NET recommended.
- Experience in XML.
Course Outline:
- Module Introduction
How to Use This Course
Course Information
- Working with SQL Server 2005
Module Introduction
- Exploring Components and Features
SQL Server 2005 Components
New Features for Database Administrators
New Features for Database Developers
- Using the SQL Server 2005 Developer Tools
SQL Server 2005 Developer Tools
What Is SQL Server Management Studio?
How to Execute a Query
How to Use Object Explorer
How to Create a SQL Server Solution
- Implementing the Security Features in SQL Server 2005
SQL Server 2005 Security Architecture
Using Schemas to Manage Security
- Exploring Transact-SQL Enhancements in SQL Server 2005
Module Introduction
- Using Data Definition Language Enhancements
Enhanced Data Definition Language Statements
New and Enhanced Data Types
What Is a Partitioned Table?
Steps for Partitioning a Table
How to Create a Partitioned Table
Enhanced Indexing Features
- Using Data Manipulation Language Enhancements
How to Use the OUTPUT Keyword
How to Use Common Table Expressions
How to Use Common Table Expressions
How to Create Recursive Common Table Expressions
Using the PIVOT and UNPIVOT Operators
How to Use the APPLY Operator
How to Use Ranking Functions
- Using Structured Exception Handling
What Is Structured Exception Handling?
Using TRY...CATCH Constructs
How to Use Structured Exception Handling
- Exploring the Use of XML in SQL Server 2005
Module Introduction
- Using XML Enhancements in SQL Server 2005
Enhancements to the FOR XML Clause
How to Use the FOR XML Clause
Enhancements to the OPENXML Function
How to Use the OPENXML Function
- Using the xml Data Type
Storing XML in the Database
How to Use Untyped XML
Managing XML Schemas
How to Use Typed XML
Managing XML Indexes
- Using XQuery
What Is XQuery?
How to Use XQuery Expressions
Querying XML with xml Data Type Methods
Modifying XML with the modify Method
Shredding XML with the nodes Method
How to Use xml Data Type Methods
5 Days (30 Hrs.)
March 27-31,2006 (09:00-16:00)
Registration Fee:
12,840 Baht (Included 7% Vat)
For more information please contact
Tel: 02-583-9992 Ext 1423
E-mail : [email protected]., www.swpark.or.th End.