Teaching as a Microsoft Certified Trainer (MCT) since 1996 specializing in SQL Server related technologies like DTS, Reporting Services, Integration Services, Analysis Services (MultiDimensional and Tabular, MDX & DAX), TSQL coding in DDL, DML & DCL.
SQL Server administration subjects like Installation, Security (using Data Control Language DCL), Filegroups, Log Shipping, Mirroring, Availability Groups, Transaction processing and log management, Backup and Restore, SQL Server Agent, Monitoring using Profiler, Extended Events and DMVs, Locking mechanisms, SQL Server Replication, Clustering, TDE, Index architecture and strategies and Query Optimization.
Database design (attribute dependencies, normalization) and implementation using Data Definition Language (DDL) to create, alter, drop databases, schemas, tables, indexes, views, stored procedures, triggers, user defined function (UDFs), user defined data types.
Querying subjects include SQL Server Data Types, the use of System Functions, Ordering, Filtering, JOINS, Analytic functions like Grouped Aggregates and Window Functions, Set Operators, Subqueries, Common Table Expression (CTEs).
Have taught a hundred plus different courses and thousands of students in classrooms, meeting rooms and online using WebEx, Adobe Connect, Go to Meeting and Zoom.