Tools of the Trade: Linux and SQL
- Offered byCoursera
Tools of the Trade: Linux and SQL at Coursera Overview
Duration | 25 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course |
Credential | Certificate |
Tools of the Trade: Linux and SQL at Coursera Highlights
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Coursera Labs Includes hands on learning projects. Learn more about Coursera Labs External Link
- Beginner Level
- Approx. 25 hours to complete
- English Subtitles: English
Tools of the Trade: Linux and SQL at Coursera Course details
- This is the fourth course in the Google Cybersecurity Certificate. These courses will equip you with the skills you need to apply for an entry-level cybersecurity job. You’ll build on your understanding of the topics that were introduced in the third Google Cybersecurity Certificate course.
- In this course, you will explore computing skills that you’ll use on-the-job as a cybersecurity analyst. First, you'll practice using Linux, an operating system commonly used by cybersecurity professionals. For example, you'll use the Linux command line through the Bash shell to navigate and manage the file system and authenticate users. Then, you'll use SQL to communicate with a database.
- Google employees who currently work in cybersecurity will guide you through videos, provide hands-on activities and examples that simulate common cybersecurity tasks, and help you build your skills to prepare for jobs.
- Learners who complete this certificate will be equipped to apply for entry-level cybersecurity roles. No previous experience is necessary.
- 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.
Tools of the Trade: Linux and SQL at Coursera Curriculum
Introduction to operating systems
Introduction to Course 4
Welcome to week 1
Kim: My journey into computing
Introduction to operating systems
Inside the operating system
Resource allocation via the OS
GUI versus CLI
Ellen: My path into cybersecurity
Wrap-up
Course 4 overview
Helpful resources and tips
Compare operating systems
Requests to the operating system
The command line in use
Glossary terms from week 1
Test your knowledge: The wonderful world of operating systems
Test your knowledge: The operating system at work
Activity: Select the user interface
Test your knowledge: The user interface
Weekly challenge 1
The Linux operating system
Welcome to week 2
Introduction to Linux
Phil: Learn and grow in the cybersecurity field
Linux architecture
Linux distributions
KALI LINUX TM
Introduction to the shell
Input and output in the shell
Wrap-up
Linux architecture explained
More Linux distributions
Resources for completing Linux labs
Glossary terms from week 2
Test your knowledge: All about Linux
Test your knowledge: Linux distributions
Test your knowledge: The shell
Weekly challenge 2
Linux commands in the Bash shell
Welcome to week 3
Linux commands via the Bash shell
Core commands for navigation and reading files
Find what you need with Linux
Create and modify directories and files
File permissions and ownership
Change permissions
Add and delete users
Damar: My journey into Linux commands
The Linux community
Man pages within the shell
Wrap-up
Navigate Linux and read file content
Filter content in Linux
Manage directories and files
Permission commands
Portfolio Activity Exemplar: Use Linux commands to manage file permissions
Responsible use of sudo
Linux resources
Glossary terms from week 3
Test your knowledge: Navigate the Linux file system in Bash
Test your knowledge: Manage file content in Bash
Portfolio Activity: Use Linux commands to manage file permissions
Test your knowledge: Authenticate and authorize users
Test your knowledge: Get help in Linux
Weekly challenge 3
Databases and SQL
Welcome to week 4
Introduction to databases
Query databases with SQL
Adedayo: SQL in cybersecurity
Basic queries
Basic filters on SQL queries
Filter dates and numbers
Filters with AND, OR, and NOT
Join tables in SQL
Types of joins
Wrap-up
Course wrap-up
SQL filtering versus Linux filtering
Query a database
Resources for completing SQL labs
The WHERE clause and basic operators
Operators for filtering dates and numbers
More on filters with AND, OR, and NOT
Portfolio Activity Exemplar: Apply filters to SQL queries
Compare types of joins
Continuous learning in SQL
Glossary terms from week 4
Course 4 glossary
Get started on the next course
Test your knowledge: SQL and databases
Test your knowledge: SQL queries
Portfolio Activity: Apply filters to SQL queries
Test your knowledge: More SQL filters
Test your knowledge: SQL joins
Weekly challenge 4