Querying SQL Server Fundamentals
Course Summary
Training level | SQL Server Foundation Courses |
Duration | 5 days / 40 Hours |
Delivery method | In Class |
Level | 200 |
Language | Bulgarian/English |
List price | 750 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
RESERVE YOUR SEAT
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