Introduction to SQL Training

- European Data Innovation Hub @ AXA, Vorstlaan 23, 1170 Brussel

VisionWorks is the Ordina division for Business Intelligence. With 150 experienced consultants we are the market leader in Performance Management and Business Intelligence in the Benelux. We help customers get added valued from information. A dedicated competence center with more than 15 experts focus on the Microsoft BI solutions.

Mario Van Hissenhoven is an SQL Data Architect at Ordina. He has more than 15 years of experience in the Microsoft SQL Server Data platform, C# .NET programming skills and is Microsoft Certified Trainer since 2008.

For August 11, he has been asked as a trainer by The Brussels Data Science community (the European knowledge hub for Big Data and Data Science) to give an introduction to SQL.

Tis training consists of theory & exercises for introducing you to the essentials of relational databases such as tables, data types and how to query data with SQL.

  • What is SQL?
  • Windowed Sets
  • Predicate logic
  • Understanding the logical order of operations in SELECT statements
  • Writing simple SELECT statements
  • Eliminating duplicates with DISTINCT and GROUP BY
  • Column and table aliases
  • CASE expressions
  • Querying with inner, outer, cross & self-joins
  • Sorting data
  • Filtering data with predicates
  • Filtering data with TOP and OFFSET-FETCH
  • Working with unknown values
  • Introducing SQL Data Types
  • Working with Character data
  • Working with Date and Time data
  • Database normal forms
  • Primary keys and constraints
  • Indexes

More info and registration via this link: http://datasciencebe.com/2015/07/22/training-aug-11-dihub-brussels-introduction-to-sql/

 Don't hesitate to contact us for more information on our Microsoft related skills and propositions.