- Course Lists
- Certified Ethical Hacker CEH
- Cert Incident Handler ECIH
- CCNA Security
- CompTIA Security+
- CompTIA CySA+
IT & Cyber Security
Database & Programming Course
Mobile App Programming
- Apple iOS App Programming
- Developing Android Apps
- Java Programming for Android
- Monetize Android Applications
- Android Security Essentials
- NICF - Intro to Networking
- IPv6 Fundamentals
- MCSA Windows Server 2012
- MCSE Windows Server 2012
- MS SQL Server 2012 - Database Administration
- MS SQL Server 2012 - Database Querying
Web Design & E-Commerce
- All-in-One Web Design
- Advanced Web Design
- Adobe Dreamweaver CS6
- Adobe Photoshop CS6
- Create Beautiful Web Design Using Wordpress
- Ecommerce - Set up Shopping Cart
- Course Schedule
- Course Registration
- About Us
Home > Course List > SQL Scripting > Understanding SQL Scripting
Understanding SQL Scriptingis now available as a SDF funded and SkillsFuture Funded course also known as NICF - SQL Scripting and Database Concepts
NICF - SQL Scripting and Database Concepts is a 3-day course which teaches database professionals about using SQL (Structured Query Language) to access and manipulate database. Usage of SQL statements to add, delete, insert, retrieve and update data in a SQL database will be covered.
You will create advanced SQL queries to manipulate and index tables. You will work with advanced queries to create and work with subqueries, creating and manipulating view and index tables.
You will learn how to do Table Design, creating tables with Constraints and Backing Up Tables. You will also create and committ transactions so that you can choose to save or cancel data entry process and learn rollback transactions.
Upgrade Path / Next Recommended Course: SQL Scripting (Advanced) 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
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
- Retrieving Data from Tables
- Advanced Querying
- Using Subqueries to perform Advanced Querying
- Data Modeling
- Manipulating Table Data
- Working with Views
- Indexing Data
- Managing Transactions
- Presenting Query Results
- Database Design Concepts
- Stored Procedures
Download Course Brochure for detailed course outline.
Course Fees (Applicable to Non-SDF/Foreigner) Course Title Normal Course Fees Promotional Course
Fees valid till
Promo 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
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 PRs
Incl Regn Fee
Excl GST 7%
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 & above
S$710.00 S$612.00 S$98.00 S$147.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 details
Self-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 © 2008
IT Enabler Consultancy Pte Ltd
(BRN/GST No: 200211025Z)
35 Selegie Road
Parklane Shopping Mall #09-06
Email : firstname.lastname@example.org