Enter your keyword

Course

SQL (Database Testing) and Unix (Shell Script)

50% New

Course Description

This course is specially designed for Software Testing professionals, This will take students from basic level to advance with decent pace videos.

Here we will cover SQL queries and Unix commands which we can use in daily QA activities and also we have covered many interview question which are asked in interviews.

In today’s competitive environment, companies need software testers who are having database as well as Unix/Linux knowledge, this course going to make you ready to perform basic to advance level backend QA activities.

This course if very useful for professional who are looking opportunities in Manual and Automation Testing.

Who is the target audience?

  • “Unix for Testers” is specially meant for software testers who are not familiar with Unix/ Linux, it will take you to basic to advance level of concepts
  • “SQL for Testers” course is meant for newbies who are not familiar with SQL, it will take you to basic to advance level of concepts

Curriculam

  • Course Introduction
  • SQL Setup Basics (Important)
  • SQL – Select Query Basics
  • SQL- Select with Where Clause
  • SQL – Select Data (In & Between)
  • SQL – Select Data (With Sorting)
  • SQL – Select Data (Patten matching – Like)
  • SQL – Select Unique Data (Distinct)
  • SQL – Subquery
  • SQL – Delete Data from Tables (Delete | Drop | Truncate)
  • Group Functions
  • SQL – Group By & Having
  • Cross or Cartesian Join
  • Inner Join | Equi Join | Simple Join
  • Outer Join (Left and Right outer)
  • Self Join
  • Create Tables
  • Insert data into Tables
  • Update data in Tables
  • SQL – Views
  • SQL – Indexes
  • SQL – Not Null Constraint
  • SQL – Unique Key Constraint
  • SQL – Primary Key Constraint
  • SQL – Difference between Unique and Primary Key
  • Unix Basic Setup (Important)
  • Why we need to learn Unix?
  • Unix Basic Commands
  • Working with Log Files
  • Processes
  • Working with Memory
  • Advance Process Work
  • File Comparison
  • Search Content
  • Backup Commands
  • Miscellaneous Commands
  • Shell Basics
  • First Shell Script
  • Variable in Shell Script
  • User Interaction for Input
  • Command line Argument
  • Condition handling – If else
  • Condition Handling – Multiple Conditions

Reviews Statistic

0
0 out of 0
0 Ratings
5 Start 0
4 Start 0
3 Start 0
2 Start 0
1 Start 0

Reviews

There are no reviews yet.

Be the first to review “SQL (Database Testing) and Unix (Shell Script)”

Duration 3 Hours
Level Beginner
Instution Testing World
Branch Group of Industry Experts
Seat avaiable 47
Price $40.00 $20.00

47 in stock

Location map

Share our course