/
/
/
/

SQL Queries 1-Day Course

(4.8)17 reviews
Recent reviews of this course provider

Pivot tables in 45 minutes

Excellent course. My teacher Sarah was really good and took me through how to cr...more

See all reviews
Add to shortlistShortlisted by 18 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

Course info
481 views
Start Date: Mon 27th May 2019
START DATES
MAY 2019
Sun Mon Tue Wed Thu Fri Sat
JUNE 2019
Sun Mon Tue Wed Thu Fri Sat

Location:

Manchester, M1 5AN, Portsmouth, PO6 3EZ, Southend-On-Sea, SS1 1NE, Milton Keynes, MK9 2UB, London, WC2N 4JF + 1 more

Time:

11:00am - 6:00pm

Duration:

1 day

Attendance:

Full time, Part time day

Qualification:

Qualification awarded by the course provider

Level:

BeginnerIntermediateAdvanced

From: £300

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

17 reviews

(94%)
(6%)

Average student ranking

Reviews of this course

pcworkshops

Great introduction to SQL!
5 5
Hotcourses
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
3 Hotcourses user(s) found the following review helpful.

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

Pivot tables in 45 minutes
5 5
Hotcourses
December 2017

Excellent course. My teacher Sarah was really good and took me through how to create pivot tables step by step. She made it simple and straightforward. I can now create a pivot table with confidence. You also get a certificate of attendance. I would highly recommend this course to a friend. Sharmini Shanthakumar

Was this review helpful? Yes No
2 Hotcourses user(s) found the following review helpful.

pcworkshops

Java taster
5 5
Hotcourses
December 2017

Sarah is an excellent mentor . She taught me well in such a short span of time and gave sufficient material to get a feeling of programming in Java. Thanks!! Rahul

Was this review helpful? Yes No
3 Hotcourses user(s) found the following review helpful.

Please note reviews of Java Programming "Taster" Course, 1 Day are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course photos

  • SQL Queries 1-Day Course by PCWorkshops on Hotcourses

Ask a question

Get course info