•   Database Administration ELA18AM01-3002 27.09.2021-19.12.2021  4 credits  (ELA19D-V) +-
    Competence objectives of the study unit
    The student knows and can perform the tasks of a database administrator.
    The student can implement program code (procedures, functions, triggers) stored inside a database.
    The student knows the basic techniques of "business intelligence".
    Prerequisites
    Database programming.
    Content of the study unit
    Installation of database management systems and creating databases.
    SQL and SQL extensions.
    Server programming:
    - Stored procedures,
    - Functions,
    - Transactions and locking,
    - Triggers
    - Using server side code in client applications.
    Administration:
    - Users and user rights
    - Backup and recovery
    - Automation of administrative tasks
    - Import and export of data (ETL)
    - Performance optimization and the basics of monitoring.
    Business Intelligence:
    - Reports
    - Data analysis
    Assessment criteria
    Failed (0)
    studerandens kunskaper uppnår inte nivån för tillfredsställande vitsord (not translated)
    Assessment criteria – satisfactory (1-2)
    The student knows the database administrator's duties.
    The student can realize databases containing simple stored procedures, functions and triggers.
    The student knows the principles of reporting and data analysis.
    Assessment criteria – good (3-4)
    The student can perform the routine tasks of the database administrator.
    The student can realize databases with more advanced stored procedures, functions and triggers.
    The student can program client applications using server-side code.
    The student can realize and use databases for reporting and data analysis.
    Assessment criteria – excellent (5)
    The student can plan and configure the database administration for a database server and its databases.
    The student can create software for database applications in multi-user environments where transaction management and locking are needed.
    The student can plan, implement and use databases for data analysis.
    Name of lecturer(s)

    Ronnie Sundsten

    Learning material

    material inlänkat på Moodle (not translated)

    Learning methods

    föreläsningar, datorövningar (not translated)

    Objects, timing and methods of assessment

    godkänd tentamen
    godkända övningar (not translated)

    Teaching language

    Swedish

    Timing

    27.09.2021 - 19.12.2021

    Enrollment date range

    11.06.2021 - 27.09.2021

    Group(s)
    • ELA19D-V
    Responsible unit

    Faculty of Technology and Seafaring

    Small group(s)
    • ELA19-V-I (Size: 20.
    Teachers and responsibilities

    Susanne Österholm

    Degree Programme(s)

    Degree Programme in Electrical Engineering and Automation

    Campus

    Vasa, Wolffskavägen 33

    Assessment scale

    H-5

    Alternative methods of attainment for implementation

    godkänd tentamen, godkänd inlämningsuppgift (not translated)

    Exam dates and retake possibilities

    tentamen december 2021
    omtentamen 1 januari 2022
    omtentamen 2 våren 2022 (not translated)

    Timing and attendance

    hösten 2021, Vasa (not translated)

    Student's schedule and workload

    närstudier ca 48 h
    eget arbete ca 60 h (not translated)

    Assessment criteria
    Failed (0)

    studerandens kunskaper uppnår inte nivån för tillfredsställande vitsord (not translated)

    Assessment criteria – satisfactory (1-2)

    Studeranden känner till databasadministratörens arbetsuppgifter.
    Studeranden kan förverkliga enkla lagrade procedurer, funktioner och triggers i en databas.
    Studeranden kan producera enklare rapporter. (not translated)

    Assessment criteria – good (3-4)

    Studeranden kan utföra databasadministratörens rutinmässiga arbetsuppgifter.
    Studeranden kan förverkliga mera avancerade lagrade procedurer, funktioner och triggers i en databas.
    Studeranden kan producera rapporter samt utföra enkel data-analys. (not translated)

    Assessment criteria – excellent (5)

    Studeranden kan planera och konfigurera databasadministrationen för en databasserver och dess databaser.
    Studeranden kan skapa programvara för databasapplikationer i fleranvändarmiljöer där transaktionshantering och låsning behövs.
    Studeranden kan planera och förverkliga Business Intelligence i mindre skala. (not translated)