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.
