Materials for BIE-DBS course (winter semester 2011)

Aims – instalation and configuration of tools

• SQLDeveloper
• SQLDeveloper Data Modeller
• connecting to your Oracle account
• setting password

Account info Login: <your-CTU-login-name>

Passowrd: <your-system-password> ( info about passwords, get my system password)

DB server: oracle.fit.cvut.cz

Port: 1521

SID: ORACLE

If your account does not work, use (temporarly my accout valenta/valenta

Changing password on Oracle

everybody can change his/her oracle passord using following statement:

 alter user <your-user-name> identified by <your-new-password>;

semicolon is important, it finishes SQL statement

Tasks:

1. work with SQL Developer
   1. explore content of your database
   2. try to manipulate data through SQLDev interface
   3. try create tables from sample semestral project
   4. try import data from sample semestral project
2. work with SQL Developer Data Modeller
   1. try to create a logical scheme

RA exercises and solutions

ER exercises and solutions

SQL exercises and solutions