Using subqueries, Using Aggregate Functions with Subqueries, Nested Subqueries, Correlated Subqueries, Using EXISTS, ANY, and ALL.
Multiple Tables in a Single SELECT Statement, Equi-Joins, Non-Equi-Joins, Outer Joins versus Inner Joins, Joining a Table to Itself
Reducing the number of test cases, Prioritization Guidelines, Priority category scheme, Risk Analysis, Probability of occurrence, Risk Matrix.
White Box Testing, Black Box Testing, Equivalence Class Testing, Equivalence partitioning, Boundary Testing, Cause and Effect Graphs, Decision Table Based Testing, Path Testing, Control flow graph (CFG), Flow Graph/ Directed Graph, Derivation of Test Cases, Control Flow Graph, McCabe’s Cyclomatic metric, Graph Matrices, Data Flow-Based Testing, Mutation Testing, Debugging, Brute-force method, Debugging by Induction (specific to general), Backtracking, Program Slicing, Static Test
Definition of Testing, What is Testing, What not is testing, problems in testing, challenges in testing, testing activities, test case information, type of testing, A Software Testing Strategy: Spiral Model, Verification vs. Testing, The objective of testing, Testing Phases, A model of the software testing process.