К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Tools of the Trade: Linux and SQL · LearnSpace
Назад в каталог
courseraПрограммирование

Tools of the Trade: Linux and SQL

Курс от Google
Начальный≈ 23.4 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Operating SystemsLinux CommandsLinuxBash (Scripting Language)SQLFile ManagementFile SystemsDatabasesAuthenticationsQuery LanguagesUser AccountsRelational DatabasesAuthorization (Computing)Linux AdministrationUnix ShellDatabase ManagementCommand-Line Interface

Программа курса

4 модулей · 144 учебных материалов

01Introduction to operating systems22 материалов

Get started with the course

Introduction to Course 4 ВидеоCourse 4 overviewЧтениеHelpful resources and tips Чтение

The wonderful world of operating systems

Welcome to module 1 Видео

Учитесь у экспертов

Google Career Certificates

Преподаватель курса

Tools of the Trade: Linux and SQL
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 23.4 ч

4 модулей

Язык: Английский

Субтитры: Арабский, Французский, Украинский, Бразильский португальский, Вьетнамский, Корейский, Немецкий, Индонезийский, Турецкий, Испанский, Японский

Часть программы вашего университета
Kim: My journey into computingВидео
Introduction to operating systems Видео
Compare operating systems Чтение
Test your knowledge: The wonderful world of operating systemsЗадание

The operating system at work

Inside the operating system ВидеоRequests to the operating systemЧтениеPractice: Order of operations in the OSPLUGINResource allocation via the OS ВидеоVirtualization technology ЧтениеTest your knowledge: The operating system at workЗадание

The user interface

GUI versus CLI ВидеоThe command line in use ЧтениеActivity: Select the user interfaceЗаданиеEllen: My path into cybersecurity ВидеоTest your knowledge: The user interfaceЗадание

Review: Introduction to operating systems

Wrap-up ВидеоGlossary terms from module 1 ЧтениеModule 1 challengeЗадание
02The Linux operating system27 материалов

All about Linux

Welcome to module 2 ВидеоIntroduction to Linux ВидеоPhil: Learn and grow in the cybersecurity fieldВидеоLinux architectureВидеоLinux architecture explainedЧтениеExplore: Components of the Linux OSPLUGINTest your knowledge: All about LinuxЗадание

Linux distributions

Linux distributionsВидеоKALI LINUX ™ВидеоMore Linux distributionsЧтениеPackage managers for installing applicationsЧтениеResources for completing Linux labsЧтениеLab tips and troubleshooting stepsЧтениеActivity: Install software in a Linux distribution

The shell

Introduction to the shell ВидеоDifferent types of shells ЧтениеInput and output in the shell ВидеоActivity: Examine input and output in the shellВнешний инструментOptional Exemplar: Examine input and output in the shellВнешний инструментExemplar: Examine input and output in the shellЧтение

Review: The Linux operating system

Wrap-upВидеоGlossary terms from module 2 ЧтениеModule 2 challengeЗадание
03Linux commands in the Bash shell46 материалов

Navigate the Linux file system

Welcome to module 3 ВидеоLinux commands via the Bash shell ВидеоCore commands for navigation and reading files ВидеоNavigate Linux and read file content ЧтениеActivity: Find files with Linux commandsВнешний инструментOptional Exemplar: Find files with Linux commandsВнешний инструментExemplar: Find files with Linux commandsЧтениеTest your knowledge: Navigate the Linux file system in BashЗадание

Manage file content in Bash

Find what you need with LinuxВидеоFilter content in LinuxЧтениеActivity: Filter with grepВнешний инструментOptional Exemplar: Filter with grepВнешний инструментExemplar: Filter with grepЧтениеCreate and modify directories and files Видео

Authenticate and authorize users

File permissions and ownership ВидеоChange permissions ВидеоPermission commands ЧтениеActivity: Manage authorizationВнешний инструментOptional Exemplar: Manage authorizationВнешний инструментExemplar: Manage authorizationЧтение

Get help in Linux

Damar: My journey into Linux commandsВидеоThe Linux community ВидеоMan pages within the shell ВидеоLinux resources ЧтениеActivity: Get help in the command lineВнешний инструментOptional Exemplar: Get help in the command lineВнешний инструмент

Review: Linux commands in the Bash shell

Wrap-up ВидеоReference guide: Linux ЧтениеGlossary terms from module 3 ЧтениеModule 3 challengeЗадание
04Databases and SQL49 материалов

Introduction to SQL and Databases

Welcome to module 4 ВидеоIntroduction to databases ВидеоQuery databases with SQL ВидеоSQL filtering versus Linux filteringЧтениеAdedayo: SQL in cybersecurityВидеоTest your knowledge: SQL and databases Задание

SQL queries

Basic queries ВидеоQuery a database ЧтениеResources for completing SQL labsЧтениеActivity: Perform a SQL queryВнешний инструментExemplar: Perform an SQL queryЧтениеOptional Exemplar: Perform a SQL queryВнешний инструментBasic filters on SQL queries ВидеоThe WHERE clause and basic operators ЧтениеActivity: Filter a SQL queryВнешний инструментExemplar: Filter a SQL queryЧтениеOptional Exemplar: Filter a SQL queryВнешний инструментTest your knowledge: SQL queries Задание

More SQL filters

Filter dates and numbers ВидеоOperators for filtering dates and numbers ЧтениеActivity: Apply more filters in SQLВнешний инструментOptional Exemplar: Apply more filters in SQLВнешний инструментExemplar: Apply more filters in SQLЧтениеFilters with AND, OR, and NOT Видео

SQL joins

Join tables in SQLВидеоTypes of joins ВидеоCompare types of joins ЧтениеIdentify: Choose the appropriate type of joinPLUGINActivity: Complete a joinВнешний инструментExemplar: Complete a joinЧтениеOptional Exemplar: Complete a join

Review: Databases and SQL

Coach dialogue: Explore SQL applications in securityDIALOGUEWrap-up ВидеоReference guide: SQL ЧтениеGlossary terms from module 4ЧтениеModule 4 challengeЗадание

Congratulations on completing Course 4!

Reflect and connect with peersЧтениеCourse wrap-up ВидеоCourse 4 glossary ЧтениеGet started on the next courseЧтение
Внешний инструмент
Optional Exemplar: Install software in a Linux distributionВнешний инструмент
Exemplar: Install software in a Linux distributionЧтение
Test your knowledge: Linux distributionsЗадание
Test your knowledge: The shell Задание
Manage directories and files Чтение
Identify: Key Linux commandsPLUGIN
Activity: Manage files with Linux commandsВнешний инструмент
Optional Exemplar: Manage files with Linux commandsВнешний инструмент
Exemplar: Manage files with Linux commandsЧтение
Test your knowledge: Manage file content in Bash Задание
Portfolio Activity: Use Linux commands to manage file permissionsЗадание
Portfolio Activity Exemplar: Use Linux commands to manage file permissionsЧтение
Add and delete users Видео
Responsible use of sudo Чтение
Activity: Add and manage users with Linux commandsВнешний инструмент
Optional Exemplar: Add and manage users with Linux commandsВнешний инструмент
Exemplar: Add and manage users with Linux commandsЧтение
Test your knowledge: Authenticate and authorize users Задание
Exemplar: Get help in the command lineЧтение
Test your knowledge: Get help in Linux Задание
More on filters with AND, OR, and NOTЧтение
Activity: Filter with AND, OR, and NOTВнешний инструмент
Optional Exemplar: Filter with AND, OR, and NOTВнешний инструмент
Exemplar: Filter with AND, OR, and NOTЧтение
Portfolio Activity: Apply filters to SQL queriesЗадание
Portfolio Activity Exemplar: Apply filters to SQL queriesЧтение
Test your knowledge: More SQL filtersЗадание
Внешний инструмент
Test your knowledge: SQL joinsЗадание
Continuous learning in SQLЧтение