Teach the Nation to Code: Databases

27th - 28th of April | 10am - 4pm | Northumbria University Newcastle

TEACH THE NATION TO CODE IS A FREE CODING WORKSHOP WHICH IS AIMED AT INSPIRING YOU TO START A CAREER IN TECH.

Get in touch with us!

Fill in this form or feel free to call us on
+44 1273 022670

Register your free place here

Register now

The Trainers

Muhammad Shafeeq

ACADEMY TRAINER, QA CONSULTING

John Gordon

HEAD OF ACADEMY TRAINING, QA CONSULTING

What is Teach the Nation to Code?

In collaboration with QA Consulting, Northumbria University and the Institute of Code, Teach the Nation to code is a non profit lecture style event which aims to bridge the skills gap within the UK. We're looking to empower those looking to enter the world of technology with the basic skills to succeed in their journey. Bring your laptop and willingness to learn and we'll teach you Databases for free!

How we do it?

How we do it?

About the Course

When working with computing systems, storing and accessing data in a structured fashion, is often required. Storing and retrieving client details, social media posts, messages within messaging applications, and streaming services (to name a few) all require a Database (DB) of some description.

Databases allow us to use the important information that is required for everyday use within the IT industry.

This course will outline how to work with both SQL and NoSQL databases, and how to effectively store and retrieve information.

This course will This course will be split in to two domains: SQL and NoSQL.

  • SQL
    • How to install and setup MySQL
    • Analyse and understand the structure of a MySQL database
    • Learn basic MySQL Command Line Interface (CLI) syntax
    • Use the MySQL CLI to make queries
    • Design and Build SQL database
    • Some advanced MySQL concepts
  • NoSQL
    • Hot to install and setup MongoDB
    • Analyse and understand the structure of a MongoDB databse
    • Learn basic MongoDB Command Line Interface (CLI)
    • Design and build a NoSQL Database
    • Some advanced MongoDB concepts

Who should attend?

This course is well suited to any individual with little to no knowledge of Databases that have a desire to begin to bridge the technical skills gap, and add value to their skills set.

To anyone looking to bolster their current role, or those looking to move in to a role that would be well supported by database knowledge (researchers, analysts, students from all disciplines)

It would also act as an excellent refresher for those who have some exposure to database management before.

Outline

Introduction to Database Management Systems

Introduction to Structured Query Language (SQL)

  • Data Manipulation Language (DML)
  • Data Definition Language (DDL)
  • Data Retrieval Language (DRL)
  • Data Control Language (DCL)
  • Transaction Control Statements (TCS)

Create, Read, Update and Delete

  • CREATE TABLE
  • Constraints: Unique, Not Null, Check, Primary Key, Foreign Key
  • INSERT INTO: Inserting records in to tables
  • SELECT … WHERE: Select statement where [mathematical/relational/logical operators]
  • DELETE: Deleting records
  • UPDATE: Updating records
  • ALTER TABLE: Add or remove columns from existing tables; Add or remove constraints from existing tables

Advanced Select Statements

  • Clause, IN(), BETWEEN, LIKE()
  • ORDER BY: sorting records
  • Joining multiple tables together

Functions

  • String, Date, Group functions
  • GROUP BY
  • HAVING
  • Sub Queries

Views

Data Dictionaries

Performance & Indexing

Data Control Language (DCL)

  • GRANT and REVOKE
  • Introduction to privileges; System and Object

Introduction to NOSQL Databases

  • What are NoSQL Databases?
  • Common Database Features
  • NoSQL Versus Relational Approach
  • Types of NoSQL Databases

Installing MongoDB

Data Modelling and Design

  • Data Storage
  • Working with Datatypes
  • Collections
  • Document Datatypes
  • Creating  _id Fields

Querying Data

  • Databases and Collections
  • Querying Collections
  • Working with Operators
  • Referencing a Database
  • Querying Dates

The Aggregation Framework

  • Aggregating Results
  • Single Purpose Functions
  • The Aggregation Pipeline
  • Data Aggregation Operators

Manipulating Data

  • Inserting Data into Collections
  • Updates
  • Deletes
  • Atomic Operations
  • Removing Data
  • Capped Collections

High Performance Options

  • Creating Indexes
  • Index Properties
  • Specialised Index Types
  • Replication
  • Sharding

You only need to submit a short form!

Register your free place here

Register now