Introduction to Database Design

Out of stock

SKU
SC-39
Design databases to support effective data management.

Learn how to design a relational database to ensure your data is organised in a way that is easily understood by a range of audiences.

This course may be stacked into a Master degree. 

$850.00

Key facts

Course category
Information Technology and Cybersecurity, Introductory Courses, Master Microcredentials, Programming and Application Development
Options

Please submit an enquiry to express an interest or to request further information.

Enquire now
Duration
2 weeks
Group Bookings
Enquire now
Prerequisite/s
There are no prerequisites for this short course
Certification
Digital Credential

Why this course?

This microcredential is designed for people with no prior experience in database design, and covers key skills in how to structure data so that it delivers value for your organisation.

 

Together with its companion course, Data Design and SQL, this microcredential can be stacked into a subject for potential advanced standing in the Master of Cybersecurity.

Why study a short course at La Trobe

Industry experience while you study

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Rising demand

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Powerful Collaborations

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Course content

Topics include: 

  • Data normalisation and manipulation using relational algebra
  • Structured Query Language (SQL) - creating database ojects through Data Definition Language (DDL) and how to insert, update, delete and query data using Data Manipulation Language (DML)
  • SQL applied practice and the basic structure of PL/SQL code blocks and persistent objects.
  • Stored procedures, functions and triggers in PS/SQL.

On successful completion of this course, you wil be awarded a digital credential and earn 5 credit points that can be accumulated with its partner course, Database Design and SQL, to stack into 'Database Fundamentals (CSE4DBF)', a subject within the Master of Cybersecurity. 

You’ll learn:

This microcredential will equip you with basic skills in:

  • Designing a relational database using an Entity Relationship (ER) or Enanced Entitiy Relationship (EER) model
  • Using a transformation process to map the ER or EER diagram to a relational database design
  • Evaluating database design in terms of data anomalies and redundancies and applying the appropriate normalization techniques
  • Evaluating the possible risks and ethical and social considerations relevant to designed systems.

 

Your study experience

This course is delivered online with live sessions, over a 2 week period.  The total time commitment for this course is up to 40 hours, which inlcudes the live sessions, extended reading and assessment.

 

The assessment for this course comprises:

  • A written assignment - database conceptual design (40%)
  • Online exam (60%).

 

Frequently Asked Questions

Proin eleifend arcu eros, id porta libero imperdiet quis. Nam sed orci sit amet quam faucibus vestibulum. In luctus metus enim.

Find out more about further education at La Trobe  View all FAQ

I would like information about a short course. Who can assist me?  

Email: LaTrobeProfessional@latrobe.edu.au 

Phone: 1300 135 045

I have paid the fee for a short course. When will I be able to access it?  

On completion of your registration, you'll be provided with an account on our Learning Management System (LMS) and the course material will be made available at the advertised date, or as outlined on your registration confirmation email.  For our on-demand courses, access will be immediate.

What payment options are there?

  • You may arrange to pay by BPAY or EFT
  • For group bookings, we encourage purchase orders.  Contact us for a quote, and upon receipt of your purchase order we can make the course available to you.
  • Unfortunately, we are not able to arrange instalment payments.

Contact us on LaTrobeProfessional@latrobe.edu.au for assistance. 

Can I arrange payment with a Purchase Order?

Yes, we accept Purchase Orders. Please email to LaTrobeProfessional@latrobe.edu.au and our La Trobe Professional team will provide you with payment details and access to your course. 

I am getting an error when I try to log into my LMS account. Can you help? 

  • The first thing to check is your order confirmation email - it will contain your Learning Management System (LMS) account and password.  Note that this account may not be the same as your staff, student or previous short course participant account. 
  • The second thing to check is that you're logging on as a short course participant and not as a student - choose 'Other Users' - select Short Course as your institution and use your account and password as provided.

If you need any assistance, contact us on LaTrobeProfessional@latrobe.edu.au. 

I want to enrol multiple staff in a short course. How do I go about this? 

Contact LaTrobeProfessional@latrobe.edu.au so that we can discuss options with you.  

What certification will I receive?

The type of certification depends on the assessment involved in the course. For example:

  • Microcredentials:  You will receive a digital credential that confirms the skills you’ve acquired, any assessments you’ve completed and potential pathways for credit or advanced standing towards a degree. 
  • Other assessed short courses:  This may include bridging programs or courses that prepare you for external certification from a professional body.  You might receive a certificate of achievement or a digital badge (a digital version of a certificate of achievement).
  • Non-assessed courses:  If a course doesn’t involve formal assessment, you’ll receive a certificate of attendance.
  • Single-subject enrolment: If you enrol in a single subject, you will receive an official transcript for that subject.

Please note that short courses or microcredentials are not formal qualifications under the Australian Qualifications Framework but may be eligible for consideration as advanced standing (credit) towards a degree.

What is a microcredential? 

Microcredentials are short courses that are assessed, carry academic credit, and to deliver specific skills or knowledge.  While they can be taken as standalone courses, many are designed to be combined or ‘stacked’ with other microcredentials to form the equivalent of a subject within a degree program.  Upon successful completion, you’ll earn a digital credential that outlines the skills and credit obtained, and any opportunities for stacking.

For La Trobe microcredentials, any advanced standing or stacking pathways are clearly expressed on the course page.   

What is advanced standing?

Advanced standing refers to credit for prior study or formal learning that can be credited towards a qualification, thereby reducing the number of subjects required to complete a course. For short courses or microcredentials (if these have been completed through recognised institutions or platforms and are deemed equivalent to La Trobe University subjects), credit may be granted either for specific La Trobe subjects or as unspecified credit towards elective requirements of a La Trobe course.

For La Trobe microcredentials, any advanced standing or stacking pathways are clearly expressed on the course page.   Upon successful completion of the course, you’ll receive a digital credential, which may be used when applying for credit for the relevant degree at La Trobe.

For more details, visit the University’s advanced standing web page.