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 SkillsFuture Course Fee Funding & 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. 

    SkillsFuture Course Title : Understanding SQL Scripting and Database Concepts (SF)
    Course Ref No. : TGS-2018500699

    WSQ Funding Course Fees
    WSQ Funding for
    Singapore Citizens & Singapore PRs
    Total Fee
    Incl Regn Fee
    Less
    SkillsFuture
    Course Fee Funding
    NETT
    Fee
    Excl GST 8%
    NETT
    Fee
    Incl GST 8%
    SME Company S$730.00S$476.00S$254.00S$312.40
    Non-SME CompanyS$730.00S$340.00S$390.00S$448.40
    Self-SponsoredS$730.00S$340.00S$390.00S$448.40*
     
    Mid-Career Enhanced Scheme (MCES)
    - Singaporean, 40 yrs & above
    S$730.00S$476.00S$254.00S$312.40*
     
    Note: * - SkillsFuture Credit Claims or/and PSEA may be used to offset the course fees.
    Course Fees (Applicable to Non-SkillsFuture Trainee/Foreigner)
    Course Title Normal Course Fees Promotional Course
    Fees valid till
    30-Jun-2023
    Promo Course Fees w GST
    NICF - Understanding SQL Scripting and Database ConceptsS$799.00S$680.00S$734.40
    Registration FeeS$50.00S$50.00S$54.00
    Total FeeS$849.00S$730.00S$788.40


    (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-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 ConceptsSingaporeRegisterFULL-TIME18-Oct-202320-Oct-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME22-Nov-202324-Nov-20239:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME11-Dec-202313-Dec-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