Loading Events

« All Events

  • This event has passed.

20762 Developing SQL Databases – Brisbane

February 26, 2018 @ 9:00 am - March 2, 2018 @ 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:
February 26, 2018 @ 9:00 am UTC+11
End:
March 2, 2018 @ 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 Brisbane
Level 1, 164 Wharf Street
Spring Hill Brisbane, Queensland 4000 Australia
+ Google Map
Phone:
1300 927 394

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