Database Design and SQL

Out of stock

SKU
SC-40
Deepen your SQL skills in database design

This microcredential extends concepts introduced in Introduction to Database Design, with a focus on using SQL and PL/SQL, and the risks and ethical and social considerations relevant to designed systems.

This course may be stacked into a Master degree. 

$1,700.00

Key facts

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

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

Enquire now
Duration
4 weeks
Group Bookings
Enquire now
Prerequisite/s
Introduction to Database Design
Certification
Digital Credential

Why this course?

This microcredential builds on concepts covered Introduction to Database Design, and covers database implementation taking cyber risks into account.

 

Together with its companion course, this microcredential can be stacked into a subject for potential advanced standing n 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:

  • Normalisation and data manipulation using relational algebra and using the bottom-up approach of database design
  • Understanding the foundations of Structured Query Language (SQL), relational algebra and the basics of data manipulation
  • SQL applied practice and basic PL/SQL - code blocks and persistent objects
  • Evaluate the possible risks and ethical and social considerations relevant to designed systems.

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

Credit for study in this course may be available. This recognises prior study or learning that can be credited towards a qualification, thereby reducing the number of subjects required to complete a course. For further information refer to the advanced standing requirements.

You’ll learn:

This microcredential will enhance skills developed in Introduction to Database Design, and giver you skills to:

  • Implement database systems using SQL and advanced PL/SQL including stored procedures and triggers
  • Understand the underlying model of relational database operations using relational algebra
  • Evaluate the risks associated with databases.

Your study experience

The course is delivered online over a 4 week period, and the total expected time commitment for this course is up to 80 hours. 

 

The assessment for this course comprises:

  • Database design and implementation written assignment (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

Can payment of a course fee be made in instalments?

No, course fees need to be paid in full before you can commence the course.

I cannot pay by credit card. Are there other payment options available? 

To arrange payment by BPAY or EFT, please contact LaTrobeProfessional@latrobe.edu.au 

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

Access to courses is generally available two weeks in advance of the scheduled course start date, or as advised in the registration confirmation email.  Course materials are made available via our Learning Management System (LMS) for which you will be provided with your username and initial password.

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? 

Please visit our Student IT Support contact us webpage if you require assistance.

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

Contact LaTrobeProfessional@latrobe.edu.au for assistance registering multiple staff.