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-25 out of 27
Location
Start Date
Price
New York, United States
9th Nov 2020
$3600
Auckland, New Zealand
9th Nov 2020
$5200
Wellington, New Zealand
9th Nov 2020
$5200
Sydney, Australia
9th Nov 2020
$5200
Canberra, Australia
9th Nov 2020
$5200
Chicago, United States
9th Nov 2020
$3600
London, United Kingdom
9th Nov 2020
£1650
San Francisco, United States
9th Nov 2020
$3600
Paris, France
9th Nov 2020
€3200
Berlin, Germany
9th Nov 2020
€3200
Melbourne, Australia
9th Nov 2020
$5200
Madrid, Spain
9th Nov 2020
€3200
Milan, Italy
9th Nov 2020
€3200
LVC, United States
23rd Nov 2020
$3600
LVC, United Kingdom
23rd Nov 2020
£1650
LVC, Australia
23rd Nov 2020
$5200
LVC, New Zealand
23rd Nov 2020
$5200
LVC, Australia
23rd Nov 2020
$5200
LVC, Germany
23rd Nov 2020
€3200
LVC, France
23rd Nov 2020
€3200
LVC, United States
23rd Nov 2020
$3600
LVC, New Zealand
23rd Nov 2020
$5200
LVC, United States
23rd Nov 2020
$3600
LVC, Australia
23rd Nov 2020
$5200
LVC, Italy
23rd Nov 2020
€3200

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