Get dates and book
SOUTHEND-ON-SEA: The Forum, Elmer Square, Southend-on-Sea SS1 1NS

SQL Course, SQL Queries, 1 Day

SQL Course. 1 day, summary

With SQL Queries, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course. Queries are made easy and simple by this hands-on, practical course. Ask your SQL questions in small, friendly classroom SQL Course. Save hours of online training.
This course is Platform Independant.
This 1 Day course is packed with power query techniques.
This SQL Introduction Course is hands-on and practical with many excellent query examples.

SQL Course London Description

Relational Database Concepts:

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

SQL Language Essentials:

The SQL Select Statement
SQL Conditions and the Where Clause: >,<,>=,<=,=,, Not, Between, AND, OR, Like, Wildcards
The SQL Order By Clause
SQL Arithmetic Operations, Expression Queries
SQL Column Aliases
Limit/Top, Distinct
Working with Null Values

SQL Summarizing and Grouping Data:

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

Additional SQL Features:

Combining Queries
The Union, Intersect and Minus Operators
Basic Subqueries

What is included in the SQL Course:
  • SQL Course Certificate on completion (assessment based)
  • SQL Course notes
  • Practical SQL Course exercises, SQL Course Homework / SQL Course Revision work
  • Tea, coffees, but no lunch
  • To assist after the course, 1 free session for questions online SQL Course via Skype or Teamviewer.
  • Max group size on this SQL Course London is 4.
LOCATIONS
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops Manchester
MANCHESTER: 53 Fountain Street, Manchester, M2 2AN
Read More
PCWorkshops Birmingham
BIRMINGHAM: One Victoria Square, Birmingham, B1 1BD
Read More
PCWorkshops Southend-on-Sea
SOUTHEND-ON-SEA: The Forum, Elmer Square, Southend-on-Sea SS1 1NS
Read More
PCWorkshops Milton Keynes
MILTON KEYNES: Exchange House, 494 Midsummer Boulevard, Milton Keynes, MK9 2EA
Read More
PCWorkshops PORTSMOUTH
PORTSMOUTH: Building 1000, Lakeside North Harbour, Western Road, Portsmouth, PO6 3EZ
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More

Subscribe our Newsletter

Sign up to receive lessons, tips, examples, quizzes and other training materials.