course-premium

Introduction to SQL 1-Day Course

PCWorkshops
4.8
6 reviews
  • Training Time well spent Usual high standard of training given at a pace which suits me. Trainer was friendly and efficient and able to provide a great background on the topic. Support materials are helpful and appropriate.
    ← | →
  • I recommend Sarah Barnards and her org PCWorkshop for full stack training. I have known Sarah for a short time. I am head of an organization that is bringing a new product in the Apartment and house rental field to market. The reason I hired Sarah was so that I could understand what my programmers were creating. We are in the middle of the training right now, we have already discussed many items in SQL and I must say I feel much more relaxed and confident about how SQL works and I believe that my programmers will be able to talk to me and I will be able to listen and understand them in a more comprehensive way. I think I will not feel overwhelmed and that I will be able to comment on the coding and ask questions and clarifications. Sarah's method is straightforward with many examples. She has answered my every question and I feel I have learned a lot. My rule was no homework for me. haha. She has been able to teach me and not give me homework to do. I look forward to our every lesson. Presently we study together 4 days a week, 2 hours at a time. She has managed to modify her method to teach me. I recommend Sarah Barnard and her org PCWorkshop.
    ← | →
  • I am glad a 1 day course exists as I am quite a busy person and this course is just perfect for someone like. I felt like I mastered everything quite quickly and that's what everyone wants in a course. Would recommend.
    ← | →

Short course

In Jersey Guernsey (UK Offshore Dependencies)

£ 350 VAT exempt

Learn SQL from the beginning to an intermediate level!

  • Type

    Short course

  • Location

    Jersey guernsey (UK Offshore Dependencies)

  • Class hours

    7h

  • Duration

    1 Day

Immerse yourself in the world of SQL with this Introduction to SQL intensive course, offered by PCWorkshops, that Emagister.co.uk has added to its educational catalogue.

Thanks to this course, you will 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 Independent. You will learn Relational Database Concepts, SQL Language Essentials, to summarize and group data, to query multiple tables, and some additional SQL features such as how to combine queries, the Union, Intersect and Minus Operators and basic subqueries.

So, if you want more information about this programme contact PCWorkshops through Emagister.co.uk without hesitation. You won’t regret it!

Facilities

Location

Start date

Jersey Guernsey (Channel Islands)
See map

Start date

Different dates availableEnrolment now closed

About this course

Learn SQL from the beginning to an intermediate level, including aggregates and join.

Data Professionals who would like to gain SQL skills for better use of BI Programs or to understand queries already supplied, or to enter into this new discipline.

Some understanding of data.

Internal Certificate.

This course is lead by experienced professionals who concentrate on delivering quality training. The course content is organized into clear, well-structured and well-paced lessons with practical examples and exercises.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.8
excellent
  • Training Time well spent Usual high standard of training given at a pace which suits me. Trainer was friendly and efficient and able to provide a great background on the topic. Support materials are helpful and appropriate.
    ← | →
  • I recommend Sarah Barnards and her org PCWorkshop for full stack training. I have known Sarah for a short time. I am head of an organization that is bringing a new product in the Apartment and house rental field to market. The reason I hired Sarah was so that I could understand what my programmers were creating. We are in the middle of the training right now, we have already discussed many items in SQL and I must say I feel much more relaxed and confident about how SQL works and I believe that my programmers will be able to talk to me and I will be able to listen and understand them in a more comprehensive way. I think I will not feel overwhelmed and that I will be able to comment on the coding and ask questions and clarifications. Sarah's method is straightforward with many examples. She has answered my every question and I feel I have learned a lot. My rule was no homework for me. haha. She has been able to teach me and not give me homework to do. I look forward to our every lesson. Presently we study together 4 days a week, 2 hours at a time. She has managed to modify her method to teach me. I recommend Sarah Barnard and her org PCWorkshop.
    ← | →
  • I am glad a 1 day course exists as I am quite a busy person and this course is just perfect for someone like. I felt like I mastered everything quite quickly and that's what everyone wants in a course. Would recommend.
    ← | →
100%
5.0
excellent

Course rating

Recommended

Centre rating

Tim Rawlings

4.0
16/04/2021
About the course: Training Time well spent Usual high standard of training given at a pace which suits me. Trainer was friendly and efficient and able to provide a great background on the topic. Support materials are helpful and appropriate.
Would you recommend this course?: Yes

Howard Haimovitch

5.0
30/03/2021
About the course: I recommend Sarah Barnards and her org PCWorkshop for full stack training. I have known Sarah for a short time. I am head of an organization that is bringing a new product in the Apartment and house rental field to market. The reason I hired Sarah was so that I could understand what my programmers were creating. We are in the middle of the training right now, we have already discussed many items in SQL and I must say I feel much more relaxed and confident about how SQL works and I believe that my programmers will be able to talk to me and I will be able to listen and understand them in a more comprehensive way. I think I will not feel overwhelmed and that I will be able to comment on the coding and ask questions and clarifications. Sarah's method is straightforward with many examples. She has answered my every question and I feel I have learned a lot. My rule was no homework for me. haha. She has been able to teach me and not give me homework to do. I look forward to our every lesson. Presently we study together 4 days a week, 2 hours at a time. She has managed to modify her method to teach me. I recommend Sarah Barnard and her org PCWorkshop.
Would you recommend this course?: Yes

Jaime Deverall

5.0
22/07/2018
What I would highlight: I am glad a 1 day course exists as I am quite a busy person and this course is just perfect for someone like. I felt like I mastered everything quite quickly and that's what everyone wants in a course. Would recommend.
What could be improved: n/a
Would you recommend this course?: Yes

Adina Sims

5.0
03/06/2017
What I would highlight: 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 knowledgeable! Highly recommend it!
What could be improved: Nothing.
Would you recommend this course?: Yes

Rachel Ashton

5.0
15/11/2015
What I would highlight: It was great to be just me and my colleague - felt like we were able to cater the course exactly to our needs.
What could be improved: Nothing.
Would you recommend this course?: Yes

Dirk-Abe Schaafsma

5.0
08/11/2015
What I would highlight: Great to have a course for just 2.
What could be improved: Nothing.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2018

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • MySQL
  • Database
    2

    2 students say they acquired this skill

  • SQL
    2

    2 students say they acquired this skill

  • Database training
    2

    2 students say they acquired this skill

  • SQLite
  • Syntax
    1

    1 students say they acquired this skill

  • SQL Database
    2

    2 students say they acquired this skill

  • Oracle SQL*Plus
  • SQL Server
    1

    1 students say they acquired this skill

  • Relational Database
    2

    2 students say they acquired this skill

  • Multiple tables
    1

    1 students say they acquired this skill

  • SQL queries
    2

    2 students say they acquired this skill

  • Additional SQL Features
    1

    1 students say they acquired this skill

Teachers and trainers (1)

Mary Smith

Mary Smith

Tutor

How Mary Smith teaches: I am consultative, flexible and understanding. I appreciate the trust given to me. What Mary Smith teaches: Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder. Java Coding Basics.

Course programme

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 SQL Select Statement
  • The SQL Select and SQL From Clauses
  • Conditions and the Where Clause
  • The SQL Order By Clause
  • Arithmetic Operations
  • Column Aliases

Summarizing and Grouping Data

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

Querying Multiple Tables

  • Inner Joins
  • Column Qualification and Table Aliases
  • Multiple table joins
  • Left Joins
  • Self Joins

Additional SQL Features

  • Union, Union All
  • Intersect Operator
  • Minus / Except Operators
  • Basic Subqueries

See related categories

Introduction to SQL 1-Day Course

£ 350 VAT exempt