This paper approaches the subject of databases from a practical perspective - how do I create a database and how do I retrieve/update data. Both aspects are heavily addressed in this paper. Database creation and querying, using SQL, will be introduced in lectures as you will master practical skills associated with a commercial Database product (Microsoft SQL Server). The paper also introduces Microsoft's extension to SQL, Transact-SQL, which provides a user interface to SQL Server. This is to promote both understanding and practice of the different tools used to build, access and maintain a database within a Client/Server database computing environment.
Paper Information
| Points: | 15.0 |
|---|---|
| Prerequisite(s): | COMP103 or COMPX101 or ENGEN103 |
| Internal assessment / examination: | 100:0 |
| Restriction(s): | COMP219 |
Note: The SEC occurrence of this paper is exclusively for Unistart students.
Trimesters and Locations
| Occurrence Code | When taught | Where taught |
|---|---|---|
| 24A (HAM) | A Trimester : 26 Feb 2024 - 23 Jun 2024 | Hamilton |
| 24A (SEC) | A Trimester : 26 Feb 2024 - 23 Jun 2024 | Secondary School - Unistart |
| 24A (TGA) | A Trimester : 26 Feb 2024 - 23 Jun 2024 | Tauranga |
Timetabled Lectures for Database Practice and Experience (COMPX223)
| Day | Start | End | Room | Dates |
|---|---|---|---|---|
| COMPX223-24A (HAM) | ||||
| Mon | 2:00 PM | 4:00 PM | L.G.03 | Feb 26 - Jun 2 |
| COMPX223-24A (TGA) | ||||
| Mon | 2:00 PM | 4:00 PM | TCBD.G.03 | Feb 26 - Jun 2 |
NB:There may be other timetabled events for this paper such as tutorials or workshops.
Visit the online timetable for COMPX223 for more details
Indicative Fees for Database Practice and Experience (COMPX223)
| Occurrence | Domestic | International | |
|---|---|---|---|
| Tuition | Resource | ||
| 24A (HAM) | $978 | $4604 | |
| 24A (SEC) | $978 | $4604 | |
| 24A (TGA) | $978 | $4604 | |
Paper Outlines
The following 2023 paper outlines are available for COMPX223. Please contact the Faculty or School office for details on 2024 outlines.
Additional Information
Available Subjects: Applied Computing | Computer Science | Data Analytics | Embedded Systems | Software Engineering
Other available years: Database Practice and Experience - COMPX223 (2023) , Database Practice and Experience - COMPX223 (2022) , Database Practice and Experience - COMPX223 (2021) , Database Practice and Experience - COMPX223 (2020) , Database Practice and Experience - COMPX223 (2019) , Database Practice and Experience - COMPX223 (2018)
Paper details current as of : 12 December 2023 8:52am
Indicative fees current as of : 12 December 2023 4:32am