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
2 - Advanced SQL
Workshop 2 - Advanced SQL
Advanced SQL concepts including views, CTEs, window functions, and more.
Table of contents
Introduction
Views
CTE
Window Functions
Transactions
JSON
Full-text
Resources