SQL Query, 1 Hour. Which Customer Bought The Most Beverages?

Actions Panel

SQL Query, 1 Hour. Which Customer Bought The Most Beverages?

1-Hour Power Session to understand the basics of SQL Queries. Practical. Online, Instructor-Led.

By PCWorkshops

Location

Online

Refund Policy

Contact the organiser to request a refund.
Eventbrite's fee is nonrefundable.

About this event

SQL Query Basics 1 Hour.

Who bought the most beverages?

Fun and informative 1-hour SQL Queries Tutorial, online, instructor-led.

This 1 HOUR course is packed with power query techniques.

We will inthis hour reveal, which customer bouth the most beverages

SQL Query Basics Course Description

Relational Database Concepts:

  • What is a Relationship? Primary Keys and Foreign Keys

SQL Language Essentials:

  • The SQL Select Statement
  • SQL Where Clause
  • Like, Wildcards
  • The SQL Order By Clause
  • SQL Column Aliases
  • Working with Null Values

Expressions :

  • Arithmetic Operations and Expressions
  • Group by and Aggregates: Sum
  • Top / Limit
  • Inner Joins

What is included in the SQL Course:

  • SQL Basics 1-Hour Course Certificate on completion.
  • SQL Course notes.
  • Practical SQL Course exercises.
  • After the course, 1 online free revision / questions session .
  • Max group size on this SQL Online Course is 4.

Organised by

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

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.

 

 

 

£15