Tools of the Trade: Linux and SQL

This course is part of Google Cybersecurity Professional Certificate

Instructor: Google Career Certificates

Access provided by KIPP Forward

416,832 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

6,130 reviews

Beginner level

No prior experience required

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

98%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

6,130 reviews

Beginner level

No prior experience required

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

98%

Most learners liked this course

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

1 quiz, 20 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 videos Total 21 minutes

Introduction to Course 4 2 minutes
Welcome to module 1 1 minute
Kim: My journey into computing 2 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 readings Total 48 minutes

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

5 assignments Total 79 minutes

Module 1 challenge 45 minutes
Test your knowledge: The wonderful world of operating systems 8 minutes
Test your knowledge: The operating system at work 8 minutes
Activity: Select the user interface 10 minutes
Test your knowledge: The user interface 8 minutes

1 plugin Total 10 minutes

Practice: Order of operations in the OS 10 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 videos Total 20 minutes

Welcome to module 2 1 minute
Introduction to Linux 3 minutes
Phil: Learn and grow in the cybersecurity field 2 minutes
Linux architecture 3 minutes
Linux distributions 3 minutes
KALI LINUX ™ 2 minutes
Introduction to the shell 2 minutes
Input and output in the shell 3 minutes
Wrap-up 1 minute

9 readings Total 52 minutes

Linux architecture explained 8 minutes
More Linux distributions 4 minutes
Package managers for installing applications 8 minutes
Resources for completing Linux labs 4 minutes
Lab tips and troubleshooting steps 4 minutes
Exemplar: Install software in a Linux distribution 8 minutes
Different types of shells 4 minutes
Exemplar: Examine input and output in the shell 10 minutes
Glossary terms from module 2 2 minutes

4 assignments Total 69 minutes

Module 2 challenge 45 minutes
Test your knowledge: All about Linux 8 minutes
Test your knowledge: Linux distributions 8 minutes
Test your knowledge: The shell 8 minutes

4 app items Total 80 minutes

Activity: Install software in a Linux distribution 30 minutes
Optional Exemplar: Install software in a Linux distribution 10 minutes
Activity: Examine input and output in the shell 30 minutes
Optional Exemplar: Examine input and output in the shell 10 minutes

1 plugin Total 10 minutes

Explore: Components of the Linux OS 10 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 readings1 quiz5 assignments12 app items1 plugin

12 videos Total 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 Linux 5 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 commands 2 minutes
The Linux community 2 minutes
Man pages within the shell 2 minutes
Wrap-up 1 minute

15 readings Total 110 minutes

Navigate Linux and read file content 8 minutes
Exemplar: Find files with Linux commands 8 minutes
Filter content in Linux 8 minutes
Exemplar: Filter with grep 4 minutes
Manage directories and files 8 minutes
Exemplar: Manage files with Linux commands 10 minutes
Permission commands 8 minutes
Exemplar: Manage authorization 10 minutes
Portfolio Activity Exemplar: Use Linux commands to manage file permissions 4 minutes
Responsible use of sudo 8 minutes
Exemplar: Add and manage users with Linux commands 10 minutes
Linux resources 8 minutes
Exemplar: Get help in the command line 10 minutes
Reference guide: Linux 4 minutes
Glossary terms from module 3 2 minutes

1 quiz Total 50 minutes

Module 3 challenge 50 minutes

5 assignments Total 66 minutes

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

12 app items Total 240 minutes

Activity: Find files with Linux commands 30 minutes
Optional Exemplar: Find files with Linux commands 10 minutes
Activity: Filter with grep 30 minutes
Optional Exemplar: Filter with grep 10 minutes
Activity: Manage files with Linux commands 30 minutes
Optional Exemplar: Manage files with Linux commands 10 minutes
Activity: Manage authorization 30 minutes
Optional Exemplar: Manage authorization 10 minutes
Activity: Add and manage users with Linux commands 30 minutes
Optional Exemplar: Add and manage users with Linux commands 10 minutes
Activity: Get help in the command line 30 minutes
Optional Exemplar: Get help in the command line 10 minutes

1 plugin Total 10 minutes

Identify: Key Linux commands 10 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 videos Total 39 minutes

Welcome to module 4 1 minute
Introduction to databases 4 minutes
Query databases with SQL 3 minutes
Adedayo: SQL in cybersecurity 2 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 SQL 6 minutes
Types of joins 3 minutes
Wrap-up 1 minute
Course wrap-up 1 minute

19 readings Total 118 minutes

SQL filtering versus Linux filtering 4 minutes
Query a database 8 minutes
Resources for completing SQL labs 4 minutes
Exemplar: Perform an SQL query 10 minutes
The WHERE clause and basic operators 8 minutes
Exemplar: Filter a SQL query 10 minutes
Operators for filtering dates and numbers 4 minutes
Exemplar: Apply more filters in SQL 10 minutes
More on filters with AND, OR, and NOT 8 minutes
Exemplar: Filter with AND, OR, and NOT 10 minutes
Portfolio Activity Exemplar: Apply filters to SQL queries 4 minutes
Compare types of joins 8 minutes
Exemplar: Complete a join 10 minutes
Continuous learning in SQL 8 minutes
Reference guide: SQL 2 minutes
Glossary terms from module 4 2 minutes
Reflect and connect with peers 2 minutes
Course 4 glossary 2 minutes
Get started on the next course 4 minutes

6 assignments Total 112 minutes

Module 4 challenge 50 minutes
Test your knowledge: SQL and databases 8 minutes
Test your knowledge: SQL queries 8 minutes
Portfolio Activity: Apply filters to SQL queries 30 minutes
Test your knowledge: More SQL filters 8 minutes
Test your knowledge: SQL joins 8 minutes

10 app items Total 200 minutes

Activity: Perform a SQL query 30 minutes
Optional Exemplar: Perform a SQL query 10 minutes
Activity: Filter a SQL query 30 minutes
Optional Exemplar: Filter a SQL query 10 minutes
Activity: Apply more filters in SQL 30 minutes
Optional Exemplar: Apply more filters in SQL 10 minutes
Activity: Filter with AND, OR, and NOT 30 minutes
Optional Exemplar: Filter with AND, OR, and NOT 10 minutes
Activity: Complete a join 30 minutes
Optional Exemplar: Complete a join 10 minutes

1 plugin Total 10 minutes

Identify: Choose the appropriate type of join 10 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

Instructor ratings

(1,546 ratings)

Google Career Certificates

Google

386 Courses 15,700,156 learners

Offered by

Google

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."

Learner reviews

5 stars
86.97%
4 stars
9.51%
3 stars
2.02%
2 stars
0.61%
1 star
0.86%

Showing 3 of 6130

Reviewed on Sep 10, 2023

I already had experience with Linux and SQL as a Computer Science student but I did pick up a few CLI commands that I haven't used before. A good way to get your feet wet with both.

Reviewed on Oct 16, 2023

Fun and more interactive then the first 3 courses, with the introduction of labs to practice and explore Linux and SQL. I found it to be a bit difficult, but ultimately rewarding.

Reviewed on Jan 18, 2024

The course itself was a lot of fun. I really enjoyed it and learned a lot. The instructor, not so much. It was just a person reading from a prompter with no real intonation or emotion.

View more reviews