Introduction to SQL
About This Course
Course Objectives:
The learning objectives of this training programme is to identify data requirements and support the design of database models, incorporating parameters, fields and mechanisms for the maintenance, storage and retrieval of data using SQL. Upon successful completion of this training programme, learners should be able to acquire the following learning outcomes:
Learning Outcomes:
LO1: Learners will be able to identify the data requirement and draft database schemas.
LO2: Learners will be able to incorporate database fields and implement mechanisms for data retrieval.
LO3: Learners will be able to perform data warehousing and aggregation and translate project specifications into database structures.
What You'll Learn
The topics include:
LU1: Get Started on SQL
LU2: SQL Database Models
LU3: SQL Data Aggregation
Entry Requirements
The learners must declare their working experience and academic qualifications that validates their basic knowledge.
Knowledge and Skills
• Able to operate computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
• Positive Learning Attitude
• Enthusiastic Learner
Experience
• Minimum of 1 year of working experience.
• Minimum 18 years old