SQL developer assignment
generallala
w1_1.pptOutline of today’s session
- Welcome BIS234 Database concepts
- What is a database?
- Administration/using tablets
- Using Oracle
*
*
What’s the unit about?
- How to use, design and manage data in a relational database
*
*
What is a database?
- Collection of records
- An example of one: telephone book
Strengths and weakness
- Relational databases
Almost every database system
- Data, Information, Metadata
*
*
Administration
- Workshop
- Using the tablets
- Uses a learnline and unit website
*
*
Using the tablets
- Use as a tablet
- Look at unit resources
Activate account
Find unit outline and information
BIS234 LearnLine
Resource website
*
Source: Microsoft Clipart
Date: 23 January 2013
*
Relational database
- Keys
primary keys
foreign keys
- Relationships
1 to many/many to 1
*
Oracle
- Popular, commercially available DBMS
- Many different tools
- We will use SQL Developer
Graphical user interface
suitable for developers not end-users!
*
*
Structured Query Language (SQL)
- Standardised language used by all relational databases
- Can be used to
Create databases (DDL)
Change, enter and retrieve information (DML)
Control access to database (DCL)
*
Data Definition Language
Data Manipulation Language
Data Control Language
*
SELECT statement
- Retrieves information from tables in the database
SELECT columnlist
FROM tablename;
- Find ItemDesc for each Item
SELECT ItemDesc
FROM Item;
- Or for all the columns
SELECT *
FROM Item;
*
*
CDU Oracle set up
*
on a tablet or PC
Use SQL Developer to log on to database
redstart: home of Oracle DBMS
Oracle is on the server redstart
Source: Microsoft Clipart
Date: 23 January 2013
Source: CDU image library
Date: 23 January 2013
*
SQL Developer
- Start SQL Developer
(Start/Programs/Development/SqlDeveloper) - Login
username: sXXXXXX
password: MondaysXXXXXX - Or generic login
username: bis234
password: Mondaybis234
*
*
Enter your name
Check this box
Username: sxxxxxx
Password MondaysXXXXXX (with Capital M)
where XXXXXX is your student number.
Enter these values
Source: screen shot from lecturer’s computer
Date: 23 January 2013
Source: screen shot from lecturer’s computer
Date: 23 January 2013
1. Type your SQL commands here
2. Click the run button
3. Enlarge the results screen
Get your hands dirty
- Complete Get your hands dirty on Using a database/Using Oracle
*
*
