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

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…

Lionel Matsuya Avatar
Girls Who Code
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.


Continuing the journey

Since supporting Nat’s training, we’ve continued to champion women in GRC through our ongoing partnership with the Women in GRC Awards. From technical upskilling to leadership recognition, we’re proud to play our part in creating pathways for women to thrive in governance, risk, and compliance.

CoreStream GRC is passionate about supporting women in GRC. Want to learn more about our sponsorship with Women in GRC awards 2026.


FAQ

What is Code First Girls and how does it support women in tech?

Code First Girls is an organization dedicated to helping women transition into technology careers. Through beginner-friendly programming courses and partnerships with tech employers, it aims to close the gender gap in the industry by giving women practical skills, mentorship, and access to opportunities in coding and data analysis.

What kind of courses does Code First Girls offer?

Code First Girls provides multiple learning pathways, including Career Switcher programs for women changing industries, Uni-Kickstarter courses for new graduates, and MOOCs (Massive Open Online Courses) that offer free access to foundational programming skills. Graduates can also join the CFG Alumni Network for ongoing learning and career support.

What was covered in the Introduction to Data & SQL course?

The eight-week Introduction to Data & SQL course taught participants how to manage and analyze databases. Key modules included SQL coding, normalization, constraints, stored procedures, subqueries, transactions, and data visualization. The course culminated in a final project where participants designed and managed their own database systems.

How did CoreStream GRC support this initiative?

CoreStream GRC sponsored team member Nat Amanfo to complete the Code First Girls course, reinforcing the company’s commitment to diversity, equality, and professional development. CoreStream’s sponsorship reflects its broader mission to empower women in technology and GRC (Governance, Risk, and Compliance).

Why does CoreStream GRC invest in diversity and equality initiatives?

CoreStream GRC believes that diverse teams create better solutions. Beyond sponsoring professional training, the company has reviewed its Equal Opportunities Policy, introduced diversity and inclusion programs, and supported charities like Lifting Limits that challenge gender stereotypes in education.

  • Designing your dream GRC home part 2: connectivity and why corridors need to be planned

    Designing your dream GRC home part 2: connectivity and why corridors need to be planned

    By Head of Client Solution Design, Lionel Matsuya   Almost every organization ends up here eventually: they’ve built good GRC point solutions in silos – and now they want to connect them.  One of the most common use cases I hear when designing an enterprise client’s GRC solution is this:  “We have a number of different…

  • Conflict of interest in healthcare: why CoreStream GRC is the trusted go-to solution

    Conflict of interest in healthcare: why CoreStream GRC is the trusted go-to solution

    In healthcare, trust is everything and CoreStream GRC helps protect it. Whether financial, personal or institutional, healthcare providers are expected to demonstrate integrity in every aspect of their operations, from procurement and prescribing decisions to partnerships and research funding. When those standards slip, the impact is serious, patient trust is business critical for healthcare providers.…

  • CoreStream GRC deepens its commitment to the Women in GRC Awards

    CoreStream GRC deepens its commitment to the Women in GRC Awards

    In Nikki Dowdall’s keynote at the 2025 Women in GRC Awards, the Founder of the initiative, shared a challenge that resonates across governance, risk and compliance: “Only 17% of Chief Risk Officers and 14% of Chief Compliance Officers are women, despite women making up 50% of entry-level functions in GRC. These figures are disappointing and…