Developing and Deploying SQL Server ISV Applications

Developing applications with SQL Server requires careful planning to ensure performance, security, and ease of maintenance. This course provides a comprehensive, layered approach to application development using SQL Server, applicable to both simple and complex applications for ISVs of all sizes.

Key Topics Covered:

• Database Design & Schema: Learn best practices for designing efficient database schemas and implementing robust data models.
• SQL Server Security: Implement strong security measures using roles, logins, and users to protect sensitive user data. Understand fundamental security best practices.
• T-SQL Optimization: Discover techniques for writing efficient T-SQL code, avoiding performance bottlenecks, and maximizing application speed.
• Application & Code Testing: Master application and code testing methodologies to ensure stability and reliability.
• Hardware & Software Requirements: Determine and communicate the necessary hardware, software, and SQL Server requirements to your users.
• Deployment Strategies: Navigate the deployment process effectively, including configuring SQL Server and database settings.
• Upgrade Management: Learn how to ensure smooth application and database upgrades, minimizing downtime and potential issues.

This course covers considerations for SQL Server 2005 and later versions. It's ideal for developers involved in all stages of the application development lifecycle that utilize SQL Server for data storage. Gain the skills to build scalable, secure, and maintainable applications with SQL Server.