DB102: Database Systems - A Primer on Database Design, Development and Management (4 days)
Course Overview
This intensive course is designed to give the student a broad
understanding of the key aspects, issues, techniques, and products
related to modern database systems. The first half of the course
is devoted to gaining an appreciation of what database systems
are designed for, how they are structured, and how one models,
utilises and communicates with a database to store and retrieve
information. The second half of the course is devoted primarily
to database applications development for distributed environments
such as the Internet - focussing on Java, SQL and XML as key foundation
technologies. A primer on database management and administration,
and in particular database security and distribution is also presented,
along with a database systems product case study examing the Oracle
platform. The course includes exercises and examples to gain practical
experience with many of the concepts discussed.
Audience
Pre-Requisites
No prior experience with database systems is assumed although
any prior usage of databases will be beneficial, as will any modern
programming and/or systems design background.
Course Topics
- Basic Concepts
- Characteristics of Databases and Database Management Systems (DBMS)
- Design Overview
- Analysis & Data Modelling
- Entity Relationship Diagrams
- Normalisation
- SQL Introduction
- Data Description
- Data Manipulation
- Authorisation and Management
- Development
- Distributed Architectures
- Database Programming with Java and SQL
- Applications for the Internet
- XML
- Management Issues
- Data Concurrency and Consistency
- Data Integrity
- Security
- Distributed Databases
- Replication
- DBMS Product Case Study
- Oracle
|
