4. ツールを使いこなす：Linux と SQL from Coursera

Google サイバーセキュリティプロフェッショナル認定証の 4 つめのコースです。各コースでは初級サイバーセキュリティの職に必要なスキルを身につけることができます。

このコースでは、サイバーセキュリティアナリストとして実際に業務で使用するコンピュータスキルを探求します。まず、サイバーセキュリティの職種でよく使われるオペレーティングシステム（OS）である Linux の使い方を学びます。例えば、Bash シェルによる Linux のコマンドラインを使って、ファイルシステムの操作や管理、ユーザー認証を実行します。そして、データベースと通信するために SQL を使う方法についても学びます。

サイバーセキュリティの分野で働いている現職の Google 社員が最適なツールやリソースを使って一般的なサイバーセキュリティの業務を遂行する実践的な方法を指導します。また就職活動への準備も手助けします。

この認定プログラムを修了すると、エントリーレベルのサイバーセキュリティの職に応募できるようになります。過去の業務経験は不要です。

What's inside

Syllabus

入門編：オペレーティングシステム（OS ）

ここではオペレーティングシステム（OS）、ハードウェア、ソフトウェアの関連性を学び、オペレーティングシステムの主な機能を理解します。具体的には、現在使用されている一般的なオペレーティングシステムを知り、ユーザーが GUI（グラフィカルユーザーインターフェース）と CLI（コマンドラインインターフェース）の両方を使って通信する方法を学びます。

Linux オペレーティングシステム

ここでは、Linux オペレーティングシステム（OS）を取り上げ、サイバーセキュリティにおける一般的な使用方法を学びます。また、Linux のアーキテクチャと一般的な Linux ディストリビューションについても学びます。さらに、Linux シェルについて、また Linux シェルによるオペレーティングシステムとの通信方法についても学んでいきます。

Bash シェルで Linux のコマンドを実行する

ここでは、Bash シェルで実行する Linux のコマンドを学びます。Bash シェルを使ってファイルシステムの操作と管理、ユーザーの認可と認証を行います。また、新しい Linux コマンドを使用する際に、サポートを得られる場所についても学びます。

データベースと SQL

ここでは、データベースと通信するために SQL を使う練習をします。また、データベースへのクエリと結果のフィルタリングの方法、SQL で複数のテーブルをクエリで結合する方法についても学びます。

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Helps learners understand the Linux operating system, which is standard in industry

Led by Google employees who are recognized for their work in cybersecurity

Suitable for beginner cybersecurity professionals

Includes lessons that teach learners to execute Linux commands in bash shell

Examines SQL database management, which is highly relevant to cybersecurity

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in 4. ツールを使いこなす：Linux と SQL with these activities:

Linux オペレーティングシステムの基礎を確認する

Show steps

Linux オペレーティングシステムの基礎を復習することで、コースで習う新しい概念をより深く理解することができます。

Browse courses on Linux

Show steps

Linux オペレーティングシステムの概要をレビューする。
Linux ディストリビューションの種類を比較する。
仮想マシンを使用して Linux をインストールする。

SQL チュートリアル

Show steps

SQL チュートリアルでは、データベースの操作とデータの管理に役立つ SQL に関する実践的なスキルを身に付けることができます。

Browse courses on SQL

Show steps

SQL の基本構文を学ぶ。
SQL を使用してデータを挿入、更新、削除する。
SQL を使用してデータをクエリする。

Show all two activities

Career center

Learners who complete 4. ツールを使いこなす：Linux と SQL will develop knowledge and skills that may be useful to these careers:

Information Security Analyst

Information Security Analysts design and implement security measures to protect an organization's computer networks and systems. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that can lead to a successful career in this field. This course focuses on Linux operating systems and SQl, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Information Security Analyst

Cybersecurity Analyst

Cybersecurity Analysts maintain and protect computer systems from attacks and unauthorized access. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that can help you succeed in this role. This course focuses on Linux operating systems and SQl, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Cybersecurity Analyst

IT Auditor

IT Auditors assess an organization's IT infrastructure to ensure compliance with security regulations and best practices. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that can support your success in this role. This course focuses on Linux operating systems and SQL, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for IT Auditor

Network Security Engineer

Network Security Engineers design, implement, and maintain security measures to protect an organization's computer networks and systems. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that can lead to success in this role. This course focuses on Linux operating systems and SQL, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Network Security Engineer

Security Engineer

Security Engineers design, implement, and maintain security measures to protect an organization's computer networks and systems. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that can support your success in this role. This course focuses on Linux operating systems and SQL, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Security Engineer

Computer Systems Analyst

Computer Systems Analysts design, implement, and maintain computer systems to meet an organization's needs. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that will help you succeed in this role. This course focuses on Linux operating systems and SQl, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Computer Systems Analyst

Database Administrator

Database Administrators are responsible for the maintenance and security of an organization's databases. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that can help you to excel in this role. This course focuses on Linux operating systems and SQL, providing you with the skills to manage databases effectively.

See salaries and explore the career path for Database Administrator

Systems Administrator

Systems Administrators are responsible for the maintenance and security of an organization's computer systems. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that will aid your success in this role. This course focuses on Linux operating systems and SQL, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Systems Administrator

Security Consultant

Security Consultants provide advice and guidance to organizations on how to protect their computer networks and systems from attacks. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that will support your success in this role. This course focuses on Linux operating systems and SQL, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Security Consultant

Cloud Architect

Cloud Architects design and implement cloud computing solutions for organizations. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that can help you succeed. This course focuses on Linux operating systems and SQL, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Cloud Architect

Software Engineer

Software Engineers design, develop, and test software applications. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that will help you to excel in this role. This course focuses on Linux operating systems and SQL, providing you with the skills to build and maintain software applications.

See salaries and explore the career path for Software Engineer

Web Developer

Web Developers design and develop websites and web applications. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that will aid your success in this role. This course focuses on Linux operating systems and SQL, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Web Developer

Mobile Application Developer

Mobile Application Developers design and develop mobile applications for smartphones and tablets. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that will aid your success in this role. This course focuses on Linux operating systems and SQL, which can help you excel in this field and move to a higher level position.

See salaries and explore the career path for Mobile Application Developer

Data Scientist

Data Scientists use data to solve business problems and make predictions. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that can help you to excel in this role. This course focuses on Linux operating systems and SQL, providing you with the skills to manage and analyze data.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts analyze business needs and develop solutions to improve business processes. A Google Cyber Security Certificate, which this course is a part of, can provide you with a strong foundation that can help you to succeed in this role. This course focuses on Linux operating systems and SQL, providing you with the skills to understand and analyze business data.

See salaries and explore the career path for Business Analyst