Integrated MRP solutions from the experts >

Off the shelf professional e-Commerce web store that grows with you

Get the Office 365 - Free Trial! Try now for 1 month with no obligation.

SQL Server Advanced - Introduction to Transact-SQL Queries

Introduction

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’t when working with NAV, the course could be equally beneficial to those just looking at understanding a bit more about querying using Transact-SQL. 

Prices

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

 

Pre-requisites

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

 

 

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

Book Now!

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

Booking Form

 

For more info contact us
enquiries@d-c.co.uk
+44 (0) 2380 982283

 

Other Pages In This Section