Advanced SQL and Data Quality Testing

• How to construct advanced SQL statements
• Where to look for SQL help
• The principles of Data Quality Testing
• How to use Excel to empower Data Quality Testing

Databases are an integral part of most software applications; for many of them, database is the major component. Thus, knowing how to tests database management applications is of utmost importance. SQL, or Simple Query Language, is the tongue almost all modern databases can understand, and therefore real database testing is impossible without the knowledge of SQL.

Many test engineers know the basics of SQL and relational databases and can write simple SELECT queries. However, a lot is to be gained from learning how to construct more advanced SQL statements. Armed with those, Data Quality Testing can be much more effective and efficient.

The course will focus on three main subjects: advanced SQL statements, data quality testing, and utilizing Excel for data quality testing. Multiple exercises will be provided during the course: there will be at least one exercise for every SQL-related topic.