Questions every good Database/SQL developer should be able to answer [closed]

by

The different types of JOINs:

  • INNER JOIN
  • LEFT and RIGHT OUTER JOIN
  • FULL JOIN
  • CROSS JOIN

See Jeff Atwood’s Visual Explanation of JOINs

  • What is a key? A candidate key? A primary key? An alternate key? A foreign key?

  • What is an index and how does it help your database?

  • What are the data types available and when to use which ones?

More Related Contents:

  1. What are the options for storing hierarchical data in a relational database?
  2. Is there any rule of thumb to construct SQL query from a human-readable description?
  3. How can I list the tables in a SQLite database file that was opened with ATTACH?
  4. In MySQL queries, why use join instead of where?
  5. Doing a WHERE .. IN subquery in Doctrine 2
  6. Transpose latest rows per user to columns
  7. Is there any boolean type in Oracle databases?
  8. A beginner’s guide to SQL database design [closed]
  9. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  10. SQLite – ORDER BY RAND()
  11. The Next-gen Databases [closed]
  12. SQL Between clause with strings columns
  13. Insert an image in postgresql database
  14. Do database transactions prevent race conditions?
  15. Need to list all triggers in SQL Server database with table name and table’s schema
  16. What is the purpose of constraint naming
  17. How can I do a BEFORE UPDATED trigger with sql server?
  18. Drop all tables command
  19. How to find a table having a specific column in postgresql
  20. Deferrable Constraints in SQL Server
  21. INSERT COMMAND :: ERROR: column “value” does not exist
  22. Comma separated values in a database field
  23. Can SQL Server Express LocalDB be connected to remotely?
  24. What can cause an Oracle ROWID to change?
  25. SQL: Using NULL values vs. default values
  26. Why don’t DBMS’s support ASSERTION
  27. What does ON [PRIMARY] mean?
  28. How do you interpret a query’s explain plan?
  29. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment