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.

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 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.

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 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.

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 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 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.

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

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.