Koulutukset

Ota yhteyttä

Myyntipalvelu

Myynti

010 4321 001 Ota yhteyttä

Kesto: 2 päivää
Veroton hinta (+ alv 24 %): 1 930 €

Tästä asiakaskohtainen toteutus?

Toteutamme koulutuksia myös asiakaskohtaisina. Jätä yhteystietosi, ja tehdään juuri teille sopiva toteutus.

Tästä koulutuksesta ei alennuksia. 

Osallistumista ei voi maksaa koulutuskortilla.


Paikka ja päiväys

Online
23.5 – 24.5
English English
Ilmoittaudu
24.5 – 25.5
English English
Ilmoittaudu
28.5 – 29.5
English English
Ilmoittaudu
30.5 – 31.5
English English
Ilmoittaudu
17.6 – 18.6
English English
Ilmoittaudu
24.6 – 25.6
English English
Ilmoittaudu
11.7 – 12.7
English English
Ilmoittaudu
18.7 – 19.7
English English
Ilmoittaudu
25.7 – 26.7
English English
Ilmoittaudu
5.8 – 6.8
English English
Ilmoittaudu
6.8 – 7.8
English English
Ilmoittaudu
2.9 – 3.9
English English
Ilmoittaudu
16.9 – 17.9
English English
Ilmoittaudu
23.9 – 24.9
English English
Ilmoittaudu
30.9 – 1.10
English English
Ilmoittaudu
9.10 – 10.10
English English
Ilmoittaudu
10.10 – 11.10
English English
Ilmoittaudu
30.10 – 31.10
English English
Ilmoittaudu
31.10 – 1.11
English English
Ilmoittaudu
11.11 – 12.11
English English
Ilmoittaudu
21.11 – 22.11
English English
Ilmoittaudu
2.12 – 3.12
English English
Ilmoittaudu
9.12 – 10.12
English English
Ilmoittaudu
17.12 – 18.12
English English
Ilmoittaudu
19.12 – 20.12
English English
Ilmoittaudu

Jaa

Lataa pdf-muodossa

Querying SQL Databases using T-SQL

This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures.

Target Audience:

IT Professionals who will be writing queries for use with Microsoft SQL Server 2005, 2008 or 2012. Non-technical 'power users' will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.

The course is aimed at both non-technical 'power users' and IT Professionals who will be writing queries for use with Microsoft SQL Server.

Please note - Delegates attending an Extended Classroom delivery will need access to a second monitor.

Prerequisites

  • There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server.

Objectives:

Course Outline:

Module 1: Introduction to T-SQL

This module provides essential background information on Relational Database Management Systems and Microsoft SQL Server and introduces the main tool that will be used throughout the course - SQL Server Management Studio.

Lab :

  • Familiarize yourself with SSMS
  • Introduction to the Query Editor

Module 2: Retrieving Data

This module describes the fundamental part of a T-SQL query: the SELECT statement.

Lab :

  • Basic Select statements
  • Using expressions in Select lists

Module 3: Filtering Rows

This module describes how you can filter unwanted data out of your results using the WHERE clause.

Lab :

  • Basic equality filters
  • Basic comparisons
  • Logical comparisons
  • String comparisons
  • NULL comparisons

Module 4: Sorting returned rows

This module describes how to use the ORDER BY clause of a query to manage the order in which rows are returned.

Lab :

  • Basic sorting
  • Sorting on expressions
  • Unique rows
  • Limiting results

Module 5: Grouping and Aggregating data

This module describes how to use the aggregate functions of SQL to calculate results for a number of records at a time and how to group results into a series of values. Finally, it describes how to filter the grouped values.

Lab :

  • Single aggregates
  • GROUP BY
  • HAVING

Module 6: Using multiple tables

This module describes how to use JOIN clauses to retrieve data from multiple tables. It also covers the UNION, INTERSECT and EXCEPT keywords

Lab :

  • Inner joins
  • Outer joins
  • Unions

Module 7: Using Views and Stored Procedures

This module provides an introduction to the benefits of using pre-written queries which have been stored in the database.

Lab :

  • Using views
  • Using stored procedures

Module 8: Common Functions

This module introduces you to some of the basic text, date and null-value manipulation functions that are built in to SQL Server.

Lab :

  • Text functions
  • Date functions
  • NULL functions
  • Formatting dates

Appendix : Modifying Data

If time allows and if enough delegates express an interest in the topic, this module gives a brief introduction to INSERT, UPDATE and DELETE statements.

Yhteistyössä