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


Visitor count