eddahviolet Goto Github PK

advanceddatamodeling

Starts with a conceptual model ends with a Tableau interactive dash board. In between there is building ER diagrams, forward engineering to build normalized databases, dimensional data modelling and visualizations in tableau.

advancedmysql

Pushing beyond simple SQL statements in MySQL to an advanced level dealing with complex stored procedures and functions, using variables and parameters, creating triggers and events, using CTEs, prepared statements, using the JSON data type. emulating full outer join.

advancedmysqltopicsfinalproject

A summary exercise applying all the advanced MySQL topics

databasestructuresandmanagementwithmysql

DBMS skills such as data creation, joins, grouping, constraints, subqueries, views, functions and simple procedures

db-capstone-project

Final project in the Meta Database Engineer Professional Certificate

eddahviolet

Config files for my GitHub profile.

finalprojectadvanceddatamodelling

Creating erd using MySQL Workbench, Forward engineering, Dimensional data model, Tableau visualisation

forking-lesson

my first fork

ig_content_creators_pay

The main challenge with content creators is the lack of transparency in payments leading to novices getting under-paid. Here is a brief analysis of the payments Kenya Instagram content creators receive for Posts, Reels & Static Posts

m3l2_forking_lab

forking exercise

m4l1_managing_a_project

Coursera lab

my-first

Learning git

myintrotosql

Hey there, welcome to my repo where I share my passion for SQL queries with you! Beginning with the basics like creating databases, tables, and inserting data into tables. Let's dive in and explore the exciting world of SQL queries together!

myjupyternotebookfinalproject

repo-exercise

usingjupyternotebook

I use Jupyter Notebook and python to work with a MySQL database