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.