SQL 1-Day Beginners Course, London

SQL 1-Day Beginners Course

From £290 - FAQ's - Included - Course outline - Bespoke SQL Course

Get interesting, insightful and essential business intelligence from data by using SQL queries. I t is made easy and simple by this hands-on, practical course. Ask you questions in small, friendly class-room training. Save hours of online training.
This course is Platform Independent.

Course Outline

Relational Database Concepts:

  • What is a Relational Database?
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Data Types
  • The Data Dictionary
  • Getting Started

SQL Language Essentials

  • The Select Statement
  • The Select and From Clauses
  • Conditions and the Where Clause
  • The Order By Clause
  • Arithmetic Operations
  • Column Aliases

Summarizing and Grouping Data

  • Aggregate Functions
  • The Group By Clause
  • The Having Clause

Querying Multiple Tables

  • Joining Tables
  • Inner Joins
  • Column Qualification and Table Aliases
  • Outer Joins
  • Self Joins
  • Alternative Join Syntax

Additional SQL Features

  • Combining Queries
  • The Union, Intersect and Minus Operators
  • Basic Subqueries

What is included in this 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 is 4.

Is this the course for you? Book today and start preparing for the course

PCWorkshops specialises in Coding Courses, Database Courses and MS Project Courses.

About Us

Free Examples and Tips