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:

30.10. 01.11.2018 Brno
15 850 CZK (without VAT)
05.11. 07.11.2018 Bratislava
620 EUR (without VAT)
07.11. 09.11.2018 Praha
15 850 CZK (without VAT)
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