VIT/03/3015

Course Name: 
Database SQL
Course Type: 
Short Course
Course Category: 
Programming
Course Status: 
Current
Course Duration: 
0 Weeks
Delivery Locations: 
Melbourne City Campus
Course Fee (Domestic): 
AUD $799.00
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
Other  
Material The course material will be provided.
Dates

Course Schedule

Day/s

Time

Intakes – 2016

2 days

Monday to Wednesday

10 am to 5 pm

August 15 to August 16

2 days

Monday to Wednesday

10 am to 5 pm

August 29 to August 30

2 days

Monday to Wednesday

10 am to 5 pm

September 12 to September 13

2 days

Monday to Wednesday

10 am to 5 pm

September 26 to September 27

2 days

Monday to Wednesday

10 am to 5 pm

October 10 to October 11

2 days

Monday to Wednesday

10 am to 5 pm

October 24 to October 25

2 days

Monday to Wednesday

10 am to 5 pm

November 7 to November 8

2 days

Monday to Wednesday

10 am to 5 pm

November 21 to November 22

2 days

Monday to Wednesday

10 am to 5 pm

December 5 to December 6

2 days

Monday to Wednesday

10 am to 5 pm

December 19 to December 20

Please note :
1. If above mentioned scheduled dates for these courses are not suitable please contact us as we may be able to adjust to suit your requirements.

2. Courses are run subject to number of enrolments.