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
SQL Beginners 1-Day Seminar: GBP 380.0 SQL Beginners 1-Day Seminar Early Bird: GBP 350.0
AddressGolden Cross House, 8 Duncannonn Street, London, Greater London,
Explore localWhat's on in London
Local tourist information guide
Other eventsWhat's on at PCWorkshops
Main photo may be copyright © LoveEvvnt
Located 200 metres from Trafalgar Square, Chandos house offers accommodation in London. Guests benefit from terrace. Free WiFi is available throughout the property.
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..
Covent Garden Apartments
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..
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..
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.