Data base for:

  • Conferences
  • Research funding opportunities
  • Competitions / Awards

Register for free and add any data by yourself!

Filter conferences

 
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
 
      
      
 
      
 
      
      
      
      
      
      
      
      
      
      
SQL Queries and Data Analytics 1-Day Workshop

SQL Queries and Data Analytics 1-Day Workshop

Date of beginning

Monday, 11 November 2019

Duration

1 day

City

London

Country

United Kingdom

Contact

Maria Beck

E-Mail

This email address is being protected from spambots. You need JavaScript enabled to view it.

Memo

SQL Queries 1-Day CourseProvides the knowledge and skills needed to retrieve and analyse data held in a database.  Who Should AttendAnyone 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 OutlineRelational Database ConceptsWhat is a Relational Database?Tables, Rows and ColumnsIndexes, Primary Keys and Foreign KeysData TypesThe Data DictionaryGetting StartedSQL Language EssentialsThe Select StatementThe Select and From ClausesConditions and the Where ClauseThe Order By ClauseArithmetic OperationsColumn AliasesPractical ExercisesSummarizing and Grouping DataAggregate FunctionsThe Group By ClauseThe Having ClausePractical ExercisesQuerying Multiple TablesJoining Tables with Inner JoinsColumn Qualification and Table AliasesOuter Joins, Self Joins, Alternative Join SyntaxPractical ExercisesAdditional SQL FeaturesCombining QueriesThe Union, Intersect and Minus OperatorsBasic SubqueriesPractical Exercises INCLUDED: What can/can't I bring to the event?You can bring your own Laptop - let us know beforehandYou can bring your own data and examples - let us know beforehandRefreshments: Tees, coffees and light refreshments are included in the priceCertificates:  You will get attendance certificatesIncluded: Notes. Query examples and exercises. After course support: 2-hours online revision session