SQL Fundamentals

Walkthrough summary

SQL Fundamentals TryHackMe walkthrough with 20 answered prompts and lab methodology notes.

Sample prompts covered

• What type of database should you consider using if the data you're going to be storing will vary greatly in its format?
  Open the walkthrough page to inspect the full answer and command flow.
• 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?
  Open the walkthrough page to inspect the full answer and command flow.
• In our example, once a record of a book is inserted into our "Books" table, it would be represented as a ___ in that table?
  Open the walkthrough page to inspect the full answer and command flow.
• Which type of key provides a link from one table to another?
  Open the walkthrough page to inspect the full answer and command flow.
• Which type of key ensures a record is unique within a table?
  Open the walkthrough page to inspect the full answer and command flow.