Skip to content

Instantly share code, notes, and snippets.

@jsvitor
jsvitor / docker-compose-ek.yml
Last active July 17, 2022 01:50
Created for up a service with elasticsearch
---
version: '3'
services:
elasticsearch:
image: docker.elastic.co/elasticsearch/elasticsearch:8.3.2
environment:
- bootstrap.memory_lock=true
- ELASTIC_PASSWORD=changeme
- discovery.type=single-node
@jsvitor
jsvitor / data-concepts-and-tools.md
Last active August 25, 2022 15:11
Tools to increase data infrastructure robustness and resilience

[approaches] Increase data infrastructure robustness and resiliency

With increasing scalability comes the need to use strategies and approaches to ensure the availability of our services. Here I list some very important tools and concepts to achieve these goals.

Most of these tools are multifunctional.

Data Catalog

Data Observability

O Elastic Stack

Sarch. Observe. Protect.

Elastic Stack

Hardware

Resumo

Sistemas de Computadores

use empresa_jose_vitor;
-- 1. Retornar os nomes dos funcionários do departamento 4 que trabalham mais de 9 horas por semana no projeto Informatização.
select FUNCIONARIO.Pnome, FUNCIONARIO.Unome
from
FUNCIONARIO join TRABALHA_EM on FUNCIONARIO.Cpf = TRABALHA_EM.Fcpf
join PROJETO on TRABALHA_EM.Pnr = PROJETO.Projnumero
where FUNCIONARIO.Dnr = 4 and TRABALHA_EM.Horas > 9 and PROJETO.Projnome = 'Informatização';
-- 2. Retornar os nomes de todos os funcionários que possuem pelo menos um dependente com o mesmo sexo do funcionário.
select FUNCIONARIO.Pnome as 'primeiro nome', FUNCIONARIO.Unome