Developing and Deploying SQL Server ISV Applications
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
What you'll learn
There are many important considerations when creating and deploying an application that uses SQL Server for data storage, whether you work for a large or small ISV, and are creating a complex or simple application. It's critical that your application performs well under load, keeps the user data secure, and is able to be installed and upgraded easily. This course explains all these considerations using a layered approach that ties into stages in the development lifecycle. The course begins by examining database design and schema considerations, plus general best practices around security using roles, logins, and users. It then explains and demonstrates numerous aspects of T-SQL coding where choices can be made to make the code and application more efficient, and avoid common performance pitfalls. Application and code testing is then addressed, along with figuring out the hardware, software, and SQL Server requirements that must be communicated to the users. The course ends by walking through the deployment phase, including common SQL Server and database configuration options that must be changed or left as the default value, and explaining how to ensure that application and database upgrades run smoothly. This course is perfect for developers who are involved in the development lifecycle of applications that use SQL Server for data storage. The information in the course applies to all versions from SQL Server 2005 onward.
Table of contents
- Introduction 3m
- What's a Database Schema? 1m
- What's a Schema in SQL Server? 3m
- Demo: Exploring the AdventureWorks Schema 3m
- Schema Recommendations 3m
- Tables: The Basics 2m
- Tables: Heaps vs. Clustered Indexes 3m
- Tables: Clustering Key 5m
- Demo: Viewing Heaps and Clustered Indexes 7m
- Tables: Constraints 4m
- Tables: Primary Keys 3m
- Tables: Foreign Keys 4m
- Demo: Constraints 6m
- Data Type Considerations 4m
- Indexes: The Basics 3m
- Indexes: Redundancy 2m
- Demo: Index Redundancy 5m
- Indexes: Unused 3m
- Indexes: Missing 3m
- Views 3m
- Indexed Views 4m
- Demo: Views 7m
- Triggers 2m
- Triggers(2) 3m
- Full-Text Indexing 2m
- Full-Text Indexing (2) 2m
- Summary 2m
- Introduction 2m
- Authentication Levels in SQL Server 3m
- Roles, Logins, and Users 3m
- The sa Login 3m
- The sa Login (2) 1m
- The sysadmin Role 1m
- Demo: Roles, Logins, and Users 5m
- CONTROL SERVER permissions 1m
- Managing Logins, Roles, and Users 2m
- Ownership Chaining 3m
- Demo: Ownership Chaining 7m
- Auditing 2m
- Auditing (2) 4m
- Encryption 1m
- Encryption (2) 2m
- Summary 2m
- Introduction 2m
- Database Connections 3m
- Transactions 3m
- Demo: Transactions 3m
- Nested Transactions 1m
- Demo: Nested Transactions 3m
- Isolation Levels 1m
- Isolation Levels (2) 3m
- Demo: Isolation Levels 7m
- Isolation Levels (3) 3m
- Accessing Data 1m
- Stored Procedures 3m
- Stored Procedures (2) 2m
- Demo: Stored Procedures 7m
- Dynamic SQL 3m
- Dynamic SQL (2) 2m
- Demo: Dynamic SQL 5m
- CLR Integration 2m
- CLR Integration (2) 1m
- Temporary Tables 2m
- Temporary Tables (2) 3m
- Demo: Temporary Tables 4m
- Implicit Conversions 2m
- Demo: The Effects of Implicit Conversions 8m
- Filtering 2m
- Just in Case 3m
- Ordering Data 3m
- Where is the Data? 2m
- Caching 1m
- Data Characteristics 2m
- Cardinality Estimate Issues 3m
- Demo: Cardinality Estimates 5m
- Validate Data Consistency and Integrity 2m
- Code Reviews 3m
- Summary 1m
- Introduction 2m
- SQL Server Installation 1m
- Database Installation 2m
- Instance and Database Configuration 2m
- SQL Server Instance Settings 3m
- SQL Server Instance Settings (2) 1m
- SQL Server Instance Settings (3) 2m
- SQL Server Instance Settings (4) 1m
- SQL Server Instance Settings (5) 3m
- SQL Server Instance Settings (6) 4m
- SQL Server Instance Settings (7) 3m
- SQL Server Instance Settings (8) 1m
- Database Settings 3m
- Database Settings (2) 4m
- Database Settings (3) 3m
- Database Settings (4) 2m
- Hardware 2m
- Summary 2m