Loading Events

« All Events

20762 Developing SQL Databases – Sydney

February 24 @ 9:00 am - February 28 @ 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 24 @ 9:00 am
End:
February 28 @ 5:00 pm
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 Sydney
Level 4, 95 Pitt St
Sydney, New South Wales 2000 Australia

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.
Developing SQL Databases
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
$ 3,650.00
5 available