Manual Testing
- SDLC
- Water fall model
- Spiral Model
- V model
- Prototype model
- Hybrid model
- Derived models
- Types of Testing a software
- White box testing
- Black box testing
- Grey box testing
- Black box testing techniques with practical examples
- Functional Testing
- Integration Testing
- System Testing
- Smoke Testing
- Acceptance Testing
- Globalization testing
- Exploratory Testing
- Adhoc Testing
- Monkey Testing/Gorilla Testing
- Regression Testing
- Compatibility Testing
- Security Testing
- Performance Testing
- Load Testing
- Stress Testing
- Soak Testing
- Volume Testing
- Spike Testing
- Test cases
- Identifying Scenarios
- Write/Review/Execute Test cases
- Test case design technique
- Brain storming sessions
- Storing test cases in Test management tools
- STLC
- System Study
- Writing Test Plan
- Preparing Traceability matrix
- Preparing STCM
- Retrospect meeting/Post Harvest meeting
- Triage meetings
- Working of code coverage tool
- White Box Versus Black Box Testing
- How to perform white box testing
- Defect tracking
- Severity versus priority
- Preparing defect report
- Reporting defect in defect tracking tool
- Defect life cycle
- Inconsistent defects etc.
- Difference between smoke and sanity
- What are stubs and drivers
- Difference between verification and validation
- Difference between static and dynamic testing
- Metrics and Analysis
Agile
- Understanding user stories
- How to give user story points
- What should be the format of user stories
- How we do planning poker activity
- Explanation on product back log
- Explanation on Sprint backlog
- What is scrum
- Explanation on Scrum team
- Purpose of standup meetings
- What we do in sprint planning
- Role of product owner
- Role of Scrum master
- Explanation on why team size should be between 6-9
- Explanation on why sprint duration should be 2 – 4weeks
- Sprint retrospect meetings
- What are burn down and burn up charts
- Why KANBAN charts are used
- Advantages
- Dis-Advantages
SQL
- Downloading MySQL
- Installing MySQL
- Connecting from Command prompt to MySQL
- Creating databases
- Create Tables
- Executing various SQL queries on
- Insert
- Update
- Delete
- Select
- Drop
- Distinct etc.
- Why SQL is called as structured query language
- Built-in functions in SQL
- Length
- Trim
- Rtrim
- Ltrim
- Count
- Max
- Min
- Avg
- Sum
- Lcase
- Ucase
- Now
- Using limit keyword in MySQL
- Sorting of Data
- Using % and _ in queries
- Data types
- Constraints
- Difference between DBMS and RDBMS
- Joins
- Sub queries
- Normalisation
- Interview questions
Project
- Industry : CRM
- Project Description: A company wants to store all its customer leads, also wants to maintain its customer billing details in the software. A company also wants to run email campaigning and SMS campaigning for lead generation. Software will also help to monitor work progress of the company along with attendance tracking of the employees. The other features of the software would include forum, organiser, reminders, note, file upload in cloud etc.
- Project execution work
- Write Test Plan
- understanding requirement and identifying scenarios
- Write / review / excuse Testing Cases in Quality Centre
- Reporting defect in bugzilla
- Performing smoke testing
- Performing functional , integration and system testing
- performing adhoc testing, exploratory testing etc.
- performing security testing
- Preparing STCM
- Preparing traceability matrix
- Preparing monthly status reports
- Validating data in the back end database using SQL
- Attending daily stand up meetings
- Analysing burn down chart