On completion of this course, attendees will be able to use SQL to develop complete computer reporting systems without writing a line of programming code. You should come to this course if your work involves the storage and retrieval of lists of information capable of being queried through an SQL interface (Oracle, Ingress, Access etc).
1. Understand fundamental database concepts, relational tables, primary and foreign keys.
2. Describe the history of SQL.
3. Understand basic SQL structure and syntax.
4. Select simple record sets from tables.
5. Utilise SQL conditional operators.
6. Use statistical and grouping functions.
7. Create advanced multiple table queries involving both inner and outer joins.
There are no pre-requisites for this course.
(03) 6334 4910
Launceston Level 1 / 65 St John Street Launceston TAS 7250
Business owner, Manager, Project Manager, Director, Trades People, Tradesman, Administration, Accounts, Payroll, Receptionist, Builder, Plumber, Electrician
Jul 19th 2019 at 12:00 AM
This course is also available subject to customer demand.
Contact the training provider for more information.
7 hours per attendee
NDA Computing Pty Ltd
NDA services include computer training, management training, traineeships and qualifications, group training and training room hire. The company has training centres in Hobart, Launceston, and Devonport. NDA is 100% Tasmanian-owned and was established in 1985.
The services provided by NDA include:
Computer training - desktop, web, systems, programming and accounting software. Management training.
Traineeships and qualifications in business, business administration, human resources, training and assessment, frontline management, IT and project management.
Group training - the supply of NDA trainees who work in your organisation.
Training needs analysis.
Project management of training roll-outs.
Courseware development and technical writing.
Training room hire.
NDA is accredited by the ASQA as a Registered Training Organisation.
NDA is accredited by Skills Tasmania as a Group Training Organisation.
NDA operates from training centres in Hobart, Launceston, and Devonport.
(03) 6334 4910
Training providers are solely responsible for the quality and accuracy of content and delivery of training courses listed on the Industry Training Calendar. Keystone Tasmania provides the Training Calendar in good faith as a service to industry practitioners. Please note that by taking the option of applying for funding you are not securing a booking for the selected course. All bookings must be made directly with the training provider.