Presentations used in the class are attached as files to this page
The presentation give an overview of what is possible with the SQL language. For a comprehensive list of features and functions look up The SQL Quick Reference For an Oracle specific view of the world look at Oracle 9i SQL Reference
Mini Assignment # 3 [ DUE 18th Feb 2008 / 9:30 AM ]
Create TWO blog posts
Part A :
Go to http://db.zoho.com and create a userid for yourself ( if you have a zoho id, you can use the same ) Create TWO tables ( eg EMPLOYEE, DEPARTMENT) Create THREE Select queries based on the examples given in the class. Publish the reports generated through these queries in your blog.
Part B :
List down the steps required to accomplish Part A. Level of detail should be such that someone with a basic idea of RDBMS / web can understand your instructions and perform the task.
Please enter the URL for your blog post through this form :
Refresh this page to confirm that your data is secure and accessible :