Learn SQL and Database Testing from Scratch (including Unix Material) [Video]
-
Free ChapterIntroduction to SQL and Database Testing
-
Getting Started with Queries to retrieve Data
-
Altering Table Schema operations
-
Getting Started with Queries to retrieve Data
-
Advanced SQL Concepts – 1
-
Advanced SQL Concepts -2
-
Dataconstraints with Database Testing perspective
-
Practise Exercises for Interviews with Solutions
-
JDBC Connectivity for Integration with Selenium (Basic Automation Knowledge req
-
SQL Injection - Database Security Testing
This course covers: Introduction to SQL, MySQL overview, start up commands to setup databases and tables, database testing to validate Schema, altering table schema operations, queries to retrieve data logical operators on queries, wild cards usage in Qqeries, SQL functions with real time scenarios, the importance of group by in SQL, advanced SQL concepts, sub-queries in syntax and usage, SQL joins usage and its advantages, the importance of views in databases, SQL string functions, data constraints with database testing perspective, practice exercises for interviews with solutions, and an SQL glossary on the discussed topics.
Style and Approach
On course completion, you will have Mastered the SQL Language with Database Testing and will be able implement these new skills successfully intoyour workplace.
- Publication date:
- February 2018
- Publisher
- Packt
- Duration
- 6 hours 12 minutes
- ISBN
- 9781789133844