SQL/Data testing training in Toronto, Mississauga, Brampton Data Testing using SQL(Structure Query Language)

  • What is Database?
  • What is RDBMS – Relational Database Management System?
  • What are the RDBMS currently available in the Market?
  • What is SQL?
  • What is Data Definition Language (DDL)
  • What is Data Manipulation Language (DML)
  • What is Data Control Language (DCL)
  • Install and Working with Toad Tool – To execute SQL queries – Toad tool is an interface to connect to Database.
  • Write different types of SQL queries with examples?
  • Home work/ Assignments
  • Role of tester in SQL?
  • Different types of SQL Functions, Arithmetic, logical, etc…
  • Primary Key, Foreign key constraint.
  • What are types of SQL Joins and Execute Joins with examples?
  • How to perform JOIN?
  • Joins, Inner Join, Outer Join, Self Join, Right Join | Right Outer Join, Left Outer Join | Left Join
  • SQL Groupby Statement
  • SQL Having clause