Using SQL queries in a SQL Server environment

The course is the first stage of SQL training. The training is recommended for anyone who will have the task of querying, displaying and organizing various data from SQL Server 2016 databases and wants to master them from the basics to the professional level.

During the extended course participants will learn the basics of SQL Server 2016, the use of Transact SQL language, simple and complex queries, basic database implementation and programming tasks.

Introduction to SQL Server - Simple queries

• Introduction to SQL Server:
  • The basic elements of a relational database
  • Normalization
  • SQL Server Releases and Versions
  • T-SQL languages
  • SQL Server Management Studio
  • The main language elements of T-SQL
• Simple queries:
  • Single-table SELECT
  • Simple WHERE condition and ORDER BY
  • CASE and IIF
  • DISTINCT
  • The JOIN terminology
  • Different JOINs
  • Handling NULL values
  • Overview of data types

Introduction to SQL Server - More complex database operations

• More complex database operations:
  • Embedded SELECT
  • Inserting a nested SELECT into a table
  • TOP and OFFSET
  • Embedded functions
  • Cross JOIN
  • UNION, EXCEPT and INTERSECT
  • Ranking functions
  • Grouping queries
  • SQL Windowing
• SQL example tasks:
  • Profit calculation
  • Trends

Introduction to SQL Server - Modifying data

• Modify data:
  • Adding new rows
  • Adding new rows: Modify or delete existing rows
  • Merge statement
  • OUTPUT clause
  • Selection and interation
  • PIVOT
  • UNPIVOT
  • Error handling
  • Basics of transaction management

Basic knowledge of Windows 8/10 or Windows Server 2012/2016, relational database management. As the course materials are in English, a basic level of English at document reading level is required. The presentation will be in Hungarian.