Course Code:
sqldedyk
Duration:
7 hours
Course Outline:
- Preferably MySQL
- Best business practices (examples preferably) to design database/pipelines for complex data processing
- focus on efficient processing (eg not storing more data than needed when processing, storing potential arguments in separate tables rather than hardcoded etc.)
- example of complex data pro/quering cessing pipelines - common errors with examples
- Manage big databases
- Security options for accessing data set on data level (not sure if avaliable in MySQL)
- This might be a BI solution allowing for some data filtering for, like query limiting visibility to logged user on the machine, or filter applied on data level)
- General best practices when building bigger databases/pipelines
- Working with protocul buffers (PROTO) (not sure if avaliable in MySQL)
- Quering Nested/Repeated Fields (not sure if avaliable in MySQL)
- Woriking with Arrays