SQL-20761-1

Using SQL Queries in SQL Server - basic course

Form of participation
Form of training
Length of training
  • 3 day (3×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates

Training price

from 
235 000 Ft
+ VAT/person
Please choose the date and form of participation!
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Suggested For

The training is recommended for anyone who will be responsible for basic, everyday queries, displaying and organizing various data from SQL Server databases and does not need advanced knowledge in the first instance.

Outline

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
    • Built-in functions
    • Ranking functions
    • Grouping queries
Outline (PDF)

Prerequisites

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.