This site uses cookies. By continuing to use it, you agree to data collection.
DATA QA
& Advanced SQL
the world's first data quality assurance course
sign up for the course and get a set of practical skills to work with data in any position: tester / analyst / developer / manager
05.05.2025 – SQL part
10.05.2025 – Data QA part
THE CREATOR OF THE COURSE
In 9 years of working in IT, I have gone from a manual QA internship to automated testing, analytics, development and project and team management, namely to the position of Engineering Manager, Data QA in an American company. For the last 5 years I have been specializing in projects related to data processing, machine learning and analytics.
I have two specialized higher educations: a bachelor's degree in computer science and a master's degree in computer science, artificial intelligence and web technologies, which I received in France.
I have two specialized higher educations: a bachelor's degree in computer science and a master's degree in computer science, artificial intelligence and web technologies, which I received in France.
Speaking at various conferences and teaching more than 150 people, I came to an important conclusion: every QA specialist should have deep technical knowledge.
My main task is to help colleagues from QA and related fields develop their TECHNICAL skills – hard skills – especially in such a promising field as working with data.
My main task is to help colleagues from QA and related fields develop their TECHNICAL skills – hard skills – especially in such a promising field as working with data.
"
"
Natalya
Yakhina
THIS COURSE IS FOR YOU IF YOU:
Software Tester
QA engineer of any level
beginner / experienced
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.
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
1st in the WORLD
Get all the knowledge on Data QA and SQL in 3 months
Get all the knowledge on Data QA and SQL
in 3 months
in 3 months
After completing the course, you will be able to apply for a salary and grade increase
(if you have sufficient experience)
(if you have sufficient experience)
SALARY OF A DATA TESTER
Lead
3000$+
Junior
Middle
Senior
Trainee
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
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
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
+
A ready-made data testing project can be added to a portfolio or used in work on real projects
RESULT
MODULE 0 – PRE-TRAINING
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
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
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
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
+
A ready-made data testing project can be added to a portfolio or used in work on real projects
RESULT
MODULE 0 – PRE-TRAINING
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
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
+ 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: 4 weeks per module
2 lessons per week + practice
2 weeks rest between modules
Natalia's homework check
Lessons are available on the record - watch them at a convenient time
BONUS
Start on May 5
+
TARIFFS
MODULE 1 – SQL
1035GEL (~350€)
/you can purchase each module separately or the entire program at once at a bargain price/
MODULE 2 – Data QA
350€
MODULE 1 + MODULE 2
SQL + Data QA
SQL + Data QA
550€
*price increase from May 1, 2025
BEST PRICE
– 4 weeks of SQL sprint
– checking tasks
– stream chat with Natalia
– live call with Natalia
– bonus master class
"How to study, work and live without burning out"
– module 0 – pre-training
– certificate of completion of the module
– access to materials for 3 months
– checking tasks
– stream chat with Natalia
– live call with Natalia
– bonus master class
"How to study, work and live without burning out"
– module 0 – pre-training
– certificate of completion of the module
– access to materials for 3 months
– 4 weeks of Data QA sprint
– checking tasks
– stream chat with Natalia
– live call with Natalia
– bonus master class
"How to study, work and live without burning out"
– module 0 – pre-training
– certificate of completion of the module
– access to materials for 3 months
– checking tasks
– stream chat with Natalia
– live call with Natalia
– bonus master class
"How to study, work and live without burning out"
– module 0 – pre-training
– certificate of completion of the module
– access to materials for 3 months
– 4 weeks of SQL sprint + 4 weeks of Data QA sprint + 2 weeks of rest between sprints
– 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
– 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
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.
Individual Entrepreneur NATALIA IAKHINA, 322440248
working hours: 10:00 -19:00 on weekdays
yakhina.ni@gmail.com , +995 511 308 272
working hours: 10:00 -19:00 on weekdays
yakhina.ni@gmail.com , +995 511 308 272