Leader: Peter FitzGerald

Lab Tutor: Jun He

Requirements: clients SQL*Plus (in the Software Hub), APEX (web-based)

EXAM WEEKs: 13, 25

Oracle Instant Client

Database Name: db1

Database Username: N0928518@db1

Database Password: HQMCQ4

peterf

What you should know

• Explain the tasks and demonstrate understanding of the problems involved in database administration, data definition and data manipulation

• Explain the principals and evaluate the characteristics of current types of DBMSs

• Explain the use of a current structured methodology in the development of a system

• Use a DDL/DML to construct relational databases and manipulate and manage data within these databases

• Analyse data requirements and formulate solutions using a DDL/DML

• Apply techniques from a current structured methodology to the analysis and design of information systems

WHAT SHOULD I KNOW FOR THE TEST

go on the lectures, on now at the end of each is a slide that says 'What you should now know for the labs and assessment'; BANG IT SAYS IT THERE retard

Free IDE here: https://livesql.oracle.com/apex

Content

Oracle SQL

Second Section

LABS