Querying SQL Server Fundamentals

Course Summary

Training levelSQL Server Foundation Courses
Duration5 days / 40 Hours
Delivery methodIn Class
Level200
LanguageBulgarian/English
List price750 Euro VAT Excl.

The program is specifically designed to give students a solid foundation in learning the query language Transact SQL. The training is very useful for all those who in their daily professional activities deal with writing queries and reports and work primarily with data in the database.

The course “Querying SQL Server Fundamentals” is practically oriented and contains numerous exercises in order to better absorb the material.

  • Database Administrators
  • Business Analysts
  • Database professionals
  • Data experts and knowledge user with SQL
  • Database Developers
  • Create simple to complex queries to retrieve data from SQL Server database using Transact-SQL language
  • Use data from several tables to group, aggregate data
  • To distinguish the types of data and use the system functions for data processing of SQL Server
  • To use specific language structures (IF ELSE, CASE) in order to write more complex queries
  • To export query results and can use Excel as a client to SQL Server

Module 1: SQL Server Overview and Tools

Module 2: The SELECT Module

Module 3: Grouping and Summarizing Data

Module 4: Joins and Subqueries

Module 5: Specific Language Construct and Data Modifications

Next planned dates:

Trainer: Rozalina Zaharieva

rozi_portrait

RESERVE YOUR SEAT

fb

You have a question or you want to book now? Feel free to contact Vili Koleva – Training Manager

E: vili.koleva@inspirit.bg

M: 0885 113 442