Week 1: Introduction to Python
Day 1: Course Introduction and Python Basics
- Introduction to the course
- Python installation and setup
- Basic syntax, variables, and data types
Day 2: Control Structures
- Conditional statements: if, elif, else
- Loops: for, while
- Practice exercises
Day 3: Functions and Modules
- Defining and calling functions
- Function arguments and return values
- Introduction to modules and packages
Day 4: Data Structures
- Lists, tuples, sets, and dictionaries
- List comprehensions
- Practical exercises
Day 5: File Handling
- Reading from and writing to files
- Working with CSV files
- Hands-on practice
Day 6: Error Handling and Exceptions
- Try, except, finally blocks
- Custom exceptions
- Practical scenarios
Day 7: Review and Mini Project
- Review of Week 1 topics
- Mini project to consolidate learning
Week 2: Advanced Python for QA
Day 8: Object-Oriented Programming (OOP)
- Classes and objects
- Inheritance, polymorphism, encapsulation
Day 9: Advanced OOP Concepts
- Special methods
- Class and static methods
- Practical exercises
Day 10: Libraries for QA
- Introduction to unittest and pytest
- Writing and running test cases
Day 11: Automation with Python
- Introduction to Selenium
- Web scraping basics
Day 12: Working with APIs
- Introduction to APIs and REST
- Using requests library to interact with APIs
Day 13: Data Analysis with Python
- Introduction to pandas
- Data manipulation and analysis
Day 14: Review and Practice
- Review of Week 2 topics
- Practice exercises and Q&A
Week 3: Introduction to SQL
Day 15: Introduction to SQL
- SQL basics: installation and setup
- Introduction to databases and RDBMS
- Basic SQL commands: SELECT, INSERT, UPDATE, DELETE
Day 16: Data Retrieval
- SELECT statements with WHERE clause
- Filtering, sorting, and limiting data
Day 17: Advanced Data Retrieval
- JOIN operations
- Subqueries and nested queries
Day 18: Data Aggregation
- Aggregate functions: COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING clauses
Day 19: Database Design and Normalization
- Database schema design
- Normalization and denormalization
Day 20: Review and Practice
- Review of Week 3 topics
- Practice exercises and Q&A
Week 4: Advanced SQL and Integration with Python
Day 21: Advanced SQL Techniques
- Window functions
- Common Table Expressions (CTEs)
Day 22: SQL Performance Tuning
- Indexing
- Query optimization techniques
Day 23: Working with Transactions
- ACID properties
- Transaction control commands: COMMIT, ROLLBACK, SAVEPOINT
Day 24: SQL in QA
- Using SQL for data validation
- Writing complex queries for testing scenarios
Day 25: Integrating Python with SQL
- Using libraries like SQLite3 and SQLAlchemy
- Performing CRUD operations from Python
Day 26: Practical Applications
- Real-world QA scenarios using Python and SQL
- Case studies and examples
Day 27: Review of Python Topics
- Overview of Python topics covered
- Advanced exercises and Q&A
Day 28: Review of SQL Topics
- Overview of SQL topics covered
- Advanced exercises and Q&A
Day 29: Combined Python and SQL Practice
- Integrated exercises using both Python and SQL
- Hands-on practice and troubleshooting
Day 30: Course Review and Wrap-Up
- Course review and recap
- Feedback and next steps
For more information about the course and dates, please mail us info@syncitlearning.com or you can reach over the phone at 510-779-9040
Learning Mode: Online
I’m CHARMI JAIN , and I’m thrilled to embark on this journey with you as your Quality Analyst instructor. With over 7 years of hands-on experience as a technical support engineer at reputable organizations, I’ve honed my skills in troubleshooting, problem-solving, and ensuring top-notch product quality. Armed with a BTech degree in Computer Science and Engineering, I’m passionate about sharing my industry insights and real-world expertise to empower you on your path to becoming successful Quality Analysts. Join me in our upcoming class sessions to unlock the secrets to mastering quality assurance and making a meaningful impact in the tech industry.
Sync IT Learning’s Quality Analyst training program aims to produce competent and well-rounded professionals who can positively impact the quality of products and services in their respective industries.
There are no prerequisites to take this course. All stakeholders working in software testing using programming languages, or quality assurance methodologies (or are wanting to get into such a role) are going to benefit from this course. Literally, this course can be taken by a high school student. That’s how easy it is. Yet do not underestimate the power of this training class. It will teach you A LOT.
Sync IT Learning’s Quality Analyst training is for 6 weeks (5 days a week)
Monday, Tuesday, Wednesday, Thursday & Friday: 10:00 AM to 11:00 Am Pacific Time.
Here is the detailed syllabus for Sync IT Learning’s Quality Analyst class.
- What is Software Testing
- Introduction to Manual testing
- Introduction to Automation testing
- Software Testing Principles
- Software Development Life Cycle (SDLC)
- Software Testing Life Cycle (STLC)
- Type of Software testing
- Levels of software testing
- Testing Concepts
- Introduction to Test Cases and Use cases.
- Test Case design techniques (Specification & Experienced)
- Test Case Format
- Creating/Designing/Executing Test Cases
- Introduction to test plan
- Introduction to Test Case Management System
- Introduction to test planning
- Test and Defect Management Tools and Process
- Introduction to defects
- Defect Life Cycle
- Status of defect
- Severity
- Priority
- Defect Report
- Defect Tracking Tool
- Introduction to Agile and Scrum
- Difference between Desktop and Web based Application Testing
- API Testing Using Postman
- Introduction to API and API Testing and setup Postman
- GET request using Postman
- GET request with path parameter and query parameters
- JSON request and response
- POST Request using Postman
- PUT, PATCH and DELETE Request using Postman
- Adding environment variables
- Creating test and adding assertions
- Basic Authentication using Postman
- Hands on
- Automation Testing Types
- Introduction to Tosca Automation
- Tosca Workspace
- What is SUT
- MBTA
- Standard Modules
- Xscan
- Identify Controls
- identify by Anchor
- Test Case in Tosca
- Execution Lists
- Requirements
- Additional Terms in Tosca
- Steps to Install Tosca
- Exercise to Run test Case
- Introduction to ISTQB
- Software testing Interview questions
The Quality Analyst training is conducted exclusively online. Participants can access training materials, lectures, and engage in interactive sessions from the convenience of their own location, providing flexibility and accessibility.
Yes, $199 fee. You can audit the class on the first day but after that, you will have to pay the fees.
The Quality Analyst training equips you with versatile skills applicable across various industries, allowing you to pursue diverse career paths in quality assurance, testing, and related fields.
Sync IT Learning specializes exclusively in IT certification training, but we can refer to some of the consultancies in the USA, one of them being Solutions Sync who can help you in understanding your requirement and helping you with job placement.
Yes, absolutely. We can give you references from all kinds of candidates – for all of the certifications we provide. Please ask your salesperson for details.
We recommend that you start the training in the current batch. Start attending the current batch even if the current batch started more than X days ago. Why? Because a lot of topics in QA and BA and PM training are not related to each other. So, you will gain tremendous knowledge regardless of when you join the batch. Yes, at times, you will be a bit lost but with the help of classmates, your own self-study with the course material that Sync IT Learning provides, you would be in pretty good shape. And, the best thing is, you can start the next batch from Day 1 (for no new charge of course). So, take the first batch you attended as your bonus training.
Unfortunately, individualized sessions for missed classes are not available. However, rest assured that you will have access to class recordings for every session.
Yes, you are very welcome to take the training again at no cost. In fact, I recommend it for some people who take longer to absorb new topics. You can take BAbAB training again and again and again at no added cost.
To enroll for the Quality Analyst certification exam, go to the “ASTQB” official website (https://astqb.org/ ) and then click on “ISTQB Exam Registration” (https://astqb.org/registration/ )
Yes! ISTQB Foundation Level and ISTQB Agile testing certifications from ASTQB (ISTQB in the U.S.) can be as valuable as experience.
The examination fee for the ISTQB Foundation Level Exam is $229..
This FAQ should answer most of your questions. But, if you still have more questions or want to sign up, please contact your salesperson who sent you this FAQ or call the main number 510-779-9040. You can also email info@syncitlearning.com
Additionally, we encourage you to join Sync IT Learning’s orientation every Wednesday, at 5:00 pm Pacific Time. A link will be sent to you 15 minutes prior to the start of the orientation. Please do let us know via email or WhatsApp, your salesperson if you will be attending the orientation.
