Querying MS SQL Server with Transact-SQL Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

This two day course will enable participants to use Transact-SQL to query Microsoft SQL Server. Retrieve data by using the SELECT statement, modify data by using the INSERT, UPDATE, and DELETE statements, summarise data using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses. Participants will also learn how to query multiple tables through the use of joins, design subqueries and work with full-text indexes.

Topics include

Exploring Transact-SQL
An Overview of SQL Server and Transact-SQL
Programming in Transact-SQL

Querying Data
Using the SELECT Statement
Formatting the Results Set

Changing Data through Queries
Inserting Data
Deleting Data
Updating Data

Summarising Data
Working with Aggregate Functions
Grouping Data

Joining Tables
Querying Multiple Tables
Implementing Advanced Table Joins

Implementing Subqueries
Designing Subqueries

Working with Full-text Indexes
Implementing the Microsoft Search Service
Querying Full-text Indexes

Programming T-SQL
Creating and Managing Views
Implementing Stored Procedures, Triggers, and
User defined Functions