Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
Data Technologies
Home
Workshops
1 - Basic SQL
Relational databases
Select
Joins
Data
Advancing
Resources
2 - Advanced SQL
Introduction
Views
CTE
Window Functions
Transactions
JSON
Full-text
Resources
3 - Database Design
Introduction
Conceptual design (ERD)
Physical design
Relations
Altering tables
Procedures & Triggers
Deleting tables
Security
Resources
4 - Normalisation
Introduction
Anomalies
Dependencies
Normal forms
Higher normal forms
Performance
Resources
5 - Optimalisation
Introduction
Indexing
Materialized Views
Partitioning
Query optimization
Caching
Resources
6 - NoSQL databases
Introduction
Types of NoSQL databases
Working with key value databases
Working with sets
Working with nummeric values
In memory databases
Using redis as message bus
Resources
7 - Key Value Databases
Introduction
Working with documents
Schema less in mongodb
Schema design principles
Indexes
Aggegration
Recourses
8 - Graph databases
Introduction
Working with graph queries
Properties on relationships
Modify relationships
Resources
9 - Security and Privacy
Introduction
Access Control
Row Level Security
Privacy and Anonymization
Resources
Git standaard workflow
Project Cases
Search Data Technologies
Workshops
6 - NoSQL databases
Workshop 6 - NoSQL databases
Introduction to NoSQL databases and Redis.
Table of contents
Introduction
Types of NoSQL databases
Working with key value databases
Working with sets
Working with nummeric values
In memory databases
Using redis as message bus
Resources