Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. The emphasis in this course is on hands-on and practical learning. Through a series of hands-on labs you will practice building and running SQL queries. No prior knowledge of databases, SQL, Python, or programming is required.
Database Fundamentals Course Content
Module 1
- What is database application?
- Back end vs. front end testing        Â
Module 2
- Database components
- Database type         Â
Module 3
- Introduction to Oracle database
- Database testing phase      Â
Module 4
- Testing methodologies
- Structural database testing
- Functional database testing
Module 5
- SQL coding standard
- SQL Basics – Select, Insert, Update, Delete
Module 6
- Select statement to test data
- Insert statement to generate data Â
Module 7
- Update and delete statement to test application accuracy
- Test data integrity  Â
Module 8
- Joining tables
- Using SQL queries for data verification     Â
Module 9
- Concurrency issues
- Database objects    Â
Module 10
- Views
- Indexes
- Stored procedure    Â
Module 11
- Triggers
- Defined functions
- Schema testÂ
Module 12
- Keys and indexes
- Integration test for server
- Test back-end via front endÂ
Database Fundamentals Course Content
- What is database application?
- Back end vs. front end testing
- Database components
- Database type
- Introduction to Oracle database
- Database testing phase
- Testing methodologies
- Structural database testing
- Functional database testing
- SQL coding standard
- SQL Basics – Select, Insert, Update, Delete
- Select statement to test data
- Insert statement to generate data
- Update and delete statement to test application accuracy
- Test data integrity
- Joining tables
- Using SQL queries for data verification
- Concurrency issues
- Database objects
- Stored procedure
- Triggers
- Defined functions
- Keys and indexes
- Test back-end via front end
API Testing Course Content:
Introduction to API Testing: Understand the significance of API testing, its benefits, and common challenges in the API testing landscape.
Postman Fundamentals: Familiarize yourself with the Postman interface, create collections, manage environments, and organize test suites.
Building Requests: Learn to construct HTTP requests using different methods (GET, POST, PUT, DELETE), handle request headers, and set up authentication.
Validating Responses: Master response validation techniques to ensure accuracy, including assertions, status code verification, and response schema validation.
Parameterization: Harness the power of data-driven testing by incorporating variables and data files into your test scripts for extensive test coverage.
No upcomming classes scheduled!