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:
| 29.05. – 31.05.2019 |
Praha
|
15 850 CZK (without VAT) | Order |
| 12.06. – 14.06.2019 |
Brno
|
15 850 CZK (without VAT) | Order |
| 26.06. – 28.06.2019 | Praha | 15 850 CZK (without VAT) | Order |
| 10.07. – 12.07.2019 | Brno | 15 850 CZK (without VAT) | Order |
| 16.07. – 18.07.2019 | Praha | 15 850 CZK (without VAT) | Order |
| 05.08. – 07.08.2019 | Praha | 15 850 CZK (without VAT) | Order |
| 06.08. – 08.08.2019 | Brno | 15 850 CZK (without VAT) | Order |
| 26.08. – 28.08.2019 | Praha | 15 850 CZK (without VAT) | Order |
| 27.08. – 29.08.2019 | Brno | 15 850 CZK (without VAT) | Order |