SQL Fundamentals and Advanced Querying

Course Description

Upon successful completion of this course, students will be able to:

Target Audience

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Training Methodologies

Trainer

Training will be conducted by our experienced local trainer who has more than 10 years of experience with ACTA and MOS certification

Duration

2 Days

Time

9am to 5pm

Course Dates

Call for Dates

Course Fee

S$495.00

(Group Discount of 10% for 3 or more participants)

Training Venue

10 Anson Road #31-12
International Plaza
Singapore 079903

Available Funding

SDF Grant, UTAP Funding & SkillsFuture Credit

VTeach Pte. Ltd.

Tel: +65 6673 4479
admin@vteach.com.sg
www.vteach.com.sg

Course Content

Lesson 1: Executing a Simple Query

Lesson 2: Performing a Conditional Search

Lesson 3: Working with Functions

Lesson 4: Organizing Data

Lesson 5: Retrieving Data from Tables

Lesson 6: Presenting Query Results

Lesson 7: Using Subqueries to Perform Advanced Querying

Lesson 8: Manipulating Table Data

Lesson 9: Manipulating the Table Structure

Lesson 10: Working with Views

Lesson 11: Indexing Data

Lesson 12: Managing Transactions