This course might be useful for Back-end Software Testers, DB Administrators / Developers. Course is available upon request. 

​

1. Tables basic.
 Basic table understanding, Data integrity, constraints, Primary and foreign key constraint.
Basic DDL operations (CREATE TABLE, ALTER TABLE).
2. Basic SELECT queries.
 Basic SQL select queries, using ordering and filtering.
3. Basic DML queries
 SQL queries for Insert, update, delete data.
4. SELECT queries.
 SELECT with join.
5. Understanding Data types.
 Data types and their features. Int, String, Date, time, Floating and fixing point data.
6. Database design.
 Database design, normalization. Best practices.
7. Advanced SELECT queries
 SELECT with subqueries, DISTINCT, AGGREGATION, UNION.
8. SQL Programming
 SQL program constructions functions
9. Advanced SQL Programming
 Procedures, Triggers
10. Database testing.
 Create basic SQL Unit test for testing SQL procedure logic.
11. DB testing frameworks (MsSQL, Oracle.)
 Using Database test Driven framework http://www.dbtestdriven.com/