Girls Who Code

Mastering SQL basics with Code First Girls: a guide for beginners

25 Jan
Nat Amanfo from our Configuration Team recently participated in a Code First Girls course. She details her experience here:

What is Code First Girls?


Code First Girls is an organization that helps women transition into tech roles by introducing them to programming and connecting them with tech companies. Their mission is to close the gender gap in the technology industry, based on the belief that women are just as capable as men but lack the support to break into these fields.

They offer a wide range of courses, including Career Switcher courses for women looking to transition into tech from other industries, Uni-KickStarter courses for recent university graduates, and MOOCs (Massive Open Online Courses), which are free and provide insights into programming languages and applications.

Upon completing a course, participants join the Code First Girls Alumni network. This provides opportunities to connect with other graduates, attend future seminars and talks hosted by CFG, and even become a CFG Instructor to lead programming courses.


What is included in a Code First Girls course


The course I completed was the Career Switcher course titled Introduction to Data & SQL. It was held every Thursday evening between September and October, spanning 8 weeks. Each session lasted 2 hours, with homework assigned after each class.

The modules covered SQL coding, database management, database analysis, and data visualization. The course culminated in a final project presentation.

Some of the key concepts included:

  • Backing up and restoring databases on a server
  • Normalization
  • Constraints on tables
  • Subqueries
  • In-built functions
  • Transactions (how to commit and roll them back)
  • Virtual tables
  • Stored functions and procedures
  • Events and triggers

For the final project, we were tasked with building a database containing multiple tables with various column types. We inserted data into these tables and connected them using primary and foreign keys. Then, we applied what we had learned to retrieve and update data within our tables, ultimately presenting the project to our group.

To keep the project engaging, I chose to base it on one of my favorite childhood pastimes – Pokémon. The project was well-received and met all requirements. Upon completion, I received a certificate recognizing my successful completion of the course.


My Experience at Code First Girls


I was able to grasp many of the SQL concepts presented during the course, thanks to my prior exposure to similar ideas in my work as a configurator.

For instance, the concept of foreign keys in child tables linking to primary keys in parent tables was familiar due to my understanding of Lookups in CoreStream GRC’s vNext Platform. Similarly, when our instructor explained the importance of ERDMs (Entity Relationship Diagram Models) to outline table connections, it resonated because we use schemas to describe relationships between collections in our HLDs.

Joins were also straightforward to understand, as they are frequently used when configuring data in CoreStream GRC sites. This demonstrates the effectiveness of CoreStream GRC’s platform; it enables us to learn SQL concepts intuitively, even without explicit training.

That said, there were many new things I learned during the course, such as subqueries, stored functions, and stored procedures. I also learned how to import data into Python and use Python functions to analyze data more effectively. Additionally, I was introduced to data visualization techniques by importing data into Tableau, where I learned how to create charts and display KPIs.


Final Thoughts


The course was incredibly helpful in teaching me new concepts related to SQL and database management. It has also boosted my confidence in pursuing a more SQL-focused role, confirming that the skills and concepts I’ve gained at CoreStream GRC are broadly applicable across various settings.

I believe any woman joining CoreStream GRC without prior SQL knowledge would benefit greatly from this course. By the end, they would feel confident handling external data sets and chart queries without relying heavily on trial and error or seeking constant help from colleagues.

I’m grateful to CoreStream GRC for sponsoring my place in this course and supporting my career aspirations. This underscores CoreStream GRC’s commitment to diversity and equality in the workplace. This dedication is further evidenced by their review of the Equal Opportunities policy in response to the BLM protests (which I truly appreciated), their diversity training initiatives, and their support for charities that challenge gender stereotypes.



CoreStream GRC is passionate about supporting women in GRC, learn more about our sponsorship with #WGRC 2025 awards here.