DFU 2025 Recap Doc

Eksamensspørgsmål

• Eksamensspørgsmål

Ressourcer

• Docker composes med database
• DB-Engines
• SQL Server Management Studio
• SQL Sever (mssql) plugin for VS Code
• MySQL Workbench
• Normalformer

Undervisninggange

DFU 01

• Slideshow
• SQL Tutorial for Beginners

DFU 02

• Slideshow
• Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
• What is an Entity Relationship Diagram (ERD)?
• Opgaver 1NF
• Opgaver 2NF
• Opgaver 3NF

DFU 03

• Slideshow
• Opgaver Functions
• Opgaver Subqueries
• Opgaver Stored Procedures
• Opgaver Transactions

DFU 04

• Slideshow

DFU 05

• Slideshow
• The Art of Aggregating Data in SQL from Simple to Sliding Aggregations
• What Are Aggregate Functions in SQL, and How Do I Use Them?
• Improving performance with SQL aggregate functions
• Opgaver

DFU 06

• Slideshow
• Replication eksempel

DFU 07

• Slideshow
• Redis Explained
• What is Redis?
• Opgaver

DFU 08

• Slideshow (ved godt der står dfu 09 her, beholder navnet for referencer i ItsLearning)
• Database opgave

Afleverede databaser (forked fra studerendes projekter)

• Apache Cassandra
• Neo4j
• InfluxDB
• Nebula Graph

DFU 09

• Slideshow