£125.94

Querying With Microsoft SQL Server (4 Evening Sessions)

Event Information

Share this event

Date and Time

Location

Location

Swindon

Venue - TBC

United Kingdom

View Map

Refund Policy

Refund Policy

No Refunds

Friends Who Are Going
Event description

Description

Querying with SQL Server

This course is intended to teach beginners how to query SQL Databases using T-SQL. This course would benefit aspiring data analysts, business analysts and BI analysts.

Important

Students will be required to bring their own device, and have installed SQL Management Studio prior to starting the course. You can download SQL Management studio from the following address https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms. And then downloading Download SQL Server Management Studio 17.3.


Session One - 5th March 2017

Create SELECT queries

Data types and working with NULLs

Session Two - 12th March 2017

Query multiple tables with JOIN

Explore set operators

Session Three - 19th March

Use functions and aggregate data

Working with subqueries

Session Four - 26th March

Use table expressions

Group sets and pivot data

Modify data

Views

Share with friends

Date and Time

Location

Swindon

Venue - TBC

United Kingdom

View Map

Refund Policy

No Refunds

Save This Event

Event Saved