Writing Queries Using Microsoft® SQL Server® 2008 Transact-SQL (MOC2778)
This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
| The course is included in the following categories: |
Microsoft Official Course Databáze → Microsoft SQL → MS SQL 2005/2008 Microsoft |
Difficulty of the course: Advanced
Course duration: 3 days
Contents of the course:
- Getting Started with Databases and Transact-SQL in SQL Server 2008
- Querying and Filtering Data
- Grouping and Summarizing Data
- Joining Data from Multiple Tables
- Working with Subqueries
- Modifying Data in Tables
- Querying Metadata, XML, and Full-Text Indexes
- Using Programming Objects for Data Retrieval
- Using Advanced Techniques
Expected knowledge: Knowledge of data integrity concepts. Core Windows Server skills. Relational database design skills. Programming skills.
.Course dates:
| 30.10. – 01.11.2018 |
Brno
|
15 850 CZK (without VAT) | Order |
| 05.11. – 07.11.2018 |
Bratislava
|
620 EUR (without VAT) | Order |
| 07.11. – 09.11.2018 |
Praha
|
15 850 CZK (without VAT) | Order |
| 12.11. – 14.11.2018 | Košice | 620 EUR (without VAT) | Order |
| 21.11. – 23.11.2018 | Brno | 15 850 CZK (without VAT) | Order |
| 26.11. – 28.11.2018 | Ostrava | 15 850 CZK (without VAT) | Order |
| 27.11. – 29.11.2018 | Praha | 15 850 CZK (without VAT) | Order |
| 03.12. – 05.12.2018 | Bratislava | 620 EUR (without VAT) | Order |
| 10.12. – 12.12.2018 | Košice | 620 EUR (without VAT) | Order |
| 12.12. – 14.12.2018 | Brno | 15 850 CZK (without VAT) | Order |
| 17.12. – 19.12.2018 | Praha | 15 850 CZK (without VAT) | Order |
| 17.12. – 19.12.2018 | Ostrava | 15 850 CZK (without VAT) | Order |
| 02.01. – 04.01.2019 | Bratislava | 620 EUR (without VAT) | Order |
| 02.01. – 04.01.2019 | Brno | 15 850 CZK (without VAT) | Order |
| 08.01. – 10.01.2019 | Praha | 15 850 CZK (without VAT) | Order |
| 21.01. – 23.01.2019 | Brno | 15 850 CZK (without VAT) | Order |
| 23.01. – 25.01.2019 | Bratislava | 620 EUR (without VAT) | Order |