Tools of the Trade: Linux and SQL

Overview

This course focuses on foundational computing skills that support the work of a security analyst. It begins with an introduction to computer operating systems, followed by a closer exploration of Linux, an operating system commonly used by security professionals. By the end of this course, learners will be able to use the Linux command line through the Bash shell to navigate and manage the file system and to authenticate and authorize users, and they will also be able to use SQL to communicate with a database. By the end of this course, you will: - Explain the relationship between operating systems, applications, and hardware. - Compare a graphical user interface to a command line interface. - Identify the unique features of common Linux distributions. - Navigate and manage the file system using Linux commands via the Bash shell. - Use Linux commands via the Bash shell to authenticate and authorize users. - Describe how a relational database is organized. - Use SQL to retrieve information from a database. - Apply filters to SQL queries and use joins to combine multiple tables.

Syllabus

Introduction to operating systems

This module provides an overview of operating systems. Learners will explore the relationship between operating systems, hardware, and software, and they will become familiar with the primary functions of an OS. They will be able to recognize some of the most common operating systems in use today and also understand how the GUI and command line both allow users to interact with the operating system.

The Linux operating system

This module introduces learners to Linux, an open-source operating system commonly used in the security profession. Learners will understand the unique features of Linux and how it is used in the security profession. They will also explore the architecture of the Linux operating system as well as common Linux distributions. Additionally, they will understand how the Linux shell provides an interface for users to interact with this operating system.

Linux commands in the Bash shell

This module introduces Linux commands as entered through the Bash shell. Learners will use Bash to navigate the file system, to manage it, and to authorize and authenticate users. They will also discover how they can independently get the support that they need to use additional Linux commands.

Databases and SQL

In this module, learners will learn how to use SQL to communicate with databases. They will learn how to query a database and filter the results. They will also learn how SQL can join multiple tables together in a query.