Wednesday, 19 June

SQL Crash Course: Which customer bought the most beverages?

SQL Query Basics: This is a fantastic intro to SQL,to get you started using SQL, Even joins and group by's explained!

By PCWorkshops

Select date and time

Wed, 19 Jun 2024 01:30 - 03:00 PDT

Location

Online

Refund Policy

Refunds up to 7 days before event

About this event

SQL 90 minutes Crash Course

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

Course Details

Duration: 90 Minutes
Location: Online or In Classroom
Instructor-led: No training-bots in our classroom yet
Joining Instructions: Full joining instructions will be sent ahead of the course.
Certificate: PCWorkshops certificate is issued on completion
Notes: Includes notes, exercises, code samples, some videos.
Pre-requisites: No SQL Knowledge needed, good for beginners.
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, max group size is 4.

COURSE OUTLINE

What is a Relational Database?

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
Wildcards
Working with null values

Expression queries
SQL Arithmetic Operation

SQL Query Summarizing and Grouping
SQL Aggregate Functions
Sum, Avg, Count, Max, Min
The Group By Clause
The Having 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.

Training manuals include SQL scripts for PostgreSQL, SQLite, Microsoft SQL Server, Oracle Database, MariaDB, Microsoft Access, SQLite3

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.

From £32.85