Training, opleiding en cursus Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (M2778)

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Deze training wordt op aanvraag gepland. U kunt contact opnemen op ons e-mail adres Dit e-mailadres is beveiligd tegen spambots, u heeft JavaScript nodig om het te kunnen bekijken

Description:

This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Target Audience:
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Duration:
3 days

Pre-Requisites:
Before attending this course, students must have:

Logical database design
Physical database design.
How data is stored in tables (rows and columns).
Data integrity concepts.
Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
Basic knowledge of the Microsoft Windows operating system and its core functionality. For example, how to use Windows Explorer, open and save files, and what a client/server application interaction means.

Objectives:

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-Test Indexes
Using Programming Objects for Data Retrieval
Using Advanced Querying Technique