SQL For Testers – Part 2

Why database testing is necessary?

• Differences between backend testing and front end testing
• Backend testing phases / Database Testing Phases
• Backend test methodology / Database Testing methodology
• Basics of SQL

Now lets put more focus on SQL Statements -
Section 1
1.1 Basics of the SELECT Statement
1.2 Conditional Selection
1.3 Relational Operators
1.4 Compound Conditions
1.5 IN & BETWEEN
1.6 Using LIKE
Section 2
2.1 Joins
2.2 Keys
2.3 Performing a Join
2.4 Eliminating Duplicates
2.5 Aliases & In/Sub-queries
Section 3
3.1 Aggregate Functions
3.2 Views
3.3 Creating New Tables
3.4 Altering Tables
3.5 Adding Data
3.6 Deleting Data
3.7 Updating Data
Section 4
4.1 Indexes
4.2 GROUP BY & HAVING
4.3 More Sub-queries
4.4 EXISTS & ALL
4.5 UNION & Outer Joins
4.6 Embedded SQL
4.7 Common SQL Questions
4.8 Nonstandard SQL
4.9 Syntax Summary
Download from here – SQL For Testers – Part 2