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 > NICF-SQL Scripting >
NICF - Understanding SQL Scripting and Database Concepts  

Course Objective:

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

 
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
    Part-Time : 6 sessions                                Time : 6.30pm - 10.00pm (twice a week)
    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
    • Practice LAB
    • Retrieving Data from Tables
    • Practice LAB

    Day 2 :

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

    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