Create Event
Search results for:
No result found! Try with different keywords!
Advertisement

SQL Queries 1-Day Course, London, Classroom or Virtual Classroom

Jul 16, 2018 - Sep 01, 2020
SQL Queries 1-Day Course, London, Classroom or Virtual Classroom

Time Mon Jul 16 2018 at 11:00 am to Tue Sep 01 2020 at 06:00 pm

PCWorkshops at Regus, near Trafalgar Square, Golden Cross House, London, United Kingdom

GBP 250
Advertisement

SQL Queries 1-Day Course London Classroom or Virtual Classroom SQL Queries 1-Day Course, London, Classroom or Virtual Classroom
SQL Queries are made easy by this hands-on, practical, instructor-led, online course. Get interesting,essential business insight from data.

About this Event

SQL Course summary

Because of the Corona-Virus Situation, we offer the courses online only until further notice.

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.

SQL Course Outline

Relational Database Concepts

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

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 Column Aliases
  • Limit/Top,
  • Distinct

SQL Arithmetic Operations,

  • Expression Queries 
  • Working with Null Values
  • Case, IIf

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, Alternative Join Syntax

Additional SQL Features

Combining Queries :

  • The Union,
  • Intersect and
  • Minus Operators

Basic Subqueries

WHAT IS INCLUDED:

  • SQL Course Certificate
  • Course notes
  • Tea, coffees, but no lunch
  • Max group size is 4.



You may also like the following events from PCWorkshops:

Also check out other Workshops in London, Virtual Events in London.

Tickets

Tickets for SQL Queries 1-Day Course, London, Classroom or Virtual Classroom can be booked here.

Ticket Information Ticket Price
ONLINE ATTENDANCE, SQL Queries Course GBP 250
SQL Queries Course, Advanced Booking, Classroom GBP 360
SQL Introduction Course GBP 420
Hosted by
We offer consulting and training courses in Java Coding, Android Development, SQL Development and similar topics.
Nearby Hotels PCWorkshops at Regus, near Trafalgar Square, Golden Cross House, London, United Kingdom
Event details from Report a problem ?

Event Information

Date & Time

Mon Jul 16 2018 at 11:00 am to Tue Sep 01 2020 at 06:00 pm

Location

PCWorkshops at Regus, near Trafalgar Square, Golden Cross House, London, United Kingdom

Advertisement
Advertisement

Planning for an event?

List your events for free and make sure your audience never miss an event from you!

Create Events