Introduction to Databases (Wellington)

27 Jan 2017
Cost per person (ex gst): 
$380.00
Duration: 
1/2 day
Location: 
Wellington

About the course

Get database basics under your belt. This course will provide an introduction to database concepts, and techniques for working with SQL databases.

Course outline

Introduction

  • Data
  • Data Storage
  • Unstructured Data
  • Structured Data
  • Undescribed Data
  • Described Data
  • Separately Described Data
  • Containers for Data

Relational Databases

  • Overview
  • A Real Product
  • First Tables
  • First Data
  • Constraints
  • Normalization
  • More Normalization
  • About Null
  • Customizing Query Results
  • Query Techniques - Lists
  • Query Techniques - Sub Selects
  • Set Operations
  • Ordering
  • Aggregates

Note: These are the topics normally covered but might alter slightly depending on the needs of the attendees.

Target Audience

Anyone who has dabbled in databases but would like a more in-depth grounding in their use.

Prerequisites

  • Some exposure to usage of command line on Linux or Windows
  • Ideally some exposure to database use

Download Introduction to Database training course description (pdf)

Register now >