Software Testing Syllabus
Credence IT Professional Training
Institute
Tushar Kathalkar/ Yusuf Tamboli
📞+918237916162 📞+917385318590
📞+919766722458 📞+918275219894
www.credence.in
Address : Indira Heights, Survey no. 34/5, Radhe Sham Building, Mohan
Nagar, Dhankawadi, Pune, Maharashtra 411043
Credence IT Professional Training Institute
Software Testing
Introduction to Software Testing Unit Testing(White Box Testing)
▸ Software testing ▸ Execution testing
▸ BRS/SRS ▸ Operational testing
▸ SDLC ▸ Mutation testing
• Waterfall
• Agile
• V model etc..
2
Credence IT Professional Training Institute
Software Testing
Black Box Testing (Functional and Non Functional) Integration Testing
▸ GUI Testing ▸ Top Down Approach
▸ Behavioural testing ▸ Bottom Up Approach
▸ Error handling message testing ▸ Hybrid
▸ Backend testing
▸ Language Compatibility Testing
▸ Cross browser testing
▸ Sanitization testing
▸ Installation testing
3
3
Credence IT Professional Training Institute
Software Testing
Performance Testing
System integration testing
Sanity Testing
Smoke Testing
Regression Testing
Retesting
User acceptance testing
• Alpha testing
• Beta testing
4
4
Credence IT Professional Training Institute
Software Testing
Testing Terminology Test Documents Concepts
▸ Monkey testing Test policy
▸ Exploratory testing Test methodology
▸ Ad hoc testing Test strategy
▸ Big Bang approach Test deliverables
Test plan
Test scenarios
Test case preparation
Software testing life cycle
5
5
Credence IT Professional Training Institute
HPALM
Project Management tool(HPALM)
▸ How to Write test cases in ALM?
▸ Release/Cycle
▸ How to execute test case?
▸ How to raise the defect?
▸ What is severity?
▸ What is priority?
▸ Traceability matrix
▸ Defects
6
6
Credence IT Professional Training Institute
Database Testing
➢ What is Data? Sql Operators
➢ What is Database? ➢ Arithmetic
➢ DBMS VS RDBMS? ➢ Comparison
➢ Roles/Responsibilities ➢ Logical
➢ Types of DB Testing ➢ Set
➢ Sql statements ➢ Like
I. DDL ➢ Concatenation
II. DML SQl functions
III. DCL ➢ Aggregate
IV. TCL ➢ Character
➢ Date
7
➢ Conversion
7
Credence IT Professional Training Institute
Database Testing
Sql joins Sql constraints Sql clauses
➢ Inner join ➢ Primary key ➢ Where
➢ Left outer ➢ Unique ➢ Group by
➢ Right outer ➢ Check
➢ Having
➢ Full outer ➢ Not null
➢ Equi join ➢ Order by
➢ Default
➢ Non equi join ➢ Foreign key
➢ Cross join ➢ Composite key
➢ Self join
➢ Multiple table joins
8
8
Credence IT Professional Training Institute
Database Testing
Pseudo columns ▸ Interview Question discussion
➢ Rank()
➢ Dense_rank()
➢ Rownum
➢ Rowid
PlSql
➢ Store procedures
➢ Triggers
➢ Views
9
9
Credence IT Professional Training Institute
Data Warehousing – ETL + BI
Testing
Data Warehouse Concepts:
➢ Introduction of Analytical system , Data Warehouse and ETL Process
➢ Architecture/technical Flow/Data Flow/High level Design of data warehouse
➢ Differences between OLTP and OLAP.
➢ Normalization and De-Normalization.
➢ Difference between relational and dimensional modelling.
➢ Introduction of Fact table, Dimension table and It’s Types
➢ Surrogate Key
➢ Data Mapping Document 10
10
Credence IT Professional Training Institute
Data Warehousing – ETL + BI
Testing
Data Warehouse Concepts:
➢ Data Models:
a) Conceptual Model
b) Logical Model
c) Physical Model
➢ Star Schema, Snowflake Schema, Galaxy Schema
➢ Types of facts :a) Additive Facts b) Semi Additive Facts c) Non Additive Facts
➢ Types of Dimensions: a) SCDs 0,1,2,3,4,6
11
11
Credence IT Professional Training Institute
Data Warehousing – ETL +
BI Testing
Data Warehouse Concepts:
➢ Types of Dimensions: b) Degenerated dimensions c) Conformed Dimension d)
rapidly Changing dimension e) Junk Dimension
➢ What is Surrogate Key ?
➢ Types of Fact Table
➢ Story of SP_ETL Project for SCD 1 and 2.
➢ Data Mapping Documents
12
12
Credence IT Professional Training Institute
Data Warehousing – ETL +
BI Testing
ETL Tool and Sql Server/Oracle IDE:
➢ SQL Server Integration Services Tool (SSIS) or Informatica or Talend or Query
surge
➢ What is Job/Scheduler ?
➢ Sql Server Management Studio Tool (SSMS)/Dbeaver
13
13
Credence IT Professional Training Institute
Data Warehousing – ETL +
BI Testing
ETL Testing and Report Testing :
➢ What is ETL Testing and importance of ETL testing
➢ Difference between ETL Testing and Database Testing
➢ Types of ETL Testing : I) Meta Data Testing ii) Data Completeness Testing iii)
Data transformation Testing iv) Data Quality Testing v) Retesting
vi) Regression Testing
➢ Story of TRG_ETL Project.
➢ What is Test Scenarios ?
14
14
Credence IT Professional Training Institute
Data Warehousing – ETL +
BI Testing
ETL Testing and Report Testing :
➢ What is Test cases ?
➢ Test case Writing
➢ Test Case Execution
➢ Roles and Responsibilities of ETL tester
➢ Software Testing Life Cycle
➢ Challenges in ETL testing
➢ Introduction of Tableau
➢ Report testing
15
15
Credence IT Professional Training Institute
Tools
1. SQL Developer
2. Sql server management studio
3. Visual studio +SSIS
4. Tableau
5. HPALM
6. Putty
16
16
Credence IT Professional Training Institute
Web Service Testing/File Processing
Web service testing
➢ Soap Ul/Postman
File processing
➢ EDI
➢ CSV
17
17
Credence IT Professional Training Institute
Unix
➢ Software Basic Unix Commands
➢ Types of OS ➢ Date
➢ Introduction of Unix ➢ Cal
➢ Architecture of Unix ➢ History
➢ File Architecture of ➢ Man
Unix
➢ Who
➢ Passwd
➢ Hostname
➢ Pwd
18
18
Credence IT Professional Training Institute
Unix
Interview Questions on Unix Commands
➢ Cat ➢ Rm ➢ Find
➢ Less ➢ Mkdir ➢ Locate
➢ More ➢ Rmdir ➢ Chmod
➢ Cd Ftp
➢ Touch ➢
➢ Ls SSH
➢ Wc ➢
➢ Head & Tail
➢ Cp
➢ Grep
➢ Mv ➢ Sed
19
19
Credence IT Professional Training Institute
Automation Testing
1: Introduction to Python 2: Python Data Types
➢ Installation and Working with Python ➢ Declaring and using Numeric data types: int, float,
➢ Understanding Python variables complex, bool
➢ Python basic Operators ➢ Using string data type and string operations
➢ Understanding python blocks ➢ Defining list and list slicing
➢ Type casting, Unicode etc. ➢ Use of Tuple data type
20
20
Credence IT Professional Training Institute
Automation Testing
3: Python Program Flow Control
➢ Conditional blocks using if, else and elif
➢ Simple for loops in python
➢ For loop using ranges, string, list and dictionaries
➢ Use of while loops in python
➢ Loop manipulation using: pass, continue, break
➢ Programming using Python conditional and loops block
21
21
Credence IT Professional Training Institute
Automation Testing
4: Python String, List, set, Dictionary Manipulations
➢ Building blocks of python programs
➢ Understanding string in build methods
➢ List manipulation using in build methods
➢ Tuple operation
➢ Set manipulation
➢ Dictionary manipulation
22
22
Credence IT Professional Training Institute
Automation Testing
5: Fundamentals of Object orientation:
➢ Class, Object
➢ Constructor
➢ Types of Variables
➢ Methods and its types
➢ Importing Class
➢ OOP’s Concepts: Inheritance, Encapsulation, Abstraction, Polymorphism
➢ File handling: text, binary, csv
23
23
Credence IT Professional Training Institute
Automation Testing
6: Selenium Web driver:
➢ Introduction to Automation Testing
➢ Scope of Selenium Training
➢ Introduction to Selenium components
➢ Why Web Driver? Installation and setting up the environment
➢ Installation of Python and PIP
➢ Downloading and setting up Selenium Installing Python IDE (PyCharm)
➢ Configuring the environment
25
24
Credence IT Professional Training Institute
Real Time Projects Training
We will cover different type of domains with real time project training such as :
➢ Telecom Billing/CRM/OSS/Mediation
➢ Capital Market/Investment Banking
➢ Healthcare Domain
➢ Card Payment
➢ As per Market demand, we will add some other important domains if required.
26
25
Thanks !
26
