Developing and Deploying SQL Server ISV Applications [2013, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Developing and Deploying SQL Server ISV Applications

Год выпуска: 2013
Производитель: Pluralsight
Сайт производителя: http://pluralsight.com/training/Courses/TableOfContents/sqlserver-developing-deploying-supporting-is
Автор: Erin Stellato
Продолжительность: 6h 02m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: Изучи как правильно использовать SQL Server в своих приложениях избегая общих проблем дизайна, безопастности, кодирования, производительности и установки. Применимо для разработчиков приложений, начиная с SQL Server 2005
Learn how to properly make use of SQL Server in your applications, avoiding common design, security, coding, performance, and installation problems, applicable for developers creating applications that use SQL Server 2005 onward
[spoiler="Содержание"]
Introduction

What is an ISV?
ISV Examples
ISV Examples (2)
The Perception of ISVs
The Perception of Users
Facts
Facts (2)
Keys for Successful ISVs
Course Scope and Summary

Schema Considerations

Introduction
What's a Database Schema?
What's a Schema in SQL Server?
Demo: Exploring the AdventureWorks Schema
Schema Recommendations
Tables: The Basics
Tables: Heaps vs. Clustered Indexes
Tables: Clustering Key
Demo: Viewing Heaps and Clustered Indexes
Tables: Constraints
Tables: Primary Keys
Tables: Foreign Keys
Demo: Constraints
Data Type Considerations
Indexes: The Basics
Indexes: Redundancy
Demo: Index Redundancy
Indexes: Unused
Indexes: Missing
Views
Indexed Views
Demo: Views
Triggers
Triggers(2)
Full-Text Indexing
Full-Text Indexing (2)
Summary

Security

Introduction
Authentication Levels in SQL Server
Roles, Logins, and Users
The sa Login
The sa Login (2)
The sysadmin Role
Demo: Roles, Logins, and Users
CONTROL SERVER permissions
Managing Logins, Roles, and Users
Ownership Chaining
Demo: Ownership Chaining
Auditing
Auditing (2)
Encryption
Encryption (2)
Summary

Efficient Code Choices

Introduction
Database Connections
Transactions
Demo: Transactions
Nested Transactions
Demo: Nested Transactions
Isolation Levels
Isolation Levels (2)
Demo: Isolation Levels
Isolation Levels (3)
Accessing Data
Stored Procedures
Stored Procedures (2)
Demo: Stored Procedures
Dynamic SQL
Dynamic SQL (2)
Demo: Dynamic SQL
CLR Integration
CLR Integration (2)
Temporary Tables
Temporary Tables (2)
Demo: Temporary Tables
Implicit Conversions
Demo: The Effects of Implicit Conversions
Filtering
Just in Case
Ordering Data
Where is the Data?
Caching
Data Characteristics
Cardinality Estimate Issues
Demo: Cardinality Estimates
Validate Data Consistency and Integrity
Code Reviews
Summary

Application Testing

Introduction
Test Plans
Testing with the Right Configuration
Testing with the Right Data and Workload
Testing Challenges: Data and Workload
Testing Challenges: People
Testing Challenges: Time
Summary

Application Requirements
Introduction
Hardware Requirements
Software Requirements
SQL Server Requirements
Additional Considerations
Supported High-Availability Options
A Final Consideration
Summary

Installation and Configuration

Introduction
SQL Server Installation
Database Installation
Instance and Database Configuration
SQL Server Instance Settings
SQL Server Instance Settings (2)
SQL Server Instance Settings (3)
SQL Server Instance Settings (4)
SQL Server Instance Settings (5)
SQL Server Instance Settings (6)
SQL Server Instance Settings (7)
SQL Server Instance Settings (8)
Database Settings
Database Settings (2)
Database Settings (3)
Database Settings (4)
Hardware
Summary

Application Upgrades

Introduction
Database Changes From an Upgrade
Database Changes From an Upgrade (2)
Requirements
Test, Test, Test
Upgrading the Database
Summary

Summary

Development Considerations
Testing and Requirements
Installation, Configuration, and Upgrades
Critical Factors
What's Next?
[/spoiler]
Файлы примеров: не предусмотрены
Формат видео: WMV
Видео: wmv3, 1024x768, 15fps, 63~1703kbps
Аудио: wma2, 128kbps, Stereo, 44.1kHz
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Exercise Material includes both slides and code files.