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.

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$612.00S$98.00S$147.70
    Non-SME CompanyS$710.00S$315.00S$395.00S$444.70
    Self-SponsoredS$710.00S$315.00S$395.00S$444.70*
     
    Mid-Career Enhanced Scheme (MCES)
    - Singaporean, 40 yrs & above
    S$710.00S$612.00S$98.00S$147.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-TIME11-Aug-202113-Aug-20219:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME13-Sep-202115-Sep-20219:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME20-Oct-202122-Oct-20219:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME1-Nov-20213-Nov-20219:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME1-Dec-20213-Dec-20219:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterSAT14-Aug-202128-Aug-20219:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterSAT9-Oct-202123-Oct-20219:30AM-5:30PM