Develop skills in data analysis and design using Unified Modelling Language (UML). Then move onto designing and writing queries. Develop core skills in Structured Query Language (SQL). Get hands on with UMLet and DBDesigner Fork.
Your upfront cost: $0
- 06 Apr 2020
The University of South Australia, UniSA, is ranked in the top 10 universities nationally and amongst the very best young universities in the world. They offer over 200 world-class degrees that are informed by industry and delivered with a highly practical approach to teaching and learning. In fact, they are South Australia’s number one university for graduate careers. They are a valuable partner with Open Universities Australia.
QS RANKING 2020
Times Higher Education Ranking 2020
By the end of this 10-week course, you’ll be able to:
- Explain how data is stored, interpreted and queried.
- Express and describe the structure of data.
- Design and structure information.
- Form database queries.
- Administer a database.
- Introduction to database fundamentals
- UML conceptual design – overview of key terms and notation
- UML – advanced relationships
- UML translation and implementation
- Consolidation week
- Relational database model
- SQL – Complex joins & intermediate queries
- SQL – Data manipulation (advanced)
- SQL – Database administration & access control, data security
- Review and viva
You must have successfully completed the following subject(s) before starting this subject:
No special requirements
The first five weeks of your course lays a solid foundation in database modelling and design.
Develop your skills in data analysis and data design using Unified Modelling Language (UML) class diagrams. Learn to map analysis outcomes to a Relational Database Schema and use your skills to implement a small relational database.
The second half of the course focuses on designing and writing queries. Develop core skills in Structured Query Language (SQL) and get hands-on experience with database technologies and tools such as UMLet and DBDesigner Fork. You’ll leave with the skills to undertake specialist analysis skills and produce analysis documentation.
UniSA Online’s 10-week short courses give you the flexibility to upskill in a certain area, stay current with developments in your field, diversify your knowledge, or even explore a new direction in your career – without having to commit to the time and cost of a full university degree.
Delivered 100% online, you’ll be able to study where and when it suits you. Access online academic and student support seven days a week, fit study around work and life commitments, view learning resources 24/7, and log in to the interactive online environment anywhere, any time and on any device.
This is a first year course from UniSA Online’s Bachelor of IT and Data Analytics degree.
- Assignment (60%)
- Programming (40%)
Check the learning management system (LMS) of your university for textbook details.