QF_Database System Assistant_CTS_NSQF-5.pdf

Database System Assistant (CTS)

  • Job DescriptionThe Database System Assistant installs Operating System and all other related application software; Configures network connection and browsing Internet. Creates, formats, edits  worksheet using Microsoft Excel. Creates customized database files using Microsoft Access. Designs and develops web pages using HTML / PHP. Installs and configures MySQL; Implements XML data and use it in SQL server. Designs online Database System using open source software tools. Secures Database System by applying Information Security, Security Threats, Security Vulnerabilities and Risk Management
  • CodeDGT/1110
  • SectorIT-ITeS
  • NSQF LevelLevel 5
  • Notional Hours2080
  • Accrediting BodiesDirectorate General of Training (DGT)
  • Certifying BodiesDirectorate General of Training (DGT)
  • Proposed Occupation

    Database System Assistant has a wide scope of Employability ranging from self-employment, contractual employment to Industrial jobs. On successful completion of this course, the candidates shall be gainfully employed in the industries for following occupations:

    • Database Administrator
    • Junior Data Associate
  • International Comparability

    1.  Existence of any official document suggesting the comparability of the qualification with the qualifications in other countries is not known.

    2.  However, ITI passed out trainees are getting employment in many Gulf countries, European countries, Australia, New Zealand, Singapore etc.

  • Progression Pathway

    Can join Apprenticeship programme in different types of industries leading to National Apprenticeship certificate (NAC).

  • Planned arrangements for RPL

    1.  Existence of any official document suggesting the comparability of the qualification with the qualifications in other countries is not known.

    2.  However, ITI passed out trainees are getting employment in many Gulf countries, European countries, Australia, New Zealand, Singapore etc

  • Qualification File QF_Database System Assistant_CTS_NSQF-5.pdf
  • Supporting Documents
  • Formal structure of the qualification
    Title of unit or other component Estimated size (Hours) Level
    Demonstrate various parts of computer system and practice with Microsoft Word. 40 5
    Familiarize with Operating System and practice with all the system application 80 5
    Install Operating System and all other related application software 40 5
    Configure network connection and browsing Internet 80 5
    Create, format, edit a worksheet using Microsoft Excel 80 5
    Create customized database files using Microsoft Access 80 5
    Design and develop web pages using HTML 120 5
    Design and develop web pages using PHP 160 5
    Install and configure MySQL; and practice on MySQL syntax for database design 200 5
    Create a table and manipulate data using query language 80 5
    Select data from table using ‘select’ query and maintain database 120 5
    Perform transactions in database using SQL programming 160 5
    Implement XML data and use it in SQL server 80 5
    Design an online Database System using open source software tools. 120 5
    Secure a Database System applying Information Security, Security Threats, Security Vulnerabilities and Risk Management 80 5
    Implement Database System backup and restoring backup 80 5
    Implement Database System security by creation of roles and functions for Database Users 80 5
    Configure and use Web Server, Reporting Services tools 80 5
    Revision, Project work and Examination 320 5
    Total 2080 5