SQL 2.0

I have started writing queries to clean data. In my learning, I have written queries to sort and filter data. When I started SQL initially, I was elated about my code running successfully without stopping to check if I actually understood the clauses. Taking a break and coming back to picking it up for the second time has made things clearer.

Using JOIN to retrieve invoice IDs from each customer. The JOIN clause helps to bring columns of two tables together. In my field, say I have a table of employee records and another table of training records, I could use one of the JOIN clauses to analyse the relationship between the both tables. For example, one of the JOIN clauses would show me every employee, even those missing a training record while another JOIN clause would retrieve all the training records available even if no employee is linked to it. This is to make decisions around compliance and employee development.

Compared to what I was learning previously which felt faster paced, I am learning it slower with a more recent content. Starting again made me realize how basic understanding of things are important before picking up bigger things. By the way, I set up my programming language studio majorly on my own. I currently use the VS Studio for querying. The course just told me what to download with the assumption that everything is going to work at once.

Get Faith U.’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

And then….Ai really be your learning buddy. There is this AI coach I speak with after every learning session . It is inbuilt by the course. The AI coach for reflection is interesting and I believe this is a good use of AI in an organisation for when colleagues are finding hard to set goals for performance reviews. I find myself thinking deeply before responding. While it was not able to replace a human coach for me, it does help a bit with reflections. The feedback it gives is what I am not still much of a fan. It does not give the feedback I am looking for.

Querying with the SELECT syntax. In my field, i could use this query for workforce planning and global mobility analysis. For example, I would find employee names, their current countries of work and filter for those who are international transfers. By sorting it, one would be able to identify locations/countries that receive the most transfers and identify patterns (an addition of GROUP BY and LIMIT clauses). This would help the organisation see where more employees are transferring to and identify patterns to note if they are positive or require any actions. Faster than using excel while ensuring that existing data is not compromised.

Currently, I am out for professional projects and opportunities to practice SQL as I am learning. For someone in HR, the next step is to use SQL to answer more related questions using a relatable dataset… off to find that!

🌻

Grateful for life. Just easing into everything again. Nothing much about my life outside the learning and development section to drop an update again. But yeah.

Meme of the Day