By the time you're done you'll understand the following topics about Microsoft 70-451: SQL Server 2008, Designing Database Solutions:
- Introduction
- SQL Server Components
- Relational Database Basics
- Designing a Database Model
- Using the Entity Framework (free video!)
- Designing Application Security
- Designing a Full-Text Search Strategy
- Selecting Data Types for Tables
- Designing Tables
- Designing Programming Constructs
- Designing T-SQL Construts
- Designing Views
- Special Programming Concerns
- Designing a Transaction and Concurrency Strategy
- Designing an XML Strategy
- Understanding Query Optimization
- Designing Optimized Queries
- Designing Optimized Index Strategies
- Designing Scalable Database Solutions
- Designing Database Performance Strategies
- Video 1 - "Introduction"
- Video 2 - "SQL Server Components" - SQL Server Agent, Database Mil, Service broker, Full-text search, DTC, linked servers, and more
- Video 3 - "Relational Database Basics" - Physical storage model, relational data, and database objects
- Video 4 - "Designing a Database Model" - About modeling, entities, entity relationships, normalization, and denormalization
- Video 5 - "Using the Entity Framework" - About the Entity Framework, defining and maintaining mappings, defining a data model, and Entity SQL
- Video 6 - "Designing Application Security" - Security overview, authentication mode, schema ownership, execution context, permissions, database roles
- Video 7 - "Designing A Full-Text Search Strategy" - About full-text search, CONTAINS, CONTAINSTABLE, FREETEXT, and FREETEXTTABLE
- Video 8 - "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
- Video 9 - "Designing Tables" - Table width, sizing data columns, IN_ROW_DATA, overflow data, sparse columns, computed columns, persisted computed columns
- Video 10 - "Designing Programming Constructs" - Stored procedures, types, functions, aggregates, triggers; CLR vs. T-SQL
- Video 11 - "Designing T-SQL Constructs" - Functions vs. views, determinism, parameters, EXECUTE AS, TRY/CATCH, WITH RECOMPILE, etc.
- Video 12 - "Designing Views" - About views, CTEs, partitioned views, indexed views, updatable indexed views, check option, schema binding
- Video 13 - "Special Programming Concerns" - Preventing SQL injection attacks, ownership chains on programming objects, cross-database ownership chaining
- Video 14 - "Designing a Transaction and Concurrency Strategy" - About locking, designing locking granularity, about transactions, designing transactions, about concurrency, designing for concurrency
- Video 15 - "Designing an XML Strategy" - About XML, designing XML storage, designing an XML query strategy, XML data transformation
- Video 16 - "Understanding Query Optimization" - how queries are physically executed, how indexes are used, about execution plans, row-based vs set-based operations
- Video 17 - "Designing Optimized Queries" - About the Query Optimizer, Optimize and Tune Queries, Analyze execution plans, row-based cs. Set-based operations
- Video 18 - "Designing Optimized Index Strategies" - Views, filtered indexes, indexed views, clustered and non-clustered indexes, unique indexes
- Video 19 - "Designing Scalable Database Solutions" - 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" - resolving performance problems by using plan guides, designing a table and index partitioning strategy, designing a table and index compression strategy
more info @http://www.cbtnuggets.com/webapp/product?id=465
Rapidshare: | Part 1 of 4 | Part 2 of 4 | Part 3 of 4 | Part 4 of 4 |
DepositFiles: | Part 1 of 4 | Part 2 of 4 | Part 3 of 4 | Part 4 of 4 |
0 comments:
Post a Comment