MOOCS

MOOCs

QUICK JUMP MENU

LEARN NEW TECH

SKILLS

The CFG Massive Open Online Courses come in two forms – our MOOC Sprints and our MOOC Challenges. Together, our MOOCs are great for beginners or those with some tech knowledge and know-how!

Our MOOC Sprints are 4-week quick learning courses that will give you a good foundational knowledge across key tech topics, including languages, problem-solving and career confidence. 

Following our Sprints, our MOOC Challenges allow you to test your knowledge and skills with a challenge, project or task with real-life examples and problem-solving.

Play Video

OPEN SESSIONS

FREE TO ATTEND

These 100% free MOOC sessions will introduce you to in-demand tech concepts and languages, and other key skills.

They are a great way to get a taste of different tech concepts, languages, and career tips’n’tricks, whilst building your knowledge and skills across various tech areas.

We often have our partner companies helping us host these sessions, so there is also a great opportunity to find out how tech works across different organisations and take part in live Q&A sessions. 

These sessions are open to all CFG members across the globe!

INFO SPOT: MOOC SPRINTS & CHALLENGES

Much like any tech role, you’ll get involved in sprints to build and ship new tech features and products. We thought the term ‘sprint’ was a fitting name for a 4-week MOOC powerhouse learning session focused on a key topic where you will walk away with new skills and knowledge.

Not only that, after completing a MOOC Sprint, you will have the opportunity to test your knowledge further by taking part in a MOOC Challenge linked to your Sprint topic.

Our MOOC Sprints are open to all CFG members globally and are 100% free for all participants.

MOOC Sprints are run over 4 weeks, with one x 1-hour session per week going into the detail of a key topic area. 

At the end of the 4 weeks, you’ll walk away with a deeper knowledge of a key topic and have the opportunity to test your knowledge with our MOOC Challenge – which will follow after each Sprint!

There will be a range of topics from introductions to languages, problem-solving, career pathways and more!

Each MOOC Sprint will include LIVE sessions (or recorded if you can’t make it), a session quiz, and upon completion by the deadline, a certification.

What we love most about our new MOOC Sprints is that they are great for all CFG members – from beginners to those further along their tech journey.

Tech is an ever-evolving area, and building your knowledge base is sure to continue throughout your career. MOOC Sprints are great for those starting and wanting to learn more about a topic, or for those who have done our class or CFGdegree and want to gain additional knowledge and skills in a topic area.

AND, our MOOCs are available for all CFG members globally!

Our MOOC Sprints will be hosted LIVE by our amazing instructors with some special guests from partner companies for key sessions.

In the LIVE sessions, you can ask any questions, get unstuck on any ‘not-so-sure-bits’ and ask guest partners about life at their company and career pathways.

To gain access to our new MOOC Sprints, we’ll send you to our new member area online where all of our MOOC sessions will take place and you can track your progress and access course materials.

We know that sometimes life gets in the way of a good MOOC session, so we will be keeping our MOOC Sprint sessions available online for some time after each of the LIVE sessions.

This means you can watch and learn in your own time, in whatever time zone, accessing the video sessions and associated content to complete each MOOC Sprint. 

PLUS, when you complete the MOOC Sprint, you will receive a certificate to recognise your achievement. There is a completion deadline for each MOOC Sprint to receive a certificate, after which you can head over to our “On Demand Library” where you can catch up on any of the Sprints for a limited time. 

We’re unleashing some mini hackathon vibes with our MOOC Challenges. Our MOOC Challenges will allow members to test their knowledge in a key topic area with a project or challenge to complete.

Much like a hackathon, there will be a kick-off event, time to develop your response, and a final presentation session – with this all happening over four weeks.

Challenges and projects are a great way to not only test your knowledge but also for building a portfolio and adding to your CV!

Our MOOC Challenges are 1-hour weekly sessions which are open to all CFG members globally and are 100% free for all participants. If you would love to take up the challenge but don’t think you have the skillset for it, check out our related Sprints first to get yourself challenge ready!

Each MOOC Challenge will begin with a kick-off event where the challenge statement and project will be presented. 

Usually, these will be presented by our partner companies who may be seeking solutions to real-life tech challenges and looking for tech talent to show them the way! 

Our MOOC Challenges are open to all CFG members globally!

It is always good to challenge yourself and put new skills (or old ones!) to the test!

Our MOOC Challenges are designed to follow our MOOC Sprint topics so that those who have participated in the Sprints can then test what they have just learnt.

These challenges are open to all participants, however, our linked Sprints are here to give you all the tools and skill sets to complete.

From the kick-off date, you will have four weeks to submit your response.

Finally, after all of your hard work, you get the opportunity to showcase your work to our partners who are your judges. Showcase all you have learned and worked on with a final presentation where one of our lucky challengers will be awarded the winner. 

The final session will take place after around four weeks of free time to complete the challenge. 

We are incredibly excited to have our partner companies involved and to see your solutions presented to the challenge.

Problem-solving is a key skill to have in tech and being able to showcase that you have participated in MOOC Challenges will be a great booster to any CV and portfolio.

Each member that takes part and completes the MOOC Challenge will receive a certificate to confirm participation.

You’ll also have a great project to add to your portfolio and be able to add this to your GitHub, website or other pages showcasing your work!

MOOC SPRINTS & CHALLENGES

Our NEW MOOC Sprints and Challenges can be found below. We will be launching more Sprints and Challenges in the coming weeks and months so make sure you tune in to our socials and emails for updates (and come back and check here!)

LIMITED TIME: 21.03.24
Free and open to all CFG Members​
INTRO TO Java

STARTS: Wednesday 14 February 2024 @ 6.00PM

The live sessions for this MOOC Sprint have ended, but you have until 21st March 2024 to get full marks and earn a certificate. 

Crave the power to build sleek websites, dynamic apps, and even games? Java, the world’s most popular programming language, is your key.  Master the fundamentals, conquer object-oriented programming, and flex your skills with real-world challenges. Plus, our interactive sessions and supportive community will have you coding with confidence in no time. Don’t let opportunity Java you by – this MOOC is your passport to a future packed with coding adventures! Join us and code your way to success!

Session 1: Java Prerequisites

  1. What is Java?
  2. Introduction to IntelliJ
  3. Data Types and Variables
  4. Arithmetic and Relational Operators
  5. User Input
  6. Demo: “Guess The Word”

Session 2: Programming Basics

  1. Conditional Operators 
  2. Arrays
  3. Functions
  4. Loops I
  5. Demo: “Guess The Word”

Session 3: Intermediate Concepts

  1. Loops II
  2. Object-Oriented Programming I
    • What Is A Class?
    • What Is An Object
    • Methods and Properties
  3. Demo: “A Simple Guessing Game”

Session 4: Advanced Topics Overview

  1. Object-Oriented Programming II
  2. Debugging
  3. Error Handling
  4. Demo: “OOP”
*LIVE* MOOC SPRINT: GET CERTIFIED (FOR FREE!)
Free and open to all CFG Members​
INTRO TO iOS Development

STARTS: Thursday 15 February 2024 @ 6.00PM

Our iOS development MOOC can turn your App dream into reality! Learn the secrets of building polished, user-friendly apps. No coding experience? No problem! We’ll guide you step-by-step, from basic concepts to building your mini-app portfolio. By the end, you’ll have the skills and confidence to launch your app on the App Store, unlock exciting career opportunities, or impress your friends with your coding prowess. Don’t wait, the future of mobile is in your hands. Enrol now and turn your passion into pixels! 

Session 1: Hello, CFG: Introduction to iOS App Development

LIVE Session: Thursday 15th February @ 6 PM (GMT)

  1. Introduction to iOS Development 
  2. Our first App:
    • Introduction to Views

Session 2: Hello, Draughts: Navigation + Some Swift Basics

LIVE Session: Thursday 22nd February @ 6 PM (GMT)

  1. Navigating between views
  2. Swift basics through the task of creating a board
    • Variables
    • Arrays/Ranges
    • Loops
    • Conditionals

Session 3: Let’s Play:  Interactivity, Data Management/persistence

LIVE Session: Thursday 29th February @ 6 PM (GMT)

  1. Getting user input 
  2. Saving values for the lifetime of the app 
  3. Adding buttons 
  4. Functions in swift

Session 4: Analysis: Best practices + future steps

LIVE Session: Thursday 7th March @ 6 PM (GMT)

  1. Look at some iOS design/development principles in light of the app so far 
  2. Available iOS toolkits/libraries e.g. for navigation, Apple Pay etc
  3. How to put one’s app on the App Store 
  4. Resources to learn more
*LIVE* MOOC SPRINT: GET CERTIFIED (FOR FREE!)
Free and open to all CFG Members​
Git & Github

STARTS: Monday 4 March 2024 @ 6.00PM

Are you ready to revolutionise your workflow and take your coding skills to new heights? Then our Git & GitHub MOOC is your gateway to that dream! Whether you’re a complete beginner or a programmer looking to level up, this MOOC equips you with the essential skills to navigate the exciting world of version control and code collaboration. Join us on a journey where you’ll unlock the power of version control, learn industry-standard collaboration practices, and elevate your coding game to new proficiency levels. Take advantage of this opportunity to join a vibrant community of learners and take control of your coding destiny. 

Session 1: Introduction: Git and GitHub

LIVE Session: Monday 4th March @ 6 PM (GMT)

  1. What is Version Control?
  2. Basic Linux Commands
  3. Git SetUp
  4. Initialise a Local Git Repository

Session 2: Git Branches

LIVE Session: Monday 11th March @ 6 PM (GMT)

  1. What is a Branch?
  2. Branching – checkout, push branch
  3. Merging Branches

Session 3: Remote Repositories

LIVE Session: Monday 19th March @ 6 PM (GMT)

  1. Initialize and Push to Remote Repositories
  2. Cloning Remote Repositories
  3. Pull Requests – Fetching and Pulling
  4. Forking a Repository

Session 4: Merge Conflicts

LIVE Session: Monday 25th March @ 6 PM (GMT)

  1. Merge Conflicts
  2. Rebasing ( Nice to have content for CFG Degree, but not necessary especially for MOOCs)
  3. Conclusion
*LIVE* MOOC SPRINT: GET CERTIFIED (FOR FREE!)
Free and open to all CFG Members​
Intro to cloud & Deployment

STARTS: Tuesday 5 March 2024 @ 6.00PM

Ready to take your coding skills to new heights and unleash the power of the cloud? Dive into the Cloud & Deployment MOOC, your free ticket to mastering the art of cloud computing and deploying applications that scale. Whether you’re a budding entrepreneur, a seasoned developer, or simply curious about the cloud revolution, this course equips you with the knowledge and tools to turn your ideas into reality. This MOOC is tailor-made to equip you with the knowledge and tools necessary to deploy, manage, and optimize applications in the cloud efficiently.

Session 1: Introduction to Cloud Computing

LIVE Session: Tuesday 5th March @ 6 PM (GMT)

  1. Define cloud computing and its key characteristics
  2. History of Cloud
  3. Benefits and challenges of using the cloud
  4. Key cloud service providers and their services

Session 2: Cloud Deployment Models and Services

LIVE Session: Tuesday 12th March @ 6 PM (GMT)

  1. Service Models
    • IaaS
    • PaaS
    • SaaS
  2. Public cloud
  3. Private cloud
  4. Hybrid cloud

Session 3: Intro to AWS

LIVE Session: Tuesday 20th March @ 6 PM (GMT)

  1. What is AWS
  2. AWS Global Infrastructure
  3. AWS High Availability Concept
  4. AWS Edge Locations

Session 4: AWS Services

LIVE Session: Tuesday 26th March @ 6 PM (GMT)

  1. AWS Services Interactions 
  2. AWS Console
  3. AWS CLI
  4. AWS SDK
*LIVE* MOOC SPRINT: GET CERTIFIED (FOR FREE!)
Free and open to all CFG Members​
intro to python

STARTS: WEDNESDAY 3 APRIL 2024 @ 6.00PM

Python is an interpreted, object-oriented, high-level programming language with dynamic semantics. Python is commonly used for developing websites, task automation, data analysis, and data visualisation. Due to the nature of Python, it is regularly used in industries and roles such as accountants and scientists, for a variety of everyday tasks.

Session 1: Introduction to Python

LIVE SESSION: Wednesday 3rd April @ 6PM (GMT)

  1. Install Python on your machine 
  2. Why learn Python? 
  3. Hello World!
  4. Variables
  5. Conditions

Session 2: Operations in Python

LIVE Session: Wednesday 10th April @ 6PM (GMT)

  1. Assigning Values
  2. Comparing values
  3. Assessing Logic 

Session 3: Function in Python

LIVE Session: Wednesday 17th April @ 6PM (GMT)

  1. Lambda functions
  2. Local and Global Scope
  3. Spelling checker project

Session 4: Statements, arguments and libraries in Python

LIVE Session: Wednesday 24th April @ 6PM (GMT)

  1. Python Libraries 
  2. Return Statements
  3. Arguments
*LIVE* MOOC SPRINT: GET CERTIFIED (FOR FREE!)
Free and open to all CFG Members​
Intro to Coding

STARTS: Tuesday 2 APRIL 2024 @ 6.00PM

Coding is how we communicate with computers! If you want to dip your toe into the world of programming, this MOOC is perfect for you. Each week, you’ll get an overview of different elements of coding and a great foundation to start building upon your knowledge further. It could be the first step in your journey to getting into tech!

Session 1: What is coding and why is it important?

LIVE Session: Tuesday 2nd April @ 6 PM (GMT)

  1. Intro to coding
  2. Compiler vs Interpreter
  3. Low level vs High-level programming language
  4. Basic concepts of computer programming, such as variables
  5. Different types of data types – Integer, Floating points (Decimals), Booleans

Session 2: Different Forms of Data Structures

LIVE Session: Tuesday 9th April @ 6 PM (GMT)

  1. Operators in programming- +,-,*,/,%,&,|, >,<,!,~, etc
  2. Strings
  3. Lists or Arrays
  4. Associated arrays such as Dictionary, Maps

Session 3: Control Structures and Functions

LIVE Session: Tuesday 16th April @ 6 PM (GMT)

  1. Conditional Statements – If, Else if and Else
  2. Loops – for, while, do-while and their basic structure
  3. Commonly used keywords with Loops- break, continue, pass
  4. Functions

Session 4:Errors, Types of Errors and Error Handling

LIVE Session: Tuesday 23rd April @ 6 PM (GMT)

  1. Syntax errors, logic errors, runtime errors
  2. How to troubleshoot and debug code
  3. Art of Pseudocode and making flowchart
  4. A small taste of how to write simple programs in a programming language, such as Python
*NEW* MOOC CHALLENGE
Free and open to all CFG Members​
Intro to coding

STARTS: Tuesday 14th May @ 7:30PM

Our MOOC Challenges give you the opportunity to test your knowledge and skills with a challenge, project or task using real-world examples.

CHALLENGE SESSIONS

Week 1 – Tuesday 14th May (Kick-off event & challenge revealed)

Weeks 2 & 3 – Wednesday 15th May – Project work begins for final hand on Tuesday 11th June

Week 4: Friday 14th June – Winners announced

TEST YOUR KNOWLEDGE, BUILD A PORTFOLIO

Challenges and projects are a great way to not only test your knowledge but also to build a portfolio and bits on your CV!

OPEN TO ALL

Our MOOC Challenges are also open to all CFG members globally and are 100% free for all participants.

*LIVE* MOOC SPRINT: GET CERTIFIED (FOR FREE!)
Free and open to all CFG Members​
CAREER DEVELOPMENT

STARTS: Thursday 4 April @ 6.00PM

Are you eager to unlock your full potential and make significant strides towards professional success? Look no further! Our Career Development MOOC is designed to empower individuals like you, equipping you with the essential skills and strategies needed to excel in today’s competitive job market. By signing up for this MOOC, you’ll gain invaluable insights and actionable knowledge that will set you apart from the crowd and open doors to exciting opportunities!

Session 1:  Introduction to career development

LIVE Session: Thursday 4th April @ 6 PM (GMT)

  1. Things you should know before embarking on your career development journey
  2. Internal and external barriers to growth for women in the workplace 
  3. Self-advocacy 
  4. Brag docs – track your achievements and make them visible

Session 2: Skills development

LIVE Session: Thursday 11th April  @ 6 PM (GMT)

  1. Progression frameworks 
  2. How to leverage your progression framework for career growth (and what to do if you don’t have one) 
  3. Which technical skills should you learn? 
  4. Feedback loops

Session 3: Just keep growing, just keep growing, just keep growing growing growing (Finding Nemo reference)

LIVE Session: Thursday 18th April @ 6 PM (GMT)

  1. Making decisions  on when it’s time to move on
  2. Way to develop your career beyond promotions  
  3. Pivoting your role 
  4. Getting the most out of your manager 
  5. Mentorship 

Session 4:  Other Awesome Career Development Tools

LIVE Session: Thursday 25th April @ 6 PM (GMT)

  1. Networking 
  2. Community 
  3. The art of negotiation 
*LIVE* MOOC SPRINT: GET CERTIFIED (FOR FREE!)
Free and open to all CFG Members​
INTRO TO C#

STARTS: Monday 8 April @ 6.00PM

Want to unlock exciting career opportunities in software development? Join our C# MOOC and master a powerful, in-demand programming language! C# is your gateway to building modern applications, games, and web services. Our MOOC provides a structured, beginner-friendly approach, taking you from the fundamentals to practical coding skills. With expert instructors and a supportive community, you’ll be well on your way to becoming a confident C# developer.

Session 1: Introduction to C#

LIVE Session: Monday 8th April @ 6 PM (GMT)

  1. Why C#?
  2. Setup
  3. Data Types
  4. Operators
  5. Variables
  6. Conditionals

Session 2: C# Fundamentals

LIVE Session: Monday 15th April  @ 6 PM (GMT)

  1. Functions (Methods)
  2. Working with user input
  3. Arrays
  4. Loops

Session 3:  Core Concepts I

LIVE Session: Monday 22nd April @ 6 PM (GMT)

  1. Making decisions  on when it’s time to move on
  2. Way to develop your career beyond promotions  
  3. Pivoting your role 
  4. Getting the most out of your manager 
  5. Mentorship 

Session 4: Core Concepts II

LIVE Session: Monday 29th April @ 6 PM (GMT)

  1. Interfaces
  2. Inheritance
  3. Extra: Lists

MOOC SPRINT: ON DEMAND LIBRARY

Even though these live MOOC Sprints have ended, you can still catch up and access all the recorded content led by our fantastic instructors. 

Much like any role in tech, you’ll get involved in sprints to build and ship new tech features and products. Our MOOC Sprint on-demand library features quick learning courses that will give you good foundational knowledge across key tech topics, including coding languages, problem-solving and career confidence. MOOC sprints are open to all CFG members globally and are 100% free for all participants.

*Please note there is no certification on completing MOOCs from the on-demand Library. If you would like to get certified, please join our live sessions above.

available on demand until 25.03.24
Free and open to all CFG Members​
Intro to Coding

Coding is how we communicate with computers! If you want to dip your toe into the world of programming, this MOOC is perfect for you. Each week, you’ll get an overview of different elements of coding and a great foundation to start building upon your knowledge further. It could be the first step in your journey to getting into tech!

Session 1: What is coding and why is it important?

  1. Intro to coding
  2. Compiler vs Interpreter
  3. Low level vs High-level programming language
  4. Basic concepts of computer programming, such as variables
  5. Different types of data types – Integer, Floating points (Decimals), Booleans

Session 2: Different Forms of Data Structures

  1. Operators in programming- +,-,*,/,%,&,|, >,<,!,~, etc
  2. Strings
  3. Lists or Arrays
  4. Associated arrays such as Dictionary, Maps

Session 3: Control Structures and Functions

  1. Conditional Statements – If, Else if and Else
  2. Loops – for, while, do-while and their basic structure
  3. Commonly used keywords with Loops- break, continue, pass
  4. Functions

Session 4:Errors, Types of Errors and Error Handling

  1. Syntax errors, logic errors, runtime errors
  2. How to troubleshoot and debug code
  3. Art of Pseudocode and making flowchart
  4. A small taste of how to write simple programs in a programming language, such as Python
available on demand until 26.03.24
Free and open to all CFG Members​
intro to python

Python is an interpreted, object-oriented, high-level programming language with dynamic semantics. Python is commonly used for developing websites, task automation, data analysis, and data visualisation. Due to the nature of Python, it is regularly used in industries and roles such as accountants and scientists, for a variety of everyday tasks.

Session 1: Introduction to Python

  1. Install  Python on your machine 
  2. Why learn Python? 
  3. Hello World!
  4. Variables
  5. Conditions
  6. Tutorial: Drawing snowflakes with turtles exercise

Session 2: Operations in Python

  1. Arithmetic 
  2. Assigning Values
  3. Comparing values
  4. Assessing Logic 
  5. Manipulating bits

Session 3: Functions, conditionals, loops

  1. Loops 
  2. Writing/Manipulating Lists 
  3. Data Types
  4. Correcting Errors

Session 4: Final Session

  1. Python Libraries 
  2. Challenge explanation
  3. Further development and Opportunities with Python
available on demand until 03.04.24
Free and open to all CFG Members​
intro to web Dev

Where the online world dominates every aspect of our lives, having the skills to create and maintain captivating websites is more essential than ever. Whether you are a beginner looking to kickstart your web development career or an experienced professional aiming to enhance your existing skills, this course is designed to equip you with the knowledge and tools necessary to build engaging websites that leave a lasting impact. With a combination of theoretical concepts, practical hands-on exercises, and interactive learning modules, you will gain an understanding of web design principles, HTML, CSS, JavaScript, and more.

Session 1:  Intro to HTML

  1. What Is HTML?
  2. Essential HTML, Boilerplate and Syntax
  3. HTML with CSS and Javascript
  4. Coding Practice – Building the foundations of your website

Session 2: Intro to CSS

  1. What is CSS
  2. Basic Syntax
  3. Accessibility
  4. Coding Practice: Styling your first website and linking CSS to HTML

Session 3: Intro to JS

  1. What is Javascript?
  2. Data Types
  3. Variables
  4. Functions
  5. Coding Practice – Developing interactivity and linking to relative files

Session 4: JS: The DOM

  1. Advanced JavaScript
  2. The DOM
  3. Coding practice: Use the DOM to change our website
available on demand until 04.04.24
Free and open to all CFG Members​
AGILE & SCRUM

Where the online world dominates every aspect of our lives, having the skills to create and maintain captivating websites is more essential than ever. Whether you are a beginner looking to kickstart your web development career or an experienced professional aiming to enhance your existing skills, this course is designed to equip you with the knowledge and tools necessary to build engaging websites that leave a lasting impact. With a combination of theoretical concepts, practical hands-on exercises, and interactive learning modules, you will gain an understanding of web design principles, HTML, CSS, JavaScript, and more.

Session 1:  Introduction to Agile and Scrum

  1. Agile vs. Waterfall
  2. Different Agile Frameworks
  3. Benefits and features of Scrum

Session 2: Sprints, teams and ceremonies

  1. Team members involved in Scrum
  2. What is a sprint
  3. Scrum ‘ceremonies’

Session 3: Jira to manage your Scrum project

  1. Introduction to Jira
  2. How to create a stories & epics
  3. Boards, Filters & JQL

Session 4: Scrum in real life

  1. More Jira: Dashboards
  2. Common Scrum misconception & challenges
  3. Scrum master  day-to-day
available on demand until 22.04.23
Free and open to all CFG Members​
intro to javascript

JavaScript is a dynamic programming language that’s used for web development, in web applications, game development, and loads more. It allows you to implement dynamic features on web pages that cannot be done with only HTML and CSS. Our Intro to JavaScript MOOC Sprint will give all members an initial intro to key concepts and this is a fantastic starting point for anyone who is curious about coding and would like a few taster sessions to understand how it can work across tech and businesses.

Session 1: Hello World

  1. Overview of JS
  2. Strings & Output
  3. Constants & Debugging
  4. Joining Strings

Session 2: Unleashing Variables and Numbers

  1. Data Types
  2. Numbers & Input
  3. Variables with let
  4. Comparison Operators

Session 3:  Making Decisions

  1. Conditional statement 
  2. Logical Operators
  3. Functions
  4. Data types: Undefined and Null

Session 4: Working with Data

  1. Arrays 
  2. Arrays: Push and Pop 
  3. Objects 
  4. Loops: For 
  5. Loops: While
available on demand until 23.03.23
Free and open to all CFG Members​
INTRO TO DATA

Let’s get into this Intro to Data MOOC! Here, you’ll learn all about the basics of data including key languages like SQL – SQL allows you to manipulate data in a useful way. In this MOOC, you’ll understand the possibilities of what we can do with data and how to do it.

Session 1: SQL Basics

  1. Understanding what SQL is and how it is used
  2. Understanding databases, tables and basic syntax
  3. How to build databases and tables, and how to populate
  4. Understand basic operators and how these can be applied in the WHERE clause 

Session 2: SQL Commands & Normalisation

  1. Introduction to SQL commands: DML and DDL statements
  2. Practical application of SQL commands
  3. Normalisation and 1-3NFg
  4. Normalisation practical

Session 3: Keys and Joins

  1. Identification of Candidate Keys
  2. Primary and Foreign Keys
  3. Types of Joins
  4. Joining Tables with Keys

Session 4: Aggregation and Sorting

  1. Aggregation in SQL
  2. SUM, COUNT, AVERAGE, MIN & MAX
  3. GROUPING and ORDERING
  4. Briefing for the Challenge

MOOCS

FAQS

The CFG Massive Open Online Courses come in two forms – our MOOC Sprints and our MOOC Challenges. Both are great for beginners or those with some tech knowledge and know-how! These 100% free MOOC sessions will introduce you to in-demand tech concepts, languages, and other key skills.

Our MOOC Sprints are a 1-hour session each week over four weeks and will give you a great taste of key tech topics – from UX/UI to bug fixing, languages to CVs and applications. After each session, you will need to complete a quick quiz on the topic.

These sessions are recorded and can be watched later, however, to get the most out of the sessions, we recommend attending live to take part in interactive tasks and engage with the instructors. Those who complete the MOOC Sprint within the initial time frame (usually 6 weeks) will receive a certification.

Our MOOC Challenges come after the Sprints and allow members to take part in a challenge – our mini ‘Hackathon’ to test their knowledge and skills. Both MOOC Sprints and Challenges are great for CFG members at any level – from beginner to more advanced.

Yes, our MOOCs are 100% free and sessions will introduce you to in-demand tech concepts, languages, and other key skills.

Other questions? Visit our knowledge base for more information.

MOOC Sprints & Challenges Web Images

BECOME A CODE FIRST GIRLS MEMBER

Skip to content