NICF - Intro to SQL Scripting


Duration : 3 Days (21hrs) / 9.30am-5.30pm

Course Summary

    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.

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
  • Create and use views that satisfy information requirements
  • Create use or drop stored procedures according to information requirements.
  1. Home
  2. Database Course > NICF - Intro to SQL Scripting

Course Information

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.
  • create and use views that satisfy information requirements
  • create use or drop stored procedures according to information requirements.


    • Download course brochure

    Course Fees & SkillsFuture Funding


    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 PRs    		 Total Fee
    Incl Regn Fee    		 Less
    SDF Training
    Grant    		 NETT
    Fee
    Excl GST 7%    		 NETT
    Fee
    Incl GST 7%
    SME Company S$710.00S$476.00S$234.00S$283.70
    Non-SME CompanyS$710.00S$340.00S$370.00S$419.70
    Self-SponsoredS$710.00S$340.00S$370.00S$419.70*
     
    Mid-Career Enhanced Scheme (MCES)
    - Singaporean, 40 yrs & above     		S$710.00S$476.00S$234.00S$283.70*
     
    Note: * - SkillsFuture Credit Claims or/and PSEA may be used to offset the course fees.
    Course Fees (Applicable to Non-SDF/Foreigner)
    Course Title Normal Course Fees Promotional Course
    Fees valid till
    31-Jul-2021    		 Promo Course Fees w GST
    NICF - Understanding SQL Scripting and Database ConceptsS$799.00S$680.00S$727.60
    Registration FeeS$30.00S$30.00S$32.10
    Total FeeS$829.00S$710.00S$759.70


    (Contact Customer Service @ 6333 4843)

    Course Prerequisite

    No prerequisite required. Some database concepts and basic programming knowledge an added advantage

    Course Outline

    1.0 Introduction to SQL Scripting

  • Database Concepts and DBMS
  • DBMS Fundamentals
  • Types of Database
  • Executing a simple Query
  • Performing a Conditional Search
  • Working with Function
  • Organizing Data
  • Retrieving Data from Tables

    • Download course brochure

    2.0 Advanced SQL and DDL

  • Advanced Querying
  • Using Subqueries to perform Advanced Querying
  • Data Modeling
  • Manipulating Table Data
  • Working with Views
  • Indexing Data

    • 3.0 DDL, Transactions and Store Procedure

  • Managing Transactions
  • Presenting Query Results
  • Database Design Concepts
  • Stored Procedures

    • Course Schedule

    Course Title   Venue Register Online
    Course Mode
    Start Date
    End Date
    Time
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME21-Dec-202223-Dec-20229:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME4-Jan-20236-Jan-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME1-Feb-20233-Feb-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME15-Mar-202317-Mar-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME4-Apr-20236-Apr-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME3-May-20235-May-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME19-Jun-202321-Jun-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME10-Jul-202312-Jul-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME2-Aug-20234-Aug-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME13-Sep-202315-Sep-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterSAT11-Feb-202325-Feb-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterSAT8-Apr-202329-Apr-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterSAT29-Jul-202312-Aug-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterSAT14-Oct-202328-Oct-20239:30AM-5:30PM