Over a million developers have joined DZone.

SQLServer Training Courses Released Under Creative Commons

DZone's Guide to

SQLServer Training Courses Released Under Creative Commons

· Database Zone
Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

As part of an ongoing release of all my training material, I am releasing "Database and SQL Testing with SQLServer" under a Creative Commons Attribution Share-Alike license. That is, you are free to share, copy, and adapt any part of this training course for your own purposes. All materials, including examples are available for download from here: http://theagiledirector.com/content/sqlserver-training-courses-released-under-creative-commons 

This workshop material is designed for testers responsible for the validation and quality control of database driven applications and who want to improve their testing capabilities, and take advantage of the advanced features within MS SQLServer. This course focuses on SQLServer, but most of the techniques will be applicable to any SQL 2003 compliant database. This material looks at relational theory and good database design, and how these underlying principles relate to writing database specific test cases. It also examines SQL, including some of the more advanced features used to test the performance of complex queries. Finally it then looks at how the SQL Server profiler and execution plan operates; how it parses SQL and how to debug SQL statements and stored procedures.

It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate


Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}