chapiter 1 :DBMS Specifics(résume)

resume of chapiter 1 (VISUAL QUICKSTART GUIDE SQL Second Edition)

1. you need a database management système to runs sql programs.
2. microsoft access graphical interface let you run only one statement at a time.
3. the other system (all DBMS server) let you run in interactive mode.
4. file maker pro (www.filemaker.com) is a popular desktop data bases programs.
5. sybase adaptative server (www.sybase.com) is a popular commercial DBMS.
6. microsoft access is appropriate for managing small and meduim size databaeses.
7. in access you must turn in ANSI -92 sql query mode to run sql statement.
8. microsoft sql server is a commercial DBMS that support very large databases and transactionsto download click here .
9. oracle is a leading DMBS.
10. other DBMS (mysql,IBM DB 2 )if you don't like the command prompt of mysql ,you can try mysql control center (MYSQLCC).
11. you can learn about open sources software at www.opensource.org.