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

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