SQL(Database Testing) & Unix(with Shell script) for Tester
4.3 (100 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,460 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL(Database Testing) & Unix(with Shell script) for Tester to your Wishlist.

Add to Wishlist

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

Specially designed course for software testers
4.3 (100 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,460 students enrolled
Last updated 1/2016
English
Current price: $10 Original price: $40 Discount: 75% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Student will be ready to face database testing challenges
  • Students will be ready for work on Unix and Linux machines
View Curriculum
Requirements
  • Must have access to Unix and Any database machine, you can also access free online Unix and SQL environment for practice
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.


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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
43 Lectures
03:00:26
+
SQL Basics
9 Lectures 27:07

SQL Setup Basics(Important)
1 page

Fetch data from the table, with conditions, Sorting etc

SQL - Select Query Basics
02:53

SQL- Select with Where clause
05:04


SQL - Select data(With Sorting)
03:55

SQL - Select data( Patten matching - Like)
04:39


SQL - Subquery
02:23
+
Delete Data
1 Lecture 05:55
SQL - Delete data from tables( Delete | Drop | Truncate)
05:55
+
Grouping
2 Lectures 09:01
Group Functions
03:19

SQL - Group By & Having
05:42
+
Joins
4 Lectures 21:47
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
+
Working with Tables
3 Lectures 10:20

Insert data into Tables
02:09

Update data in Tables
02:35
+
Advance SQL
2 Lectures 07:02
SQL - Views
03:11

SQL - Indexes
03:51
+
Constraint
4 Lectures 14:34
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
+
Unix for Testers
11 Lectures 39:19
Unix Basic Setup(Important)
1 page

Why we need to learn Unix ?
04:08



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
+
Shell Scripting
7 Lectures 43:21
Shell Basics
04:18


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
About the Instructor
T World
4.3 Average rating
826 Reviews
6,715 Students
10 Courses
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.




Testing World
4.1 Average rating
1,610 Reviews
14,192 Students
48 Courses
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