Querying SQL Server Fundamentals

Course Summary

Training levelSQL Server Foundation Courses
Duration3 days / 24 Hours
Delivery methodIn Class
Level200
LanguageBulgarian/English
List price450 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





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