4: Tools of the Trade - Linux and SQL
- Description
- Curriculum
- Reviews
- Grade
Tools of the Trade: Linux and SQL
In this course, you will gain foundational skills in Linux and SQL, two essential tools for cybersecurity and IT professionals. You’ll explore how operating systems, applications, and hardware interact, learn to navigate and manage systems using the command line, and discover how to retrieve and manipulate data from databases using SQL.
Throughout this course, you will:
-
Explain the relationship between operating systems, applications, and hardware
-
Compare a graphical user interface (GUI) to a command line interface (CLI)
-
Navigate and manage files and directories using Linux commands via the Bash shell
-
Use SQL to query databases and retrieve critical information
-
Complete over 20 hands-on labs to practice real-world Linux and SQL tasks
By the end of this course, you’ll have practical experience using Linux and SQL to manage systems and access data, preparing you for real-world cybersecurity tasks.
-
1
Introduction to the Course -
2
Course Overview -
3
Helpful Resources and Tips
-
4
Welcome to Module 1
-
5
Laura - My Journey into Computing
-
6
Introduction to Operating Systems
-
7
Compare Operating Systems
-
8
Quiz - The Wonderful World of Operating SystemsQuiz - The Wonderful World of Operating Systems -
9
Inside the Operating System
-
10
Requests to the Operating System
-
11
Quiz - Matching - Order of Operations in the OSQuiz - Matching - Order of Operations in the OS
-
12
Resource Allocation via the OS
-
13
Virtualization Technology
-
14
Quiz - The Operating System at WorkQuiz - The Operating System at Work
-
15
GUI versus CLI
-
16
The Command Line in Use
-
17
Assignment - Select the User Interface -
18
Maya - My Path into Cybersecurity
-
19
Quiz - The User InterfaceQuiz - The User Interface
-
20
Module 1 Wrap-UP
-
21
Module 1 Glossary Terms
-
22
Module 1 Final QuizQuiz - Module 1 Final Quiz Description: This quiz assesses your understanding of operating systems, user interfaces, and their role in computer security. You will answer multiple-choice and select-all-that-apply questions that cover topics such as how operating systems manage hardware and resources, the differences between graphical user interfaces (GUIs) and command-line interfaces (CLIs), the purpose of BIOS and bootloaders, and the use of history files in cybersecurity tasks. Each question tests both your knowledge of core concepts and your ability to apply them to real-world scenarios, helping reinforce key principles of computer operation and security management.
-
23
Welcome to Module 2
-
24
Introduction to Linux
-
25
Ethan - Learn and Grow in the Cybersecurity Field
-
26
Linux Architecture
-
27
Linux Architecture Explained
-
28
LAB - Linux Core Concepts 1 - KodeKloud Studio
-
29
Quiz - Matching - Components of LinuxQuiz - Matching - Components of Linux
-
30
Quiz - All About LinuxQuiz - All About Linux
-
31
LAB - Linux Core Concepts 2
-
32
Linux Distributions
-
33
KALI Linux
-
34
More Linux Distributions
-
35
Package Managers for Installing Applications
-
36
LAB - Installing Oracle Virtual Box and Kali Linux
-
37
LAB - Install Software in a Linux Distribution
-
38
Quiz - Linux DistributionsQuiz - Linux Distributions
-
39
Introduction to the Shell
-
40
Different Types of Shells
-
41
Input and Output in the Shell
-
42
LAB - Exploring Input and Output in the Kali Linux Terminal
-
43
LAB - Linux Bash Prompt
-
44
Quiz - The ShellQuiz - The Shell
-
45
Module 2 - Wrap-Up
-
46
Module 2 Glossary Terms
-
47
Module 2 Final QuizModule 2 Final Quiz Description: This quiz is designed to test your understanding of Linux fundamentals, including the architecture, shells, distributions, and basic input/output concepts. You will answer multiple-choice and multiple-selection questions that assess your knowledge of key components such as the kernel, shell, and Filesystem Hierarchy Standard (FHS), as well as your understanding of open-source principles, common Linux distributions, and how commands interact with the operating system. By completing this quiz, you will demonstrate your ability to identify Linux components, understand their functions, and apply foundational concepts relevant to cybersecurity and system administration.
-
48
Welcome to Module 3
-
49
Linux Commands via the Bash Shell
-
50
Core Commands for navigating and Reading Files
-
51
Navigate Linux and Read File Content
-
52
LAB - Find Files with Linux Commands, Linux Basic Commands 1
-
53
Quiz - Navigate the Linux File System in BashQuiz - Navigate the Linux File System in Bash
-
54
Find What you Need with Linux
-
55
Filter Content in Linux
-
56
LAB - Filter with Grep, Linux Basic Commands 2
-
57
Create Modify Directories and Files
-
58
Manage Directories and Files
-
59
Quiz - Matching - Key Linux CommandsQuiz - Matching - Key Linux Commands
-
60
LAB - Managing Directories and Files in Kali Linux
-
61
Quiz - Manage File Content in BashQuiz - Manage File Content in Bash
-
62
File Permission and Ownership
-
63
Change Permissions
-
64
Permission Commands
-
65
LAB - Manage Authorization, Linux Permissions & Ownership
-
66
Add and Delete Users
-
67
Responsible Use of Sudo
-
68
LAB - Linux Account Management
-
69
Quiz - Authenticate and Authorize UsersQuiz - Authenticate and Authorize Users
-
70
Alex - My Journey into Linux Commands
-
71
LAB - Linux Account Management in Kali Linux
-
72
The Linux Community
-
73
LAB - Using Linux Help Commands in Kali Linux
-
74
Man Pages Within the Shell
-
75
Linux Resources
-
76
LAB - Network Treasure Hunt in Kali Linux
-
77
Kali Linux Treasure Hunt Cheat-Sheet
-
78
Quiz - Get Help in LinuxQuiz - Get Help in Linux
-
79
Module 3 Wrap-Up
-
80
Reference Guide - Linux
-
81
Module 3 Glossary Terms
-
82
Module 3 Final QuizModule 3 Final Quiz Description: This quiz assesses your understanding of key Linux commands and concepts that security professionals use to navigate the file system, manage files and directories, and control user permissions. You will apply knowledge of commands such as cp, cd, chmod, grep, touch, and sudo to identify their functions, arguments, and proper usage. The quiz also evaluates your understanding of file permissions, directory hierarchy, and Linux support tools, ensuring you can perform fundamental tasks while maintaining system security and proper authorization.
-
83
Welcome to Module 4
-
84
Introduction to Databases
-
85
Query Databases with SQL
-
86
SQL Filtering versus Linux Filtering
-
87
Abe - SQL in Cybersecurity
-
88
Quiz - SQL and DatabasesQuiz - SQL and Databases
-
89
Basic Queries
-
90
8 - Query a Database
-
91
LAB - Perform a SQL Query
-
92
Basic Filters on SQL Queries
-
93
LAB - SELECT from Nobel Tutorial
-
94
Quiz - SQL Queries does this make senseQuiz - SQL Queries
-
95
Filter Dates and Numbers
-
96
Operators for Filtering Dates and Numbers
-
97
LAB- Using Subqueries in SQL
-
98
Filters with AND,OR,NOT
-
99
More on Filters with AND, OR, and NOT
-
100
LAB - Aggregate Functions, SUM and COUNT
-
101
LAB - Using NULL in SQL
-
102
Apply filters to SQL queries
-
103
Quiz - More SQL FiltersQuiz - More SQL Filters
-
104
Join Tables in SQL
-
105
LAB - This Tutorial Introduces the Notion of a Join
-
106
Types of Joins
-
107
LAB - More JOIN Operations in SQL
-
108
Compare Type of Join
-
109
LAB - Self Join in SQL
-
110
Quiz - Choose the Appropriate Type of JoinQuiz - Choose the Appropriate Type of Join
-
111
Quiz - SQL JoinsQuiz - SQL Joins
-
112
Continuous Learning in SQL
-
113
Dialogue - Explore SQL Applications in Security
-
114
Module 4 - Wrap-Up
-
115
SQL Reference Guide
-
116
Module 4 Glossary Terms
-
117
Quiz - Module 4 Final QuizModule 4 Final Quiz Description: This quiz is designed to test your understanding of SQL concepts, database querying, and data analysis as applied in security contexts. You will answer questions on topics such as querying tables, applying filters, joining tables, using aggregate functions, and interpreting query results. The questions include both conceptual and practical scenarios, giving you an opportunity to demonstrate your ability to write, read, and analyze SQL queries while applying your knowledge to real-world examples. Correct and incorrect answer explanations are provided to help reinforce your learning and ensure you understand not only the answers but the reasoning behind them.
-
118
Reflect and Connect with Peers
-
119
Course Wrap-Up
-
120
Course Glossary
-
121
Get Started on the Next Course
-
Course Title: Tools of the Trade: Linux and SQL
-
Course Level: Beginner / Intermediate
-
Duration: 25-30 hours
-
Delivery Format: Online
-
Prerequisites: Foundations of Cybersecurity recommended
-
Estimated Time Commitment: 5–6 hours per week
-
Course Type: Video Lessons
-
Hands-On Labs: Over 20 practical labs covering Linux commands, Bash shell, and SQL queries
-
Focus: Operating systems, command-line navigation, and database querying
Technical Requirements:
-
A computer (Windows, macOS, or Linux) with reliable internet access
-
At least 8 GB of RAM and 30 GB of free storage space
-
Ability to install and run virtual machines (e.g., VirtualBox)
-
Basic web browser and text editor (e.g., Chrome, Firefox, VS Code)
Software Requirements:
-
Kali Linux Virtual Machine (provided in course instructions)
-
Python (latest version)
-
OpenSSL
-
Access to cybersecurity tools introduced in labs (free and open-source)
Academic Requirements:
-
Completion of all assigned readings and video lessons
-
Participation in hands-on labs and exercises
-
Submission of lab reports or reflections (as assigned)
-
Passing scores on quizzes and final assessment
Recommended Skills (not required):
-
Basic computer navigation (file management, installing software)
-
Interest in technology, problem-solving, and digital safety
This course is designed for beginners who are interested in learning the fundamentals of cybersecurity. It is ideal for:
-
Students exploring a career in cybersecurity or IT
-
Professionals looking to strengthen their digital security knowledge
-
Individuals interested in understanding how networks, systems, and data are protected
-
Anyone with curiosity about online threats, hacking, and cyber defense
No prior technical experience or programming knowledge is required—just a willingness to learn and explore the world of cybersecurity.
