Skip Main Navigation
Page Content

Save This Event

Event Saved

SQL Queries 1-Day Course, Manchester

PCWorkshops

Monday, 3 December 2018 from 11:00 to 18:00 (GMT)

SQL Queries 1-Day Course, Manchester
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
SQL Introduction Course
Thanks for booking! Please call us on 020 7164 6359 or 07784 357309 to confirm your attendance. Keep the mobile number for your contact on the day.
1 Dec 2018 £380.00 £0.00
SQL Introduction Course, Advanced Booking
Please call us on 020 7164 6359 or 07784 357309 to confirm your attendance. Keep the mobile number for your contact on the day. Thanks for booking!
26 Nov 2018 £350.00 £0.00

Share SQL Queries 1-Day Course, Manchester

Event Details

SQL Course summary

Get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course. Queries are made easy and simple by this hands-on, practical course. Ask your SQL questions in small, friendly classroom SQL Course. Save hours of online training.

This course is Platform Independant. 

SQL Course Outline

Relational Database Concepts

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


SQL Language Essentials

  • The SQL Select Statement
  • SQL Conditions and the Where Clause
  • The SQL Order By Clause
  • SQL Arithmetic Operations
  • SQL Column Aliases


SQL Summarizing and Grouping Data

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


Querying Multiple Tables

  • Joining Tables
  • Inner Joins, Outer Joins, Self Joins, Full Joins, Alternative Join Syntax


Additional SQL Features

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

 

WHAT IS INCLUDED:
  • SQL Course Certificate 
  • Course notes 
  • Tea, coffees, but no lunch 
  • Max group size is 4. 
Do you have questions about SQL Queries 1-Day Course, Manchester? Contact PCWorkshops

Save This Event

Event Saved

When & Where


PCWorkshops Manchester
Pall Mall Court
61-67 King Street Manchester
M2 4PD Manchester
United Kingdom

Monday, 3 December 2018 from 11:00 to 18:00 (GMT)


  Add to my calendar

Organiser

PCWorkshops

  • PCWorkshops  is a specialist provider of training courses in Java programming, Databases and MS Project.

More about us:

Our up-to-date training courses are designed and delivered by registered, qualified instructors with a wealth of experience in software development and training.

The maximum class-size is normally 4.

Every one gets personalised attention.

Why learn with us at PCWorkshops:

Up-to-date relevant courses for todays’ business world

Trainers with professional experience

Award Winning Trainer

21 Years In Business

Excellent Client References

Assessment-based certificate, Oracle exam vouchers

Weekdays, Evenings and Weekends

At PCWorkshops, we love out job!

We offer Training Courses in Software Packages:

MS Project Training

Database design and Data Normalisation

SQL Courses

Data Analysis and Data visualtion courses

MS Excel, data analyses with Excel. Excel VBA

Access Database Courses.

Java Programming.

MS Office Training.

Our Style:

Relaxed, Practical, Useful

Methods of instruction:

Classroom training with max class-size 4 peopl

Virtual classrooms

1-1 mentoring

Customised training

Certification:

Our PCWorkshops certificates are assessment based.
Our course outlines are in-line with Oracle courses. We assist with exam prep for the presitigeous, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of data
Software companies, testing companies,companies who employ software developers
Coders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 

 

  Contact the Organiser

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.