itEnabler
+CISCO
+Android Programming Course
+SQL Scripting
+MS SQL Server 2012
- MS SQL Server 2012 Database Administration
- MS SQL Server 2012 Database Querying

+Oracle Database SQL
- Oracle Certified SQL Expert

+ITIL
+VBA Excel / Access / Word
+Web Design & Ecommerce
+Web Development &
  Programming

- SQL Scripting
- Adv SQL Scripting
- Javascript
- HTML5 with JavaScript and CSS3
+Microsoft Infrastructure Certification

CompTIA Courses


+

Basic Networking & IC3 Courses



Register Courses at IT Enabler
Home > Course List > SQL Scripting >
Understanding SQL Scripting  

Course Objective:

Understanding SQL Scripting

is 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
    Day 2 :
    • Advanced Querying
    • Using Subqueries to perform Advanced Querying
    • Data Modeling
    • Manipulating Table Data
    • Working with Views
    • Indexing Data
    Day 3 :
     
    Course Fees (Applicable to Non-NICF/Foreigner)
    Course Title Normal Course Fees Promotional Course
    Fees valid till
    31-Dec-2017
    Promo Course Fees w GST
    NICF - Understanding SQL Scripting and Database ConceptsS$1,398.00S$640.00S$684.80
    Registration FeeS$30.00S$30.00S$32.10
    Total FeeS$1,428.00S$670.00S$716.90

    Government Funding
    Course is eligble for SDF Training Grant & Absentee Payroll from WDA. 
    Course is eligible for PIC Grant from IRAS. 
    Self-Sponsored trainee may use their SkillsFuture Credit Claim to offset the course fee payable. 
    Terms and conditions apply. 

    NICF Course Title : NICF - Understanding SQL Scripting and Database Concepts
    Course Ref No. : CRS-Q-0027954-IT

    NICF Funding Course Fees
    NICF 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$670.00S$576.00S$94.00S$140.90
    Non-SME CompanyS$670.00S$300.00S$370.00S$416.90
    Self-SponsoredS$670.00S$300.00S$370.00S$416.90*
     
    Mid-Career Enhanced Scheme (MCES)
    - Singaporean, 40 yrs & above
    S$670.00S$576.00S$94.00S$140.90*
     
    Workfare Trainig Support(WTS)S$670.00S$608.00S$62.00S$108.90*
     
    Note: * - SkillsFuture Credit 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)

    Course Title   Venue Register Online
    Course Mode
    Start Date
    End Date
    Time
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME3-Jan-20185-Jan-20189:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME26-Feb-201828-Feb-20189:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME21-Mar-201823-Mar-20189:00-6:00PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME9-Apr-201811-Apr-20189:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME2-May-20184-May-20189:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterFULL-TIME11-Jun-201813-Jun-20189:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterSAT20-Jan-20183-Feb-20189:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterSAT14-Apr-201828-Apr-20189:30AM-5:30PM 
    NICF - Understanding SQL Scripting and Database ConceptsSingaporeRegisterSAT14-Jul-201828-Jul-20189:30AM-5:30PM