# Blackbelt 2.0 - Databases
Senseis:
* Angie Nobre
* Matheus Arrais
* Murilo Nascimento

# **Links Uteis**
* AWS Database Blog: https://aws.amazon.com/blogs/database/
* AWS Blogs em Pt: https://aws.amazon.com/pt/blogs/database/

* Partner Training: https://aws.amazon.com/pt/partners/training/

* AWS Samples: https://github.com/aws-samples

* Página de Database da AWS (aceitamos dicas de revisão de tradução!): https://aws.amazon.com/pt/products/databases/?nc1=h_ls

# **Dia 1** - 18 de Agosto
Video Reinvent 2018 - https://youtu.be/-pb-DkD6cWg?t=1304
Feedback pro Dia 1: https://amazonmr.au1.qualtrics.com/jfe/form/SV_0upXQaQJ6t6f1jf

# **Dia 2** - 19 de Agosto

### **DocumentDB**
1. Página do Serviço: https://aws.amazon.com/documentdb/
2. FAQ: https://aws.amazon.com/pt/documentdb/faqs/
3. Banco de dados de documentos: https://aws.amazon.com/pt/nosql/document/
4. 12 things you should know about Amazon DocumentDB (with MongoDB compatibility): https://aws.amazon.com/pt/blogs/database/12-things-you-should-know-about-amazon-documentdb-with-mongodb-compatibility/
5. Scaling Amazon DocumentDB (with MongoDB compatibility), Part 1: Scaling reads: https://aws.amazon.com/blogs/database/scaling-amazon-documentdb-with-mongodb-compatibility-part-1-scaling-reads/
6. Getting Started with Amazon DocumentDB (with MongoDB compatibility); Part 2 – using AWS Cloud9: https://aws.amazon.com/pt/blogs/database/part-2-getting-started-with-amazon-documentdb-using-aws-cloud9/
7. Getting started with Amazon DocumentDB (with MongoDB compatibility); Part 3 – using Robo 3T: https://aws.amazon.com/pt/blogs/database/part-3-getting-started-with-amazon-documentdb-using-robo-3t/?nc1=b_rp
8. Migrating to Amazon DocumentDB with the hybrid method: https://aws.amazon.com/blogs/database/migrating-to-amazon-documentdb-with-the-hybrid-method/
9. Backing up data with Amazon DocumentDB (with MongoDB compatibility): https://aws.amazon.com/blogs/database/backing-up-data-with-amazon-documentdb-with-mongodb-compatibility/
10. Optimizing for cost with Amazon DocumentDB (with MongoDB compatibility): https://aws.amazon.com/blogs/database/optimizing-for-cost-with-amazon-documentdb-with-mongodb-compatibility/
11. Migrating to Amazon DocumentDB with Online method
https://aws.amazon.com/pt/blogs/database/migrating-to-amazon-documentdb-with-the-online-method/
12. DocumentDB Tools
https://github.com/awslabs/amazon-documentdb-tools
13. Diferenças de funcionalidade com o MondoDB
https://docs.aws.amazon.com/documentdb/latest/developerguide/functional-differences.html
14. Best Practices DocumentDB
https://docs.aws.amazon.com/documentdb/latest/developerguide/best_practices.html
15. Support MongoDB Apis
https://docs.aws.amazon.com/documentdb/latest/developerguide/mongo-apis.html
16. Monitoring DocumentDB (metricas)
https://docs.aws.amazon.com/documentdb/latest/developerguide/cloud_watch.html

### **Keyspaces**

1. Keyspaces Toolkit
https://github.com/aws-samples/amazon-keyspaces-toolkit
2. Keyspaces Lambda Python
https://github.com/aws-samples/aws-keyspaces-lambda-python
3. Documentação sobre o acesso programático
https://docs.aws.amazon.com/keyspaces/latest/devguide/programmatic.drivers.html
4. FAQ
https://aws.amazon.com/keyspaces/faqs/?nc1=h_ls
5. Quotas
https://docs.aws.amazon.com/keyspaces/latest/devguide/quotas.html
6. Video sobre o teorema CAP (Português/7min)
https://www.youtube.com/watch?v=06eCRNJz9Ds
7. Boa e velha Wikipedia sobre o teorema CAP
https://en.wikipedia.org/wiki/CAP_theorem
8. Migração Keyspaces - Transferência de dados por cqlsh
https://aws.amazon.com/pt/blogs/database/loading-data-into-amazon-mcs-with-cqlsh/

# **Dia 3** - 20 de Agosto

### **QLDB**
1. QLDB Samples
https://github.com/aws-samples/amazon-qldb-dmv-sample-java
2. PartiQL (A linguagem SQL do QLDB)
https://partiql.org/
3. Amazon ION (a estrutura de dados utilizada pelo QLDB)
http://amzn.github.io/ion-docs/
4. Querying Ion with PartiQL
https://docs.aws.amazon.com/qldb/latest/developerguide/ql-reference.query.html
5. Tutorial (demo feita)
https://docs.aws.amazon.com/qldb/latest/developerguide/working.create.html
6. QLDB Driver
https://docs.aws.amazon.com/qldb/latest/developerguide/getting-started-driver.html

### **Oracle Migration to AWS**
1. Documento Oracle sobre licenciamento em nuvens
http://www.oracle.com/us/corporate/pricing/cloud-licensing-070579.pdf
2. Blog Oracle sobre upgrade e migração
https://mikedietrichde.com/
3. Database Freedom Program:
https://aws.amazon.com/pt/solutions/databasemigrations/database-freedom/
4. Strategies for Migrating Oracle Database to AWS (Paper que cobre o material apresentado):
https://d1.awsstatic.com/whitepapers/strategies-for-migrating-oracle-database-to-aws.pdf
5. Blog Post – Migrating Oracle databases with near-zero downtime using AWS DMS:
https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/

### **Workshop DMS**
1. Link do laboratório
https://aws.qwiklabs.com
2. Cursos de Partner Training - Há um curso dedicado de Migration
https://aws.amazon.com/pt/partners/training/latam-br/

# **Dia 4** - 25 de Agosto

### **ElastiCache**
1. ElastiCache Samples
https://github.com/aws-samples/amazon-elasticache-samples
2. Caching Strategies
https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html

### **DynamoDB**
1. Link do Workshop
https://amazon-dynamodb-labs.com/design-patterns.html
2. The DynamoDB Book
https://www.dynamodbbook.com/

# **Dia 5** - 27 de Agosto

### **RDS/Aurora**
1. Aurora Labs
https://awsauroralabsmy.com/provisioned/create/

# **Dia 6** - 31 de Agosto

### **Neptune**
1. Excelente guia sobre Gremlin
https://kelvinlawrence.net/book/Gremlin-Graph-Guide.html#_introduction
2. Getting Started (contém CloudFormations pra criar ambiente de testes)
https://docs.aws.amazon.com/neptune/latest/userguide/get-started-create-cluster.html
3. Video com casos de uso da Rede Globo
https://www.youtube.com/watch?v=tGUOfJeAVp4&app=desktop
4. Neptune samples (GitHub)
https://github.com/aws-samples/amazon-neptune-samples
5. Neptune Tools (GitHub)
https://github.com/awslabs/amazon-neptune-tools