Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Tools of the Trade: Linux and SQL

Google via Google Skills

Go to class Write review
Financial Edge Ad

The Private Equity Associate Certification

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Advance your cybersecurity skills by learning how to use Linux and SQL for real-world analyst tasks. Learn to navigate file systems with Bash, authenticate users, and communicate with databases. Google experts provide hands-on activities simulating common cybersecurity scenarios to build your practical skills. This is the fourth course in the Google Cybersecurity Certificate, a series designed to prepare you for an entry-level cybersecurity role.

Syllabus

  • Introduction to operating systems
    • Introduction to Course 4
    • Course 4 overview
    • Welcome to module 1
    • Kim: My journey into computing
    • Introduction to operating systems
    • Compare operating systems
    • Practice Quiz: Test your knowledge: The wonderful world of operating systems
    • Inside the operating system
    • Requests to the operating system
    • Resource allocation via the OS
    • Virtualization technology
    • Practice Quiz: Test your knowledge: The operating system at work
    • GUI versus CLI
    • The command line in use
    • Practice Quiz: Activity: Select the user interface
    • Ellen: My path into cybersecurity
    • Practice Quiz: Test your knowledge: The user interface
    • Wrap-up
    • Glossary terms from module 1
    • Graded Quiz: Module 1 challenge
  • The Linux operating system
    • Welcome to module 2
    • Introduction to Linux
    • Phil: Learn and grow in the cybersecurity field
    • Linux architecture
    • Linux architecture explained
    • Practice Quiz: Test your knowledge: All about Linux
    • 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
    • Exemplar: Install software in a Linux distribution
    • Exemplar: Install software in a Linux distribution
    • Practice Quiz: Test your knowledge: Linux distributions
    • Introduction to the shell
    • Different types of shells
    • Input and output in the shell
    • Activity: Examine input/output in the Linux shell
    • Exemplar: Examine input/output in the Linux shell
    • Exemplar: Examine input and output in the shell
    • Practice Quiz: Test your knowledge: The shell
    • Wrap-up
    • Glossary terms from module 2
    • Graded Quiz: Module 2 challenge
  • Linux commands in the Bash shell
    • 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
    • Exemplar: Find files with Linux commands
    • Exemplar: Find files with Linux commands
    • Practice Quiz: Test your knowledge: Navigate the Linux file system in Bash
    • Find what you need with Linux
    • Filter content in Linux
    • Activity: Filter with grep
    • Exemplar: Filter with grep
    • Exemplar: Filter with grep
    • Create and modify directories and files
    • Manage directories and files
    • Activity: Manage files with Linux commands
    • Exemplar: Manage files with Linux commands
    • Exemplar: Manage files with Linux commands
    • Practice Quiz: Test your knowledge: Manage file content in Bash
    • File permissions and ownership
    • Change permissions
    • Permission commands
    • Activity: Manage authorization
    • Exemplar: Manage authorization
    • Exemplar: Manage authorization
    • Portfolio Activity Exemplar: Use Linux commands to manage file permissions
    • Practice Quiz: Portfolio Activity: Use Linux commands to manage file permissions
    • Add and delete users
    • Responsible use of sudo
    • Activity: Add and manage users with Linux commands
    • Exemplar: Add and manage users with Linux commands
    • Exemplar: Add and manage users with Linux commands
    • Practice Quiz: Test your knowledge: Authenticate and authorize users
    • Damar: My journey into Linux commands
    • The Linux community
    • Man pages within the shell
    • Linux resources
    • Activity: Get help in the command line
    • Exemplar: Get help in the command line
    • Exemplar: Get help in the command line
    • Practice Quiz: Test your knowledge: Get help in Linux
    • Wrap-up
    • Reference guide: Linux
    • Glossary terms from module 3
    • Graded Quiz: Module 3 challenge
  • Databases and SQL
    • Welcome to module 4
    • Introduction to databases
    • Query databases with SQL
    • SQL filtering versus Linux filtering
    • Adedayo: SQL in cybersecurity
    • Practice Quiz: Test your knowledge: SQL and databases
    • Basic queries
    • Query a database
    • Resources for completing SQL labs
    • Activity: Perform a SQL query
    • Exemplar: Perform a SQL query
    • Basic filters on SQL queries
    • Exemplar: Perform an SQL query
    • The WHERE clause and basic operators
    • Activity: Filter a SQL query
    • Exemplar: Filter a SQL query
    • Exemplar: Filter a SQL query
    • Practice Quiz: Test your knowledge: SQL queries
    • Filter dates and numbers
    • Operators for filtering dates and numbers
    • Activity: Apply more filters in SQL
    • Exemplar: Apply more filters in SQL
    • Exemplar: Apply more filters in SQL
    • Filters with AND, OR, and NOT
    • More on filters with AND, OR, and NOT
    • Activity: Filter with AND, OR, and NOT
    • Exemplar: Filter with AND, OR, and NOT
    • Exemplar: Filter with AND, OR, and NOT
    • Practice Quiz: Portfolio Activity: Apply filters to SQL queries
    • Portfolio Activity Exemplar: Apply filters to SQL queries
    • Practice Quiz: Test your knowledge: More SQL filters
    • Join tables in SQL
    • Types of joins
    • Compare types of joins
    • Activity: Complete a SQL join
    • Exemplar: Complete a SQL join
    • Exemplar: Complete a join
    • Practice Quiz: Test your knowledge: SQL joins
    • Continuous learning in SQL
    • Wrap-up
    • Reference guide: SQL
    • Glossary terms from module 4
    • Graded Quiz: Module 4 challenge
    • C4M4 Weekly Challenge 4
    • Course wrap-up
    • Course 4 glossary
    • Get started on the next course
    • Course 4 resources and citations

Tags

Reviews

Start your review of Tools of the Trade: Linux and SQL

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.