MENU
Introduction
CoursesCourses
Writing Queries Using Microsoft® SQL Server® 2008 Transact-SQL
Interest in course

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ázeMicrosoft SQLMS 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)
27.08. 29.08.2018 Praha
15 850 CZK (without VAT)
27.08. 29.08.2018 Brno
15 850 CZK (without VAT)
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