Querying SQL Server Fundamentals

Course Summary

Training levelSQL Server Fundamental Courses
Duration3 days (24 hours)
Delivery methodIn class
Level100
LanguageBulgarian/English
List price350 Euro VAT excl.

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

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

  • Database Administrators who are new in role
  • Business Analysts
  • Data professionals
  • All professionals who work with data and need to learn how to get data from a database
  • Create simple to complex queries to retrieve data from an SQL Server database using Transact-SQL language
  • Use data from several tables to group and aggregate data
  • Distinguish the types of data and use the system functions for data processing of SQL Server
  • Use specific language structures (CASE) in order to write more complex queries
  • Export query results from SQL Server

Module 1: SQL Server Overview

Module 2: The SELECT module 

Module 3: Grouping and Summarizing data

Module 4: Joins and Subqueries

Module 5: Advanced data-analysis calculations 

Next planned dates:

Trainer: Rozalina Zaharieva

rozi_portrait

Reserve your seat





Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date
Days
Hours
Minutes
Seconds