Tools of the Trade: Linux and SQL
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Tools of the Trade: Linux and SQL
This course is part of Google Cybersecurity Professional Certificate
454,791 already enrolled
Included with
Ask Coursera
6,260 reviews
6,260 reviews
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
Details to know
See how employees at top companies are mastering in-demand skills
Build your Computer Security and Networks expertise
- 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
- 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
- Module 1 challenge•45 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
- Test your knowledge: All about Linux•8 minutes
- Test your knowledge: Linux distributions•8 minutes
- Test your knowledge: The shell •8 minutes
- Module 2 challenge•45 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 readings6 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
6 assignments•Total 116 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
- Module 3 challenge•50 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
- 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
- Module 4 challenge•50 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
Explore more from Computer Security and Networks
- Status: Free TrialD
Duke University
Course
- Status: Free Trial
Course
Course
- Status: Free Trial
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
87.01%
- 4 stars
9.47%
- 3 stars
2.01%
- 2 stars
0.62%
- 1 star
0.87%
Showing 3 of 6260
Reviewed on Aug 15, 2023
The different learning aspects within the course really helped me to better understand each concept. The labs also help by adding repetition and letting me know where I need study further.
Reviewed on Jan 25, 2024
The hands on practice with the Labs for Linux and SQL was the MOST beneficial. This helped with learning, absorbing, and genuinely understanding the material. This course is set up very well!
Reviewed on Jan 3, 2024
It was a very wonderful course full of practical aspects and theoretical guidance. I enjoyed it very much and promise to further my study in Linux and SQL.......To my Instructor I thank YOU.
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.
More questions
Financial aid available,