© 2019 All Rights Reserved, Learnix Center -

QA Training School in: Vienna, VA; Hallandale Beach, FL

Software Testing Courses, Classes, Training, Bootcamps

  • White Instagram Icon
  • White YouTube Icon
  • White Facebook Icon
  • White LinkedIn Icon

Advanced SQL

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/