Tools of the Trade: Linux and SQL Flashcards
(155 cards)
1
Q
Application
A
A program that performs a specific task.
2
Q
Basic Input/Output System (BIOS)
A
A microchip that contains loading instructions for the computer and is prevalent in older systems.
3
Q
Bootloader
A
A software program that boots the operating system.
4
Q
Graphical user interface (GUI)
A
A user interface that uses icons on the screen to manage different tasks on the computer.
5
Q
Hardware
A
The physical components of a computer.
6
Q
Legacy operating system
A
An operating system that is outdated but still being used.
7
Q
Operating system (OS)
A
The interface between computer hardware and the user.
8
Q
Random Access Memory (RAM)
A
A hardware component used for short-term memory.
9
Q
Unified Extensible Firmware Interface (UEFI)
A
A microchip that contains loading instructions for the computer and replaces BIOS on more modern systems.
10
Q
User interface
A
A program that allows the user to control the functions of the operating system.
11
Q
Virtual machine (VM)
A
A virtual version of a physical computer.
12
Q
What does BIOS stand for?
A
Basic Input/Output System
13
Q
What does CLI stand for?
A
Command-line interface
14
Q
What does GUI stand for?
A
Graphical user interface
15
Q
Operating system
A
What does OS stand for?
16
Q
Random Access Memory
A
What does RAM stand for?
17
Q
What does UEFI stand for?
A
Unified Extensible Firmware Interface
18
Q
What does VM stand for?
A
Virtual Machine
19
Q
Bash
A
The default shell in most Linux distributions.
20
Q
CentOS
A
An open-source distribution that is closely related to Red Hat.
21
Q
Central Processing Unit (CPU)
A
A computer’s main processor, which is used to perform general computing tasks on a computer.
22
Q
Command
A
An instruction telling the computer to do something.
23
Q
Digital forensics
A
The practice of collecting and analyzing data to determine what has happened after an attack.
24
Q
Directory
A
A file that organizes where other files are stored.
25
Distributions
The different versions of Linux.
26
File path
The location of a file or directory.
27
Filesystem Hierarchy Standard (FHS)
The component of the Linux OS that organizes data.
28
Hard drive
A hardware component used for long-term memory.
29
Hardware
The physical components of a computer.
30
Internal hardware
The components required to run the computer.
31
Kernel
The component of the Linux OS that manages processes and memory.
32
Kali Linux ™
An open-source distribution of Linux that is widely used in the security industry.
33
Linux
An open source operating system.
34
Package
A piece of software that can be combined with other packages to form an application.
35
Package manager
A tool that helps users install, manage, and remove packages or applications.
36
Parrot
An open-source distribution that is commonly used for security.
37
Penetration test (pen test)
A simulated attack that helps identify vulnerabilities in systems, networks, websites, applications, and processes.
38
Peripheral devices
Hardware components that are attached and controlled by the computer system.
39
Red Hat® Enterprise Linux®
A subscription-based distribution of Linux built for enterprise use.
40
Standard error
An error message returned by the OS through the shell.
41
Shell
The command-line interpreter
42
Standard input
Information received by the OS via the command line.
43
Standard output
Information returned by the OS through the shell.
44
String data
Data consisting of an ordered sequence of characters.
45
Ubuntu
An open-source, user-friendly distribution that is widely used in security and other industries.
46
User
The person interacting with a computer.
47
AlmaLinux
A community-driven Linux distribution that was created as a stable replacement for CentOS.
48
What does FHS stand for?
Filesystem Hierarchy Standard
49
What does CPU stand for?
Central Processing Unit
50
Absolute file path
The full file path, which starts from the root.
51
Argument (Linux)
Specific information needed by a command.
52
Authentication
The process of verifying who someone is.
53
Authorization
The concept of granting access to specific resources in a system.
54
Command
The default shell in most Linux distributions.
55
nano
A command-line file editor that is available by default in many Linux distributions.
56
Options
Input that modifies the behavior of a command.
57
Permissions
The type of access granted for a file or directory.
58
Principle of least privilege
The concept of granting only the minimal access and authorization required to complete a task or function.
59
Relative file path
A file path that starts from the user's current directory.
60
Root directory
The highest-level directory in Linux.
61
Root user (or superuser)
A user with elevated privileges to modify the system.
62
File path
The location of a file or directory.
63
/bin
This directory stands for “binary” and contains binary files and other executables. Executables are files that contain a series of commands a computer needs to follow to run programs and perform other functions.
64
/home
Each user in the system gets their own home directory.
65
/etc
This directory stores the system’s configuration files.
66
/tmp
This directory stores many temporary files. The /tmp directory is commonly used by attackers because anyone in the system can modify data in these files.
67
/mnt
This directory stands for “mount” and stores media, such as USB drives and hard drives.
68
Filtering
Selecting data that match a certain condition.
69
grep
This command searches a specified file and returns all lines in the file containing a specified string or text.
70
Piping
This sends the standard output of one command as standard input to another command for further processing.
71
find
This command searches for directories and files that meet specified criteria.
72
pwd
This command prints the working directory to the screen.
73
ls
This command displays the names of the files and directories in the current working directory.
74
cd
This command navigates between directories.
75
cat
This command displays the content of a file.
76
head
This command displays just the beginning of a file, by default 10 lines.
77
tail
This command can be used to display just the end of a file, by default 10 lines.
78
less
This command returns the content of a file one page at a time.
79
mkdir
This command creates a new directory.
80
rmdir
This command removes, or deletes, a directory.
81
touch
This command creates a new file.
82
rm
This command removes, or deletes, a file.
83
mv
This command moves a file or directory to a new location.
84
cp
This command copies a file or directory into a new location.
85
>
This operator sends output of echo to an existing file by overwriting it.
86
>>
This operator sends output of echo to an existing file by adding your content to the end of this file instead of overwriting it.
87
read permissions
For files, this is the ability to read the file contents; for directories, this is the ability to read all contents in the directory including both files and subdirectories.
88
write permissions
For files, this is the ability to make modifications on the file contents; for directories, this is the ability to create new files in the directory.
89
execute permissions
For files, this is the ability to execute the file if it’s a program; for directories, this is the ability to enter the directory and access its files.
90
user
The owner of the file.
91
group
A larger group that the owner is a part of.
92
other
All other users on the system.
93
ls -a
Displays hidden files. Hidden files start with a period (.) at the beginning.
94
ls -l
Displays permissions to files and directories. Also displays other additional information, including owner name, group, file size, and the time of last modification.
95
ls -la
Displays permissions to files and directories, including hidden files. This is a combination of the other two options.
96
chmod
This command can help you manage this authorization by changing permissions on files and directories.
97
sudo
This command is important for security analysts because it allows users to have elevated permissions without risking the system by running commands as the root user. It is a command that temporarily grants elevated permissions to specific users.
98
root user
A user with elevated privileges to modify the system.
98
useradd
This command adds a user to the system.
99
useradd -g
This command sets the user’s default group, also called their primary group,
100
useradd -G
This command adds the user to additional groups, also called supplemental or secondary groups.
101
usermod
This command modifies existing user accounts.
102
useradd -g
This command changes the primary group of an existing user.
103
useradd -a -G
This command appends a supplemental group for an existing user.
104
useradd -d
This command changes the user’s home directory.
105
useradd -l
This command changes the user’s login name.
106
useradd -L
This command locks the account so the user can’t log in.
107
userdel
This command deletes a user from the system, but doesn’t delete the files in the user’s home directory.
108
userdel -r
This command deletes a user from the system and deletes the files in the user’s home directory.
109
chown
This command changes ownership of a file or directory.
109
usermod -L
This command deactivates the user account.
110
chown :
This command designates a group name, or changes group ownership, to a specific file.
111
man
This command displays information on other commands and how they work.
112
apropos
This command searches the man page descriptions for a specified string.
113
apropos -a
This command searches the man page descriptions for a specified string using multiple words.
114
whatis
This command displays a description of a command on a single line.
115
Database
An organized collection of information or data.
116
Date and time data
Data representing a date and/or time.
117
Exclusive operator
An operator that does not include the value of comparison (e.g. <= and >=).
118
Filtering
Selecting data that match a certain condition.
119
Foreign key
A column in a table that is a primary key in another table.
120
Inclusive operator
An operator that includes the value of comparison (e.g. < and >).
121
Numeric data
Data consisting of numbers.
122
Operator
A symbol or keyword that represents an operation.
123
Primary key
A column where every row has a unique entry with no NULL values.
124
Query
A request for data from a database table or a combination of tables.
125
Relational database
A structured database containing tables that are related to each other.
126
SQL (Structured Query Language)
A programming language used to create, interact with, and request information from a database.
127
Syntax
The rules that determine what is correctly structured in a computing language.
128
Wildcard
A special character that can be substituted with any other character.
129
sqlite3
After this command, any commands typed in the command line will be directed to SQL instead of Linux commands.
130
SELECT
This keyword indicates which columns to return.
131
SELECT *
This statement will return all columns in a table.
132
FROM
This keyword indicates which table to query.
133
DESC
This keyword is short for "descending" and tells SQL to sort numbers from largest to smallest, or alphabetically from Z to A.
133
ORDER BY
This keyword is used for organizing the data you extract from a table by sequencing the records based on a specified column or columns.
134
WHERE
This clause creates a filter in SQL.
135
wildcard
This is a special character that can be substituted with any other character. Two of the most useful wildcards are the percentage sign (%) and the underscore (_)
136
%
The wildcard substitutes for any number of other characters.
137
_
The wildcard only substitutes for one other character.
137
LIKE
This operator applies wildcards to the filter.
138
<> or !=
This comparison operator denotes not equal to.
139
BETWEEN
This operator filters for numbers or dates within a range and is inclusive.
140
AND
This operator specifies that two conditions must be met simultaneously.
141
OR
This operator specifies that either condition or both conditions can be met.
142
NOT
This operator negates a condition.
143
INNER JOIN
This join returns rows matching on a specified column that exists in more than one table
144
LEFT JOIN
This join returns all the records of the first table, but only returns rows of the second table that match on a specified column.
145
RIGHT JOIN
This join returns all of the records of the second table, but only returns rows from the first table that match on a specified column.
146
FULL OUTER JOIN
This join returns all records from both tables.
147
ON
This keyword is used with the = operator to indicate the column you are joining the tables on.
148
Aggregate functions
Functions that perform a calculation over multiple data points and return the result of the calculation.
148
COUNT
This aggregate function returns a single number that represents the number of rows returned from your query.
148
AVG
This aggregate function returns a single number that represents the average of the numerical data in a column.
149
SUM
This aggregate function returns a single number that represents the sum of the numerical data in a column.
