About
Consulting
Blog
SQL trainings
Quarto Dashboards & Presentations
Hands On Trainings
Teaching
CV
- Resume
- Vitae
Resources
Contact me
- Email
- LinkedIn

SQL and databases lessons

A glimpse of the Tidyverse
Data Transformation and Explanatory analysis
Introduction GLMs
Gaussian GLMs
Poisson GLMs
Binomial GLMs
Gamma GLMs
Beta GLMs
Common GLM Problems
Zero Inflated GLMs

Categories

Data engineering

Databases

SQL

data manipulation

databases

sql training

SQL and databases lessons

My blog on Data science and Structured query language

working with strings in SQL

databases

sql training

data manipulation

most data cleaning processes involve working with structured and unstructured character/string datatypes . the ability to manipulate string data can be a super power

4 February 2024

SQL Window Functions

databases

sql training

data manipulation

However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row:

4 February 2024

An SQL case study

databases

sql training

data manipulation

try to find out where the missing values are coming from , will check the row numbers with missing values.

4 February 2024

SQL and R compared

databases

sql training

data manipulation

The Notebook is divided into tabbed sections as seen below.

3 February 2024

Up and Running with SQL

Databases

SQL

Data engineering

We do realise that most of the softwares around are designed to solve a problem!. To better understand what databases are ,we need to first understand the problems that…

2 December 2023

No matching items

Copyright 2024, Bongani Ncube

Bongani Ncube
Data Science and Statistics Researcher r195334vncube@gmail.com
NEAT ELITE RESEARCH AND DATA ANALYTICS CONSULTANCY
University Of Zimbabwe, Zimbabwe.