Day 1 - Train the Trainers

Day One of training is finally here. After weeks preparation and days of travel I'm finally here to delivery my services. 

Today, I'm work with a Microsoft Partner - TPLC (The Professional Learning Centre) . TPLC is a Centre of Excellence in Professional Training and IT Certification. TPLC founded in the year 2011, is operating under the aegis of Harel Mallac Technologies Ltd, the leading ICT organization in Mauritius.

The team of trainers that I will be working with at TPLC have years of experience in Infrastructure ( Windows Server, Exchange, Cisco) and Programming (Java, Visual Basic, PHP, JavaScript). I'm coming to help them get up to speed on SQL Server, this is Microsoft's relational database technology. To be more specific this team is very interested in learning about business intelligence. 

Today, I wanted to focus the first day training around SQL Server Querying. This would ensure that the team understood many of the querying concept of T-SQL. T-SQL stands for Transaction-Structured Query Language. The primary programming language used to insert, delete, update data in SQL Server. We spent some time understanding Select Statement, Data Types, Functions. Grouping and Aggregating, Modifying Data and Retrieving data.  

The team seemed to catch on quickly because of there experience in other areas of technology. This enabled us to move through the planned deliverable quickly and move into some of the planned presentation information for Day 2 which introduce us to SQL Server Business Intelligence stack of SSIS (Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services). 

Without any sleep the previous night I thought this could be a issue, but I pushed through and took a great nap after Day 1 of training was complete.