Loading Events

« All Events

20762 Developing SQL Databases – Brisbane

February 10, 2020 @ 9:00 am - February 14, 2020 @ 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 10, 2020 @ 9:00 am
End:
February 14, 2020 @ 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 Brisbane
Level 1, 164 Wharf Street
Spring Hill Brisbane, Queensland 4000 Australia
Phone:
1300 927 394

Tickets

8 available
Developing SQL Databases$3,650.00 + GSTThis 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