Learn SQL Basics, 1-Day Course

Course details
Learn SQL Course, 1-Day

    SQL Queries Course, 1-Day. Basic SQL syntax.
    Most attendees are in-work IT Professional.
    Private individuals are also very welcome.
    Evening courses also running.
    Our Style: Hands-on, Practical
    Location: Online, Instructor-led
    Download: anaconda.com
    Duration: 6 weeks, 1 evening per week, 6pm - 8pm
    Times: arrange a time for your time zone

Learn SQL Course, 1-Day

With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK.
Queries are made easy and simple, saving hours of online training.
This 1 Day course is packed with power query techniques.

This SQL Introduction Course is hands-on, practical with many excellent query examples.

This course is Platform Independent.

This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

Ask your SQL questions in small, friendly classroom SQL Course.

Online, Instructor-led, Interactive, full screen sharing.

Learn SQL Relational Database Concepts:

What is a Relational Database?
Tables, Rows and Columns
Indexes, Primary Keys and Foreign Keys
Data Types

Learn SQL Essentials:

SQL Language Essentials:
The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
SQL Arithmetic Operations, Expression Queries
SQL Column Aliases
Limit/Top, Distinct

Summarizing and Grouping Data:

Group by
Aggregate Functions (Sum, Avg, Count, Max, Min)
The Group By Clause
The Having Clause

Querying Multiple Tables:

Joining Tables
Inner Joins, Outer Joins, Self Joins, Full Joins,
Cross Joins
Alternative Join Syntax

Basic Subqueries

Basics of CTE tables
SQL subqueries
Using subqueries in the from clause
Using subqueries in the where clause
Using subqueries in the select clause
Using subqueries in the having clause

Combine Queries

Combine Queries
The Union Operator
Intersect and Minus Operators
Simulating combine Intersect and Minus queries by using sub-queries

What is included
  • PCWorkshops Course Certificate on completion
  • SQL Course Notes
  • SQL Code Examples
  • Practical SQL Course exercises and Code Samples
  • After the course: 1-Hour personalised online revision session
Book the SQL Course
About us
Learn SQL
Special Offers
PCWorkshops London
Special Offer on the 'Visual Data with Power BI' Webinar
Read More
PCWorkshops Manchester
Special Offer: Python Course
Read More
PCWorkshops Birmingham
Special Offer on the 'SQL Queries in 1-Day' webinar
Read More
PCWorkshops Southend-on-Sea
Special Offer on the 'Java Cross-Over for Coders' Webinar
Read More