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.

1. 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

2. 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

3. 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

4. Which type of key provides a link from one table to another? foreign key

5. which type of key ensures a record is unique within a table? primary key

6. What serves as an interface between a database and an end user? DBMS

7. What query language can be used to interact with a relational database? SQL

   

8. 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}

   

9. 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}

   

   

10. 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

    

11. Using the tools_db database, what is the shared category for both USB Rubber Ducky and Bash Bunny? USB attacks

    

    

12. Using the tools_db database, what is the total number of distinct categories in the hacking_tools table? 6

    

13. Using the tools_db database, what is the first tool (by name) in ascending order from the hacking_tools table? Bash Bunny

    

14. Using the tools_db database, what is the first tool (by name) in descending order from the hacking_tools table? Wi-Fi Pineapple

    

    

    

    

    

15. Using the tools_db database, which tool falls under the Multi-tool category and is useful for pentesters and geeks? Flipper Zero

    

16. Using the tools_db database, what is the category of tools with an amount greater than or equal to 300? RFID cloning

    

17. Using the tools_db database, which tool falls under the Network intelligence category with an amount less than 100? Lan Turtle

    

    

18. Using the tools_db database, what is the tool with the longest name based on character length? USB Rubber Ducky

    

19. Using the tools_db database, what is the total sum of all tools? 1444

    

20. 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. We can also connect more on LinkedIn or X.