Discover Classes. Earn Rewards.

Microsoft SQL Server 2016 Administration is unfortunately unavailable

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

SQL Level I

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Learn the fundamentals of SQL and relational databases in this introductory course, where you'll gain the skills to write SQL queries, filter results, and combine data from multiple tables. Explore the basics of database architecture and develop your skills in writing real SQL code with practical, hands-on exercises.

(680) Beginner 18 and older

SQL Level II

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Take your SQL skills to the next level by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and performing advanced JOINs. Unlock the power of SQL to extract and analyze data with precision and turn it into actionable insights.

(680) Intermediate 18 and older

SQL Level III

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.

(680) Advanced 18 and older

SQL Server Bootcamp

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Gain 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. Take your data analysis skills to the next level at Noble Desktop.

(372) All levels 18 and older
$975

3 sessions

Gift it!

SQL Bootcamp

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Master the art of extracting actionable insights from databases with the SQL Bootcamp at NYC Career Centers. Learn Microsoft SQL Server, join tables, aggregate data, and filter results in this hands-on course. Gain the skills needed to turn raw data into valuable insights for decision-making in any industry.

(680) All levels 18 and older
$975

3 sessions

Gift it!
See all SQL Server classes NYC

Microsoft SQL Server 2016 Administration

  • Advanced
  • 18 and older
  • $2,795
  • (Exact location to be announced), New York, NY
  • 40 hours over 5 sessions

Start Dates (0)

  • $2,795
  • NY - Manhattan @ (Exact location to be announced), New York, NY 00000
  • 40 hours over 5 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this sql server training:

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)

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 27950 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

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....

Read more about Hands On Technology Transfer, Inc.

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Hands On Technology Transfer, Inc.

Hands On Technology Transfer, Inc.

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a 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.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...