SQL(Database Testing) & Unix(with Shell script) for Tester

Specially designed course for software testers
4.0 (74 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,362 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 43
  • Length 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

SQL & Unix for Software Testers

This course is specially designed for Software Testing professionals, This will take students from basic level to advance in 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.


What are the requirements?

  • Must have access to Unix and Any database machine, you can also access free online Unix and SQL environment for practice

What am I going to get from this course?

  • Student will be ready to face database testing challenges
  • Students will be ready for work on Unix and Linux machines

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: SQL Basics
Course Introduction
Preview
01:01
SQL Setup Basics(Important)
1 page
02:53

Fetch data from the table, with conditions, Sorting etc

SQL- Select with Where clause
05:04
SQL - Select data (In & Between)
Preview
05:12
SQL - Select data(With Sorting)
03:55
SQL - Select data( Patten matching - Like)
04:39
SQL - Select Unique data(Distinct)
Preview
02:00
SQL - Subquery
02:23
Section 2: Delete Data
SQL - Delete data from tables( Delete | Drop | Truncate)
05:55
Section 3: Grouping
Group Functions
03:19
SQL - Group By & Having
05:42
Section 4: Joins
Cross or Cartesian Join
03:54
Inner Join | Equi Join | Simple Join
06:44
Outer Join( Left and Right outer)
05:36
Self Join
05:33
Section 5: Working with Tables
Create Tables
Preview
05:36
Insert data into Tables
02:09
Update data in Tables
02:35
Section 6: Advance SQL
SQL - Views
03:11
SQL - Indexes
03:51
Section 7: Constraint
SQL - Not Null constraint
04:22
SQL - Unique Key constraint
03:57
SQL - Primary key constraint
03:12
SQL - Difference between Unique and Primary key
03:03
Section 8: Unix for Testers
Unix Basic Setup(Important)
1 page
Why we need to learn Unix ?
04:08
Unix Basic Commands
Preview
04:07
Working with Log files
Preview
04:32
Processes
01:41
Working with Memory
02:48
Advance Process work
02:27
File Comparison
03:36
Search content
02:50
Backup commands
09:55
Miscellaneous commands
03:15
Section 9: Shell Scripting
Shell Basics
04:18
First Shell Script
Preview
04:47
Variable in Shell Script
08:12
User interaction for input
03:18
Command line Argument
06:34
Condition handling - If else
08:58
Condition Handling - Multiple conditions
07:14

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

T World, Automation expert at theTestingWorld

Having more than 8 yrs industry experience.

Worked on different tools like Selenium, QTP, LoadRunner, Jmeter, Mobile Automation, SoapUI

ISTQB Certified, QTP Certified, QC Certified, LoadRunner Certified, CMAT Certified, SoapUI Certified

Trained more than 800 professionals in classroom training and more than 100 professionals online

Running CMS thetestingworld also contributing many online running blogs.




Instructor Biography

Testing World, Director of Testing World

Handling Testing World Operations

Involve in Testing Course Video update and management

Handling online and Face to face classes of Testing World

Masters In Computer Science

Expertise in manual testing & Automation testing using Selenium, QTP, LoadRunner, Jmeter and Mobile Automation

Found of Testing World

Trained more than 4000 students online 

Actively involved in corporate training

Ready to start learning?
Take This Course