Geek Answers Handbook

Fundamental knowledge of SQL?

I am going to pass a test test, so I do not need to take a database processing class. Despite the fact that I have been working with databases for the past 5 years, I can not help but get nervous because of the test. These are 50 questions and there are two parts: the true / false part and the part where I actually write SQL commands. It is not platform.

What are the main things I should know in this test? Why do you need new SQL developers in your company to know how to do this? What questions can be a hoax?

EDIT:

As I said, it is non-platform, but it is non-linguistic. There will be no questions about how to connect in ASP.Net, PHP, or in other languages.

+5
source share
6 answers

/ . Joins ( ). ( ) . (esp ). . . . .

, , .

. - . , .

+3

-:-) :

  • (DDL), .

  • (DML), .

  • , (DCL), .

  • .

  • .:-D

+2

g.d.d.c. . :

.

. , , ! , , , , ORM .

.

, , , , .

NoSQL .

+2
source

If this is a basic course, then you should know everything under w3schools and very well with normalization. (They like to ask about normalization and joining)

+1
source

Know that you prefer JOIN for polluting your WHERE clause with connectors.

+1
source

In addition to what gddc, JustBoo, ​​and HLGEM said, a basic understanding of transactions, especially rollback and commit. Also TRUNCATE TABLE.

0
source

More articles:


All Articles