Dienstag, 22. Mai 2018, Regus at Chandos Place, Data analysis with SQL Queries, 1-Day Workshop, London

Von 22. Mai 2018 - 11:00
Bis 22. Oktober 2019 - 18:00

Regus at Chandos Place

Karte anzeigen
8 Teilnehmer an
Ereignisbeschreibung
SQL Queries 1-Day Course in London

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


Mehr anzeigen
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,  data and examples, but let us know beforehand
Refreshments: Tees, coffees but no lunch
Certificates:  Certificates included
Course Materials: Notes. Query examples and exercises. 
After course support: 1-hours online revision session
 



 
 
 

Data analysis with SQL Queries, 1-Day Workshop, London, Regus at Chandos Place ereignis

Totale Sonnenfinsternis am 03.09.2081

Totale Sonnenfinsternis am 03.09.2081

Mittwoch 03. September 2081
8408 shares
Totale Sonnenfinsternis am 03.09.2081

Totale Sonnenfinsternis am 03.09.2081

Mittwoch 03. September 2081
8337 shares
Totale Sonnenfinsternis 2081
Mittwoch 03. September 2081
4977 shares
Totale Sonnenfinsternis am 03.09.2081 - WIR SIND DABEI
Mittwoch 03. September 2081
219 shares
100.000 Stimmen für 4 Soßen zu 20 Nuggets!!!
Donnerstag 31. Dezember 2020
9491 shares
100.000 Stimmen für 4 Soßen zu 20 Nuggets!!!
Donnerstag 31. Dezember 2020
9447 shares
Emotional Eating
Freitag 13. März 2020
1 shares
DSA Workshop, Newcastle
Mittwoch 18. September 2019
1 shares
Weitere interessante veranstaltungen
Holen event empfehlungen basierend auf Ihre Facebook geschmack. Hol es dir jetzt!Zeigen sie mir die passenden veranstaltungen für michJetzt nicht