Course ID - T2TSQL500

About the Course
The SQL course covers the most useful tool that all testers must have as part of their skill set. Not only will the course introduce you to the versatile SELECT statement and JOINS but also the very useful aspects of getting access to databases and creating test data using INSERTS and restoring and backing up database which is a crucial part of the test environments. The focus for this course will be Microsoft SQL server but techniques can be equally applied to ORACLE.

What will you learn?
* installing SQL Server and accessing databases
* Backing up and restoring databases
* SELECT statement and JOINS
* INSERT statement and creating test data
* UPDATE statements and modifying databases to help with testing
* Basics of stored procedures from creation and execution
* Database administrator functions for testers

Who should attend the course?
This is a must know course for all testers. Most applications will have one or many databases somewhere in its architecture and this course will cover concepts to help with interrogating databases and setting up databases for test environments.

* Test Analysts
* Senior Test Analysts
* Test Managers

What are the prerequisites?
At least one year's testing experience.

What's next after this course?
* unix/cygwin for testers - a very useful tool to for creating automated test environments and automating web tests as part of a continuous integration environment.
* imacros for testers - a very useful open source tool that will allow you to automate your web testing. It's a very powerful tool that can be used as well as Selenium.

What are the course costs?
* £575 per delegate
* 20% Discount available for companies who have three or more delegates attending the same course date
* Ask us about the special offers for January and February 2010

What are the course dates?

• 14th January 2010 - City, London - BOOKED
• 11th February 2010  - City, London - BOOKED
• 11th March 2010 - City, London
• 15th April 2010 - City, London