" rel="stylesheet">
Skip Main Navigation
Page Content

Save This Event

Event Saved

SQL Queries 1-Day Seminar

PCWorkshops

Wednesday, April 12, 2017 from 11:00 AM to 6:00 PM (BST)

SQL Queries 1-Day Seminar
Available Dates

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
sql beginners 4 Tickets Apr 7, 2017 £350.00 £0.00

Who's Going

Loading your connections...

Share SQL Queries 1-Day Seminar

Event Details

SQL Queries 1-Day Course

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

Who Should Attend

Anyone who needs to understand and use SQL to manipulate a database. There are no formal pre-requisites for this Introduction to SQL 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
  • 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 canbring 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

Notes: You will get brief course notes 

After course support: 24-hours turnaround email support is included in the price

Telephone support: Call if you have questions, although me may only answer at around 4pm after lessons.

On-site support: 2-hours on-site support is included after the course, to be used within 2 weeks of completion

Have questions about SQL Queries 1-Day Seminar? Contact PCWorkshops

Save This Event

Event Saved

When & Where


http://www.connectionsattrafalgarsquare.com/location/
8 Northumberland Ave
WC2N 5BJ London
United Kingdom

Wednesday, April 12, 2017 from 11:00 AM to 6:00 PM (BST)


  Add to my calendar

Organizer

PCWorkshops

About Us

PC Workshops is an IT Training company with 21 years of IT training experience. 

Our inspiring IT training programs, aim to be practical and effective.

Specialties: MS Project, Java Programming,Database setup, SQL,  Excel, Microsoft Access,

MS Office (Word, PowerPoint, Publishing) Presentational skills training, Train-the-trainer

Winner : Trainer of the Year Award, 2007 awarded by the Learning and Performance Institute.

http://www.pcworkshopslondon.co.uk

Linkedin Profile

 

 

References:  

From: Aine

To: Sarah (Ms)

Date: 25/09/2014

Rating:                        

Report: Sarah is a fantastic tutor. She helped me to study for a Java Programming exam in University. I ended up doing really well in the exam thanks to Sarah. She not only has a brilliant understanding of the subject but also had the ability to explain things to me in a way I understood. I would recommend her to anyone!

 

From: Tim

To: Sarah (Ms)

Date: 15/08/2013

Rating:

Report: Sarah is a very versatile and knowledgeable tutor. She is very intelligent and so can understand the students specific needs very quickly (even in specialist areas of a wider subject). Sarah can focus her tutoring to be very fact and situation specific. Her teaching style is very relaxed and informative. I would fully recommend Sarah to anyone wanting to learn more in her chosen subject areas.

 

From: Mohamed

To: Sarah (Ms)

Date: 19/06/2014

Rating:

Report: Sarah Barnard is one of the greatest tutor that I have ever meet with, she has excellent knowledge for Javascript, SQL and Pseudo-Code .
She also has a great way of teaching. I really enjoyed learning from Sarah.

 

 

Our Location:

Training Location - 8  Northumberland Avenue, London, WC2N 5BY

  Contact the Organizer

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.