Relational database systems, such as Microsoft SQL Server, are used throughout organizations. TSQL, or Transact-SQL, is the language used to program, manage, and query Microsoft SQL Server.
But did you know there are two different ways people use TSQL, and two difference audiences for TSQL training?
What are the two types of TSQL programming?
A SQL Server database provides the “back end,” or data services layer, of a business application such as a CRM, ERP, a student or patient records system, or an order processing system. One type of TSQL programming, what we’ll call transactional programming, is about creating, managing, and modifying database objects such as tables and indexes, as well as adding, modify, and deleting data. The other type of TSQL programming, which we’ll call analytical query writing, is about retrieving data for reporting and analysis.
Analytical query writing is the focus of Course 55232: Writing Analytical Queries for Business Intelligence
The analytical query writer is concerned with the process of extracting and making meaning from database data. This user needs to understand the SELECT statement and other TSQL features used to analyze data, and to produce datasets for reports and client tools such as SQL Server Reporting Services, Power BI, R, Excel, and other tools used to analyze data and/or create reports. The focus is on making meaning from database data, rather than managing and collecting it.
Transactional programming is the focus of Course 20761: Querying Data with Transact-SQL
The transactional programmer is concerned with creating and managing the database server and databases, and/or with adding, modifying, and deleting database data. This user benefits most from a course focused on transactional programming, and covering the breadth of the TSQL language. The focus is on collecting and managing data from many simultaneous processes.
Author: John M. Bunch