Must Learn Skills for Testers[SQL+Unix+ShellScript+Jira+ALM]

Learn basic commands to list and manage files, including revealing hidden items and handling file visibility, with practical steps for navigating and modifying directories.

Learn to inspect log files with core Unix commands such as head, tail, more, and less to view top or bottom lines and navigate pages.

Learn to view all system processes and monitor CPU and memory usage, including paging, to understand how processes affect overall system performance.

Learn essential Unix file operations for backing up and managing data, including creating folders, navigating with cd, viewing with cat, copying with cp, and merging, moving, and removing files.

Explore essential Unix memory and disk usage commands, including df -h, du -h, and free, to assess total, used, and free memory and file sizes in human-readable formats.

Explore unix commands to compare two or more files, identify common content with comm, reveal differences with diff, and count lines and words with wc, then sort results.

Learn how to locate running processes on a Unix system, kill them by process id with kill -9, and use grep to verify a specific process like Java.

Learn essential Unix search commands to locate content and files efficiently. Use grep to search inside files for errors, use find to verify current files, and locate for system-wide results.

Explore essential Unix commands for testers, including who, whoami, finger, ls, chmod, and export, to inspect users, file permissions, and environment variables.

Learn to locate applications with whereis and which, then use ping, whois, dig, and wget to test connectivity, inspect domain info, DNS records, and resume downloads.

Create groups and users in Unix, assign users to groups, and manage permissions; add a new user with sudo, view details with finger, and switch to the new account.

Explore how to view all environment variables on a Unix/Linux machine, print a specific variable like home, and set and verify an environment variable's value.

Understand the sudo command and sudoers file, how they grant selected users permission to run commands as root and log all commands for auditing.

Learn how the kernel serves as the interface between user commands and hardware. Explore how shell scripting writes and executes groups of shell commands as scripts.

Learn to create your first shell script, writing it in a text editor and saving as first.sh. Set execute permissions with chmod and run it using ./first.sh or sh first.sh.

Learn shell scripting basics by creating a script, adding comments, using echo to display output, and manage system defined and user defined variables, including single versus double quotes.

Capture user input in a shell script with read, prompt for a name, and display the entered value stored in a variable, while setting permissions and running the script.

Learn to pass and handle command line arguments in shell scripts using positional parameters ($1, $2, $3) and the count ($#), with examples of echoing and iterating all inputs.

Master condition handling in shell scripting with if and else, learn string and numeric comparisons, read user input, and validate values through practical examples.

Learn to handle multiple conditions with if, else if, and else in a Unix environment by processing user input and comparing it to designations such as manager, lead, or director.

Master shell script conditional logic using or and and operators to evaluate designation and salary, producing grades such as A, B, or C for employees.

Explore how the shell for loop iterates over a list or sequence and prints each value, highlighting its similarity to a for each loop.

Explore shell scripting functions, including definitions, arguments, and calling conventions. Learn to create functions with and without arguments and to return values using the return keyword in shell scripts.

Learn how to write select queries to fetch all data from a table using the star and to fetch specific columns, comparing all columns to selected columns.

Explore how to use the select with where clause to filter data. Apply comparison operators and logical conditions (and, or) across one or more columns.

Learn how to select data using in and between conditions to filter records from a dataset by matching against a list or range.

Sort data by department number in ascending or descending order to display records clearly and understand the effect of sorting on result presentation.

Learn to select data using pattern matching with the like operator and wildcards to filter records by name patterns and other fields.

Learn to fetch unique values from a table and display only distinct job names, ensuring that only unique records are retrieved without duplicates.

Learn how to use subqueries to select records from a table, compute an average salary, and identify reports where Sylvie is better than the rest.

Learn how delete, drop, and truncate remove data and the table structure, and how rollback can restore data after deletion.

Explore group functions in SQL to summarize data across a table, using sum, average, min, max, and count to compute row-based aggregates and insights.

Learn to use group by and having to summarize data by department and display only groups meeting an aggregate condition, such as more than a certain number of employees.

Explore the cross join, or cartesian join, by pairing every row from one table with every row from another to illustrate why two 5-row tables yield 25 results.

Master equi, simple, and inner joins to link department and employee data by location, revealing how joins enhance test data and reporting in SQL.

Explore outer joins, including left and right joins, and contrast them with inner joins. See how matching and nonmatching records across two tables yield comprehensive result sets.

Learn how to perform a self join on a single table to map employees to their managers, retrieving manager names and related details through internal table relationships.

Learn how to create a table in a database, define columns including an ID column, and insert numbers while considering how changing table structure affects the data.

Learn how to insert data into a database table, identify each column's role and data type, and query the table to retrieve all records while applying table rules.

Update data in a table using conditional logic across multiple records, aligning data changes with code, and handling day-to-day updates and multiple missions.