SQL ASSIGNMENTS USING MYSQL SUMMER, 2009
Description: 'SQL (Structured Query Language) is a coding language used for retrieving information out of
relational databases such as Oracle, Informix, Microsoft SQL Server, Microsoft Access and Sun's MySQL.'
MYSQL VS SQL SERVER (Use IE to view)
These assignments are in text format and include SQL code and the resulting output
using "PHPMyAdmin" or "Putty"; both are a LAMP (Linux, Apache, MySQL, PHP/Perl) testing server.
(*The SEMI-COLON symbol (;) may be absent in these text documents.
'Count 0,30' is part of MySQL compilation, not part of the SQL coding phrase.)
|
'Tutorial' Assignment Basic commands with existing tables in a database |
'Fruitcmds' Assignment This assignment uses a Linux interface with more basic commands - write comments regarding each query |
'Select' Assignment Queries for an existing table including count and sort |
'P 21' Assignment Querying with multiple commands and more than one table |
|
'P 58' Assignment Queries with database design fundamentals |
'P 87' Assignment Reviewing table data and creating tables |
'P 88' Assignment Multiple conditions and math |
'P 125' Assignment More math functions, and subqueries |
|
'P 157' Assignment Joining tables |
'P 177' Assignment Updating data including insert, delete, update, commit and rollback |
'PHPMyAdmin' Assignment Multiple functions and more advanced queries |
|