Contents

B461: Advanced Database Concepts

Fall 2009

Resources

• Course text web page.
  
  
• Oncourse: Oncourse
  
  
• If you are not familiar with latex, I recommend the book-lshort .
  
  
• The SQL tutorial in w3school.



• embedded SQL C(hand out of the class on 10/16/2008)



• SQL Server at IU homepage .



• Oracle at IUB help
  • Oracle at IU homepage.
  • Accessing Oracle on Steel

    Important: Your initial password is set to your IU network ID and the name of the database is oed1,i.e., you will initially login with
    username: netid@oed1
    password: netid
    where netid is your IU network ID. Please change your password after your first login.

  • Oracle 9i Online Documentation
  • Oracle for B561 primer
• Some Lecture Notes
• SQL Aggregation
• Query Optimization
• Relational Programming (PLSQL)
• Simple PLSQL examples
• Overview of PLSQL
• Cursors with parameters
• Embedded SQL Program in C
• Dynamic SQL



• Previous Assignments
• Fall 2007
• Assignment 1:
  • ER diagrams and the relational model
• Assignment 2:
  • Relational Algebra (Solutions)
• Assignment 3:
  • Formulating Queries (Solutions)
• Assignment 4:
  • Dynamic and PL/SQL (Solutions)
• Exercises for FDs, Normal Forms, Decompositions:
  • FDs, Normal Forms, Decompositions (Solutions)
• Assignment 5:
  • B+-Trees, Hash Tables, Query Evaluation (Solutions)
• Assignment 6:
  • Transaction Management, Concurrency Control, Crash Recovery. Solutions can be found here, here, and here.

---

The B461 web pages are maintained by Jeremy. If you notice problems or inconsistencies, send e-mail to .