Change Location × London, UK

    Recent Locations

      SQL Course 1-Day in London - Data Analysis with SQL Queries. in Covent Garden


      • SQL Course 1-Day in London - Data Analysis with SQL Queries. Photo #1
      1 of 1
      May 29, 2018

      Tuesday  11:00 AM - 6:00 PM

      53-59 Chandos Place,
      Covent Garden, Greater London WC2N 4HS

      Performers:
      EVENT DETAILS
      SQL Course 1-Day in London - Data Analysis with SQL Queries.

      Course summary - SQL Course in London, 1 Day, Data Analysis with SQL Queries

      Get interesting, insightful and essential business intelligence from data by using SQL queries. It is made easy and simple by this hands-on, practical course. Ask you questions in small, friendly class-room training. Save hours of online training.

      This course is Platform Independent.

      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
      *Summarizing and Grouping Data
      ---Aggregate Functions
      ---The Group By Clause
      ---The Having Clause
      *Querying Multiple Tables
      ---Joining Tables
      ---Inner Joins
      ---Column Qualification and Table Aliases
      ---Outer Joins
      ---Self Joins
      ---Alternative Join Syntax
      *Additional SQL Features
      ---Combining Queries
      ---The Union, Intersect and Minus Operators
      ---Basic Subqueries

      Cost: Payment required - £350 per course

      Categories: Business & Networking | Science | Technology

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.
      COMMENTS ABOUT SQL Course 1-Day in London - Data Analysis with SQL Queries.