Do I need to download software

You can use any sql database if you have access to one

What data-sets will I need

We use the data on w3schools for sql. you can also use this webiste's online sql editor

Friday, 2 May

SQL Basics 1 Hour Course : Which customer bought the most beverages?

SQL Query Basics: This is an interesting, practical introduction to SQL, to get you started with SQL. Even joins and group by's explained!

By PCWorkshops

Select date and time

Fri, 2 May 2025 05:00 - 06:00 PDT

Location

Online

Refund Policy

Refunds up to 7 days before event

About this event

Master SQL basics in 1 hour

This is an excellent SQL Summary to get you started with SQL Basics, including group by's and joins.

Course Details

Duration: 60 Minutes
Location: Online or In Classroom
Instructor-led: No training-bots in our classroom yet
Location: online, instructor-led.
Certificate: PCWorkshops certificate is issued on completion
Notes: Includes notes, exercises, and code samples.
Pre-requisites: No SQL knowledge is needed.
Software: You can code along or watch the demo.
Sample data: We will use an online platform where there is sample data available.

WHAT IS INCLUDED:

SQL Course Certificate
Course notes
Course exercises and worked examples
Personal attention, the maximum group size is 4.

COURSE OUTLINE

What is a Relational Database? Overview: Tables, Rows and Columns, Data Types

Relationships, Primary Keys and Foreign Keys

SQL Queries with the Select Statement
The Select and From Clause
Column Aliases
The Order By Clause
Conditions and the Where Clause
Arithmetic Expressions, (e.g. Price * Quantity)
Top Queries ( e.g. Top 1, for who bought the most )

SQL Query Summarizing and Grouping
SQL Aggregate Functions
Sum
The Group By Clause
Querying Multiple Tables

Joining Tables Inner Joins

Your Trainer

Sarah Barnard has been a software and database developer for 20+ years.

Alongside the training, she works as an independent freelancer as database developer on various freelancer website.

She has published 5000+ educational programming scripts, 49 training manuals, manages a Udemy channel and a Programming Languages Meetup group.

Organised by

PCWorkshops

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

Our classes are instructor led, in our Live Virtual Classroom
Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
The maximum groups size that can access our Virtual Classroom, is 4.
Every one gets personalised attention.

Why learn with us at PCWorkshops:

Excellent, up-to-date courses, following latest trends and technologies.
Excellent trainers with professional experience.

Award Winning Trainer

21 Years In Business
Excellent Client References
PCWorkshops Certificate
Weekdays, Evenings and Weekends
At PCWorkshops, we love out job!

We offer Training Courses in Software Packages:

Java Programming
Python Programming, Python data analytics, Python Machine Learning
Database design and Data Normalisation
SQL Courses
Data Analysis and
MS Excel, data analyses with Excel. Excel VBA
Access Database Courses.
MS Project Training
MS Office Training

Our Style:

Relaxed, Practical, Useful

Methods of instruction:

Classroom training with max class-size 4 people
Virtual classrooms via online video links
1-1 mentoring
Customised training

Certification:

Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualification

Customisation:

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

Terms and Conditions:

By booking a course with us, you agree to the terms and conditions specified on our website: https://pcworkshopslondon.co.uk/termsandconditions.html