SQL Queries 1-Day Course Provides the knowledge and skills needed to retrieve and analyse data held in a database. Who Should Attend Anyo
SQL Queries 1-Day CourseProvides 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: PC Workshops at The Grand, 8 Northumberland Avenue, London, WC2N 5BY
Price
SQL Beginners 1-Day Seminar: GBP 350.00
SQL Beginners 1-Day Seminar Early Bird: GBP 315.00
Links:
WebsiteVisit website
VenuePC Workshops at The Grand
Address8 Northumberland Avenue, London, Greater London,
Explore localWhat's on in London
Local tourist information guide
Other eventsWhat's on at PC Workshops At The Grand
Main photo may be copyright © LoveEvvnt
Nearest Hotels
Staying overnight in London?
We've teamed up with Booking.com to provide the best room rates for hotels near the vicinity of the Sql Queries And Data Analytics 1day Workshop event in London.
Club Quarters, Trafalgar Square
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..
The Grand at Trafalgar
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..
Valet Apartments Whitehall
Valet Apartments Whitehall is situated in London, 200 metres from Trafalgar Square. Big Ben is 600 metres away. Free WiFi is provided throughout the property.
The Trafalgar Hilton
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..
Citadines Trafalgar Square
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..
Trafalgar Square Apartment
Trafalgar Square Apartment offers pet-friendly accommodation in London, 100 metres from Trafalgar Square. The property boasts views of the city and is 300 metres from Prince Of Wales Theatre. Free WiFi is featured throughout the property.
Your comments:
comments powered by DisqusDisclaimer: 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.