Web Hacking: SQL Fundamentals (TryHackMe)

Web Hacking: SQL Fundamentals (TryHackMe)

In this article, I will write a write-up for SQL Fundamentals that covers Database 101, SQL, Database and Table Statements, CRUD Operations, Clauses, Operators, and Functions.

What type of database should you consider using if the data you're going to be storing will vary greatly in its format? Non-relational database
What type of database should you consider using if the data you're going to be storing will reliably be in the same structured format? relational database
In our example, once a record of a book is inserted into our "Books" table, it would be represented as a ___ in that table? row
Which type of key provides a link from one table to another? foreign key
which type of key ensures a record is unique within a table? primary key
What serves as an interface between a database and an end user? DBMS
What query language can be used to interact with a relational database? SQL
Using the statement you've learned to list all databases, it should reveal a database with a flag for a name; what is it? THM{575a947132312f97b30ee5aeebba629b723d30f9}
In the list of available databases, you should also see the task_4_db database. Set this as your active database and list all tables in this database; what is the flag present here?THM{692aa7eaec2a2a827f4d1a8bed1f90e5e49d2410}
Using the tools_db database, what is the name of the tool in the hacking_tools table that can be used to perform man-in-the-middle attacks on wireless networks? Wi-Fi Pineapple
Using the tools_db database, what is the shared category for both USB Rubber Ducky and Bash Bunny? USB attacks
Using the tools_db database, what is the total number of distinct categories in the hacking_tools table? 6
Using the tools_db database, what is the first tool (by name) in ascending order from the hacking_tools table? Bash Bunny
Using the tools_db database, what is the first tool (by name) in descending order from the hacking_tools table? Wi-Fi Pineapple
Using the tools_db database, which tool falls under the Multi-tool category and is useful for pentesters and geeks? Flipper Zero
Using the tools_db database, what is the category of tools with an amount greater than or equal to 300? RFID cloning
Using the tools_db database, which tool falls under the Network intelligence category with an amount less than 100? Lan Turtle
Using the tools_db database, what is the tool with the longest name based on character length? USB Rubber Ducky
Using the tools_db database, what is the total sum of all tools? 1444
Using the tools_db database, what are the tool names where the amount does not end in 0, and group the tool names concatenated by " & ". Flipper Zero & iCopy-XS

Thank you for reading my article. Please leave any questions or comments on improving my learning journey and the THM challenges.