Manual Testing, SQL & Agile
Course
Manual Testing, SQL & Agile
Software testing has very high job demand across the globe.The worldwide software testing outsourcing market has grown to $30 Billion in 2010 and is expected to be $50 Billion in 2020 according to NASSCOM report. In simple words software development is incomplete without quality check and software testing helps to deliver quality software so that the risk can be minimised.
BATCH SCHEDULES
Contact us for any other queries
08064444451
About Course
Software testing has very high job demand across the globe.The worldwide software testing outsourcing market has grown to $30 Billion in 2010 and is expected to be $50 Billion in 2020 according to NASSCOM report. In simple words software development is incomplete without quality check and software testing helps to deliver quality software so that the risk can be minimised.
At the end of this course you will have all that skill sets required to perform testing at expert level.
Course Objective
Pankaj Sir's Academy online training is designed to help you acquire all the trending skill sets required to become top software tester. At the end of the course you will be able to
- Understand the fundamentals of software testing along with testing techniques
- Performing different types of testing
- Understand how to identify scenarios.
- Write / execute / review test cases
- Report generation and analysis
- Effectively communicate with stake holders
- validating data in the back end database
- Configuring and using testing tools effectively
- Learn to plan and design testing activities
- Test estimations
- Preparing and updating STCM with test execution reports
- Effectively work on live project using agile scrum process etc.
What are the pre-requisites for the Software Testing Course?
As such, there are no pre-requisites for learning Software Testing. This course is designed for graduates and professionals who want to learn and gain insights on software testing eg. Software Testing Engineers,Software Test Managers, QA Engineers, QA leads and Managers, Fresh Graduates and Students.
How will I do practicals in Online Training and clear our doubts?
Pankaj Sir's Academy will provide virtual lab facility for practicals. Our subject matter expert team will help you install virtual lab and they will also help you resolve your queries. Our subject matter expert will be available 24/7 to take queries and help you enjoy your learning.
Case-Studies
Towards the end of the course, you will work on live CRM project where you will be gaining excellent practical knowledge. You will be performing manual testing , validating data in databases by building SQL queries. The complete project execution will happen using Agile scrum process.
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 #1:
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
Once you complete your live project work, you will be awarded with Pankaj Sir's Academy course completion certificate. After completion of your course you can apply for jobs through job portal of testing campus. We will provide life access to the job portal.
Every year thousands of students get placed in top IT companies through our quality training program!!!
-
Do you provide job assistance?
Pankaj Sir's Academy is biggest online training solution provider and is tied up with 400 IT companies. After completion of course you will get access to our in-house job portal through which you can starting applying for jobs all over india. Every day hundreds students appear for placements through Pankaj Sir's Academy online job portal. You will get job assistance till you get placed.
-
Have to clear doubts?
In case of any doubts you can reach of subject matter experts(Technical Trainers) 24X7. You can also opt for one to one doubt clearing session with out subject matter expert
-
What are the payment options?
You can pay by credit card, debit card, net banking or even deposit cheque
-
Who are our instructors?
All our instructors have 12 to 15 years of experience in relevant domain and have experience training thousands of students every year
-
Do we get practise test facility?
yes, we will give you access to our LMS through which you can take hundreds of practise test.
Krishna Sai ,Bangalore
The exposure I've gained on Software Testing and how the industry works and the first job I worked in an company, though I'm in United States now, the things he taught me helping me in every aspect of mine. Thank you so much pankaj sir. Will always be..
Er Kumarsharma Rakesh ,Bangalore
Here teaching is wao,no where you can get this teaching before joining to this institute I joined system domain which is in Sarjapur and they completed Java bbut nothing comes in my mind but here really I m getting knowledge ,try this you will get benefit.