Over 10 years in IT, I have progressed from a manual QA intern to roles in test automation, analytics, development, and project and team management, eventually reaching the position of Engineering Manager, Data QA, at a U.S.-based company. For the past five years, I have specialized in projects focused on data processing, machine learning, and analytics. I hold two degrees in Computer Science: a bachelor’s degree and a master’s degree in Computer Science with a focus on Artificial Intelligence and Web Technologies, which I obtained in France.
Through speaking at industry conferences and teaching over 150 professionals, I’ve come to an important conclusion: every QA specialist needs strong technical foundations. My mission is to help QA engineers and professionals in related fields develop their technical (hard) skills especially in the fast-growing and highly promising area of data.
"
"
Natalia
Iakhina
THIS COURSE IS FOR YOU IF YOU:
Software Tester QA engineer of any level beginner / experienced
Analyst / developer / Manager – it is important for you to improve your data skills
/
The course has its main focus on developing the practical skills necessary to work in positions at least Middle. At the same time, all the necessary theory is provided at the academic level and in an easy-to-understand format. The course also provides a complete overview of all modern tools used by market leaders in data analytics.
IT IS AN EXHAUSTIVE GUIDE TO THE WORLD OF WORKING WITH DATA AND ANALYZING ITS QUALITY
There are few specialists with knowledge of SQL and Data QA on the market right now (based on internal job analytics on LinkedIn), so your chances of getting a high-paying job after training will increase significantly.
500-1200€
1000-1800€
1800-3000€
300-600€
WHAT WILL BE ON THE COURSE:
MODULE 1 – SQL
Database theory: fundamentals, normal forms, transactions, concurrency
Architecture: models, data schemas, indexes, storage structures
Entity-relationship (ER) diagrams
SQL Basics: SELECT, JOIN
SQL Basics: Aggregation Functions
SQL basics: subqueries, table expressions
SQL Advanced level: window functions
SQL Advanced level: window function frames
SQL Advanced level: indexes, query optimization
SQL Advanced level: Data marts
SQL Advanced level: working with conditional statements
Data Warehouse
ETL & ELT Systems
→
Database and SQL skills at the Middle+ level for most data-related professions: data analyst, developer, tester, product/project owner
RESULT
MODULE 2 – Data QA
Data quality metrics, Reasons for poor data quality
Purification, Preparation of test data
Data Profiling methods for identifying data problems
Using operations on sets for testing
Validation of schemes and Business rules
Metadata
Using service tables
Checking the correctness of the storage/database architecture
Testing columns containing complex data types (for example, json with a high level of nesting)
The main tools used on Data projects:
Automatically run tests written in SQL and analyze the results
Finding root causes for bugs, or how to perform root-cause analysis in a data project
Correct bug reporting
Typical bugs in the data – checklist
Documentation: test plan for database testing, test strategy for data migration, test coverage – learning to count, metrics and test reports
Typical interview questions about working with and testing data
How to successfully complete an interview
→
A complete set of practical skills to start or continue a career in IT. + A ready-made data testing project can be added to a portfolio or used in work on real projects
The importance of developing hard skills for any profession in IT: from a tester to a manager Who is Data QA, how to become one, and for whom this profession is suitable The difference between Data QA and other roles in data management projects Instructions for completing the course: how to get the most out of learning Kick-off session with Natalia [LIVE] Master class "How to study, work and live without burning out" from an invited expert on neurointegration
WHAT WILL BE ON THE COURSE:
MODULE 1 – SQL
Database theory: fundamentals, normal forms, transactions, concurrency
Architecture: models, data schemas, indexes, storage structures
Entity-relationship (ER) diagrams
SQL Basics: SELECT, JOIN
SQL Basics: Aggregation Functions
SQL basics: subqueries, table expressions
SQL Advanced level: window functions
SQL Advanced level: window function frames
SQL Advanced level: indexes, query optimization
SQL Advanced level: Data marts
SQL Advanced level: working with conditional statements
Data Warehouse
ETL & ELT Systems
→
Database and SQL skills at the Middle+ level for most data-related professions: data analyst, developer, tester, product/project owner
RESULT
MODULE 2 – Data QA
Data quality metrics, Reasons for poor data quality
Purification, Preparation of test data
Data Profiling methods for identifying data problems
Using operations on sets for testing
Validation of schemes and Business rules
Metadata
Using service tables
Checking the correctness of the storage/database architecture
Testing columns containing complex data types (for example, json with a high level of nesting)
The main tools used on Data projects:
Automatically run tests written in SQL and analyze the results
Finding root causes for bugs, or how to perform root-cause analysis in a data project
Correct bug reporting
Typical bugs in the data – checklist
Documentation: test plan for database testing, test strategy for data migration, test coverage – learning to count, metrics and test reports
Typical interview questions about working with and testing data
How to successfully complete an interview
→
A complete set of practical skills to start or continue a career in IT. + A ready-made data testing project can be added to a portfolio or used in work on real projects
The importance of developing hard skills for any profession in IT: from a tester to a manager Who is Data QA, how to become one, and for whom this profession is suitable The difference between Data QA and other roles in data management projects Instructions for completing the course: how to get the most out of learning Kick-off session with Natalia [LIVE] Master class "How to study, work and live without burning out" from an invited expert on neurointegration
YOUR TRAINING:
Live calls with Natalia, where you can ask questions + installation session
Chat with participants and Natalia
Bonus master class "How to study, work and live without burning out" from an expert on neurointegration
Certificate of completion of the course
Sprint training: 5 weeks per module
2 lessons per week + practice
2 weeks rest between modules
Homework feedback from Natalia
Lessons are recorded - watch them at any convenient time
– bonus master class "How to study, work and live without burning out"
– module 0 – pre-training
– access to materials for 3 months
– opening of materials immediately after payment
– 4 weeks of SQL + 4 weeks of Data QA + 2 weeks of rest between modules
– checking tasks
– stream chat with Natalia
– live calls with Natalia
– bonus master class "How to study, work and live without burning out"
– module 0 – pre-training
– certificate of completion of 2 modules
– access to materials for 6.5 months
600€
1100€
FAQ
Yes! The training program includes: general chat + homework check + live calls with Natalia to answer questions and check/discuss assignments
The course has 2 lectures per week + practice = an approximate load of 4 hours per week (this is the minimum required time, it may take more time, since everyone has their own speed of assimilation of the material)
Lectures in your personal account and live calls with Natalia. One module is 4 weeks of training, followed by a 2–week break and a second module.
The course has a schedule, lessons will be opened as you progress through the course.
Yes, the course does not require prior knowledge, all topics will be covered from the beginning
Yes, you can skip the already familiar basic topics, but the course also contains many advanced topics and practical tasks of different levels of complexity that will be interesting and useful to specialists of different levels
Access is granted for 3 months for each module, the total period of access to the entire course is 6 months. The extension of access is paid additionally.