JML INSTITUTE ONLINE: BSC
Business School Center
Instructor: Professor Steven Lopin
____________________________________________
QUERIES: 
____________________________________________
subject overview:

          Database programs always have modules that provide query functions.  Database software like MS SQL Server, Oracle, MS Access, Informix, DB2, dBase, and Foxpro surely have user friendly querying methods.  Visual Basic 6.0  also provides its users a means to connect to a database and then  to create queries via the older DAO (data access objects) and RDO (remote data objects) connectivity to ODBC databases and the newer ADO (activeX data objects) connecting to OLE DB data sources.  Visual C+ 6.0 or later also has classes that offer both types of connectivity.  Computer programmers can write routines that can process data from theses databases and put the updated data back into the databases.

	Microsoft has thrown its hand into the data-accessing-over-the-internet game that was generally handled by CGI and Perl scripts.   Its ASP (Active Server Pages) came initially with each copy of IIS (Internet Information Server 3.0) which uses ADO to OLE DB interfaces.  Now it's stand alone versions offers the user a way to create awesome webpage with database functionality.  ASP runs on the server like CGI (common gateway interface)
which is the way forms on your webpages are process in a CGI-BIN folder on the server.  Perl is the actual language used with CGI.  So the next time you see a form on a webpage, that some sellers is trying to dupe you to submit and login or join some money making scheme, you'll know that form's destination.  The data probably is going to be sorted by a CGI Perl script and the info put into a database table which is the object that holds files.

query: A question asked the database about its records,  like which records have this or that field?

SQL:  sample SQL commands

	FROM - file that is the location of records

	WHERE -  a condition property of desired records.

	ORDER BY - which field will the queried records be shown or listed.

	SELECT - which record . . .

	JOIN -  two or more . . . 

	GROUPBY - field selected to separate records.