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

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.