50401
Designing and Optimizing Database Solutions with Microsoft SQL Server 2008
Course Outline
Lesson 1 - Designing a Conceptual Database Model
-
Overview of Database Design
-
Gathering Database Requirements
-
Creating a Conceptual Database Design
-
Overview of Entity Framework
-
Lab : Designing a Conceptual Database Model
Lesson 2 - Designing a Logical Database Model
-
Guidelines for Building a Logical Database Model
-
Planning for OLTP Activity
-
Evaluating Logical Models
-
Lab : Designing a Logical Database Model
Lesson 3 - Designing a Physical Database Modell
-
Selecting Data Types
-
Designing Database Tables
-
Designing Data Integrity
-
Lab : Designing a Physical Database Model
Lesson 4 - Designing Databases for Optimal Performance
-
Guidelines for Designing Indexes
-
Designing a Partitioning Strategy
-
Designing a Plan Guide
-
Designing Scalable Databases
-
Lab : Designing Databases for Optimal Performance
Lesson 5 - Designing Security for SQL Server 2008
-
Exploring Security in SQL Server 2008
-
Implementing Identity and Access Control
-
Guidelines for Secure Development in SQL Server 2008
-
Guidelines for Secure Deployment of SQL Server 2008
-
Guidelines for Secure Operations
-
Lab : Designing Security for SQL Server 2008
Lesson 6 - Designing a Strategy for Database Access
-
Guidelines for Designing Secure Data Access
-
Designing Views
-
Designing Stored Procedures
-
Designing User
-
Defined Functions
-
Lab : Designing a Strategy for Database Access
Lesson 7 - Designing Queries for Optimal Performance
-
Considerations for Optimizing Queries for Performance
-
Refactoring Cursors into Queries
-
Extending Set
-
Based Operations
-
Lab : Designing Queries for Optimal Performance
Lesson 8 - Designing a Transaction and Concurrency Strategy
-
Guidelines for Defining Transactions
-
Defining Isolation Levels
-
Guidelines for Designing a Resilient Transaction Strategy
-
Lab : Designing a Transaction and Concurrency Strategy
Lesson 9 - Designing an XML Strategy
-
Designing XML Storage
-
Designing an XML Query Strategy
-
Designing a Data Conversion Strategy
-
Lab : Designing an XML Strategy
Lesson 10 - Designing SQL Server 2008 Components
-
Overview of SQL Server 2008 Components
-
Designing a Service Broker Architecture
-
Designing the Service Broker Data Flow
-
Designing the Service Broker Availability
-
Exploring Full
-
Text Search
-
Designing a Full
-
Text Search Strategy
-
Lab : Designing SQL Server 2008 Components
show more>>
Our Training Center
We encourage you to take this Instructor-Led Training: Live Online course at our downtown Toronto Training Center at 40 University Avenue. For TTC riders, we are right on the subway line just south of the St. Andrews station. For GO-Train commuters, we are just steps north of Union Station.
show more>>
In our Training Center every student gets their own powerful Dell workstation with dual monitors. Our classrooms are designed around comfortable ergonomic chairs, generous work surfaces, special air conditioning by classroom and a high-speed fibre connection to the Internet. So it really is a great place to take any of our courses.
However, we understand that it is not always possible for you to take this Instructor-Led Training: Live Online course at our Center. Therefore, you have the option to take part or all of this course from an offsite location. As long as you have at least DSL-speed Internet connectivity, our Operations Staff can easily connect and join you into this Instructor-Led Training: Live Online class directly from your work, home or other location. Our Site, Your Site or Offsite. Whatever works best for you!
