Course Detail()

SkillsFuture Credit

14.00 CPE Hours (Category 1, Category 2, Category 3, Category 4Category 5, Others)
Classroom

 

Notice
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.

Programme Objective

After the course, participants will be able to:

  • Work with Excel and external databases such as MS-Access using SQL
  • Understand and use advanced Excel statistical and data manipulation functions for business analysis and reporting
  • Move datasets between MS-Access and MS-Excel
  • Understand the strengths and weaknesses in MS-Access, MS-Excel

Programme Outline

 

Understanding Data

  • Fundamentals of Data Analysis & Synthesis
  • Types of data
  • Developing a Data Analysis Strategy
  • Basic Data Analysis Techniques

Understanding database design basics

  • What are databases?
  • Introduction to data modeling
  • Organizing and manipulating the data in databases
  • Working with relational databases

Building and working with tables including linked tables

  • Creating Forms
  • Creating Queries
  • Reports
  • Sorting and Filtering Data
  • Viewing Data

Working with Tables

  • Customizing Tables
  • Formatting Tables
  • Controlling Table Data Entry
  • Managing Table Data Entry

Relational Database Basics

  • Brief history of SQL
  • Overview of relational databases
  • Anatomy of a relational database

Acquiring & Exporting Data

  • Methods of accessing data
  • Working with Access
  • Working with other DAO Databases

Excel and SQL

  • Connect from Excel to a database
  • Export: Query data into Excel
  • Excel database communication features, commands, etc.

SQL Basics

  • Terminology
  • Basic Select Statements
  • Select list
  • FROM clause
  • WHERE clause
  • ORDER BY clause
  • GROUP BY and HAVING clause
  • Subqueries
  • Joins

To view our full list of Infocomm courses, please click here.

Training Methodology
 
Lecture style, with computer hands-on Exercises
 
Closing Date for Registration

1 Week before Programme or Until Full Enrolment

Intended For

This course is useful for anyone who works with external relational databases and wishes to learn SQL to enhance on their data analysis, synthesis and reporting in Excel.

Schedule & Fees

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 15 Dec 2022
Course Reference Number: TGS-2020500387

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. You may wish to use your SFC to pay for partial/full ISCA course fees. 

On 1 Oct 2020, the Government provided a one-off SkillsFuture Credit Top-up of $500 for all eligible Singaporeans aged 25 or above by 31 Dec 2020. Singaporeans aged 40 to 60 by 31 Dec 2020 will also receive an Additional SkillsFuture Credit (Mid-Career Support) of $500 which can be used for courses under: (i) SGUnited Skills Programme, (ii) SGUnited Mid-Career Pathways Programme – Company Training, and (iii) Career Transition Programmes. This additional SFC (Mid-Career Support) is NOT applicable for use on ISCA courses. (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)

If you wish to enrol for the course with SFC Funding, please proceed with the following steps:

Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $42.80 for any revision of invoice.


2] WDA Training Grant - SDF Funding
This course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply). 

Funding Period: Until 15 Dec 2022
Funded Hours: 14 hours
Course Reference Number: TGS-2020500387

If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for WDA Funding?”, click Yes and input all required information. At the Cart page, please ensure that SDF funding is applied before clicking “Checkout”.
 

For course run start date before 1 Nov 2020, submit training grant application in SCN until 30 Nov 2020.

For course run start date on or after 1 Nov 2020, Enterprises/employers are NOT required to log into TPGateway/SCN to submit training grant.

Remarks

Step 2: After receiving email that the programme status is confirmed, please proceed to submit the Training Grant application via SkillsConnect Portal (https://www.skillsconnect.gov.sg/).

Employers of company-sponsored participants must submit training grant via SkillsConnect to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date.

The employee’s enrolment, attendance and assessment recordswill be submitted by ISCA onto TPGateway.


Please note that there will be an administrative fee of $42.80 for any revision of invoice.

Eligibility Criteria:

  • Company must be registered or incorporated in Singapore and;
  • Applicant is taking the course for the first time.
  • Applicant must be employed, and is either Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must achieve at least 75% attendance, and pass all examinations /assessments and;
  • Applicant must be fully sponsored by the Company for all costs associated with the training and;
  • Payment has to be made via corporate means (e.g. corporate cheque, corporate GIRO, corporate credit card).

Programme Facilitator(s)

 

Notice
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.

Programme Objective

After the course, participants will be able to:

  • Work with Excel and external databases such as MS-Access using SQL
  • Understand and use advanced Excel statistical and data manipulation functions for business analysis and reporting
  • Move datasets between MS-Access and MS-Excel
  • Understand the strengths and weaknesses in MS-Access, MS-Excel

Programme Outline

 

Understanding Data

  • Fundamentals of Data Analysis & Synthesis
  • Types of data
  • Developing a Data Analysis Strategy
  • Basic Data Analysis Techniques

Understanding database design basics

  • What are databases?
  • Introduction to data modeling
  • Organizing and manipulating the data in databases
  • Working with relational databases

Building and working with tables including linked tables

  • Creating Forms
  • Creating Queries
  • Reports
  • Sorting and Filtering Data
  • Viewing Data

Working with Tables

  • Customizing Tables
  • Formatting Tables
  • Controlling Table Data Entry
  • Managing Table Data Entry

Relational Database Basics

  • Brief history of SQL
  • Overview of relational databases
  • Anatomy of a relational database

Acquiring & Exporting Data

  • Methods of accessing data
  • Working with Access
  • Working with other DAO Databases

Excel and SQL

  • Connect from Excel to a database
  • Export: Query data into Excel
  • Excel database communication features, commands, etc.

SQL Basics

  • Terminology
  • Basic Select Statements
  • Select list
  • FROM clause
  • WHERE clause
  • ORDER BY clause
  • GROUP BY and HAVING clause
  • Subqueries
  • Joins

To view our full list of Infocomm courses, please click here.

Training Methodology
 
Lecture style, with computer hands-on Exercises
 
Closing Date for Registration

1 Week before Programme or Until Full Enrolment

Intended For

This course is useful for anyone who works with external relational databases and wishes to learn SQL to enhance on their data analysis, synthesis and reporting in Excel.

Programme Facilitator(s)


No course instances or course instance sessions available.