SQL Fundamentals

Introduction

Cyber security is a broad topic that covers a wide range of subjects, but few of those are as ubiquitous as databases. Whether you’re working on securing a web application, working in a SOC and using a SIEM, configuring user authentication/access control, or using malware analysis/threat detection tools (the list goes on), you will in some way be relying on databases. For example, on the offensive side of security, it can help us better understand SQL vulnerabilities, such as SQL injections, and create queries that help us tamper or retrieve data within a compromised service. On the other hand, on the defensive side, it can help us navigate through databases and find suspicious activity or relevant information; it can also help us better protect a service by implementing restrictions when needed.

Because databases are ubiquitous, it is important to understand them, and this room will be your first step in that direction. We’ll go through the basics of databases, covering key terms, concepts and different types before getting to grips with SQL.

Room Prerequisites

This room has been written specifically for beginners. Because of this, users with little to no IT experience will be able to follow this room without the need to complete any of our material beforehand. However, having the Linux Fundamentals down would prove helpful.

Learning Objectives

• Understand what databases are, as well as key terms and concepts
• Understand the different types of databases 
• Understand what SQL is
• Understand and be able to use SQL CRUD Operations
• Understand and be able to use SQL Clauses Operations
• Understand and be able to use SQL Operations
• Understand and be able to use SQL Operators
• Understand and be able to use SQL Functions