Advanced MySQL Am I missing a point?

Question

Not sure if this question makes sense. But I know all the basic mysql CRUD commands. Probably a little more here and there (foreign keys, etc.). But there are so many books written in mysql / dbms. I can write decent queries and get all my results as I want. They may not be the most effective, but they work. That is because my facebook applications arent so far I have to worry about optimization. Or me?

Did I miss the point here? What else should I know?

Many thanks.

Answer 1

What else should I know?

• , SQL. " SQL Relational Theory," C. J. Date, .

• security - , SQL-, , OWASP, SANS.org, " 19 ." , SQL, , .

• - , , ?

• I18N, L10N, .

• - , .

• Replication, .

• - .

• SQL, RDBMS. , , , .

• - .

• . SQL - , , .

Answer 2

- . , . , .

-, , , , . , (. SQL-).

Answer 3

imho. , 10 , , , , , " ", , .

Answer 4

MySQL, , CRUD. , , . , , , , .

Answer 5

CRUD. , , , .. , , MySQL.

Answer 6

, " ". , .

Answer 7

, , , . , CJ Date - , ( ).

Answer 8

, mysql RDBMS, . , , , , . Advanced X , , .

, , . . , , , , db .

Answer 9

, (). , : " " Advanced "" MySQL "?".: -)

MySQL , , , , gotchas, , .

, "": , - . MicroSoft, SQL Server , Windows. , * nix, PostgreSQL. , ROLLBACK, , , , (, ) . MySQL , (IMHO) . 2000 " xBASE SQL". ( SQL - , , , " " )

Answer 10

MySQL, , -. , "" MySQL, - .

, SQL , MySQL . .

Advanced , . , MySQL .