Loading Events

« All Events

  • This event has passed.

20762 Developing SQL Databases – Melbourne

April 9, 2017 @ 9:00 am - April 13, 2017 @ 5:00 pm UTC+11

$3650
Developing SQL Databases

SATVs 5 DaysThis five-day instructor-led course provides participants with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

Overview

This five-day instructor-led course provides participants with the knowledge and skills to develop a Microsoft SQL Server 2016 database.

The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

Download Course Outline View Schedule/Book Online

Who Should Attend

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database. The secondary audience for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.

Course Objectives

After completing this course, participants will be able to:

  • Design & Implement Tables
  • Describe advanced table designs
  • Ensure Data Integrity through Constraints
  • Describe indexes, including Optimized & Columnstore indexes
  • Design & Implement Views
  • Design & Implement Stored Procedures
  • Design & Implement User Defined Functions
  • Respond to data manipulation using trigger
  • Design & Implement In-Memory Tables
  • Implement Managed Code in SQL Server
  • Store & Query XML Data
  • Work with Spatial Data
  • Store & Query Blobs & Text Documents

Course Prerequisites

Before attending this course, participants must have, in addition to their professional experience:

  • A working knowledge of relational databases
  • A working knowledge of Transact-SQL
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

Details

Start:
April 9, 2017 @ 9:00 am UTC+11
End:
April 13, 2017 @ 5:00 pm UTC+11
Cost:
$3650
Event Categories:
, , ,

Organizer

WARDY IT Solutions Training
Phone:
1300 WARDY IT (927 394)
Email:
training@wardyit.com
Website:
https://www.wardyit.com/training/

Venue

WARDY IT Solutions Melbourne
Level 23, HWT Tower, 40 City Road
Southbank Melbourne, Victoria 3006 Australia
+ Google Map

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available