Loading Events

« All Events

20764 Administering a SQL Database Infrastructure – Melbourne

September 23 @ 9:00 am - September 27 @ 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:
September 23 @ 9:00 am
End:
September 27 @ 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 Melbourne
Level 23, HWT Tower, 40 City Road
Southbank Melbourne, Victoria 3006 Australia

Tickets

8 available
Administering a SQL Database Infrastructure (20764) - Melbourne$3,650.00 + GSTThis 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.