Sql

When learning about Databricks optimization, you have probably seen many articles, videos and documentation pages talking about it What I was missing, is a series of articles / notebooks to gather all the information and show concrete examples of how the techniques work This is the first notebook of the…

In the WBS Coding School, I have started a project in the field of Data Engineering that aims to prepare data for analytical or operational purposes. Specifically, I built an automated pipeline to collect information from various sources and store it appropriately in the cloud. The project was embedded in…

👉Excel | 👉Statistics | 👉Power BI | 👉SQL | 👉Python | 👉Portfolio — It’s possible to become a data analyst within 90 days without spending any money! That’s correct, you heard it right. Follow these steps to ensure success (make sure you go with the mentioned order)

SQL (Structured Query Language) is a programming language that is used for managing and manipulating data stored in relational databases. SQL is widely used by businesses and organizations of all sizes to manage large amounts of data efficiently. If you’re looking to learn SQL, you can do so for free…

Hola👾 Let’s solve Lab 1 of Port Swigger under Access Control which is Unprotected admin functionality. Description: This lab has an unprotected admin panel. Solve the lab by deleting the user carlos. Let’s start solving the lab: First, we will append robots.txt to the lab URL You’ll notice that the Disallow line discloses the path to the admin panel. Just copy the path and append it with the lab URL by replacing /robots.txt

This is my completed case study from an optional course in the Google Data Analytics Course named: Capstone Project. The analysis follows the 6 steps of Data Analysis taught in the Google course: Ask, Prepare, Process, Analyse, Share and Act. Step 1: Ask In this first step, I will define the problem and…

Find the name or ID of the container running the PostgreSQL database. You can use the docker ps command to list all running containers and their IDs and names. $ docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES e4972eb9d0e9 postgres:12-alpine "docker-entrypoint.s…" 26 minutes ago Up 26 minutes 0.0.0.0:5432->5432/tcp my-postgres-db