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:
| 05.06. – 07.06.2018 |
Praha
|
15 850 CZK (without VAT) | Order |
| 06.06. – 08.06.2018 |
Bratislava
|
630 EUR (without VAT) | Order |
| 13.06. – 15.06.2018 |
Brno
|
15 850 CZK (without VAT) | Order |
| 25.06. – 27.06.2018 | Praha | 15 850 CZK (without VAT) | Order |
| 02.07. – 04.07.2018 | Bratislava | 630 EUR (without VAT) | Order |
| 02.07. – 04.07.2018 | Brno | 15 850 CZK (without VAT) | Order |
| 17.07. – 19.07.2018 | Praha | 15 850 CZK (without VAT) | Order |
| 24.07. – 26.07.2018 | Bratislava | 630 EUR (without VAT) | Order |