Skip to content

Introduction to Databases

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

Not currently scheduled

$380.00 per person (excl. GST)

Wellington

enquire about availabilityfor introduction_to_databases-wellington training

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

Course description

Download the Introduction to Databases course description (pdf)

Return to training pages

Click here to return to upcoming training pages
enquire about availabilityfor introduction_to_databases-wellington training