Level 2: Front-End, Back-End and Database Testing
Overview
In this level, you will learn and understand the purpose of Front-end, Back-end, and Database testing. You will understand and distinguish the functional and non-functional requirements and testing.
At the end of the lectures, you will be able to create and execute test cases for Front-end and Back-end testing of applications, you will know how to prepare test data and validate the manipulated data in the database during testing. Moreover, you seamlessly distinguish between functional and non-functional testing. Lastly, you will perform basic non-functional testing using a tool or a browser add-on.
Course Details
Level Duration: 4 weeks
Total Program Length: 40 hours
Lectures Length: 16 hours
Practical Exercises Length: 24 hours
- Part 1: Testing User Interfaces
- Part 2: API (Back-End) Testing
- Part 3: Database Testing
- Part 4: Functional vs Non-functional Testing
The part will cover GUI testing principles and the significance of following the style guides for design consistency. During the practical exercises, you will create test cases for a web application, perform GUI testing, and evaluate design consistency using a style guide on a website.
Lecture
- Understanding GUI testing principles
- Testing style guides and design consistency
Practical Exercises
- Create test cases for the user interface on a sample web application.
- Conduct GUI testing on a sample web application.
- Explore a style guide and perform design consistency checks on a website.
In the part, you will learn about client-server architecture, API principles, and the significance of back-end testing. The practical exercises include creating test cases and conducting API testing using Postman on a given endpoint. You will also have the opportunity to apply black box testing techniques to evaluate the API’s functionality.
Lecture
- Overview of client-server architecture and API principles
- Importance of back-end (API) testing
- API testing with Postman
Practical Exercises
- Create test cases for API testing on a given API endpoint.
- Practice API testing using Postman on a provided API endpoint.
- Apply different black box testing techniques to test the provided API.
In this part, you will gain a better understanding of relational and non-relational databases, SQL basics (entities, columns, views, etc.), test data preparation, and database testing principles. The practice session includes writing basic SQL queries (select, insert, update) for test data preparation and validation. Additionally, you will create and execute test cases with database checks.
Lecture
- Understanding relational and non-relational databases
- Basics of SQL including entities, columns, views, stored procedures, constraints, and data types
- Preparing test data
- Database testing
Practical Exercises
- Write basic SQL queries (select, insert, update) to prepare test data and validate stored data.
- Create more complex SQL queries with inner and outer joins for data analysis and testing purposes.
- Create test cases and execute them by adding DB checks.
During this level, you will gain better understanding of the distinction between functional and non-functional testing, covering various types such as smoke and regression testing for the former, and performance, security, usability, and accessibility testing for the latter. Afterwards, you will focus on hands-on experience through analyzing requirements, developing test cases, using accessibility tools, and measuring application performance.
Lecture
- Differentiating between functional and non-functional testing
- Understanding various types of functional testing (smoke, regression)
- Understanding various types of non-functional testing (performance, security, usability, accessibility, etc.)
Practical Exercises
- Analyze requirements to determine functional and non-functional testing needs for a given project.
- Develop test cases for both functional and non-functional requirements.
- Using accessibility tools to identify accessibility issues.
- Measure the performance of the application.
- Completion of Level 1: Intro to Software Testing
You will need access to a computer with stable internet for the online lectures, practical exercises, and project work. Additionally, access to relevant software tools such as Postman for API testing and SQL for database testing is recommended.
We’ve created a flexible environment which will enable you to have the best learning experience from the comfort of your own home. We offer two paces of studying, so it’s up to you to choose the one that best fits your schedule. That said, to successfully pass the class, students should aim to reach at least 90% of the available points.
In accordance with our Code of Conduct, punctuality, participation in discussions, completion of assignments, and demonstration of professional courtesy to others are required. Attendance will be recorded at the start of the class. Passing requires attendance on the full course.
