Transact SQL Basic Training Course

Primary tabs

Course Code

transsqlbas

Duration Duration

14 hours (usually 2 days including breaks)

Overview Overview

Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following:

  • Construct queries to extract and filter data from a SQL Server database
  • Create summarised results
  • Change, derive and format data to suit the required output
  • Change data and maintain database components and definitions

This course is for anybody who needs information from a Microsoft SQL Server database. It is suitable for either system developers or people from other areas who need to use SQL to extract and analyse data.

Course Outline Course Outline

Basics

  • Selection of all columns/fields
  • Selection of certain columns/fields
  • Use of distinct/unique
  • Selection of certain rows/records
  • Selection of values in a range
  • Selection of values matching a pattern mask
  • Selection of values within a list
  • Treatment of null values
  • How to sort and order data
  • Selection of calculated and derived values
  • How to control column headings in query results
  • How to send query results to external files

Joining Tables

  • Principles of joining tables:
    • Use of cartesian join
    • Use of inner join
    • Use of non-equi join
    • Use of outer join

Joining Queries

  • Union operator
  • Intersect operator
  • Except operator

Simple Functions

  • Conversion functions
  • Date functions
  • Number functions
  • Text functions
  • Group/summary/aggregate functions

Sub-Queries

  • Principles of sub-queries
  • How to filter rows from main query
  • Use of nested sub-query
  • Use of multi-column sub-query
  • Use of correlated sub-query
  • Use of sub-query as an inline view and common table expression
  • Use of sub-query as a column in main query

Case Statements

  • Principles of case statements
  • Use of case statement to derive column values
  • Use of nested case statements
  • Use of case statements to produce pivot tables
  • Use of case statement with sub-queries

Data Manipulation

  • How to insert values into a table
  • How to copy values between tables
  • How to update values
  • How to delete records
  • How to change data via views
  • Use of transactions
  • How to lock rows and tables

Data Definition

  • Principles of a relational database and data normalisation
  • Use of primary key and foreign key relationships and constraints
  • How to create tables
  • How to alter tables
  • How to create views
  • Use of synonyms
  • How to remove tables and views

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From 3542PLN
(86)
Private Classroom Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From 10370PLN
Request quote

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Remote
1 3542PLN 10370PLN
2 2866PLN 6280PLN
3 2641PLN 4917PLN
4 2528PLN 4235PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

SQL Training

Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
Bydgoszcz, ul. Dworcowa 94Tue, 2017-01-31 09:0010370PLN / 3642PLN
Gdańsk, ul. Powstańców Warszawskich 45Tue, 2017-01-31 09:0010370PLN / 3842PLN
Toruń, ul. Żeglarska 10/14Wed, 2017-02-01 09:0010370PLN / 3742PLN
Olsztyn, ul. Kajki 3/1Wed, 2017-02-01 09:0010370PLN / 3642PLN
Kielce, ul. Warszawska 19Mon, 2017-02-06 09:0010370PLN / 3842PLN

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
SQL language in MSSQL Kielce, ul. Warszawska 19 Wed, 2017-01-18 09:00 N/A / 1443PLN
OCUP2 UML 2.5 Certification - Intermediate Exam Preparation Warszawa, ul. Złota 3/11 Wed, 2017-01-18 09:00 5148PLN / 2175PLN
Introduction to CSS Poznan, Garbary 100/63 Fri, 2017-01-20 09:00 1485PLN / 695PLN
Angular JavaScript Poznan, Garbary 100/63 Mon, 2017-01-23 09:00 7425PLN / 3275PLN
Container management with Docker Zielona Góra, ul. Reja 6 Mon, 2017-01-23 09:00 8910PLN / 3720PLN
Comprehensive Git Kraków, ul. Rzemieślnicza 1 Mon, 2017-01-23 09:00 5841PLN / 3147PLN
Building Web Apps using the MEAN stack Poznan, Garbary 100/63 Mon, 2017-01-30 09:00 14652PLN / 5440PLN
Adobe Photoshop Elements Katowice ul. Opolska 22 Mon, 2017-01-30 09:00 1881PLN / 1327PLN
Psychologiczne aspekty zarządzania zespołem IT – psychologia zespołu Scrum agile Toruń, ul. Żeglarska 10/14 Mon, 2017-02-06 09:00 5742PLN / 2340PLN
Programming in C++ Warszawa, ul. Złota 3/11 Mon, 2017-02-06 09:00 5445PLN / 2815PLN
Visual Basic for Applications (VBA) in Excel (intermediate level) Warszawa, ul. Złota 3/11 Mon, 2017-02-06 09:00 2376PLN / 1192PLN
C#.Net Olsztyn, ul. Kajki 3/1 Mon, 2017-02-06 09:00 25047PLN / 8840PLN
Creating and managing Web sites Olsztyn, ul. Kajki 3/1 Mon, 2017-02-06 09:00 5841PLN / 2548PLN
Java Performance Wroclaw, ul.Ludwika Rydygiera 2a/22 Mon, 2017-02-06 09:00 9801PLN / 3000PLN
Marketing Analytics using R Gdańsk, ul. Powstańców Warszawskich 45 Wed, 2017-02-08 09:00 11880PLN / 5010PLN
Team Building and Management Szczecin, ul. Małopolska 23 Tue, 2017-02-14 09:00 5346PLN / 1569PLN
Microsoft Access - download the data Poznan, Garbary 100/63 Thu, 2017-02-16 09:00 2475PLN / 1225PLN
OCUP2 UML 2.5 Certification - Foundation Exam Preparation Warszawa, ul. Złota 3/11 Mon, 2017-02-20 09:00 7000PLN / 2933PLN
Programming in ASP.NET MVC 5 Gdynia, ul. Ejsmonda 2 Mon, 2017-02-20 09:00 5841PLN / 2673PLN
Introduction to CSS3 Poznan, Garbary 100/63 Wed, 2017-03-22 09:00 1881PLN / 952PLN

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients