•   Database Administration ELA22AM01-3001 30.09.2024-22.12.2024  4 credits  (ELA22D-V) +-
    Competence objectives of the study unit
    The student:
    - can plan and realize a database system
    - knows and can perform the tasks of a database administrator
    - can implement program code (procedures, functions, triggers) stored inside a database
    - knows the basic techniques of "business intelligence".
    Prerequisites
    Database programming.
    Content of the study unit
    Installation of database management systems and creating databases.
    Advanced SQL.
    Code inside databases.
    Database 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
    - Simple 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 on Moodle.

    Learning methods

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

    Objects, timing and methods of assessment

    godkänd tentamen
    godkända uppgifter/godkänd inlämningsuppgift (not translated)

    Teaching language

    Swedish

    Timing

    30.09.2024 - 22.12.2024

    Enrollment date range

    15.06.2024 - 29.09.2024

    Group(s)
    • ELA22D-V
    Responsible unit

    Faculty of Technology and Seafaring

    Small group(s)
    • ELA22-I (Size: 40.
    Teachers and responsibilities

    Susanne Österholm

    Degree Programme(s)

    Degree Programme in Electrical Engineering and Automation

    Campus

    Vasa, Wolffskavägen 33

    RDI share

    0.00 credits

    Share of online studies

    0.00 credits

    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 2024
    omtentamen 1 januari 2025
    omtentamen 2 våren 2025 (not translated)

    Timing and attendance

    hösten 2024, 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)