It is assumed in this course that participants have a basic knowledge of a computer operating system and basic operation.
This instructor led course aims to create, retrieve and manipulate objects in a relational database using ANSI standard Structured Query Language (SQL).a
Understanding relational database and connect to SQL database.
Querying records using SELECT statement
Using SQL Functions.
Manipulating 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
The course material will be provided.
1. If you want to schedule dates for the course, please contact us as we may be able to make adjustments to suit your requirements(firstname.lastname@example.org). 2. Courses are run subject to number of enrolments.
Let's get in touch
Give us a call or drop by anytime, we endeavour to answer all enquiries within 24 hours on business days.