ITS Databases – Introduction to databases

Documentation
Registration
Inscripció

Inscripció

Pas 1

Pas 2

    • Registration

      Attach documentation

      • To complete your registration and make it valid, we need you to attach the following documentation:

        E-mail address:

        Annex 1: download the document, fill it in and attach it.

        Download Annex 1

        DNI/NIE

        CV

        Last pay slip (only if you are an employee)

        Last payroll (Only if you are an employee)

        Dart (Only if you are unemployed)

        Document showing the number. of social security affiliation

        • Tuition fee
        100% subsidized

        Duration
        50 hours

        Dates
        From 26/09/2023 to 18/10/2023

        Opening hours
        From 18:00 to 22:00 h
        (One session will be face-to-face the day 26/09/2023)

        Methodology
        Virtual

        Location
        Llorens i Artigas, 12 – 08028 BCN

        Objectives

        Obtain basic knowledge on how to design and query relational databases, such as MySQL, Microsoft SQL-Server or Oracle.

        This training is oriented towards the preparation of the official certification IT Specialist: Databases.

        Minimum requirements

        Check the requirements to access the course here.

        Check the minimum technology requirements here.

        Contents

        1. Database design
        2. Management of database objects via DDL
        3. Data recovery.
        4. Data manipulation using DML
        5. Troubleshooting

        How to register

        To register you must fill in the form that you will find in the “registration” button and attach the following documentation:

        Complete and attach Annex 1 to the pre-registration form.

        • Photocopy of valid ID card.
        • Curriculum Vitae.
        • Photocopy of the last payroll in its entirety showing the following information: Social Security No. of the worker, Social Security No. of the company and CIF of the company (if you are in active employment).
        • Photocopy of the last receipt of self-employed (only if you are self-employed).
        • Photocopy of the updated DARDO (document of registration of job application to the Public Employment Service of Catalonia) (only if you are unemployed).
        • Photocopy of any document showing your Social Security affiliation number (only if you are unemployed).
        For more information
        logo-sepe-ministerio_9_1_2_0_3

          Information request

          For more information fill out the form below and we will contact you within 24 hours.

            Registration

            Attach documentation

              To finish formalizing your registration and for it to be valid, we need you to attach the following documentation:

              E-mail address:

              Annex 1: download the document, fill it in and attach it.

              Download Annex 1

              DNI/NIE

              CV

              Last pay slip (only if you are an employee)

              Last payroll (Only if you are an employee)

              Dart (Only if you are unemployed)

              Document showing the number. of social security affiliation

              Minimum technological requirements

              1. RAM Memory >= 8 GB. 6GB RAM it’s enough, but it’s note recommended.
              2. Processor Intel Core i5 (mid-range) or equivalent. With an Intel Core i3 (mid-range) or equivalent, it’s
              3. Internet connection (preferably via Ethernet cable or good signal Wifi ).
              4. Peripherials: keyboard, mouse, mic, web camera , loudspeakers/headphones.
              5. Computer equipment administration privileges .
              6. Specific software installation will be carried during the first formative sessions.
              7. 30GB disc free space (HDD/SDD).
              Operative system
              • Microsoft Windows >= 10 (x86_64)
              • macOS >= 12
              • Linux distributions:
                • Debian GNU/Linux >= 10
                • SUSE Enterprise Linux >= 12
                • Ubuntu LTS >= 18.04
                • Oracle Linux >= 6
                • CentOS >= 6
                • Red Hat Enterprise Linux >= 6

              Access requirements for participants

              In the event that no accreditations/qualifications are required, it is necessary to have sufficient linguistic communication skills to be able to take the course successfully.

              Accreditations/ Qualifications: Meet at least some of the following requirements:

              • Certificate of professionalism level 1
              • Basic Vocational Qualification (FP Básico)
              • Compulsory Secondary Education Graduate (ESO) or equivalent.
              • Technical degree (FP Grau Mig) or equivalent.
              • Level 2 Certificate of Professionalism
              • Have passed the entrance exam to Intermediate Level Training Cycles.
              • Have passed any official university entrance exams.

              Professional experience: Not required

              Others: Where the applicant does not have the required accreditation or qualification, he/she shall demonstrate the sufficient knowledge and competences through a competency test.

              Minimum requirements

              • Salaried female workers who work in private companies or public entities not included in the scope of application of the training agreements of public administrations and who pay Social Security contributions for Vocational Training.
              • Discontinuous permanent workers in periods of non-employment, people who become unemployed when they are in the training period or people under employment regulation in their periods of work suspension.
              • Unemployed female workers (limited places for all schemes per call).
              • Special scheme for self-employed persons.
              • Women workers in ERTO situations.
              • Female workers in the service of public administrations can only participate in the transversal training actions foreseen in base 2 of this annex, with a maximum limit of 10% of the total number of persons participating in the training programme.