Français · Montreal, September 05, 2008 17:11 ET
 
   

Special Event


Date: July 28-29, 2008 (2 days)
Location:Sutton Place
845 Burrard Street,Vancouver, BC,V6Z 2K6

Room: Salon Belair

Note: register for the 2 days workshop and get a free book dedicated to you by the author.


Smart Database design

Database performance, scalability, and extensibility don't happen by accident. The truth is that the way the database is designed is the single greatest factor determining the performance of the database.

Smart Database Design is the premise that an elegant physical schema makes the data intuitively obvious and enables writing great set-based queries that respond well to indexing. This in turn creates short, tight transactions which improves concurrency and scalability while reducing the aggregate workload of the database.

This flow from layer to layer becomes a methodology for designing, developing, and optimizing databases. The core of Smart Database Design is based on the six primary goals of every database: Usability, Data Integrity, Performance/Scalability, Extensibility, Security, and Availability.

Every option and pattern for every design and development decision for each layer (schema, queries, indexing, concurrency, adv. scalability) is analyzed by how the option impacts, improves, or risks these six goals.

Smart Database Design is more than a collection of best-practices; it's the business and architectural case for the best-practices.

As we go through each section outlined, we will also spend time discussing best practices.

Who Should Attend

You Will Learn How To:
  • Design an elegant efficient database physical schema that's fast, easy to query, and flexible so it works today and can handle changes in the future.
  • Design performance into the schema - why 3rd Normal Form and denormalization alone aren't enough
  • Use the right set-based solution to solve query problems.
  • Tighten transactions for scalability with thousands of users.
  • Refactor complex cursors into high-performance set-based queries
  • Develop a comprehensive indexing strategy for overall best performance
  • Dramatically improve the performance of legacy databases and,Analyze design decisions from a sound architectural point of view

Curriculum

1) Data Architecture

  • Defining Data Architecture / Enterprise Data Architecture
  • Data Architecture Principle
  • Six Database Design Goals
2) Smart Database Design
  • RDBMS System
  • Smart Database Design Layers
  • Applying the Methodology
3) Physical Schema Performance
  • The Modeling Process
  • Designing Entities
  • Normalization and the Rules of One
  • Data Design Patterns
  • Generalization
  • Responsible Denormalization
  • Primary and Foreign Keys
  • Situational Modeling
  • Muck Tables
  • Managing Optional Data
4) Set-based Queries
  • Recommended Solutions
  • Logical Query Flow
  • Cursor Strategies and Refactoring Cursors
  • Hierarchical Patterns
  • T-SQL Best Practices
  • Query Plan Reuse
5) Zen and the Art of Indexing
  • Index Structures
  • Scans, Seeks, and SARGS
  • Query Paths
  • Base Indexes
  • Comprehensive Indexing Strategy
6) Managing Transactions, Locking & Blocking
  • Transactional Integrity & ACID
  • Isolation Levels and Locks
  • Transaction Log Flow
  • Locking and Blocking
  • Optimistic Locking
  • Triggers
7) Advanced Scalability
  • Disk Subsystem Planning
  • Partitioning
  • Indexed Views
  • Filtered Indexes
  • Data Compression

Seminar F.A.Q.
  • What materials will I receive at the workshop?
    Attendees receive a copy of SQL Server 2005 Bible, a spiral binder with all the slides printed for note taking, and a USB flash drive with all the sample code.

  • What's the seminar's style?
    Paul's style is very interactive with lively discussions and stories. Several times during the seminar, you'll break into small groups to discuss an issue or role-play a development situation.

  • We're not designing a new database but trying to optimize our current database. Will these optimization techniques still apply?
    Absolutely. Design principles are easiest to implement on a clean slate, but they become even more critical when optimizing a production database.

  • I'm not a SQL Expert, will I be able to keep up with an advanced course?
    Yes. A basic familiarity of SQL Server, data modeling, and T-SQL programming is assumed, but you don't need to be a SQL expert to benefit from this course.

  • We're planning on upgrading but still running SQL Server 2005. How much of the course is specific to SQL Server 2008?
    The design principles, and almost all of the implementation details apply to both SQL Server 2005 and SQL Server 2008. Where new features of SQL Server apply, they are explained. The proofs and examples use SQL Server 2008.

  • Theory's great, but is the seminar is practical?
    Theory without practical implementation is useless. The seminar is designed around a decision template that focuses on the design and development decisions you must face with every project.

  • What are the seminar hours?
    9 am until 5pm with a 1 hour break for lunch.

  • May I bring my notebook computer?
    Yes, please do. You're encouraged to try the scripts and proofs for yourself. Sample databases and scripts are on the USB flash drive that every attendee receives.

  • Is the seminar competitively priced?
    Yes. The average cost per day for advanced SQL Server training nationally is about $580.

  • Are questions answered after the class?
    Yes. Paul answers all email from students.

  • Can we offer an in-house seminar within our organization?
    Yes. Paul can present in-house training customized to your specific needs. This format has the advantage of being able to address specific issues privately.

  • What is the dress code?
    Dress is business casual. Wear comfortable clothing and bring a sweater or jacket in case the room is cool.

  • Can I just "show up" for a seminar?
    I don't recommend it, there may not be any available seats. It's best to register, even if it's a last minute registration.

Agenda for July 30-31,2007
Date: July 28-29, 2008 (2 days)
Location:Sutton Place
845 Burrard Street,Vancouver, BC,V6Z 2K6

Room: Salon Belair

Day 1 July 28

8:00 AM – 8:30 AM
Welcome and Registration
8:30 AM – 10:30 AM
Data Architecture
Defining Data Architecture / Enterprise Data Architecture
Data Architecture Principle
Six Database Design Goals
10:30 AM – 10:45 AM
-- BREAK --
10:45 AM – 12:00 PM
Smart Database Design
RDBMS System
Smart Database Design Layers
Applying the Methodology
12:00 PM – 1:00 PM
LUNCH (Not included)
1:00 PM – 03:30 PM
Physical Schema Performance
The Modeling Process
Designing Entities
Normalization and the Rules of One
Data Design Patterns
Generalization
03:30 PM – 03:45 PM
-- BREAK --
03:45 PM – 05:00 PM
Responsible Denormalization
Primary and Foreign Keys
Situational Modeling
Muck Tables
Managing Optional Data

Day 2 July 29th

8:30 AM – 10:15 AM
Set-based Queries
Recommended Solutions
Logical Query Flow
Cursor Strategies and Refactoring Cursors
Hierarchical Patterns
T-SQL Best Practices
Query Plan Reuse
10:15 AM – 10:30 AM
-- BREAK --
10:30 AM – 12:00 AM
Zen and the Art of Indexing
Index Structures
Scans, Seeks, and SARGS
Query Paths
Base Indexes
Comprehensive Indexing Strategy
LUNCH (Not included)
1:00 PM – 03:30 PM
Managing Transactions, Locking & Blocking
Transactional Integrity & ACID
Isolation Levels and Locks
Transaction Log Flow
Locking and Blocking
Optimistic Locking
Triggers
03:30 PM – 03:45 PM
-- BREAK --
03:45 PM – 05:00 PM
Advanced Scalability
Disk Subsystem Planning
Partitioning
Indexed Views
Filtered Indexes
Data Compression
05:00 PM – 05:15 PM
-- Q&A --


Price and registration

The cost of this 2 Days workshow is 999.00$plus taxes. Every attendees will get a free copy of the book SQL Server 2005 Bible. A value of 69$

Space is limited. Register early!

Register for SQL Best-Practises workshop
Date: July 28-29, 2008 (2 days)
Location:Sutton Place
845 Burrard Street,Vancouver, BC,V6Z 2K6

Take advantage of the SQLTeach special hotel rate at 217$. Contact Jean-René Roy by email. We can get you that rate. Jrroy@devteach.com
The regular rate is 284.75$.


Pre-requirements

Maximize your training experience by bringing a laptop. There will be free internet wireless on site. During the sessions you can download the sessions material and try it during the presentations. Having a free internet access can let you be in touch with the office and you can also write in you blog the cool tips and tricks you’ll learn onsite.


Instructor Bio: Paul Neilsen

 
Paul Nielsen, www.SQLServerBible.com   
Paul Nielsen, SQL Server MVP, is a hands-on database architect and the author of the SQL Server Bible series from Wiley & Son. Paul leads SQL Server Bible Workshops and speaks at several conferences. Paul will be giving the welcome address at the Colorado PASS SQL Server Code Camp next week in Denver, and he serves on the PASS Board of Directors.






Copyright © 2003-2008, DevTeach Inc., All Rights Reserved
SQL Server Conference 370 Greber Suite 215, Gatineau, Quebec, J8T 5R6 SQL Server Training
Telephone: 1-866-913-0430 Fax: 1-819 205-1422 Email: Info4You@devteach.com