SQL Queries and Data Analytics 1-Day Workshop Miscellaneous

sql_queries_and_data_analytics_1day_workshop


SQL Queries 1-Day Course Provides the knowledge and skills needed to retrieve and analyse data held in a database.  

SQL Queries 1-Day Course

Provides the knowledge and skills needed to retrieve and analyse data held in a database.  
Who Should Attend
Anyone who needs to understand and use SQL to manipulate a database. There are no formal pre-requisites for this course, although an understanding of databases and exposure to information technology in general would be useful.  
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
Practical Exercises

Summarizing and Grouping Data

Aggregate Functions
The Group By Clause
The Having Clause
Practical Exercises

Querying Multiple Tables

Joining Tables with Inner Joins
Column Qualification and Table Aliases
Outer Joins, Self Joins, Alternative Join Syntax
Practical Exercises

Additional SQL Features

Combining Queries
The Union, Intersect and Minus Operators
Basic Subqueries
Practical Exercises


 
INCLUDED:
What can/can't I bring to the event?
You can bring your own Laptop - let us know beforehand
You can bring your own data and examples - let us know beforehand
Refreshments: Tees, coffees and light refreshments are included in the price
Certificates:  You will get attendance certificates
Included: Notes. Query examples and exercises. 
After course support: 2-hours online revision session

 

Venue: PCWorkshops, Golden Cross House, 8 Duncannonn Street, London, WC2N 4JF

Price

SQL Beginners 1-Day Seminar: GBP 380.0
SQL Beginners 1-Day Seminar Early Bird: GBP 350.0

Links:

Website: https://go.evvnt.com/583582-0?pid=269
Tickets: https://go.evvnt.com/583582-2?pid=269
Facebook: https://go.evvnt.com/583582-3?pid=269

More details


Date(s)27 Jan 2020
WebsiteVisit website
VenuePCWorkshops
AddressGolden Cross House, 8 Duncannonn Street, London, Greater London,
WC2N4JF

Explore localWhat's on in London
 Local tourist information guide
Other eventsWhat's on at PCWorkshops


Main photo may be copyright © LoveEvvnt


Nearest Hotels

Chandos house

ROOMS FROM£0
92mAWAY
0

Located 200 metres from Trafalgar Square, Chandos house offers accommodation in London. Guests benefit from terrace. Free WiFi is available throughout the property.

Postcode: WC2N 4HS
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

Club Quarters, Trafalgar Square

ROOMS FROM£128.52
143mAWAY
4

Just off Trafalgar Square, Club Quarters has an elegant brasserie and boutique rooms with free Wi-Fi. The National Gallery and Nelsons Column are a 2-minute walk away..

Postcode: WC2N 5BY
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

The Grand at Trafalgar

ROOMS FROM£128.52
146mAWAY
4

Just off Trafalgar Square, in Central London, this beautifully restored Victorian building houses a 4-star luxury hotel offering free Wi-Fi and elegant air-conditioned rooms..

Postcode: WC2N 5BY
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

Covent Garden Apartments

ROOMS FROM£183.2
163mAWAY
0

Situated just a few metres from Trafalgar Square, Covent Garden Apartments offer self-catering accommodation in Central London. The property is 100 metres from Charing Cross and 200 metres from Embankment on the River Thames..

Postcode: WC2N 6NE
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

Citadines Trafalgar Square

ROOMS FROM£182
188mAWAY
4

Citadines Trafalgar Square London offers modern, self-catering accommodation in central London. Trafalgar Square is just 150 metres away, and Embankment Underground Station is a 2-minute walk..

Postcode: WC2N 5EA
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

The Trafalgar Hilton

ROOMS FROM£191.2
219mAWAY
4

This deluxe 4-star hotel is on Londons famous Trafalgar Square, just half a mile from Westminster. There is a roof-top bar with spectacular views of the Square..

Postcode: SW1A 2TS
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

View all hotels near PCWorkshops


Your comments:

comments powered by Disqus

Disclaimer: This event is not organised by BritEvents, and we cannot be held responsible for the accuracy of the information provided, errors, or omissions. Always check the information provided before you book tickets.

Event Details

Date27 Jan 2020
Time(s)11:00 AM - 6:00 PM
CostSee full price details in event description
VenuePCWorkshops
Golden Cross House, 8 Duncannonn Street
London
Greater London
WC2N4JF
Phone02071646359
CategoryMiscellaneous


LoveEvvnt

Added
18 Jan 2020

Contact organiser

View full profile