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:
| 20.08. – 22.08.2018 |
Bratislava
|
630 EUR (without VAT) | Order |
| 27.08. – 29.08.2018 |
Praha
|
15 850 CZK (without VAT) | Order |
| 27.08. – 29.08.2018 |
Brno
|
15 850 CZK (without VAT) | Order |
| 10.09. – 12.09.2018 | Bratislava | 630 EUR (without VAT) | Order |
| 11.09. – 13.09.2018 | Ostrava | 15 850 CZK (without VAT) | Order |
| 17.09. – 19.09.2018 | Praha | 15 850 CZK (without VAT) | Order |
| 18.09. – 20.09.2018 | Brno | 15 850 CZK (without VAT) | Order |
| 18.09. – 20.09.2018 | Košice | 630 EUR (without VAT) | Order |
| 08.10. – 10.10.2018 | Brno | 15 850 CZK (without VAT) | Order |
| 09.10. – 11.10.2018 | Bratislava | 630 EUR (without VAT) | Order |
| 17.10. – 19.10.2018 | Praha | 15 850 CZK (without VAT) | Order |