Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
18 Hour(s) 30 Minute(s)
Language
English
Taught by
Automation World
Rating
2 views
Course Overview
E2E Setup Installation |E2E Database Testing coverage|| Joins | Grouping|DDL|DML|DRL|Unix /Linux commands +Shell Script
Course Updates
Mar 2024 : Added videos related to Shell Scripting.
Apr 2022 : Updated Setup Instructions, Now you can setup MySQL DB + Workbench, Also setup a sample DB for practice
Jul 2021 : Updated Select query videos with better voice quality
Oct 2020 : Added Sample questions for practice
______________________________________________________________________________
SQL & Unix for Software Testers
This course is specially designed for Software Testing professionals(Be it Manual or Automation), 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.
Database Testing Coverage
1. Basic Select Operations
2. Table Operations (DDL)
3. Delete data from table
4. Constraints
5. Interview Questions
6. Detailed DRL queries (Fetch data with different clauses)
7. Data Grouping and Filtration
8. Different Types of Joins(Inner, Outer, Self, Cross)
9. Detailed DML Operations (Update, Delete, Insert)
10. Best Practices for Software Testers
11. Realtime implementation of Concepts.
12. Interview Questions.
13. Practice Exercises with Solutions.
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.
Unix/Linux Coverage
1. Need of Unix in Software Testing
2. Check Logs
3. Perform basic operations by command
4. Interview Questions
5. Shell Scripting
This course if very useful for professional who are looking opportunities in Manual and Automation Testing.
Course Content
- 26 section(s)
- 179 lecture(s)
- Section 1 Course introduction & Setup Instructions
- Section 2 Fetch Data from Table using Basic Select Queries - With Data Filtration
- Section 3 Advance Select Queries : Pattern Matching(Like with Characters) and Sub Queries
- Section 4 Other Common Select Query Operations
- Section 5 Delete Table Structure & Table Data (Delete, Drop, Truncate)
- Section 6 Data Fetch and Display after Grouping (Group By and Having)
- Section 7 Joins : Fetch Data from multiple Tables (Inner, Outer , Simple & Cross Join)
- Section 8 Working with Tables : Create table, Insert, Update and Delete data from table
- Section 9 Advance SQL Queries : Views, Index and Union
- Section 10 Data Constraint : Apply rules to columns for Data insertion and update
- Section 11 Advance Constraints : Must for Realtime DB Testing and Interviews
- Section 12 -------QUIZ for SQL Queries ------- 25 Questions in 25 mins
- Section 13 SQL Interview Questions : Must for all Interview Aspirants
- Section 14 Introduction to Unix (Linux)| Why as Tester we should Learn ? :Environment Setup
- Section 15 Let's Start Practical Session with very basic Unix /Linux Commands
- Section 16 Check content of File(Log Files) : Must Learning Concepts/practical for Tester
- Section 17 Search Data in a File : This Section is also MUST for Realtime Work + Interviews
- Section 18 Cut & Copy Files and Folder |Taking Files and Folders from one location to Other
- Section 19 Command Operators : Passing Date between 2 or more commands or Files
- Section 20 File Comparison : Cmp, Comm and Diff command
- Section 21 Search Files and Folder on current location or complete system
- Section 22 Process File data using CUT Command : Fetch columns from delimiter file
- Section 23 Advance miscellaneous Operations : Most usable unix/linux commands
- Section 24 Introduction to Shell Scripting, Lets start Writing Shell Scripting
- Section 25 Database Testing using JMeter :- Functional and Performance Testing of SQL Query
- Section 26 Database Testing using JMeter :- Execute Query & Validate Result
What You’ll Learn
- Detailed knowledge of Database/SQL queries and its implementation while working as Tester/QA, Will be able to perform Database testing & validate data and other database factors, Will get decent understanding of Unix/Linux and its implementation in testing tasks/activities, Ready to perform complex database operations on realtime application, Ready to Face Database Testing interviews with best practices and Examples, Detailed understanding of advance concepts like Complex Joins, Grouping etc
Skills covered in this course
Reviews
-
JJyothi Shetty
Good explanation of commands with execution.
-
MMohd Kaif
Good / Amazing
-
SSurendra Marrivada
Good
-
MMakani Tirupathiraju
Good for the learners
