Mark Edgar Available Services

M

SQL Training

In-person SQL training using Microsoft SQL Server and Microsoft Access. Currently two classes are available – introductory and advanced.

Introductory

SQL & relational model background & history
Data integrity
Select query syntax and logic
Insert, update & delete queries

Advanced

Subqueries
Stored procedures, functions, views, CTEs, Access saved queries
Window functions
APPLY operator
PIVOT & UNPIVOT operators

Database Development

Database design & normalization
Query development for reporting and applications

Database Performance Tuning

Indexing
Query modification