Jun Qi
          My name is Jun Qi, a student currently attends Massachusetts Academy of Mathematics and Science at Worcester Polytechnic Institute. I will become a senior in the fall of 2007. This summer, I started my internship at the Computer Science Department at Worcester Polytechnic Institute. The department offers research experiences for students from kindergarten to twelfth grade. My duties during this internship are concentrated in creating a project related to store and display database publications. The project, as a website itself, displays all DSRG (Database System Research Group) publications in table forms and allows users to add, update and delete their publications.

To create this project, I was assigned to read several comprehensive books, including Oracle 8i, Oracle 9i, JSP 2.0, and Programming World Wide Web, etc. Moreover, I also used online tutorials to enhance my understanding of database related programming. From this wonderful two-month internship at WPI, I learned how to use SQL (Structured Query Language) commands create tables, insert and select data in MySQL software. Moreover, I learned basic JSP (Java Server Page) syntaxes to create User Interfaces for WPI DSRG Web Page. With all this novel knowledge, I am able to accomplish my duty during this internship. I believe that interning at the Computer Science Department is a wondrous opportunity to gain excellent experiences and knowledge from the field of Computer Science.

What I have Learned from the Internship:
SQL syntaxes
MySQL syntaxes
Relational database
Unix Commands (cd, ln, ls, chmod)
JSP commands
JDBC
NetBeans Tutorial
Eclipse Tutorial
BibTeX
Triggers and sequences
Html and Javascript
 

 

Weekly Activities

        Below is the list of the books, online tutorials (URL) I have accessed to learn SQL, JSP, Database Management System during the passed two weeks.

 Books:

        Oracle 9i  Programming

o       Chapter 1 The Relational Data Model

o       Chapter 2 Oracle SQL

        A Guide to LATEX

o       Appendix B – Bibliographic Databases

        Oracle 8i – A Beginner’s Guide

o       Chapter 7 – SQL 101

        Database Management Systems

        JSP 2.0

        Programming the World Wide Web

 

URLs:

n      How to use Bibtex. (1994.) Retrieved July 4th, 2007,

n      Introduction to Developing Web Applications. Retrieved July 12, 2007,

n      Jacobson, Dana. (1996.) BibTeX. Retrieved July 3rd, 2007,

n      MySQL Basics -- A Helpful MySQL Tutorial. (2006). Retrieved July 16, 2007

   n Nested Tables and VARRAYS. (2000). Retrieved July 3rd, 2007, from           

 

SNAIL:

Computer Science Department Worcester Polytechnic Institute
100 Institute Road
Worcester, MA 01609

E-mail: junqi@wpi.edu

Working Hours
Monday- Friday 10am -6pm

 

Top Links