Global software tester

Fpî Software

GLOBAL SOFTWARE TESTER

(Bộ tài liệu dùng cho chương trình giảng dạy Global Software Talent

của Fpt Software dành cho sinh viên ngành công nghệ thông tin các trường

cao đẳng, đại học tại Việt Nam)

GLOBAL SOFTWARE TALENT FOR TESTER

F ore w o rd s.......................................................................................................................................................................2

Training o b je ctive s....................................................................................................................................................... 2

Training program ...........................................................................................................................................................2

LI (Know-How) Topics - 4 days............................................................................................................. 2

BasicTech/SQL4T - 4d.......................................................................................................................... 2

L2 (Industry Readiness) Topics - 22 days...............................................................................................3

Processi/SWR - Id ............................................................................................................................... 3

Process 1/Extra - Id ............................................................................................................................... 3

MockProjectl - 1 Id .............................................................................................................................. 3

Automation test - 2.5h.......................................................................................................................... 3

MockProject2 - 9 d ................................................................................................................................ 3

!

Forewords

Global Software Talent program is training program of FSofit for the third-year or fourth-year IT

students in almost universities in Viet Nam. Program is designed to help student to get software

know-how and industry readiness so that they can join any global software companies in Viet Nam

immediately without company’s training. For more details, please visit us at www.career.fsoft￾software.com.

This document describes all modules in Global Software Talent program for software tester.

Training objectives

Global Software Tester training program include 3 following modules.

M o d u le T r a in in g O b jectiv e s C o u rses

L I - (K n o w

H o w ) T o p ics

- 4 d ays

- Have Database basics, SQL basics and MS SQL

Server knowledge enough to serve a good tester

job.

- SQL4T (4 d)

L 2 -

(In d u str y

R e a d in e ss) -

22 d a y s

- Understand Software Requirement Concept &

Process.

- Have the concept of Review & Software Testing

Basics; Configuration Management Basic and

know how to use SVN tool.

- Know Test plan structure; understand objective of

each part and which part should be focus as a test

team member.

- Can study software requirement, get acquainted

with and know how to ask questions to clarify

requirement.

- Write good test cases and effective defects.

- Know how to report working progress and write

test report.

- Know what is automation test? Why automation

test? When we use automation test? Automation

test scripting techniques.

- Team work

- Presentation skill

- Documentation skill

- Attitude and code of ethics.

- SWR (1 d)

- RVTB&CMB (Id)

- Test Tech-Mock 1 (11 d)

- Automation test (2.5 h)

- Mock 2 (9 d)

L3(Fsoft

Readiness)

Topics - 4d

to 2 months

Student who has passed GLOBAL SOFTWARE TALENT program could join

internship program in FSOFT if not graduated yet. Otherwise, for graduated

student, you can join real project at Fsoft (or any other global software

companies) as a software tester immediately and might have 4 days more to

learn about FSoft, as well as FPT culture, and FSoft development process.

Training program

LI (Know-How) Topics - 4 days

BasicTech/SQL4T - 4d

Database Basics

o Database concepts

o Entity Relationship Modeling

o Normalization

r\ T m e f n r H R H a c irrn irvrr Q O T R a c ie c

SQL Basics

o Ms SQL Server Overview

o SQL Data Types

o SQL Overview

o Data Definition Language (DDL)

o Data Manipulation Language (DML)

Microsoft SQL Server

o SQL Server Management Studio

o Profiler

L2 (Industry Readiness) Topics - 22 days

Proeessl/'SW R- Id

Requirement Concepts & Process

Exam

Processl/Extra - Id

Review and Software Testing Basic; Configuration Management Basic and SVN tool.

M ockProjectl - lid

Include testing theory and practice.

Theory:

Test plan

Test case

Test techniques

Web application testing

Test report

Practice:

# T a sk A ctiv ities an d O u tp u t

1 K ic k o f f K ic k o ff, in tro d u c e p ro je c t sc h e d u le .

R e q u ire m e n t b ra in s to rm in g . D is trib u te ta s k s to te a m .

2 R e q u ire m e n t

u n d e rs ta n d in g a n d

a n a ly sis

P re s e n ta tio n a b o u t sy s te m fu n c tio n a n d Q & A list.

3 W rite T e s t D e s ig n T e s t d e s ig n d o c u m e n t.

4 W rite T e s t c a s e s C re a te d a n d u p d a te d te s t c a s e d o c u m e n t.

5 T e s t e x e c u tio n a n d te s t

re p o rt

D a ily re p o rt.

C re a te d a n d u p d a te d T e s t re p o rt.

C re a te d a n d u p d a te d D e fe c t list.

Automation test - 2.5h

Introduction to Automation Test.

MockProject2 - 9d

Similar to practice part of Mock 1.

8/16/20

Agenda

• Database Concepts

• Entity Relationship Modeling

• Normalization

• Tips for DB Designing

1

8/16/20

Data Model

4A data model is a “description” of both a container for

data and a methodology for storing and retrieving data

from container.

*4 “you can think of a data model as the infrastructure of the

data organizations, in other words, the way data is

presented to the user.”

Data model is.....

❖ Not a thing

❖You cannot touch it

❖ Data model are abstractions, mathematical algorithms &

Concepts.

❖You can not touch a data model.

Database Systems Models

Data base management systems follow particular

models (known as database models) to store and

manipulate

data. A data base model is characterized by:

1. The way it stores data : STR U C TU R E

2. The way data in the

structure are manipulated: OPERATIO NS

8/16/20

Limitations

Searching for

records

Data Redundancy

Data Inconsistency

Data in books 7 A

and registers V '

F L A T

F IL E

Advantages

•Overcame limitations

•Compact

•Easy to use

•Accurate

The Relational Database

• “A DBMS that manages data as collection of

tables in which all data relationships are

represented by common values in related

tables.”

• “A DBMS that follows all the twelve rules of

CODD is called RDBMS”

3

8/16/20

Supplier

Tuple

s

Primary

Key

TABLE Structure 1/2

............ Domain Domain

MÉdfi. SName Quantity City

s i K a m r a n 2 0 L a h o r e

S 2 Z a fa r 10 I s la m a b a d

S 3 A z m a t 4 0 K a r a c h i

S 4 A b d u l 3 4 L a h o r e

S 5 N a s ir 2 5 I s la m a b a d

\ ___ L

Attributes

Cardi

nality

TABLE Structure 2/2

«Attribute (field):

Member of a relation type (set / table),

e Attribute Name:

All attribute names must be unique within a

table / relation.

« Attribute Domain:

Aset of all possible values that can be attain by

an attribute.

* Attribute Value Set

Values currently contained in an attribute.

« Relation I Table Degree:

Number of attributes in a relation / table.

« Tuples: Rows in a table / relation.

« Cardinality: Number of tuples in a relation / table.

8/16/20

Ex: Instance of Students Relation

Student(studno,name,address)

Course (courseno,lecturer)

Schema

Student(123,Bloggs,WooIton)

(321,Jones,Owens) Instance

sid Name Login age GPA

53666 J o n e s Jo n e sT T c a 18 3.4

53444 s m ith S m ith ( S e c s 18 3.2

53777 B la k e B la k e w ia a 19 3.8

1 Cardinality = 3, arity = 5 , all rows distinct

■ Do all values in each column of a relation instance have to be distinct?

Relational Database Concepts

Table

Record

CD ID

1

Title

The Wall

Artist

Pink Floyd

Field

3 Requiem W.A. M ozart

5

Basic component of a Relation

Relation name Attributes

STUDENT Name 1 SSN HomePtione Address OfliœPtoe Age GPA

/ * ■ Benjamin Bave»? Ị 305-61-2435 373-1616 2918 Bluebonnet Une nul 19 3.21

Katherine Áshỉy 1 361-62-1245 375-4400 125 Kjrby Road nui 18 2 M

Dick Davidson ị 422-11-2320 nul 3452 Elgin Road 740-1253 2i> 3v53

Orates Cooper ! 483-22-1100

Barbara Benson I 533-89-1238

376-9821

839-8461

266 lark Lane

7384 Fontana Lane

749-6492

raíl 19 3,25

Tuple:

• The actual data values for the attributes of a relation are stored in tuples, or

rows, of the table.

• It is not necessary for a relation to have rows in order to be a relation; even

if no data exists for the relation

• The relation remains defined with its set of attributes

Attribute:

The term attribute refers to characteristics. This simply means that what the

column contains will be defined by the attribute of the column

Examples of Attribute Domains

A & rm m S íím f

, T ¿ \ v&,ìĩ*ỉ /V ẽ ềềíềện

B§j» B R A N C H .N U M B ER S 'H it M.I Aû t e íiu l ì iiyjiibi'ts u m s < r-ằ$Ệf lĩl Ệ ộ#

•STREET N A M E S lift' 4*1 i l i i  e t k f A m m ìK ĩ Mt/Í 25

.'Vcá A W Ä \ A M k s '%%t Mti <2 si'û <nc4 'iïMiW*. m Bếllâliỉl AmfáUMt u m 2*Ị

€ m onT. N A M E S Th« m I T(1 A ! itiỊ î i m m m i k im n d u ĩ& ía r . u m 15

Pende T O S T C O D E S iìỉỂ m t nể â l m llrkuin AiM ứUHt' h im %

T il N*> n a i - Ä X N U M B E R S ìT íe m í ỉ ẩ ã ẵ ĩtỉcpkM K nmẵ ï m tíó tífb m m ầ m m ế đm rnầ® r: u m ì :!

h fx N » r ü J A X s t M EEK S 11 k 'x i *4 a l g d q th w t Ỉ8f! 1 \ m iftnabCTtt Its iìn im ị ở m m ầ m w m 15

S fi- S E S l ầ ặ m% *Ểề p< m:m A u iiu m r ' WỈK 1, Villes M ' f V

P O B 0A T H S ..O P H t r n i 1* n&ble !*t U A i iw tll 'Ì8Vf* Jaíté* í h f *1> i

ỆiỊ&ìM ể ề ^ Â ẫ ỉ H Ệ

S Á r f SALARIES f m r n m mằmm ý f ^ IT s ạ Ịạ m ií 1 dìỉĩiix* m m m

8/16/20

DBMS vs. RDBMS

DBMS RDBMS

The concepts of relationships is

missing in a DBMS. If it exits it is

very less.

It is based on the concept

Of relationships

Speed of operation is very slow Speed of operation is very Fast

Hardware and Software

requirements are minimum

Hardware and Software

requirements are High

Platform used is normally DOS Platform used can be any DOS,

UNIX,VAX,VMS, etc

Uses concept of a file Uses concept of table

DBMS normally use 3GL RDBMS normally use a 4GL

Examples are dBase, FOXBASE,

etc _ ......

Examples are ORACLE,

JMGRESS, SQL Server 2000 etc

Ị w FPT Software g

Oracle

Sybase

Microsoft SQL Server

Informix

Ingress

DB2

7

8/16/20

RDBMS Users

* Database admin

■ Database designer

■ Developer

■ Implementer

■ End users.

Entity Relationship Modeling

Database design

• Database design is the process of producing a detailed

data model of a database

• Process of Database Design:

- Determine the relationships between the different

data elements.

- Superimpose a logical structure upon the data on the

basis of these relationships

Database designs also include ER (Entity-relationship

model) diagrams.

An ER diagram is a diagram that helps to design

databases in an efficient way.

8/16/20

9

8/16/20

Entity Relationship Modeling

Sample E-R Diagram

SUPPLIER

Cardinalities

........{} ■■' Mandatory One

— Mandatory Many

— Optional One

Optional Many

Supplies

SHIPMENT Includes ITEM CUSTOMER

Entity Relationship Modeling

Basic E-R Notation

Basic sym bols

Entity

symbols

Relationship

symbols

Strong entity

Weak entity

Identifying relationship

Associative entity

A special

entity that is

also a

relationship

Multivalued attribute Attribute

symbols

, Derived attribute

10

8/16/20

Entity Relationship Modeling

Attributes

• Attribute - property or characteristic of an entity type

• Classifications of attributes:

- Simple versus Composite Attribute

- Single-Valued versus Multivalued Attribute

- Stored versus Derived Attributes

- Identifier Attributes

Entity Relationship Modeling

Identifiers (Keys)

• Identifier (Key) - An attribute (or combination of

attributes) that uniquely identifies individual

instances of an entity type

• Simple Key versus Composite Key

• Candidate Key - an attribute that could be a

key...satisfies the requirements for being a key

• Characteristics of Identifiers:

- Will not change in value

- WII not be null

- No intelligent identifiers (e.g. containing locations or people that might

change)

- Substitute new, simple keys for long, composite keys

11