Authored by: Erin Stellato
Duration: 6h 2m
Level: Intermediate
Released: 5/31/2013

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.

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.


http://www.pluralsight.com/training/Courses/TableOfContents/sqlserver-developing-deploying-supporting-isv-applications

Download File Size:514.24 MB

---