Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: SQL Basics|
SQL Setup Basics(Important)
Fetch data from the table, with conditions, Sorting etc
SQL- Select with Where clause
SQL - Select data (In & Between)Preview
SQL - Select data(With Sorting)
SQL - Select data( Patten matching - Like)
SQL - Select Unique data(Distinct)Preview
SQL - Subquery
|Section 2: Delete Data|
SQL - Delete data from tables( Delete | Drop | Truncate)
|Section 3: Grouping|
SQL - Group By & Having
|Section 4: Joins|
Cross or Cartesian Join
Inner Join | Equi Join | Simple Join
Outer Join( Left and Right outer)
|Section 5: Working with Tables|
Insert data into Tables
Update data in Tables
|Section 6: Advance SQL|
SQL - Views
SQL - Indexes
|Section 7: Constraint|
SQL - Not Null constraint
SQL - Unique Key constraint
SQL - Primary key constraint
SQL - Difference between Unique and Primary key
|Section 8: Unix for Testers|
Unix Basic Setup(Important)
Why we need to learn Unix ?
Unix Basic CommandsPreview
Working with Log filesPreview
Working with Memory
Advance Process work
|Section 9: Shell Scripting|
First Shell ScriptPreview
Variable in Shell Script
User interaction for input
Command line Argument
Condition handling - If else
Condition Handling - Multiple conditions
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.
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