The database essential for software testers course helps software testers to learn how to identify bugs in the database of a software application for eradicating any errors to software system including deadlock, poor performance, data corruption and so on. Through this course, software testers get an overall knowledge of performing a database testing process into the database of a software system both theoretically and practically.
- Know the different databases in the marketplace
- Have an understanding of different types of databases
- Understand the basic structure of a database specifically for relational databases
- Main principles and techniques of Data Quality Testing
- Be able to write SQL queries using SELECT, INSERT, UPDATE and DELETE Statements and execute them
- Understand packages, stored procedures, triggers and indexes
- How to look for performance bottlenecks
Module 1: Introduction
Databases – An Overview
Describe a Database
Define a Database Management System (DBMS)
List the Advantages of a DBMS
Define a Relational Database Management System (RDBMS)
Module 2: Relational Database Fundamentals
Describe a Table
Explain Data Types
SQL – An Overview Define what is SQL
Explain the Role of SQL
List the Functions of SQL
Getting Started with Oracle
Understand the Features of Oracle
Building and Executing Queries
Understand what is SQL Developer/TOAD
Use TOAD for scripting
Use Auto-generating SQL Statements
Module 3: Creating Database Objects
Introduce the SELECT statement
Use the SELECT statement
Execute a query in Oracle
Retrieve specific columns in a table
Sorting Results with ORDER BY
Filter rows with the WHERE clause
Use operators to create conditions
Sort the ResultSet with the ORDER BY clause
Use the DISTINCT keyword to suppress duplicate rows
View top rows in a large result set
Use the LIKE keyword with wildcards to retrieve data
Working with Multi-Table Queries
Module 4: Retrieving Data from Tables/Views
Understand what are Joins
Use different types of Joins
Creating Joins with the FROM Clause
Using the WHERE clause to create a join
Using SQL Functions in Queries
Understanding Functions and Function Arguments
Use Aggregate Functions: SUM, AVG, MIN, MAX and COUNT
Module 5: Manipulating data in database
Manipulating data in a Table
Insert rows into a table
Using the INSERT INTO statement
Update existing rows in a table
Using the UPDATE INTO statement
Delete rows from a table
Using the DELETE statement
Module 6: Advance Database Objects
Working with Views and Stored Procedures
Understand and describe what is a View
Using the CREATE VIEW statement
Modifying a View with the ALTER VIEW statement
Deleting a View with the DROP VIEW statement
Understand and create an Indexed View
Understand and describe what is a Stored Procedure
Understand what are parameters in a Stored Procedure
Create a Stored Procedure with the CREATE PROCEDURE statement
Execute a Stored Procedure with the EXECUTE statement
Modify a Stored Procedure with the ALTER PROCEDURE statement
Delete a Stored Procedure with the DROP PROCEDURE statement
Triggers, Cursors and Indexes
Module 7: Importance of Back End Testing
Why back end testing is important
Characteristics of Back End testing
Back End testing phases
Back end test method
* Note: We are open for any customization to course contents.
Q: When are the courses held?
A: The courses are scheduled monthly throughout the year.
Q: What do I take away from the course?
A: As well as the skills to use the product, you also receive a comprehensive workbook and a certificate of attendance.
Q: Do I get a course manual to keep?
A: Yes, you receive a comprehensive workbook.
Q: Where are the classroom training courses held?
A: The courses are all held in Parramatta, Sydney.
Q: Is the training practical or theory based?
A: Both. All of our course combine practical demonstrations and theory. You will have a sole use of a laptop throughout the course and can practice what you have learnt at the end of each chapter.
Q: Do I need to bring a laptop?
A: Yes, it is required to help you start from scratch on your own machine.
Q: What qualification will I get?
A: You will receive a certificate of attendance.
Q: Do I need any previous practical experience?
A: This depends on the course you choose to take. All of our Introductory and Complete courses require no prior knowledge. If you are considering attending an Advanced course, but have not sat the basic course, then you will be expected to have relevant practical experience in the tool.
Q: Do you offer on-site training?
A: Yes, all of our courses can be delivered as on-site courses. We provide all laptops, projector, workbooks and certificates. We can also deliver on-line training just for your company with a schedule to suit you.
Q: Do you offer post course support?
A: Yes, in two ways; firstly, all our trainers can help with initial queries you may have when using the tools post-course via email. Secondly we also provide short-term on-site internship.