Statement of Attainment in Database Fundamentals

 
Qualification:
Statement of Attainment   NRT
Course no:
TTPCRE0136
Start date:
To be advised
 –   Ultimo
  • Expand all
  • Database Fundamentals course details

    Course description and aims

    This course will offer an overview of the fundamental aspects of data persistence, manipulation and management with relational databases. We have selected Microsoft SQL Server as the Relational Database Management System (RDBMS) to demonstrate the core concepts. The following topics will be covered:

    1. Data Models
    2. Data Definition Language
    3. Data Manipulation Language
    4. Conceptual Modelling
    5. Logical Modelling
    6. Normalisation

    Course outcomes and careers

    Systems Analysis and Design

    Recommended Pathways

    This is part 2 of a 4 part bridging course suite in preparation for Diploma of Systems Analysis and Design or Advanced Diploma of Business Analysis.

    Skill sets

    Basic understanding of concepts and techniques in Database design as required in the skill set for an occupation in the field of System Analysis and Design.

    Entry requirements

    There are no entry requirements for this course.

    This course is available to Australian Citizens or Australian Permanent Residents who are over 15 years of age, have left school and live or work in NSW.

    Enrol at any location

    Ultimo
    Part Time Day
    Course start:
    Fri 23 Mar 2018
    Course duration:
    4 Weeks
    Attendance:
    6 Hours per week
    Code:
    TTPCRE0136-18ULT-335
    View details
    About offering:

    INFORMATION SESSION

    Attend the following information session to meet with the teaching staff, discuss the course and get more information about enrolment and next steps.

    Wednesday, 7 February 2018 at 2:00pm or 6:00pm at Ultimo Campus, Thomas Street Ultimo, Building G, Ground level, Room GG.19.

    Indicative timetable:

    You will need to attend approximately 6 hours of class over 1 day per week for four weeks. An indication of how your weekly timetable may look is: Friday, 10:00am to 4:30pm.

    How to enrol or apply:

    To apply for this course you must meet the Smart and Skilled eligibility criteria: http://www.sydneytafe.edu.au/courses/smart-skilled

    GET YOUR UNIQUE STUDENT IDENTIFIER (USI)

    Before you enrol you must have a Unique Student Identifier (USI). Visit http://www.usi.gov.au/students/create-your-usi to request a USI. Remember to add Sydney TAFE to your account via the Manage Permissions page (code: 90003, name: TAFE NSW - Sydney Institute).

    Find out more about applying and enrolling: http://www.sydneytafe.edu.au/courses/applying-and-enrolling

    Fee information:

    FULLY GOVERNMENT SUBSIDISED

    This course is fully government-subsidised for eligible students, meaning you won't have to pay any course fees. It is part of a program to help people develop the skills they need to get a job, undertake entry level qualifications or transition to a new job.

    Subjects

    NumberSubject nameNominal hours
    ICTDBS412Build a database30
    ICTPRG425Use structured query language60

     

     

    Got questions? Need help?

    Scholarships

    Female students at Sydney TAFE

     

    A scholarship can help with fees and related study expenses.
    Find out if you are eligible.