====== Materials for BIE-DBS course (winter semester 2011) ======


===== The first computer lab - acount info, tools =====
**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> ([[http://it.fit.cvut.cz/doku/doku.php?id=en:start#usernames_and_passwords | info about passwords]], [[https://it.fit.cvut.cz/umap/syspwd.php | 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:

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

// semicolon is important, it finishes SQL statement //

**Tasks:**

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

===== Relational algebra =====
[[fit:bie-dbs:seminars:ra|RA exercises and solutions]]
===== ER Model =====
[[fit:bie-dbs:seminars:er|ER exercises and solutions]]
===== SQL =====
[[fit:bie-dbs:seminars:sql|SQL exercises and solutions]]