Loading Events

« All Events

  • This event has passed.

20764 Administering a SQL Database Infrastructure – Brisbane

December 4, 2017 @ 9:00 am - December 8, 2017 @ 5:00 pm UTC+11

$3650
Database Administration

SATVs 5 DaysThis five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Administering a SQL Database Infrastructure

Overview

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Download Course Outline View Schedule/Book Online

Who Should Attend

This course is intended for individuals who:

  • Administer & maintain SQL Server databases
  • Perform database administration & maintenance or work in environments where databases play a key role in their job
  • Who develop applications that deliver content from SQL Server databases

Course Objectives

After completing this course, participants will be able to:

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data

Course Prerequisites

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

  • A basic knowledge of the Microsoft Windows operating system
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Some experience with database design

Details

Start:
December 4, 2017 @ 9:00 am
End:
December 8, 2017 @ 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
+ Google Map
Phone:
1300 927 394

Tickets

Tickets are not available as this event has passed.