Technology : Intro to Data in Association with Code First Girls – 4 Part Course

Sign Up Now: £0.00

Starts: Monday, 03 June 2024 at 6:00PM
Ends: Monday, 24 June 2024 at 6:00PM



Available spaces: 412
Host: Code First Girls

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.

This 4-part course takes place over 4 weeks and will be hosted via Code First Girls online teaching platform in webinar format. 

This course is great for beginners or anyone that fancies a little refresher or upskill opportunity! Learn the principles of key tech topics with Code First Girls 'MOOC' (Massive Open Online Courses) Sprints and test your knowledge with MOOC Challenges.

Please note these courses are available to anybody who identifies as a woman and is over the age of 18.

 

Session 1: SQL Basics

PRE-RECORDED Session: Monday 3rd June @ 6pm - 7pm

  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

PRE-RECORDED Session: Monday 10th June @ 6pm - 7pm

  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

PRE-RECORDED Session: Monday 17th June @ 6pm - 7pm

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

 

Session 4: Aggregation and Sorting

PRE-RECORDED Session: Monday 24th June @ 6pm - 7pm

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

 

Find out more about Code First Girls:

Code First Girls has become one of the largest providers of free coding courses for women globally, having delivered over £75 million worth of free technology education and teaching three times as many women to code as the entire UK university undergraduate system!

They’re on a mission to close the gender gap in the tech industry by providing employment through free education. They’ve already helped more than 150,000 women learn to code and by working with companies globally, we’re boosting employability, diversity and social mobility, transforming local economies and communities.

 

When you sign up to this course, you will receive a link which will take you through to the Code First Girls platform where you will need to fill in a registration form. Upon completion you will then be fully registered to the course and will receive a confirmation email directly from Code First Girls which will include your links to join each live session. After each live session takes place, a follow up recording link will be sent to you to allow you to catch up and a mini quiz.