Software Testing: Database Fundamentals for Test Engineers

ENO.com
Stafford, Virginia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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

...''

Phone:(888) 742-3214 or 540-720-9660

School Address:

E&A Information Services Inc. (DBA: Eno.com)
6 St. Charles Ct
Stafford, VA 22556. USA

Jobs & Resumes: Stafford
Houses & Roommates: Stafford

Scada Security
UMTS Security
Voice Over IP Security (VoIPSEC)
Wireless LAN Security
Certified Software Test Professional (CSTP)
Certified Test Manager
Software Testing: Advanced Performance Testing & Tuning Techniques
Software Testing: Becoming an Effective Test Manager: An Interactive Workshop
Software Testing: Building Quality Assurance Function
Software Testing: Database Application Testing Fundamentals
Software Testing: Database Testing: Structured Query Language (SQL) for Test Professionals
Software Testing: Essentials of Graphical User Interface Testing
Software Testing: Estimating and Controlling Testing Projects
Software Testing: Improving Performance through Standards and Processes
Software Testing: Improving Software Testing with the Use of Metrics
Software Testing: Industry Best Practices in Software Quality Assurance and Testing
Software Testing: Performance Testing: Analysis and Planning
Software Testing: Performance Testing for Web and Client/Server Applications
Software Testing: Practical Techniques for Software Quality Assurance

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.