DevC Nairobi

How does React Native actually do its work?

If you are like me, a curious George , you will not be happy to just accepting what…

How to create windows and use window functions for pretty advanced SQL analysis.

One of the most powerful concepts in SQL data analysis is the window function, it took a little practice for me to really nail it and it become extremely useful on my Machine learning journey…

How to use SQL subqueries to substantially increase the types of problems you can solve

How to Automate and Scale SQL capabilities using Google Cloud Platform

How to use SQL Aggregations to add value to raw data

Imagining myself as a marketing manager at Kiwanda, I wanted to compare Facebook as a marketing channel against all other channels.I knew Facebook is a great channel for my business, but is it better than all the rest combined ? How would…

The real power of SQL is JOINs

The real power of SQL comes from working with data across multiple tables at once. The term relational database reffers to the fact that tables within it realate to one another. They contain common identifiers that allow information from multiple table to be easily combined.

Why do analysts like SQL

Entity Relationship Diagram for Kiwanda database

On my transitioning journey from…

C#(Dotnet) Setup in Ubuntu with VSCode

C# is a general-purpose, multi-paradigm programming language encompassing static typing…