/
/
/
/

SQL Queries 1-Day Course

(5.0)15 reviews
Recent reviews of this course provider

Great introduction to SQL!

I loved taking this course. I truly felt like i left understanding the basics of...more

See all reviews
Buy a voucher
Add to shortlistShortlisted by 11 people

https://www.hotcourses.com/courses-by-subject/SQL-Queries-1-Day-Course-courses/56209426/

Course description

SQL Queries 1-Day Course:

Get interesting, insightful and essential business intelligence from data by using SQL queries. It is made easy and simple by this hands-on, practical course. Ask you questions in small, friendly class-room training. Save hours of online training.

This course is Platform Independant.

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

Summarizing and Grouping Data

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

Querying Multiple Tables

  • Joining Tables
  • Inner Joins
  • Column Qualification and Table Aliases
  • Outer Joins
  • Self Joins
  • Alternative Join Syntax

Additional SQL Features

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

Additional entry requirements

Some experience working with data would be good but not necessary

Training for employers

This course has been specifically designed for companies training their employees.

Course info
392 views
Start Date: Fri 30th June 2017
START DATES
JUNE 2017
Sun Mon Tue Wed Thu Fri Sat
JULY 2017
Sun Mon Tue Wed Thu Fri Sat

Location:

Manchester, M2 2AN, Portsmouth, PO6 3EZ, Southend-On-Sea, SS1 1NE, Milton Keynes, MK9 2UB, London, WC2N 5BY

Time:

11:00am - 6:00pm

Duration:

1 day

Attendance:

Full time, Part time day

Qualification:

Qualification awarded by the course provider

Level:

BeginnerIntermediateAdvanced

Class size:

Max size:4

From: £262.50

Other SQLS training courses

Data Analysis using Microsoft SQL Report Builder

PCWorkshops

Duration: Variable

Intermediate

Certificate of Attendance

View 1 courses

Summary of all course reviews for PCWorkshops

15 reviews

(100%)

Average student ranking

Reviews of this course

pcworkshops

Great introduction to SQL!
5 5
Hotcourses
SQL Queries 1-Day Course (Booked online with Hotcourses)
by John - June 2017

I loved taking this course. I truly felt like i left understanding the basics of SQL and immediately booked the next level course. The course teacher Sarah was a delight and very knowledgable! Highly recommend it!

Was this review helpful? Yes No

Please note reviews of SQL Queries 1-Day Course are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Reviews of other courses at PCWorkshops

pcworkshops

Fantastic course, highly recommended!
5 5
Hotcourses
by Lucy - March 2017

I had my course with Sarah today and I was really impressed. We worked through my spreadsheets which I brought with me on my laptop, and we also ran through some example spreadsheets so that I could get the hang of various functions and formulae not relevant to my spreadsheet, but useful to know and practice in general. It was actually really fun! I estimate today will make me about 20% more efficient in my work, so thank you Sarah! Also, the venue was lovely.

Was this review helpful? Yes No

pcworkshops

Strongly recommended
5 5
Hotcourses
by banox - January 2017

Very happy with the efficiency and proficiency in teaching. Many thanks!

Was this review helpful? Yes No
MORE REVIEWS

Please note reviews of MS Project Intermediate / Advanced, (2007, 2010, 2013,2016), Private, One-to-one, Customised are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course photos

  • SQL Queries 1-Day Course by PCWorkshops on Hotcourses

Hotcourses promise to you

Here at Hotcourses, our aim is to make things as easy as possible for you when booking your course. That’s why we promise –

To keep the booking process safe and secure

Our payment systems are Verisign secured and all details are stored encrypted via Sagepay, a leading UK payment gateway.

That you can book with confidence

We don’t transfer your money to the people running your course until it starts, so that if the worst happens we can deal with it for you.

To be transparent

The organisers of the course are the ones who set the cancellation terms and any refund arrangements but we will show you these so you can make an informed booking.

View the cancellation policy for PCWorkshops

To share experiences

Some of our reviews are flagged as ‘Booked through Hotcourses Marketplace’ to indicate that you’re reading the genuine opinion of someone who has taken the course. How do we know? We took their booking!

Ask a question

Get course info
Add to shortlist