Course Name:		Software Testing: Database Fundamentals for Test Engineers Training
Deployment Options:		Onsite - Instructor-Led Training
Course Duration:		2-days

Introduction:

This tutorial covers the Elective area of the Test Management Body of Knowledge (TMBOK) required for the Certified Test Manager (CTM) certification. This tutorial also covers the Elective area of the Certified Software Test Professional requirements.

Concepts:

Knowledge is power and the data is what creates the knowledge. We need to know how to store it and how to retrieve it in order to be effective in testing the data flow through a system. In this section we will discuss what a database is, why it's used and how to use it. We'll touch on a little bit of SQL, although this isn't a class on SQL. SQL can be a major tool for verifying the data that you are processing during testing. Throughout this course we'll look at database design issues and how they affect the testing requirements.

Objectives:

Course Outline

What is a database? Flat files Hierarchical databases Relational databases Why use one? Data integrity Data accessibility Predicting the future Database tools RAD DBMS tools SQL --What is SQL? --SQL general info Identifying the data Data types and how to define them Numbers, strings and others Organizing the data Who needs what, when Schemas and tables Rows and columns Creating the database Database design --Specifics to consider --Tools to use Creating tables --Understanding data relationships --Storage for efficiency and ease --Identifying and creating keys and indices Example walkthroughs with RAD and SQL Where's the data? Populating the database --Via program --Importing --Via manual input Accessing the data – Finding what you want Protecting the data --“You can't touch that” --SQL transactions SQL in the modern world ODBC and JDBC Triggers and cursors Stored modules Handling errors Database technology and how it relates to QA The data is what it's all about Integrity of data handling --Inputs --Retrievals --Updates --Deletions Performance and recoverability testing issues Error handling testing issues QA involvement during design --Are you the middleman? --Maintain the “Big Picture” view --Expectations for technical input and understanding

For organizational purchases, please send us a message at salesinfo@eno.com or complete and submit this form .

Other Expertise:

CBT's and Online Training Catalog Oracle Applications Training and Consulting Peoplesoft Applications Training and Consulting SAP Applications Training and Consulting Security Technologies Training and Consulting Software Testing Training and Consulting Telecommunications Training and Consulting Wireless Technology Training and Consulting