- Quick Links
- Course Schedule
- Course Registration
- About Us
Home > Course List > NICF-SQL Scripting > NICF - Understanding SQL Scripting and Database Concepts 
Course Objective:
At the end of the course, participants will be able to write to SQL statements and sub-queries based on the requirements of database structures, create and manipulate database tables based on the requirements of database structures. Participants will also learn to create and use views that satisfy information requirements and create use or drop stored procedures according to information requirements.This course teaches participants the knowledge and skills to use SQL (Structured Query Language) to access, define, create and manipulate database. Usage of SQL Statements to add, delete, insert, retrieve and update data in a SQL database.
Prerequisite: No prerequisite required. Some database concepts and basic programming knowledge an added advantage.
Certificate Of Attendance: Certificate Of Attendance will be awarded to participants completing the course.achieving minimum 75% attendance.
Training Methodology & Materials: - Practical case study sessions to enhance concept.
- Well-designed lab sessions to further enhance the understanding of the courseware given.
Training Duration: Full-Time : 3 weekdays / 3 Sats Time : 9.30am - 5.30pm
Part-Time : 6 sessions Time : 6.30pm - 10.00pm (twice a week)Course Outline: Day 1 : - Database Concepts and DBMS
- DBMS Fundamentals
- Types of Database
- Executing a simple Query
- Performing a Conditional Search
- Practice LAB
- Working with Function
- Organizing Data
- Practice LAB
- Retrieving Data from Tables
- Practice LAB
Day 2 :
- Advanced Querying
- Using Subqueries to perform Advanced Querying
- Practice LAB
- Data Modeling
- Manipulating Table Data
- Practice LAB
- Working with Views
- Indexing Data
- Practice LAB
Day 3 :
- Managing Transactions
- Presenting Query Results
- Practice LAB
- Database Design Concepts
- Stored Procedures
- Practice LAB
Download Course Brochure for detailed course outline.
Course Fees (Applicable to Non-SDF/Foreigner) Course Title Normal Course Fees Promotional Course
Fees valid till
31-Dec-2019Promo Course Fees w GST NICF - Understanding SQL Scripting and Database Concepts S$799.00 S$680.00 S$727.60 Registration Fee S$30.00 S$30.00 S$32.10 Total Fee S$829.00 S$710.00 S$759.70
Government Funding
Course is eligble for SDF Training Grant & Absentee Payroll from SSG.
Self-Sponsored trainee may offset course fee payable using their SkillsFuture Credit Claim or/& PSEA (subject to available balance in trainee's account).
Terms and conditions apply.
SDF Course Title : Understanding SQL Scripting and Database Concepts (SF)
Course Ref No. : CRS-Q-0031866-ICT
WSQ Funding Course Fees WSQ Funding
Singapore Citizens & Singapore PRsTotal Fee
Incl Regn FeeLess
SDF Training
GrantNETT
Fee
Excl GST 7%NETT
Fee
Incl GST 7%SME Company S$710.00 S$612.00 S$98.00 S$147.70 Non-SME Company S$710.00 S$315.00 S$395.00 S$444.70 Self-Sponsored S$710.00 S$315.00 S$395.00 S$444.70* Mid-Career Enhanced Scheme (MCES)
- Singaporean, 40 yrs & aboveS$710.00 S$612.00 S$98.00 S$147.70* Workfare Trainig Support(WTS) S$710.00 S$646.00 S$64.00 S$113.70* Note: * - SkillsFuture Credit Claims or/and PSEA may be used to offset the course fees.
- Singapore Citizens & Singapore PRs
- Terms and conditions apply
- Please visit www.skillsconnect.gov.sg for more detailsSelf-Sponsored trainees may use their SkillsFuture Credit Claim to offset the NETT Course fee and it's associated GST.
Download Course Brochure (Contact Customer Service @ 6333 4843)
Copyright © 2008IT Enabler Consultancy Pte Ltd (BRN/GST No: 200211025Z) |
Address:
35 Selegie Road Parklane Shopping Mall #09-06 Singapore 188307 |
Telephone:
6333 4843 |
Fax
No: 6333 4883 |
Email
: customerservice@ienabler.com.sg |