Microsoft 70-451: SQL Server 2008 PRO

Designing Database Solutions and Data Access

Not rated 0 Reviews
Trainer: Don Jones | Videos: 20 | Time: 7 hrs
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.

Buy/Subscribe

Using the Entity Framework

Prerequisites

Course Materials

What You'll Learn

  • Video 1: Introduction|04:26

  • Video 2: SQL Server Components|19:38

    SQL Server Agent, Database Mil, Service broker, Full-text search, DTC, linked servers, and more

  • Video 3: Relational Database Basics|19:22

    Physical storage model, relational data, and database objects

  • Video 4: Designing a Database Model|21:29

  • Video 5: Using the Entity Framework|12:40

  • Video 6: Designing Application Security|26:20

    Security overview, authentication mode, schema ownership, execution context, permissions, database roles

  • Video 7: Designing a Full-Text Search Strategy|16:33

    About full-text search: contains, CONTAINSTABLE, FREETEXT and FREETEXITABLE.

  • Video 8: Selecting Data Types for Tables|12:29

    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

  • Video 9: Designing Tables|29:44

    Table width, sizing data columns, IN_ROW_DATA, overflow data, sparse columns, computed columns, persisted computed columns

  • Video 10: Designing Programming Constructs|24:55

    Stored procedures, types, functions, aggregates, triggers; CLR vs. T-SQL

  • Video 11: Designing T-SQL Construts|21:23

    Functions vs. views, determinism, parameters, EXECUTE AS, TRY/CATCH, WITH RECOMPILE, etc.

  • Video 12: Designing Views|26:16

    About views, CTEs, partitioned views, indexed views, updatable indexed views, check option, schema binding

  • Video 13: Special Programming Concerns|17:20

    Preventing SQL injection attacks, ownership chains on programming objects, cross-database ownership chaining

  • Video 14: Designing a Transaction and Concurrency Strategy|23:01

    About locking: designing locking granularity; about transactions, designing transactions; about concurrency, designing for concurrency

  • Video 15: Designing an XML Strategy|25:45

    About XML: designing XML storage; designing an XML query strategy; XML data transformation

  • Video 16: Understanding Query Optimization|21:32

    How queries are physically executed; how indexes are used; about execution plans; row-based vs set-based operations

  • Video 17: Designing Optimized Queries|27:42

    About the Query Optimizer; Optimize and Tune Queries; Analyze execution plans; row-based cs; Set-based operations

  • Video 18: Designing Optimized Index Strategies|23:06

    Views: filtered indexes; indexed views; clustered and non-clustered indexes; unique indexes

  • Video 19: Designing Scalable Database Solutions|26:04

    About scalability: scale up vs out; federated databases; distributed partitioned views; scalable shared databases; replication; offloading read-only queries

  • Video 20: Designing Database Performance Strategies|21:07

Member Reviews

View All Reviews

Related Series

Related Certifications

All trademarks and copyrights are the property of their respective holders.