h**h
发帖数: 488 | 1 我是做统计/经济的，用SAS和Excel。上一个工作我们那里economics的人喜欢用access
。现在我找工作，看见很多job要求懂SQL（Structured Query Language）。 这个是指
的哪种，数据库的还是编程的？我基本是都不懂的，就是跟着我老板学会用Access，也
就是从ODBC database里调个数。我想自己看看这方面的东西，起码知道基本原理。 | i****a
发帖数: 36252 | 2 SQL is a language. Different database systems use slightly different
favors of SQL (but in some specific cases can be very different).
http://www.w3schools.com/sql/default.asp
access
【在 h**h 的大作中提到】
: 我是做统计/经济的，用SAS和Excel。上一个工作我们那里economics的人喜欢用access
: 。现在我找工作，看见很多job要求懂SQL（Structured Query Language）。 这个是指
: 的哪种，数据库的还是编程的？我基本是都不懂的，就是跟着我老板学会用Access，也
: 就是从ODBC database里调个数。我想自己看看这方面的东西，起码知道基本原理。
| h**h
发帖数: 488 | 3 Thanks. So this refers to a programming language.
I remembered, we used ODBC database, my boss used to design the query with
Access to perform the functions with excel, so he was using the SQL
programming language as well?
Also, linking with the ODBC, it manipulate data on what database? I saw "MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems", which one I should take a look?
【在 i****a 的大作中提到】
: SQL is a language. Different database systems use slightly different
: favors of SQL (but in some specific cases can be very different).
: http://www.w3schools.com/sql/default.asp
:
: access
| i****a
发帖数: 36252 | 4 the query designer in Access is just a graphical interface to build SQL
commands for you.
If you look at the ODBC on the computer the Access is running on, you can
see the details on the connection.
that tutorial website talks about the basic and standard SQL, which is
almost the same for all systems.
with
"MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database
systems", which one I should take a look?
【在 h**h 的大作中提到】
: Thanks. So this refers to a programming language.
: I remembered, we used ODBC database, my boss used to design the query with
: Access to perform the functions with excel, so he was using the SQL
: programming language as well?
: Also, linking with the ODBC, it manipulate data on what database? I saw "MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems", which one I should take a look?
|
|
