All Brands   >   Microsoft   >   Microsoft SQL Server   >   Microsoft SQL Server Programming

CMDBID: 37336 | Course Code: SQL | Duration: 4 Days
Overview >

This is a comprehensive, intensive course with plenty of illustrated examples and augmented with practical hands-on exercises.

Please note that the optional modules detailed in the course content below are not delivered as part of the standard course, due to time constraints. However, as this course is fully modularised, when delivered as an on-site course, optional modules can be included on request.

Upon successful completion of this course, delegates will be able to:

  • Use SQL Server Management Studio
  • Understand the Syntax of Transact-SQL
  • Retrieve, Filter and Sort Data
  • Query Data from Multiple Tables by Using Joins
  • Summarize and Rank Grouped Data
  • Combine and Limit Result Sets
  • Work with Subqueries
  • Understand Query Performance Issues
  • Use Crosstab Queries
  • Use Common Table Expressions
  • Modify Data with INSERT, DELETE and UPDATE
  • Understand and Implement Transactions
  • Understand SQL Server Locks
  • Work with the SQL Server Date and Time Data Types
  • Query and Work with XML Data in SQL Server
  • Create and Manage Views
  • Create and Manage Stored Procedures
  • Handle Errors in Transact-SQL Code
  • Create and Manage User Defined Functions
  • Create and Manage Triggers
Audience >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-4 out of 4
Location
Duration
Start Date
Price
Bath, United Kingdom
4 Days
10th May 2021
£1650
Bath, United Kingdom
4 Days
13th Sep 2021
£1650
Bath, United Kingdom
4 Days
15th Nov 2021
£1650
ONSITE, United States
4 Days
Onsite
£1650

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes