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 (enrol@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

    • Very Convenient location had a wonderful journey at VIT.


      - Ms. Christine G

    • Staff member specially Dhara was excellent.


      - Mr. Michael G

    • Flexible payment option and very supportive trainer.


      - Ms. Melissa C

    • especially Trainer Andrea was my favourite.


      - 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

    • It is a very enjoyable and informative class.


      - Mr. Sylvie T

    • Student Services was very supportive.


      - Mr. Li Y

    • Best education and Graduation Ceremony


      - Nabin Pun (BITS Graduate 2017)

    • Enjoyed the education journey and Good teaching staff


      - Pardeep Singh Dhillon (BITS Graduate 2017)

    • Everyone Friendly and Helpful @ VIT


      - Keshav Shrestha (BITS Graduate 2017)

    • Very supportive lecturers, best staff and organising commitees


      - Dhanuka Nilanjana (BITS Graduate 2017)

    • Graduation Ceremony the best and I enjoyed thoroughly


      - Sahil Sharma (BITS Graduate 2017)

    • Study environment @ VIT is best


      - Anjali Devi (BITS Graduate 2017)

    • Great inspiration by our Chairman and CEO of VIT


      - Lekhnath Sapkota (BITS Graduate 2017)

    Watch VIT Video

    International Overview