Back

Microsoft Database PRO SQL Server 2008 Design 70-451

Designing Database Solutions and Data Access
IT TRAINING
The 24-Hour Solution
Try it out,
24 hrs for $24

Prepare for an upcoming exam. Make corporate training decisions without risk. Access all of our IT training for 24 hours. Learn More
In this training, database expert Don Jones takes you on a tour of SQL Server 2008 that ultimately prepares you for prestigious Microsoft MCITP: SQL Server 2008 Database Developer certification.

He starts by covering the basics, including relational database concepts and table design, and moves you all the way through to advanced topics, like query optimization and index tuning.

Throughout, you'll get plenty of in-the-product experience and demonstrations, clear explanations of core concepts, and guidance for implementing best practices in your own database application designs.

All trademarks and copyrights are the property of their respective holders.
  • Videos
  • Purchase Options
Title Duration
 
Introduction
This MCITP certification training series will start with an overview of the series.
 00:04:26
 
SQL Server Components
Training content; SQL Server Agent, Database Mil, Service broker, Full-text search, DTC, linked servers, and more
 00:19:38
 
Relational Database Basics
Training content; Physical storage model, relational data, and database objects
 00:19:22
 
Designing a Database Model
Continuing your MCITP certification exam readiness, we will discuss designing a database model, in this training video.
 00:21:29
 
Using the Entity Framework
MCITP training content; what is the entity framework, mappings and models and finally entity SQL.
 00:12:40
 
Designing Application Security
Training content; Security overview, authentication mode, schema ownership, execution context, permissions, database roles
 00:26:20
 
Designing a Full-Text Search Strategy
About full-text search: contains, CONTAINSTABLE, FREETEXT and FREETEXITABLE.
 00:16:33
 
Selecting Data Types for Tables
About data types: new types (geography, hierarchyid, date, time, datetime2, datetimeoffset, varbinary (MAX), and filestream); traditional types (varchar and varchar(MAX), char, ints, bit); Outdated types; Type options
 00:12:29
 
Designing Tables
Table width, sizing data columns, IN_ROW_DATA, overflow data, sparse columns, computed columns, persisted computed columns
 00:29:44
 
Designing Programming Constructs
Stored procedures, types, functions, aggregates, triggers; CLR vs. T-SQL
 00:24:55
 
Designing T-SQL Construts
Functions vs. views, determinism, parameters, EXECUTE AS, TRY/CATCH, WITH RECOMPILE, etc.
 00:21:23
 
Designing Views
About views, CTEs, partitioned views, indexed views, updatable indexed views, check option, schema binding
 00:26:16
 
Special Programming Concerns
Preventing SQL injection attacks, ownership chains on programming objects, cross-database ownership chaining
 00:17:20
 
Designing a Transaction and Concurrency Strategy
About locking: designing locking granularity; about transactions, designing transactions; about concurrency, designing for concurrency
 00:23:01
 
Designing an XML Strategy
About XML: designing XML storage; designing an XML query strategy; XML data transformation
 00:25:45
 
Understanding Query Optimization
How queries are physically executed; how indexes are used; about execution plans; row-based vs set-based operations
 00:21:32
 
Designing Optimized Queries
MCITP certification training content; About the Query Optimizer; Optimize and Tune Queries; Analyze execution plans; row-based cs; Set-based operations
 00:27:42
 
Designing Optimized Index Strategies
MCITP training content; Views: filtered indexes; indexed views; clustered and non-clustered indexes; unique indexes
 00:23:06
 
Designing Scalable Database Solutions
Training content; About scalability: scale up vs out; federated databases; distributed partitioned views; scalable shared databases; replication; offloading read-only queries
 00:26:04
 
Designing Database Performance Strategies
Lets wrap up your MCITP certification readiness training by talking about plan guides, partitions and compression.
 00:21:07
Total Series Duration: 7 hours
Which option is right for you?
Buy a Single Series
"Focus your training on one series, for one month, for one low price."
StreamOne
StreamOne SUBSCRIPTION
Includes ExamPrep
StreamOne is your monthly option for streaming access to Microsoft Database PRO SQL Server 2008 Design 70-451. One multi-user license gives you and a small team access to one full series. Cancel at any time. A StreamOne subscription gives you plenty of time to explore the benefits of CBT Nuggets, while paying for just the specific series you want.
MULTI-USER
$199
per license
Add to Cart
$499
EDM
Download
Download Microsoft Database PRO SQL Server 2008 Design 70-451.
$499
DVD
DVD
Have Microsoft Database PRO SQL Server 2008 Design 70-451 delivered on DVD.
 
Buy a Certification Package
"Secure your future with professional recognition via industry certification. Certification Packages give you the training you need to pass those certification exams."
Get Certified. Cisco, Microsoft, CompTIA and more.
Inclusive pricing. Package includes training videos and any relevant and available exam-prep.
Image
Certification Packages
Professional Recognition from Renowned IT Organizations
CBT Nuggets offers certification packages to help you achieve valuable professional recognition. Get the most popular certifications from Cisco, Microsoft and others. IT certification after training with CBT Nuggets will help you do a lot more than put letters after your name. Begin your path to a better job and a better future today!
  • Certification Package
    $599
    4 MONTHS STREAMING
    Add to Cart
    MCITP: SQL Server 2008 Database Developer Certification Package
    IT pros Don Jones and Julie Johnson have created SQL Server 2008 trainings that fully prepare you for database development. Whether you already work in SQL Server 2008 or you're just eager to learn how, these two offerings are exactly what you need. By the time you've finished watching the trainings below, you'll know all the latest techniqu... Learn more...
Buy an Annual Subscription to Everything IT
"Eliminate your limitations. An IT Nuggets streaming subscription puts our complete IT training library at the fingertips of IT pros."
All topics. From admin to programming.
Image
IT Nuggets
Productivity for Companies and IT Advancement for Professionals
Get access to better training, and never lose it, with an IT Nuggets subscription. IT Nuggets is a multi-user product that supports all levels of your IT department, even as employees come and go. One locked-in rate gets you access to our IT training catalog, which is updated regularly and automatically at no additional charge. As long as your subscription is maintained, the rate won't change, and neither will your budget. Our full IT library is designed for Pros to keep current for career advancement and companies that want their IT Pros to reach their full potential.
YEARLY
MULTI-USER
$1999
per license
Add to Cart
Bookmarks

No Bookmarks