ANA104 – Database For Business Intelligence

Home

Unit code & Title	ANA104 - Database For Business Intelligence
Pre-requisite	Not Applicable
Delivery modes	On-campus; Online;
Credit points	10
Study commitment	Average of 150 hours of teaching, learning and assessment over the trimester.
Scheduled learning (On-campus)	2 × 3 hours on-campus seminar and tutorial weekly (for block mode)
Scheduled learning (AIA Online)	Recorded contents + 2 × 3 hour online seminar and tutorial weekly
Learning Outcomes	ULO1: Understand the concept, infrastructure, and essential components of relational databases. ULO2: Understand the rules and principles for designing relational data models. ULO3: Apply practical knowledge and skills in analysing and transforming business needs and problems into data models. ULO4: Design and implement database schemas with SQL and data modelling tools. ULO5: Deploy SQL skills to explore, manipulate, analyse, and report data addressing business problems. ULO6: Understand advanced concepts of transaction management and data integrity control of relational databases. ULO7: Understand the basic concept of Data warehouse and OLAP services. ULO8: Browse and analyse data from OLAP services and present insights to management audiences.

Overview

The purpose of this unit is to introduce the fundamental concepts of relational databases and develop database programming proficiency for students, with no prior programming background required. This course is designed to equip students with hands-on skills to work with databases, focusing on data analytics needs. Upon completion of this unit, students will have a working knowledge of databases and SQL (Structured Query Language) in a data science environment. They will learn how to access, design, create, query, explore, and analyze data from database instances using real-world datasets provided on relational databases (DB: MS SQL Server or MySQL + Excel). Advanced concepts such as transaction management, data integrity, Data Warehousing (DW), and online analytical processing (OLAP) services are also introduced to give students an overview of how different data storage platforms support data-driven decision-making in a business context.

Unit Fee Information

Fees and charges vary depending on the type of fee place you hold, your course, your commencement year, the units you choose to study and their study discipline, and your study load.

Tuition fees increase at the beginning of each calendar year and all fees quoted are in Australian dollars ($AUD). Tuition fees do not include textbooks, computer equipment or software, other equipment or costs such as mandatory checks, travel and stationery.

For further information regarding tuition fees, other fees and charges, invoice due dates, withdrawal dates, payment methods visit Current student page

Important Dates

Refer to Academic Calendar