Manual Testing with API & SQL

BY
GroTechMinds

Learn to master the concepts of software testing and fireproof the software with the Manual Testing with API & SQL online course

Mode

Online

Duration

50 Hours

Fees

₹ 18000 22000

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

The Manual Testing with API & SQL online course is designed to provide individuals with a comprehensive understanding of manual testing, specifically focusing on API and SQL testing. This course is suitable for beginners as it starts from scratch and gradually progresses to advanced concepts. Throughout the Manual Testing with API & SQL certification by GroTechMinds, learners will gain theoretical knowledge and practical skills necessary to perform manual testing effectively. 

Industry experts will guide individuals through the entire learning journey, ensuring that they develop a strong foundation in manual testing methodologies. The Manual Testing with API & SQL training course will cover various topics such as understanding API and SQL, API testing techniques, how to create and execute test cases, and performing SQL queries to validate data. 

Participants will also learn about functional and non-functional testing, test planning, defect management, and reporting. Learners will have the opportunity to work on real-world projects and gain practical experience by applying their knowledge to solve practical challenges. This equips them with the necessary skills to excel in a professional manual testing environment. Read more to learn about manual testing certification courses.

The highlights

  • 50 Hours Duration
  • 3 Months Course
  • Skill-Based Learning
  • Online Programme Mode

Program offerings

  • Iso certification
  • Live video
  • E-learning
  • Test
  • Masterclass sessions
  • Project
  • Resume preparation
  • Real project assignment
  • Doubt solving sessions

Course and certificate fees

Fees information
₹ 18,000  ₹22,000

Manual Testing with API & SQL fee structure :

Course Name

Fee Details

Manual Testing with API & SQL

Rs. 18,000

certificate availability

Yes

certificate providing authority

GroTechMinds

Who it is for

The Manual Testing with API & SQL certification syllabus is for both beginners who have no prior experience in Manual Testing and experienced professionals who want to upgrade their skills in software development. For example–

Eligibility criteria

Certification Qualifying Details of Manual Testing with API & SQL

The Manual Testing with API & SQL certification by Grow Tech Minds is granted upon completing the course successfully.

What you will learn

Sql knowledge

During the Manual Testing with API & SQL certification syllabus, the participants will learn:

  • Understand the fundamentals of manual testing with a focus on API and SQL testing.
  • Gain practical knowledge in creating and executing test cases.
  • Perform API testing using various techniques and tools.
  • Validate data by writing and running SQL queries.
  • Develop an understanding of functional and non-functional testing.
  • Learn how to plan and manage testing activities effectively.

The syllabus

Module 1

  • Introduction about Software Testing
  • Why is software testing required in the IT industry?
  • What are B2B and B2C applications?
  • What are service based and product based companies?

Module 2

  • What is manual testing?
  • What is Automation Testing?
  • What is SDLC? What is the need of it? What will happen if we don’t follow it?
  • What are the 7 stages of SDLC?

Module 3

  • What is the Waterfall model?
  • What is V & V model?
  • What is a prototype model?
  • What is Black Box Testing?
  • What is Component testing?

Module 4

  • What does the test case template look like?
  • How to write scenarios and test cases?
  • Difference between test scenarios and test cases?
  • Things to keep in mind before writing test cases?
  • Test Case Design techniques?

Module 5

  • What is Positive testing?
  • What is Negative testing?
  • What is the Test Case review process?
  • What is Integration testing?
  • How to write integration test cases?
  • What is system testing?
  • What do you mean by a testing server similar to the production server?
  • What is Acceptance testing?
  • What are the other names of Acceptance testing?
  • What are the different ways to do acceptance testing?
  • What is Regression testing?
  • Types of Regression testing?
  • Impact Analysis meeting?
  • What is Smoke testing?
  • What is Hot Fix? Incident Management?

Module 6

  • What are the 7 principles of software testing?
  • What is Defect Cascading?
  • What is Defect Masking?
  • What is Defect clustering?
  • What is bug release?
  • What is bug leakage?

Module 7

  • What is Agile?
  • What is product Backlog?
  • What is a sprint?
  • What is sprint planning?
  • What is Epic?
  • What is the story point?
  • What is a Scrum meeting?/Daily standup meeting
  • What is a bug bucket?
  • What is a bug triage meeting?
  • Who is scrum master?
  • What is a sprint retrospective meeting?
  • What is performance testing?
  • What are performance testing types?
  • What is compatibility testing?
  • What is exploratory testing?
  • What is Recovery testing?
  • What is reliable testing?
  • What is Functional and non functional testing?
  • What is static and dynamic testing?
  • Smoke testing vs Sanity testing?
  • What is build?

Module 8

  • What is STLC?
  • What is the Bug Life cycle?
  • What is the test plan?
  • What is Patch?
  • What is a Web Application?
  • What are Client Server Applications?
  • What are Stand Alone Applications?
  • What is Usability Testing?

Module 9

  • API Testing syllabus
  • What is API?
  • What is API Testing?
  • Why is an API needed?
  • How does API play an important role in 2 diff applications?

Module 10

  • Why do we need a Postman?
  • What is a Postman tool?
  • 3 layer architecture of API
  • What is the relationship between client and server?
  • What all things your request should consist of?
  • HTTP methods available in API
  • HTTP status code in API

Module 11

  • Introduction to Database-use cases
  • What Is a Database?
  • Why do we need Database?
  • Practical examples of Database?
  • What is SQL?
  • What is a Database Management System (DBMS)?
  • What is a Relational Model ?
  • Introduction to RDBMS

Module 12

  • Data Integrity-web
  • What is data integrity?
  • What is the use of data integrity
  • What are Data Types ?
  • What are Constraints?
  • Not Null
  • Primary Key
  • Foreign Key
  • Check
  • Unique

Module 13

  • Statements in SQL
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Data Control Language (DCL)
  • Data Query Language (DQL)

Module 14

  • Software mysql server installation
  • Installing and set up of software
  • We will be working on mysql server

Module 15

  • When to use following
  • From
  • Where
  • Group By
  • Having
  • Order By

Module 16

  • Operators
  • Comparison operators
  • Logical operators
  • Special operators

Module 17

  • Functions in SQL
  • Max ()
  • Min ()
  • Sum ()
  • Avg ()
  • Count ()
  • upper()
  • lower()
  • rank()
  • dense_rank()

Module 18

  • Sub Query
  • Introduction to Sub Query
  • Problems on subquery
  • Query Writing and Execution on DBMS practical class

Module 19

  • JOINS
  • What Is Join?
  • Types of Joins.
  • Cross join Join
  • Inner Join syntax and queries in DBMS
  • Outer Join syntax and queries in DBMS
  • Self-Join syntax and queries in DBMS
  • Left Outer Join syntax and queries in DBMS
  • Right Outer Join syntax and queries in DBMS
  • How to join 2 tables and 3 tables?
  • Queries and Examples.

Module 20

  • Data Definition Language (DDL)
    • Create
    • Rename
    • Alter
    • Truncate
    • Drop
  • Data Manipulation Language (DML)
    • Insert
    • Update
    • Delete
  • Transaction Control Language (TCL)
    • Commit
    • Save point
    • Rollback
  • Data Control Language (DCL)
    • Grant
    • Revoke

Module 21

  • Normalization
  • Introduction to Normalization
  • Types of Normal Forms
  • Examples.

Module 22

  • Difference between SQL and MYSQL
  • Resume preparation and Points to be mentioned in the ResumeSQL Syllabus:

Admission details

Follow the steps below to join the Manual Testing with API & SQL classes.

Step 1- Click on the link below:

https://grotechminds.com/courses/manual-testing-course/

Step 2- Click on the “Get Course” option on the webpage, and register on the platform.

Step 3- Upon successful payment of fees, the course becomes available.

How it helps

Manual Testing with API & SQL certification benefits include

  • Comprehensive understanding of manual testing techniques.
  • Proficiency in API testing and SQL queries.
  • Hands-on experience through real-world projects.
  • Learning from industry experts in the field.
  • Strong foundation in test planning and defect management.
  • Improved career prospects in software testing.

Instructors

Mr Manish Kumar Tiwari
Instructor
Freelancer

FAQs

Is any prior experience required to enrol in this Manual Testing with API & SQL online course?

No, this course starts from scratch and is suitable for beginners.

What will be covered in this Manual Testing with API & SQL certification course?

The course covers manual testing fundamentals, API testing, SQL queries, test planning, defect management, and more.

Will I get hands-on experience in the course?

Yes, the course offers hands-on experience through real-world projects.

How long does it take to complete the course?

The course duration may vary, but learners can typically complete it within a few weeks by dedicating a few hours each day.

Are there any prerequisites for this course?

There are no prerequisites for this course. Basic computer skills are recommended.

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses