| | |
|
SQL Server 2005 Fundamentals
|
This course covers the wide range of technologies added or enhanced in
SQL Server 2005 starting with database topics such as the T-SQL language,
the database engine, and security enhancements. The new XML data type
including support for XML Schema and XQuery; using .NET inside of SQL
Server to extend it; and ADO.NET that is used inside SQL Server as
well as on the client rounds out the coverage.
|
Who Should Attend
This course is targeted at developers of databases and the applications
that use them. This release of SQL server is meant to expand the range of
developers who use SQL Server. This is not a DBA oriented course, but it will
be of interest to DBA’s who do some development, so that they can prepare
for new uses of the databases they administer.
|
|
|
|
|
|
|
course details
| Technologies: |
.NET 2.0, SQL
|
| Language(s): |
T-SQL, C#
|
| Length: |
Four days, 9am-5pm
|
| US Class Price: |
$2795 |
| UK Class Price: |
$3195 |
|
|
|
|
|
|
|
Course outline:
Day 1
|
| |
T-SQL I |
- development tools
- snapshot isolation
- event notification
- large data types
- TOP option
- covering indexes
- delete/update
- bulk provider
|
|
| |
T-SQL II |
- output clause
- apply operator
- common table expressions
- recursive queries
- windowing and partitioning functions
- pivot
- intersect
- try/catch
- table sampling
|
|
| |
Security |
- authentication
- authorization
- surface area configuration
- sql login management
- schemas
- permission hierarchy
- covering permissions
- impersonation
- encryption
- code signing
|
|
Day 2
|
| |
XML Datatype |
- text vs. xml
- untyped xml
- xml encoding
- xml schemas
- stongly typed xml
- well-formed xml
- valid xml
- namespaces
- xml indexes
- XPath
- xml composition
|
|
| |
XQuery |
- XQuery languauge
- using XQuery
- T-SQL integration
- XQuery functions
- FOWR expressions
- static analysis
- joining xml and relational data
- shredding xml
|
|
| |
Common Language Runtime Based Functionality |
- security, reliability, and scalability
- CLR hosting
- assemblies
- permission sets
- stored procedures
- functions
- SqlTypes
- errors
|
|
Day 3
|
| |
In-Process Data Access |
- in process model
- SqlContext
- commands and results
- SqlPipe
- rowsets
- triggers
|
|
| |
CLR Based User Defined Types and Aggregates |
- user defined types
- native serialization
- user defined serialization
- instances members
- static members
- sort order
- user defined aggregates
|
|
| |
ADO Enhancements |
- large object support
- user defined type support
- xml support
- multiple active result sets
- declarative transactions
- client side bulk import
- asynchronous operations
- client side statisitics
- generic coding
|
|
Day 4
|
| |
SQL Server Management Object - SMO |
- object models
- connection management
- managing database objects
- object identity
- scripting
- ADO vs. SMO
- transactions
- ad hoc queries
|
|
| |
Query Plan Management |
- query plan operation
- accessing query plans
- recompilation
- parameterization of plans
- controlling usage of plans
|
|
|
|
|
| | |