Skip to the content



This course is aimed at the more advanced user that is looking to understand how data can be queried at the database level, how to create new SQL tables and views, and how these skills can be applied to an Excel or PowerBI Data Source for improved reporting performance. Whilst the course examples are based on a Cronus NAV database, and there is a section describing the advantages / disadvantages of using SQL Queries over NAV Queries and examples will be given of do’s and don’ts when working with NAV, the course could be equally beneficial to those just looking at understanding a bit more about querying using Transact-SQL.

Course Overview

The following is a list of the subjects covered in the course. For more detail For more details please download the course overview.

  • The SQL Server Management Studio Environment
  • Queries
    • Select
      • Single Table
      • Filtering
      • Wild Cards and LIKE.
      • Inner Joins
      • Outer Joins
      • Grouping and Aggregate Functions
      • Sorting
      • Cross Database Reporting
    • Creating Tables
    • Insert
    • Update
    • Delete
    • if not exist, then insert, else update
    • Creating Views
    • Updating Views
    • Using SQL Queries in Excel Connections
    • Sub Queries


Our scheduled training courses are £250.00 per person per day. If you are coming to our site, parking and refreshments will be provided.


A keen mind A working knowledge of Excel A basic understanding of databases.

Terms & Conditions

For details on what to expect, dress code and general terms and conditions, please see our standard training T&Cs.

Terms & Conditions

Attend This Course

Please fill in the following form to book onto this course.

Book Now


What will we do with your data? See our Privacy Policy for more information.

Use Your Rewards Here!

Reward Scheme for Partners

If you have earned credit on the Customer Partner Rewards Scheme, you can use it here!

As part of being a customer of 安博电竞 Consultants, you will receive reward credit when you renew your support contract. This credit can be spend on a range of services, including training, SQL server healthchecks and user shadowing. 

Held at our Southampton Offices

40 Locks Heath Centre
Centre Way
Locks Heath
SO31 6DX

Partner with the Experts

With over 300 years of combined experience in Microsoft business solutions, our team will help to get you up and running, as well as building a partnership that keeps you supported, all from our UK offices. 

From functionality and licensing to business strategy, we like your questions; contact our experienced team for open, honest and reliable advice so that we can find the answers.

飞鱼电竞押注网站 28加拿大记录手机版数据 江湖电竞最新版比赛(江湖电竞投注app网站) 金沙电竞app pc加拿大28计划最稳胆码授权平台 街霸5(上海)查询APP v8.6