MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Developing and Deploying SQL Server ISV Applications

Course Summary

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 perf


  • +

    Course Syllabus

    ● 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?
     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top