SQL Queries and Data Analytics 1-Day Workshop
Added by Evvnt_Promotion on 2020-01-16
Conference Dates:
Start Date: 2020-01-20Last Day: 2020-01-20
Conference Contact Info:
Contact Person: Maria BeckEmail: [email protected]
Address: PCWorkshops, Golden Cross House, 8 Duncannon Street, London, City of Westminster, WC2N 4JF, United Kingdom
Tel: 02071646359
Conference Description:
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
URLs:
Tickets: https://go.evvnt.com/581302-1?pid=154
Facebook: https://go.evvnt.com/581302-2?pid=154
Prices:
SQL Beginners 1-Day Seminar: GBP 380.0,
SQL Beginners 1-Day Seminar Early Bird: GBP 350.0
Speaker: Sarah Barnard
Time: 11:00 - 18:00