This subject serves as an introduction to the SQL language, focusing on Database Testing, SQL, and MySQL. It covers the basics of setting up databases and tables, database testing to validate schema, altering table schema operations, and executing queries to retrieve data with logical operators.

Knowledge Core Competency:

Upon completing this subject, students are expected to explain how SQL is used for database testing.

Objectives:

1. State the difference between SQL and MySQL.
2. Describe the process of creating tables in a database.
3. Explain how to update rows in a table.
4. Emphasize the importance of Group By in SQL.
5. Highlight the significance of views in databases.

Skill Core Competency:

Upon completing this subject, students are expected to utilize SQL concepts to perform database testing.

Objectives:

1. Create and modify databases effectively.
2. Develop proficiency in writing SQL queries.
3. Validate and test database schemas.
4. Apply an in-depth understanding of advanced SQL concepts for database testing.
5. Effectively use JDBC ODBC Java programming knowledge to handle databases.

This module provides a comprehensive understanding of SQL for effective database testing, equipping students with both theoretical knowledge and practical skills.