|
 |
|
How to be successful as a Data Architect
Understand the emerging technologies and which to use for the right task
How to plan for performance and scalability
How to refactor an older database to a high performance design
How to design database using high-performance physical schema patterns
How to develop a solid data abstraction layer
How to develop set-based code and convert difficult cursors into queries
How to develop a comprehensive indexing strategy for best performance
How to read and understand query execution plans
How to reduce the performance impact of concurrency
|
 |
|
|
|
Data Architects who want to take advantage of the SQL Server 2005 in their designs
Data Modelers who want to design high-performance database physical schemas
Database Developers who are responsible for database design
Database developers with 2 or more years experience with SQL Server.
|
|
|
|
1) Data Architecture
The Information Architecture Principle
The Data Architect's Role: Governance, Standards, and Development
Measuring Database Objectives: simplicity, usability, data integrity, performance, availability, extensibility, security
Service Oriented Architecture (SOA), Web Services, and SQL Server
|
|
2) Optimization Theory
The Framework for Performance Designs
Optimization Theory and Refactoring
|
|
3) Measuring Performance
Establishing the Performance Baseline
Critical Counters in Performance Monitor (lab)
Key Events in SQL Server Profiler (lab)
Measuring Raw Performance (lab)
Measuring Concurrency Performance (lab)
Database Performance KPI
|
|
4) Physical Schema Design
Relational Schema Design for Performance
Schema Design Layers
Normalization & the Rules of One
Generalization (lab)
Primary Key Design
Foreign Key Design (lab)
Supertype-Subtype
Attribute Design
Constraints
Responsible Denormalization (lab)
Generic Designs (lab)
|
|
5) Hierarchical Data Designs
Adjacency List (lab)
Materialized Path (lab)
|
|
6) Designing a Data Abstraction Layer
Stored Procedures (lab)
Complex Triggers (lab)
T-SQL Best Practices
|
|
7) Dealing with Optional Data
Null Rows (lab)
Null Attributes (lab)
Surragate Nulls (lab)
|
|
8) Set-based Queries
Advanced Query Strategies
When to use or avoid Temp Tables
Understanding Basic Query Plans (lab)
The Causes of Iterative Code
Refactoring Cursors into Set-based solutions (lab)
Query Plan Reuse (lab)
|
|
9) Query Plans and Index Tuning
SQL Server Page Structures
Clustered Indexes and Heaps (lab)
Non-Clustered Indexes (lab)
Covering Indexes (lab)
Scans, Seeks, Joins and SARGs (lab)
Base Indexes (lab)
CRUD Matrix Index Strategy (lab)
|
|
10) Managing Transactions, Locking & Blocking
Transactional Integrity & ACID
Isolation Levels and Locks (lab)
Snapshot Isolation and Row Versioning (lab)
Diagnosing Concurrency Problems (lab)
Deadlocks (lab)
Handling Concurrency Problems (lab)
|
|
11) Advanced Scalability
Disk Subsystem Planning
Partition Tables (lab)
Indexed Views (lab)
Service Broker (lab)
|
|
12) Nordic O/R Database Design
Classes (lab)
Objects (lab)
Associations (lab)
|
|
13) Data Quality Analysis
Components of Data Quality
Heuristic Quality Rules (lab)
Database Triggers
|
|
14) Data Auditing
Fixed Audit Triggers (lab)
Dynamic Audit Triggers
Database Triggers
Rollback (lab)
Analysis
|
|
15) XML
XML (lab)
XML Indexes (lab)
XQuery (lab)
|
|
16) SOA & Web Services
HTTP Endpoints (lab)
SOAP (lab)
SOA Solution (.Net - Endpoint - Service Broker - Sproc - XML) (lab)
|
|
|
$2,750 USD
You may qualify for discounts
|
|
