Tools of the Trade: Linux and SQL

Ends tomorrow! Save 40% on your access to 10,000+ programs and make a real impact in your career. Save now.

Tools of the Trade: Linux and SQL

This course is part of Google Cybersecurity Professional Certificate

Instructor: Google Career Certificates

458,099 already enrolled

Included with Learn more

Ask Coursera

4 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

No prior experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

No prior experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Explain the relationship between operating systems, applications, and hardware
Compare a graphical user interface to a command line interface
Navigate and manage the file system using Linux commands via the Bash shell
Use SQL to retrieve information from a database

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

21 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Computer Security and Networks expertise

This course is part of the Google Cybersecurity Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Google

There are 4 modules in this course

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.

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.

What's included

9 videos7 readings5 assignments1 plugin

9 videosTotal 21 minutes

Introduction to Course 4 2 minutes
Welcome to module 1 1 minute
Kim: My journey into computing2 minutes
Introduction to operating systems 3 minutes
Inside the operating system 3 minutes
Resource allocation via the OS 2 minutes
GUI versus CLI 4 minutes
Ellen: My path into cybersecurity 2 minutes
Wrap-up 1 minute

7 readingsTotal 48 minutes

Course 4 overview10 minutes
Helpful resources and tips 8 minutes
Compare operating systems 8 minutes
Requests to the operating system8 minutes
Virtualization technology 8 minutes
The command line in use 4 minutes
Glossary terms from module 1 2 minutes

5 assignmentsTotal 79 minutes

Module 1 challenge45 minutes
Test your knowledge: The wonderful world of operating systems8 minutes
Test your knowledge: The operating system at work8 minutes
Activity: Select the user interface10 minutes
Test your knowledge: The user interface8 minutes

1 pluginTotal 10 minutes

Practice: Order of operations in the OS10 minutes

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.

What's included

9 videos9 readings4 assignments4 app items1 plugin

9 videosTotal 20 minutes

Welcome to module 2 1 minute
Introduction to Linux 3 minutes
Phil: Learn and grow in the cybersecurity field2 minutes
Linux architecture3 minutes
Linux distributions3 minutes
KALI LINUX ™2 minutes
Introduction to the shell 2 minutes
Input and output in the shell 3 minutes
Wrap-up1 minute

9 readingsTotal 52 minutes

Linux architecture explained8 minutes
More Linux distributions4 minutes
Package managers for installing applications8 minutes
Resources for completing Linux labs4 minutes
Lab tips and troubleshooting steps4 minutes
Exemplar: Install software in a Linux distribution8 minutes
Different types of shells 4 minutes
Exemplar: Examine input and output in the shell10 minutes
Glossary terms from module 2 2 minutes

4 assignmentsTotal 69 minutes

Module 2 challenge45 minutes
Test your knowledge: All about Linux8 minutes
Test your knowledge: Linux distributions8 minutes
Test your knowledge: The shell 8 minutes

4 app itemsTotal 80 minutes

Activity: Install software in a Linux distribution30 minutes
Optional Exemplar: Install software in a Linux distribution10 minutes
Activity: Examine input and output in the shell30 minutes
Optional Exemplar: Examine input and output in the shell10 minutes

1 pluginTotal 10 minutes

Explore: Components of the Linux OS10 minutes

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.

What's included

12 videos15 readings6 assignments12 app items1 plugin

12 videosTotal 45 minutes

Welcome to module 3 1 minute
Linux commands via the Bash shell 3 minutes
Core commands for navigation and reading files 5 minutes
Find what you need with Linux5 minutes
Create and modify directories and files 8 minutes
File permissions and ownership 7 minutes
Change permissions 4 minutes
Add and delete users 5 minutes
Damar: My journey into Linux commands2 minutes
The Linux community 2 minutes
Man pages within the shell 2 minutes
Wrap-up 1 minute

15 readingsTotal 110 minutes

Navigate Linux and read file content 8 minutes
Exemplar: Find files with Linux commands8 minutes
Filter content in Linux8 minutes
Exemplar: Filter with grep4 minutes
Manage directories and files 8 minutes
Exemplar: Manage files with Linux commands10 minutes
Permission commands 8 minutes
Exemplar: Manage authorization10 minutes
Portfolio Activity Exemplar: Use Linux commands to manage file permissions4 minutes
Responsible use of sudo 8 minutes
Exemplar: Add and manage users with Linux commands10 minutes
Linux resources 8 minutes
Exemplar: Get help in the command line10 minutes
Reference guide: Linux 4 minutes
Glossary terms from module 3 2 minutes

6 assignmentsTotal 116 minutes

Module 3 challenge50 minutes
Test your knowledge: Navigate the Linux file system in Bash10 minutes
Test your knowledge: Manage file content in Bash 8 minutes
Portfolio Activity: Use Linux commands to manage file permissions30 minutes
Test your knowledge: Authenticate and authorize users 10 minutes
Test your knowledge: Get help in Linux 8 minutes

12 app itemsTotal 240 minutes

Activity: Find files with Linux commands30 minutes
Optional Exemplar: Find files with Linux commands10 minutes
Activity: Filter with grep30 minutes
Optional Exemplar: Filter with grep10 minutes
Activity: Manage files with Linux commands30 minutes
Optional Exemplar: Manage files with Linux commands10 minutes
Activity: Manage authorization30 minutes
Optional Exemplar: Manage authorization10 minutes
Activity: Add and manage users with Linux commands30 minutes
Optional Exemplar: Add and manage users with Linux commands10 minutes
Activity: Get help in the command line30 minutes
Optional Exemplar: Get help in the command line10 minutes

1 pluginTotal 10 minutes

Identify: Key Linux commands10 minutes

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.

What's included

12 videos19 readings6 assignments10 app items1 plugin

12 videosTotal 39 minutes

Welcome to module 4 1 minute
Introduction to databases 4 minutes
Query databases with SQL 3 minutes
Adedayo: SQL in cybersecurity2 minutes
Basic queries 3 minutes
Basic filters on SQL queries 5 minutes
Filter dates and numbers 4 minutes
Filters with AND, OR, and NOT 6 minutes
Join tables in SQL6 minutes
Types of joins 3 minutes
Wrap-up 1 minute
Course wrap-up 1 minute

19 readingsTotal 118 minutes

SQL filtering versus Linux filtering4 minutes
Query a database 8 minutes
Resources for completing SQL labs4 minutes
Exemplar: Perform an SQL query10 minutes
The WHERE clause and basic operators 8 minutes
Exemplar: Filter a SQL query10 minutes
Operators for filtering dates and numbers 4 minutes
Exemplar: Apply more filters in SQL10 minutes
More on filters with AND, OR, and NOT8 minutes
Exemplar: Filter with AND, OR, and NOT10 minutes
Portfolio Activity Exemplar: Apply filters to SQL queries4 minutes
Compare types of joins 8 minutes
Exemplar: Complete a join10 minutes
Continuous learning in SQL8 minutes
Reference guide: SQL 2 minutes
Glossary terms from module 42 minutes
Reflect and connect with peers2 minutes
Course 4 glossary 2 minutes
Get started on the next course4 minutes

6 assignmentsTotal 112 minutes

Module 4 challenge50 minutes
Test your knowledge: SQL and databases 8 minutes
Test your knowledge: SQL queries 8 minutes
Portfolio Activity: Apply filters to SQL queries30 minutes
Test your knowledge: More SQL filters8 minutes
Test your knowledge: SQL joins8 minutes

10 app itemsTotal 200 minutes

Activity: Perform a SQL query30 minutes
Optional Exemplar: Perform a SQL query10 minutes
Activity: Filter a SQL query30 minutes
Optional Exemplar: Filter a SQL query10 minutes
Activity: Apply more filters in SQL30 minutes
Optional Exemplar: Apply more filters in SQL10 minutes
Activity: Filter with AND, OR, and NOT30 minutes
Optional Exemplar: Filter with AND, OR, and NOT10 minutes
Activity: Complete a join30 minutes
Optional Exemplar: Complete a join10 minutes

1 pluginTotal 10 minutes

Identify: Choose the appropriate type of join10 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Google Career Certificates

Google

386 Courses17,170,147 learners

Offered by

Google

Explore more from Computer Security and Networks

Status: Free Trial
Duke University
Linux and Bash for Data Engineering
Course
Status: Free Trial
Pearson
Linux Security Basics and Beyond: Unit 1
Course
Status: Free Trial
University of Colorado System
Linux Server Management and Security
Course
Status: Free Trial
Pearson
Linux Security Basics and Beyond: Unit 4
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.