Skip to content

Data

Data has been important to me since my research days when I used it to answer queries from clients and to ensure everything within a project was working as planned.
Starting with the correct cuts of data meant for speedier analysis. I would wait and watch an IT colleague use SQL to get this initial data for me, and then use Microsoft Access’ query interface and Excel.
Recently I’ve mostly dealt with data via the Java Persistence API, creating and dropping tables to a local MySql server using Spring entities.
From a coding perspective I remember persisting data for the first time made it feel like my code had stuck. Ever since, I’ve understood the importance of having data persisted in a quick and flexible way. A H2 development database in a Spring project gives everyone the ability to experiment without breaking the hosted ‘production’ database. I learned how to do this through extra study and convinced my colleagues to let me set it up for our end project.
I consider myself a beginner with a good understanding of database design and how SQL queries are put together. I’m interested in pushing this further, if SQL were to be an important part of any future role, I’ll enjoy learning more.
Data Timeline
H2Shar3azy 2022-08-22 121304.jpg
7/27/2021
H2 Set up as one of the options in a personal project.
SQLSandbox 2022-08-22 111108.jpg
5/31/2021
Free SQL course that I followed and eventually purchased.
SQLSandbox02 2022-08-22 111213.jpg
8/22/2022
The set up for SQL_Sandbox and some extras.
MySQLWorkBench 2022-08-22 071647.jpg
During my studies, and for later personal projects, I set up my own local MySQL tables.
ClientPanel Firestore 2022-08-22 080208.jpg
8/5/2021
My first use of a non-relational, document based, database was with an Angular project. I also brushed briefly with MongoDB when creating a MEAN stack project.
aftermbf 2022-08-19 092617.png
4/30/2020
After ending the Made by Fun pilot I continued improving my skills. Looking at my Udemy purchase history (pictured) I was definitely moving towards learning VBA and DAX for data analysis at the time.
WooCommerceAccessImport2022-08-22 092011.png
2/18/2019
Querying a customers Woo Commerce data after importing it into Access




Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.