Victorian institute of technology (VIT)
Victorian institute of technology (VIT)

Programming |SQL | Database


Course Name SQL Programming
Course Code VIT/03/3015
Course Type Programming
Cost $799.00 Enrolment Form
Duration Two Days (10 Hours)
Prerequisites It is assumed in this course that participants have a basic knowledge of computer operating system and basic operation.
Outline This instructor lead course aims to create, retrieve and manipulate objects in a relational database using ANSI standard Structured Query Language (SQL).
Objectives
  • Understand relational database and connect to SQL database.
  • Query records using SELECT statement
  • Using SQL Functions.
  • Manipulate data with INSERT, UPDATE, DELETE statement.
  • Loading tables from external sources.
  • Controlling access to your tables and defining tables.
  • Creating tables view and other schema objects.
  • Selecting records from multiple tables.
  • Using Aggregate functions and other SQL advance techniques.
  • This course by default uses MS Access. Course can be customized to use MS SQL server or Oracle. Charges may differ. Please call VIT for further information.
  • Modules
    Material The course material will be provided.

    Please note :
    1. If you want to schedule dates for the courses. Please contact us as we may be able to adjust to suit your requirements (info@vit.edu.au).

    2. Courses are run subject to number of enrollments.

    Testimonials

    • “I benefitted greatly from this course while still working in the workplace (restaurant).”


      - Kishan S

    • I was very happy with my time at VIT studying hospitality. I don’t think there is anything I would change, everything was good”


      - Vijay S

    • Excellent trainer, thoroughly enjoyed the course. Was well paced and time went quickly. Appreciated being able to complete some projects as a group in class, venue convenient and all facilities required were available


      - Ms. Christine G

    • Very good relationships developed from the beginning. Staff members have been fantastic even before commencement of the course. They made my time in class informative and pleasurable


      - Mr. Michael G

    • Very well structured course. I have got a lot out of this course and looking forward to putting my new skills and knowledge to work –


      - Ms. Melissa C

    • First time I have had such a positive, intelligent and charismatic trainer. He has a talent for training and made a challenging course achievable with his attitude and advice. I would definitely like to study with him in future on another course and have enjoyed the time


      - Mr. Jason P

    • Fantastic opportunity to be a student of VIT. Excellent trainer and best Administrator, thanks for their help and support


      - Ms. Ramanpreet P

    • The course was very good. Trainer was fantastic and was flexible and informative


      - Ms. Rebecca B

    • So far the course has been fantastic with a patient and understanding teacher.  The course is very informative and helpful with my current job.


      - Mr. Chris C

    • The written information I found to be useful, well written, concise. The instructor was very helpful in any difficulties that I experienced. Also very knowledgeable and very communicative. I would recommend this course.


      Web theme by Online Pokies website where you can play pokies online for free via this online pokies websites


      - Mr. Effie S

    • It is a very enjoyable and informative class.


      - Mr. Sylvie T

    • The course gave me confidence though it was a little challenging. My teacher was friendly and very helpful.


      - Mr. Vincen R

    • My English teacher is responsible and patient who uses simple ways to help us understand English words.


      - Mr. Yuwen Z

    • Our English teacher is a nice person who is patient, responsible and kind.


      - Mr. Li Y

    Watch VIT Video

    International Overview

    //