Queries with Microsoft SQL Server

SpiralTrain BV

In the course Queries with Microsoft SQL Server, participants learn the syntax and use of the query language SQL in the context of a Microsoft SQL Server database.

Price

from €1,999

Level

Not specified

Kind

Training

Subject

Automation and IT, Training and education

More information and registration at SpiralTrain BV

Description

SQL Intro After an introduction to relational databases, the SQL standard and Microsoft SQL, the Microsoft SQL Server installation, environment and tooling are discussed. Like other DBMS systems, Microsoft SQL Server has added extra features of its own to standard SQL and these are also discussed in the course. SQL Data Definition In the first place, it will be discussed how SQL statements can be created and executed in Microsoft SQL Server. Subsequently, the various components of SQL are discussed step-by-step, such as Data Definition Language with CREATE TABLE and Data Manipulation Language with INSERT and UPDATE. SQL Select Queries Next attention is paid to writing SELECT queries. This includes clauses such as WHERE, ORDER BY, LIKE and BETWEEN .. AND. The grouping of data by means of GROUP and HAVING clauses is also on the program of the course. SQL Functions The various standard SQL functions are also discussed. Among other things, the mathematical, conversion and aggregation functions for calculating sum and average are treated. Attention is also paid to Microsoft SQL Server specific functions for table expressions, window ranking and pivoting.