DATABASE TESTING + UNIX / LINUX

Database Testing + Unix / Linux

This course covers JMeter tool in detail for Performance and API Testing.

PRICE

INR 10,000 INR 8,000

You can make this payment online after 2 classes.

DURATION:-

20 Hours (10 Classes of 2 Hours Each)

CLASS TIMING:-

  • Weekend (Saturday & Sunday)
  • Weekdays (In Early Morning & Nights)

SYLLABUS

Introduction & Setup

  • MySql Server Installation
  • MySql Client Installation
  • Create Database
  • What is Database Testing?

Basic Query

  • Create Tables
  • Inserting Data into Table
  • Update Data of a Table
  • Update Table Structure

Select Query

  • Fetch Data from Table
  • Fetch Distinct records from Table
  • WHERE Clause
  • Fetch Data from Selected Columns
  • Display Data with Column Alias
  • Display Data in Sorting Order
  • Logical AND & OR
  • Logical Operators ‘In’ & ‘Between’
  • Regular Expressions
  • Wild Cards Usage in Queries
  • Fetch Null Data

Delete Data

  • Delete Data from Tables
  • Drop
  • Truncate

Group By, Aggregate Functions

  • Group By in SQL
  • Aggregate Functions (Count, Sum, Min, Max, Avg)
  • Having Keyword

Joining

  • What is Join
  • Cross or Cartesian Join
  • Inner Join | Equi Join | Simple Join
  • Left Join | Left Outer Join
  • Right Join | Right Outer Join
  • Full Join | Full Outer Join
  • Self Join

View, Indexes, Union & Union All

  • Views
  • Indexes
  • Union
  • Unior All

Constraint

  • Not Null Constraint
  • Check Constraint
  • Default Constraint
  • Unique Key Constraint
  • Primary Key
  • Foreign Key
  • Unique Key

Other Important Queries

  • Copy a Table Without Structure
  • Find Highest, 2nd Highest Salary
  • Find Lowest Salary
  • Find Duplicate Records
  • String Functions
  • Exists Keyword
  • CASE Statement in SQL

Unix / Linux for Tester

  • Why Unix / Linux?
  • Setup Environment for Unix / Linux on Windows
  • Basic Unix Commands
  • Check content of File
  • Search Data in a File
  • Copy & Paste Commands
  • Shell Scripting Basics

If you are interested or have any query, please text or WhatsApp at +91-9910-399-344 or email me at deepakraja@devtestops.in

WhatsApp Me