Understanding Databases: A Beginner’s Guide
I’m Sithranjan, a high school senior with a passion for cybersecurity, system administration, and leading teams to tackle real-world challenges.
As co-captain of my school’s CyberPatriot team, I’ve led our group through national cybersecurity defense competitions, focusing on system hardening, vulnerability mitigation, and strategic planning. I’m committed to enhancing my technical expertise in ethical hacking and cybersecurity, while mentoring others and driving team success.
Alongside my work in cybersecurity, I’m exploring the intersection of technology, leadership, and innovation. Whether it’s through competitions, courses, or personal projects, I’m constantly pushing myself to grow and develop the skills needed to build secure systems and lead with impact.
Let’s connect, share knowledge, and work toward a safer, more secure digital future.
What is a Database?
In the simplest terms, a database is an organized collection of information stored electronically. It helps applications store, retrieve, and manipulate data efficiently.
Think of it like a smart Excel sheet — but way more powerful and secure.
Types of Databases
Relational Databases (SQL)
Data stored in tables (rows and columns)
Uses Structured Query Language (SQL)
Examples: MySQL, PostgreSQL, Microsoft SQL Server
Non-Relational Databases (NoSQL)
Data stored in documents, key-value pairs, or graphs
Flexible structure, better for unstructured data
Examples: MongoDB, Redis, Cassandra
Basic SQL Commands You Should Know
| Command | Description | Example |
SELECT | Get data from a table | SELECT * FROM users; |
INSERT | Add data to a table | INSERT INTO users VALUES (...); |
UPDATE | Change existing data | UPDATE users SET name='Bob'; |
DELETE | Remove data | DELETE FROM users WHERE id=1; |
WHERE | Filter results | SELECT * FROM users WHERE age>18; |
Why This Matters in Cybersecurity
Understanding databases is crucial for spotting and preventing attacks like:
SQL Injection: Injecting malicious queries into user inputs to gain unauthorized access.
Misconfigurations: Open databases exposing sensitive data.
Privilege Escalation: Exploiting weak permission settings.
If you're learning hacking or ethical pentesting, you must know how databases work.
If you're just starting out, feel free to learn alongside me! You can always reach out!
