问题每一个好数据库/ SQL开发人员应该能够回答 [英] Questions every good Database/SQL developer should be able to answer

问题描述

我正在浏览各种问题开发人员应该能够回答，并对这个问题的内容和方法印象深刻，因此，以同样的精神，我要问数据库/ SQL Developer的这个问题。

h2_lin>解决方案

不同类型的JOIN：

• INNER JOIN


• LEFT和RIGHT OUTER JOIN


• FULL JOIN


• CROSS JOIN

请参阅Jeff Atwood的 JOIN的视觉说明

• 什么是密钥？候选键？主键？备用密钥？外键？



• 什么是索引，它如何帮助您的数据库？




• 可用的数据类型和何时使用哪些数据类型？

I was going through Questions every good .Net developer should be able to answer and was highly impressed with the content and approach of this question and so in the same spirit, I am asking this question for Database/SQL Developer.

What questions do you think should a good Database/SQL programmer be able to respond to?

解决方案

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?

这篇关于问题每一个好数据库/ SQL开发人员应该能够回答的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！