Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days Airflow Amazon Web Services Apache Iceberg AWS Azure bash Batch CAP Coders At Work Data data lakes Data Warehouse Docker Edsger W. Dijkstra Excel Git Hadoop HDFS Hellerstein Hive Javascript Networking NoSql Postman Power Bi Powershell Pyspark Python Redash S3 Social Skills Software Developer Spark Spark: The Definitive Guide SQL SSH terraform Testing The Elements of Programming Style Traversy Media Understanding Distributed Systems Virtual Box whale-alert Yaml

Archives

Common table expressions

Specifies a temporary named result set, known as a common table expression (CTE). Microsoft Documentation Although there are some time around us the first time someone asked me about it I was confused: I haven’t know its proper definition until that momento. In fact, the common table expressions where added to the SQL standard in
Read More

Principle of Data Wrangling

Data Wrangling involves the process of cleaning and organizing data before any analysis takes place. It typically consumes between 50% and 80% of an analyst’s time. Factors to consider include time, granularity, scope, and structure. Importance: 1. Understanding the type of available data. 2. Choosing which data and level of detail to focus on. 3.
Read More

50projectsIn50days – Day 18: Background Slider

A Image carrousell changes the background image deppending where you clikc. It’s an easy and well known task to perform in your mind but, when you have to use Vainilla Javascript it should be something different. The first thing you’ll notices is that there is an event listener in the two buttons: right and left.
Read More

Importance of a Database System

As should be clear from this paper, modern commercial database systems are grounded both in academic research and in the experiences of developing industrial-strength products for high-end customers. The task of writing and maintaining a high-performance, fully functional relational DBMS from scratch is an enormous investment in time and energy. Many of the lessons of
Read More

4.6 Data Warehouses

DataWarehouses—large historical databases for decision-support that are loaded with new data on a periodic basis — have evolved to require specialized query processing support, and in the next section we survey some of the key features that they tend to require. This topic is relevant for two main reasons: 1. Data warehouses are a very
Read More

50projectsIn50days – Day 17: Movie App

The movie app needs you create an account in the movie db beacuse you need this access to get the data The new part in this path is the oner related to take information from another services, in this case a movie information provider. This information is obtained using the function getMovies(url) Using the fetch
Read More

50projectsIn50days – Day 15: Counter

A page which load three values that are hardcoded in the HTML tag: Each one with a class “counter” will be selected and for each one an inner text will be added as Zero and will be aded an increment up to the target (which is located in the data-target) is reached: The functions call
Read More

50projectsIn50days – Day 14: animated navigation

A navigation bar inside the html is the responsible of hosting the menu li. But, for the example is not necesarry to use explain more about that. This nav has an event listener which listen for a click. When it happens it will be added elelment active which is the responsible of change the style.
Read More

50projectsIn50days – Day 13: Random Picker

A text area where you add a number of elements divided by comma. Then, when you press enter the you’ll see a simple animation and a, in yellow, the chosen one. The text area in index.html is where you’ll add the text And the relevant Style are related with the elements: tag and tag.higlight Let’s
Read More