<<< see all Conflair courses
Training

SQL and Data Quality Testing

General description

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.
The course will focus on two main subjects: explaining the basics of databases and SQL, and then focusing of specific areas of testing where SQL skills are necessary. First we will cover the basics of databases, and SQL statements that are most useful for testing. Then we will proceed to discussing the application of SQL skills in two main areas: SQL Injection testing and Data Quality testing.
Multiple exercises will be provided during the course.

Participants will learn

  • What is the role of databases and what are the main types of databases
  • The main components of relational databases
  • Basic syntax of SQL
  • SQL statements that are most useful for testing
  • What is SQL injection and how to test for it
  • Main principles and techniques of Data Quality Testing
  • Where to look for SQL help

Syllabus

  • Databases - Basics
    • The function of databases
    • Relational vs. non-relational databases
    • Tables, Queries, Stored Procedures, Views, Triggers
  • Common Database Management Systems
    • Access
    • SQL Server
    • MySQL
    • more...
  • SQL
    • SELECT, INSERT, UPDATE, DELETE
    • Advanced queries and sub-queries
    • Wildcards
    • JOINs: Retrieving data from multiple tables
    • Keys: Data constraints
  • Security Testing
    • SQL Injection
    • Testing for injection vulnerabilities
  • Data Quality Testing
    • Data Quality issues
    • Generating Test Data
  • Where to look for help?

About us

Conflair's mission is to improve the quality of software. To do that, we break it. In other words, we test software systems in order to discover issues before the user does. We do it in a variety of ways, manually and with the help of special test automation tools; for a variety of platforms, from the good all mainframe to web and mobile devices; locally, globally, and virtually. We go further and help our clients in setting up processes to make sure software quality is built into the development life cycle. Whatever we do, our focus is always on delivering high-quality solutions to our clients.

We are located in Atlanta, GA, USA, and since 2006 we have been helping numerous companies around the world to achieve their goals through software quality. Our team has expertise in a variety of methods and technologies, decades of experience, and we are ready to help.

Want to learn more? Drop us a line to info@conflair.com or contact us at ++1-678-467-1464.

Contact us