Discover Classes. Earn 10% Rewards.

Microsoft SQL Server 2016 Administration is unfortunately unavailable

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

SQL Server Bootcamp

SQL Server Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Pick up actionable insights and turn raw data into useful information with the SQL Server Bootcamp. Learn Microsoft SQL Server and how to write SQL queries to extract, join, aggregate, and filter data in databases. Push your data analysis skills to a new level.

(452) All levels 18 and older

Nov 2nd

10am–5pm ET

Meets 3 Times

$975
20 Seats Left

Dec 9th

10am–5pm ET

Meets 3 Times

$975
20 Seats Left

This class has 4 more dates.

Tap here to see more
Mon. Nov 2nd, 10am–5pm ET  (21 hours over 3 sessions)  
$975

3 sessions

Attend
Gift it!
SQL Level I

SQL Level I

NYC Career Centers See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Step into the fundamentals of SQL and relational databases in this introductory course, where you will pick up the skill to write SQL queries, filter results, and join data across multiple tables. Get into the basics of database architecture and build your SQL coding through practical hands-on exercises.

(686) Beginner 18 and older

Nov 2nd

10am–5pm ET

$350
20 Seats Left

Dec 9th

10am–5pm ET

$350
20 Seats Left

This class has 6 more dates.

Tap here to see more
Mon. Nov 2nd, 10am–5pm ET  (7 hours)  
$350
Attend
Gift it!
SQL Level II

SQL Level II

NYC Career Centers See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Push your SQL skills further by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and running advanced JOINs. Unlock the power of SQL to pull and analyze data with precision and turn it into actionable insight.

(686) Intermediate 18 and older

Nov 3rd

10am–5pm ET

$350
20 Seats Left

Dec 10th

10am–5pm ET

$350
20 Seats Left

This class has 6 more dates.

Tap here to see more
Tue. Nov 3rd, 10am–5pm ET  (7 hours)  
$350
Attend
Gift it!
Excel Level I: Fundamentals

Excel Level I: Fundamentals

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Build a confident foundation in Microsoft Excel through this practical workshop at Noble Desktop. You'll work with calculations, functions, charts, formatting, and print layouts to manage data and produce well-structured spreadsheets.

(452) Beginner 18 and older

Nov 2nd

6–9pm ET

Meets 2 Times

$299
20 Seats Left

Nov 3rd

10am–5pm ET

$299
20 Seats Left

Nov 9th

10am–5pm ET

$299
20 Seats Left

Nov 13th

10am–5pm ET

$299
20 Seats Left

Nov 23rd

10am–5pm ET

$299
20 Seats Left

This class has 67 more dates.

Tap here to see more
Mon. Nov 2nd, 6–9pm ET  (6 hours over 2 sessions)  
$299

2 sessions

Attend
Gift it!
SQL Level III

SQL Level III

NYC Career Centers See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Push your SQL skills further with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.

(686) Advanced 18 and older

Nov 4th

10am–5pm ET

$425
20 Seats Left

Dec 11th

10am–5pm ET

$425
20 Seats Left

This class has 6 more dates.

Tap here to see more
Wed. Nov 4th, 10am–5pm ET  (7 hours)  
$425
Attend
Gift it!
See all Microsoft classes NYC

Microsoft SQL Server 2016 Administration

Hands On Technology Transfer, Inc.
4.6 7 reviews
  • Advanced
  • 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!

  • <b>(Exact location to be announced)</b>, New York, NY
  • 40 hours over 5 sessions
Microsoft SQL Server 2016 Administration
Microsoft SQL Server 2016 Administration
Sold Out
Book Private Class Save to WishList

1 person wishlisted

Start Dates (0) $2,795/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 Professional Group Events

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

Class Description

Description Cancellation Policy

Description

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. 

This five-day instructor-led course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure.


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.


Students Will Learn:

  • Authenticating and authorizing users
  • Assigning server and database roles
  • Authorizing users to access resources
  • Protecting data with encryption and auditing
  • Recovery models and backup strategies
  • Backing up SQL Server databases
  • Restoring SQL Server databases
  • Automating database management
  • Configuring security for the SQL Server agent
  • Managing alerts and notifications
  • Managing SQL Server using PowerShell
  • Tracing access to SQL Server
  • Monitoring a SQL Server infrastructure
  • Troubleshooting a SQL Server infrastructure
  • Importing and exporting data

Course Prerequisites:

 
  • Familiarity with database concepts, Windows desktop navigation and Transact-SQL. 
  • Attendance at SST's Microsoft Transact-SQL Programming course is highly recommended although not required.

Course Overview


Installation and Configuration

  • Installing Multiple Instances of SQL Server 2016
  • Applying a Service Pack
  • Creating Aliases
  • Setting up a Central Management Server

Authenticating and Authorizing Users

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

Assigning Server and Database Roles

  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-Defined Database Roles

Authorizing Users to Access Resources

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level

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

SQL Server Recovery Models

  • Backup Strategies
  • Understanding SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy

Backup of SQL Server Databases

  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options

Restoring SQL Server Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Working with Point-in-time Recovery
  • Restoring System Databases and Individual Files

Tracing Access to SQL Server

  • Capturing Activity Using SQL Server profiler
  • Improving Performance with the
  • Database Engine Tuning Advisor
  • Working with Tracing Options

Monitoring SQL Server

  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

Troubleshooting SQL Server

  • Resolving Service Related Issues
  • Resolving Login and Connectivity Issues
  • Troubleshooting Common Issues

Importing and Exporting Data

  • Transferring Data to/from SQL Server
  • Importing and Exporting Table Data
  • Using BCP and BULK INSERT to Import Data

Maintaining High Availability of Data

  • Windows Clustering
  • AlwaysOn Availability Groups
  • Implementing AlwaysOn
  • Implementing Log Shipping

Refund Policy

Tuition includes all course materials. Students may withdraw before the second day of class to receive a 100% refund, provided course materials are returned to the instructor. Prorated refunds may be granted for withdrawals after the first day.

Cancellations and Changes: There are no cancellation fees.

Attendance Requirements: Students must attend each day of a course and successfully complete hands on exercises in order to receive a certificate of completion. If a student wishes to retake any portion of a class that he or she completes, the student may do so within 12 months at no extra cost.

Intended Audience: Hands On Technology Transfer, Inc., provides IT training designed for technology professionals who wish to quickly upgrade their computer skills. In most states, the employer bears all training costs.

Reviews of Classes at Hands On Technology Transfer, Inc. (7)

(4.6-star rating across 7 reviews)
See reviews for other classes at Hands On Technology Transfer, Inc.
loading...
Hide Reviews

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 27950 points. Earn 10% back in reward points!

Hands On Technology Transfer, Inc.

HOTT delivers instructor-led technical training across the United States, Canada and the United Kingdom. Whether you attend in person, remote-live or on-demand, our classroom-based training philosophy zeroes in on your ability to work more productively and with higher quality results after training....
View school profile
Hands On Technology Transfer, Inc.
Vetted by CourseHorse

A verified NYC educator.

Give an experience worth remembering

One CourseHorse gift card. Thousands of classes to choose from.

  • Instant or scheduled delivery
  • No expiration date
  • Earn 15% reward points
Buy a Gift Card
gift card with the CourseHorse logo
Loading...