£360.75 – £376.88

Multiple Dates

SQL Queries and Data Analytics 1-Day Workshop, Portsmouth

Event Information

Share this event

Date and Time

Location

Location

Portsmouth

Lakeside 1000, North Harbour

London

PO6 3EN

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

SQL Queries 1-Day Course

Provides the knowledge and skills needed to retrieve and analyse data held in a database.

Who Should Attend

Anyone who needs to understand and use SQL to manipulate a database. There are no formal pre-requisites for this course, although an understanding of databases and exposure to information technology in general would be useful.

Course Outline

Relational Database Concepts

  • What is a Relational Database?
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Data Types
  • The Data Dictionary
  • Getting Started

SQL Language Essentials

  • The Select Statement
  • The Select and From Clauses
  • Conditions and the Where Clause
  • The Order By Clause
  • Arithmetic Operations
  • Column Aliases
  • Practical Exercises

Summarizing and Grouping Data

  • Aggregate Functions
  • The Group By Clause
  • The Having Clause
  • Practical Exercises

Querying Multiple Tables

  • Joining Tables with Inner Joins
  • Column Qualification and Table Aliases
  • Outer Joins, Self Joins, Alternative Join Syntax
  • Practical Exercises

Additional SQL Features

  • Combining Queries
  • The Union, Intersect and Minus Operators
  • Basic Subqueries
  • Practical Exercises

INCLUDED:

What can/can't I bring to the event?

You can bring your own Laptop - let us know beforehand

You can bring your own data and examples - let us know beforehand

Refreshments: Tees, coffees and light refreshments are included in the price

Certificates: You will get attendance certificates

Included: Notes. Query examples and exercises.

After course support: 2-hours online revision session

Share with friends

Location

Portsmouth

Lakeside 1000, North Harbour

London

PO6 3EN

United Kingdom

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved