Discover Classes. Earn 10% Rewards.

Administering a SQL Database Infrastructure is unfortunately unavailable

Thankfully we have 17 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.

SQL Bootcamp (Self-Paced)

Noble Desktop See all classes by this school - Self-paced Video Training

Gain the ability to query, filter, and analyze data with this self-paced SQL course using PostgreSQL. Learn to write effective queries, extract meaningful insights from datasets, and build skills that transfer across a wide range of database systems and data-focused roles.

(452) All levels 18 and older

SQL Server Certification Program

Noble Desktop See all classes by this school @ Zoom Conference

Gain practical SQL skills in this hands-on certification program, where you’ll learn to write queries, manage data, and analyze results using Microsoft SQL Server.

(452) All levels All ages
$1,699

3 sessions

Gift it!

SQL Server Level I

NYIM Training See all classes by this school

Build strong foundational skills in SQL and relational databases in this hands-on course. Learn to write SQL queries, filter data, and join info across multiple tables. Step into the fundamentals of database architecture and apply your skill across SQL flavors.

(750) Beginner 18 and older

Data Analytics Technologies Bootcamp

Noble Desktop See all classes by this school - Virtually Online

Through this course, students build mastery in Excel, SQL, and Tableau, some of the top data analytics tools. Students develop the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.

(452) All levels 18 and older
$1,949

8 sessions

Gift it!

SQL Level 2

Noble Desktop See all classes by this school - Virtually Online

Sharpen your SQL skills by mastering outer joins, NULL data, grouping, aggregate functions, filtering, and working with dates/times. Pull and analyze specific data from databases, turning raw information into valuable insight. Prerequisite: SQL proficiency equivalent to Noble Desktop's SQL Level 1 course.

(452) Intermediate 18 and older
See all SQL classes Online

Administering a SQL Database Infrastructure

  • All levels
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Live, Interactive Online Classroom
  • 40 hours over 5 sessions

Start Dates (0) $2,975/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Data Analytics Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

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. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.


Who should attend

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

Course Objectives

  • 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

Outline: Administering a SQL Database Infrastructure (20764)

1 - SQL Server Security

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Connect to databases
  • Authorization Across Servers
  • Partially Contained Databases

2 - Assigning Server and Database Roles

  • Working with server roles
  • Working with Fixed Database Roles
  • Assigning User-Defined Database Roles

3 - Authorizing Users to Access Resources

  • Describe and use server roles to manage server-level security.
  • Describe and use fixed database roles.
  • Use custom database roles and application roles to manage database-level security.

4 - Protecting Data with Encryption and Auditing

  • Options for auditing data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption

5 - Recovery Models and Backup Strategies

  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies

6 - Backing Up SQL Server Databases

  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options

7 - Restoring SQL Server Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery

8 - Automating SQL Server Management

  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Management

9 - Configuring Security for SQL Server Agent

  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts

10 - Monitoring SQL Server with Alerts and Notifications

  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Operators, Alerts, and Notifications
  • Alerts in Azure SQL Database

11 - Introduction to Managing SQL Server by using PowerShell

  • Getting Started with Windows PowerShell
  • Configure SQL Server using PowerShell
  • Administer and Maintain SQL Server with PowerShell
  • Managing Azure SQL Databases using PowerShell

12 - Tracing Access to SQL Server with Extended events

  • Extended Events Core Concepts
  • Working with Extended Events

13 - Monitoring SQL Server

  • Monitoring activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility

14 - Troubleshooting SQL Server

  • A Trouble Shooting Methodology for SQL Server
  • Resolving Service Related Issues
  • Resolving Connectivity and Log-in issues

15 - Importing and Exporting Data

  • Transferring Data to and from SQL Server
  • Importing and Exporting Table Data
  • Using bcp and BULK INSERT to Import Data
  • Deploying and Upgrading Data-Tier Application

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

Cancellation Policy:

Public Classes

All requests to cancel a registration must be in writing via e-mail to [email protected]

  • You may cancel 11 or more business days from the start of the class for a refund less 5% cancellation fee.
  • If you cancel less than 11 business days from the start of the class, you are responsible for 100% of the course fee.

Cisco Data Center or Cisco Cloud Courses

All requests to cancel a Cisco Data Center or Cisco Cloud class reservation must be made via e-mail.

  • You may cancel or reschedule more than 19 business days from the start of the class for a refund less 5% cancellation fee.
  • If a Learner chooses to reschedule, the payment already received will be applied to the new class.
  • If a cancellation request is made within 19 business days of the class start date, no refund will be provided, regardless of payment method.

Partner-Delivered Classes

For Partner-delivered courses, if a reservation is canceled or rescheduled fewer than 16 business days before the class start date, the entire original course fee will be forfeited. An additional course fee will be required for the new reservation.


*The school, or one of its Partners, reserves the right to cancel a course for any reason and without penalty more than ten (10) business days before the start of the class.


Rescheduling:

All requests to reschedule a registration must be in writing via e-mail to [email protected]

Public Classes

  • Students may reschedule a registration up to 11 business days before the scheduled start date without penalty.
  • Rescheduling will be defined as transferring the registration to the same course on a different date or transferring to another course of equal or lesser value up to 6 months from the original course start date.

Partner Delivered Classes

  • For Partner delivered courses, if a student reschedules less than 16 business days before the class, the entire original course fee may be forfeited. An additional course fee may be required for the new registration.


* You are allowed two (2) reschedules. After a second reschedule, the entire original course fee will be forfeited, and an additional course fee will be required for a new registration.


No Shows:

Failure to attend without prior written notice to the start date of the course will be considered a "no show" and will result in forfeiture of the full course price including NetApp courses paid for with NetApp Training Units. Under these conditions, the school, at its own discretion may allow you to re-sit another session of the same or lower priced course.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Similar Classes

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 29750 points. Earn 10% back in reward points!

Fast Lane - New York

Fast Lane, a leading provider of advanced IT training courses, offers complete authorized training solutions for Cisco, NetApp, VMware and more. We are a proud developer of new advanced technology courses to ensure your access to the most updated training for your career.

Fast Lane’s instructor-led...

View school profile
Fast Lane - New York
Vetted by CourseHorse

A verified Online educator.

Loading...