L3S Wiki

(A) SQL Reminder

(B) Overview of Database Management Systems

(C) Short tutorial of MySql

(D) Example Class

FOR ALL: How to Make Good Presentations

• Volunteers:
  • Martin Lemke
  • Jiankang Yuan
• Outline:
  • Present the most basic SQL commands.
  • Please include commands “select”, “delete”, “update”, “insert”, “create table”
• Links:
  • http://www.w3schools.com/sql/sql_quickref.asp
  • http://www.sqlcommands.net

• Volunteers:
  • Thomas Thiel
  • name 2
• Outline:
  • Present an overview of the capabilities/features provided by a couple of db systems.
  • Please include MySQL, Apache Derby, and Oracle or BerkeleyDB
• Links:
  • Apache Derby → http://db.apache.org/derby/
  • Oracle → http://www.oracle.com
  • MySQL → http://www.mysql.com/
  • BerkeleyDB → http://www.oracle.com/database/berkeley-db/je/index.html

• Volunteers:
  • Wei Chen
  • Verena Honsel
• Outline:
  • Present how to “install” and use MySQL
  • Please include basic commands, e.g., connect, list databases, use database
  • Please explain how we can create database, and new users
• Links:
  • MySQL Command-Line Tool → http://dev.mysql.com/doc/refman/5.0/en/mysql.html
  • MySQL Basics → http://www.analysisandsolutions.com/code/mysql-tutorial.htm#creating

• Volunteers:
  • Philipp Kemkes
  • Maximilian Sohrt
• Outline:
  • Make an example java class for connecting to a database. Derby or MySQL can be use for the database.
  • Please make methods for connecting to a database (DriverManager.getConnection()), inserting records (Statement executeUpdate), and reading records (Statement executeQuery and ResultSet)
• Links:
  • http://java.sun.com/developer/onlineTraining/Database/JDBCShortCourse/jdbc/jdbc.html
  • http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html#run_sample_app