Seminar Microsoft SQL Server 2017 Administration Seminar

Presented by Software Skills Training, Inc.

Hands On Technology Transfer Computer Training

Bring this seminar on-site to your facility for groups of 10 or more.

This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure

Course Description


Students Will Learn

  • Installing and configuring SQL Server 2017
  • 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
  • Tracing access to SQL Server
  • Monitoring a SQL Server infrastructure
  • Troubleshooting a SQL Server infrastructure
  • Importing and exporting data
  • Creating a high availability solution

Course Description

This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2017. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data, configure for high availability, and plan disaster recovery.

Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency. 

Course Prerequisites

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

Course Overview
Installation and Configuration
  • Installing Multiple Instances of SQL Server 2017
  • 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
q

 

More Seminar Information

Software Skills Training, Inc.
Hands On Technology Transfer Computer Training

Summary

This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure

Delivery Method

Seminar Seminar

Also Available As

On-Site Training On-Site Training

Who Should Attend

SQL Server administrators

 
Search similar training
Email this page
Print this document
 

Dates and Locations

Fairfax, VA
10/28/2019 - 11/1/2019
Tuition: $2795

Columbia, MD
10/28/2019 - 11/1/2019
Tuition: $2795

Charlotte, NC
10/28/2019 - 11/1/2019
Tuition: $2795

Baltimore, MD
10/28/2019 - 11/1/2019
Tuition: $2795

Arlington, VA
10/28/2019 - 11/1/2019
Tuition: $2795

see all dates/locations

 

Frequently Asked
Questions

Payment Options
Bill Me/Invoice
Credit Card

Register
Online
Fax Form

Availability
Select a date from the list at the bottom of the page for specific information about that class.

Other Information
Seminar

All Date/Location Information

Alberta (Find training in Alberta)
11/25/2019-11/29/2019 in Calgary, AB         Find a seminar in Calgary AB
11/25/2019-11/29/2019 in Edmonton, AB         Find a seminar in Edmonton AB

Arkansas (Find training in Arkansas)
12/16/2019-12/20/2019 in Little Rock, AR         Find a seminar in Little Rock AR

Arizona (Find training in Arizona)
12/9/2019-12/13/2019 in Phoenix, AZ         Find a seminar in Phoenix AZ
12/9/2019-12/13/2019 in Tucson, AZ         Find a seminar in Tucson AZ

British Columbia (Find training in British Columbia)
11/25/2019-11/29/2019 in Vancouver, BC         Find a seminar in Vancouver BC

California (Find training in California)
12/2/2019-12/6/2019 in Bakersfield, CA         Find a seminar in Bakersfield CA
12/2/2019-12/6/2019 in Fresno, CA         Find a seminar in Fresno CA
12/9/2019-12/13/2019 in Irvine, CA         Find a seminar in Irvine CA
12/9/2019-12/13/2019 in Los Angeles, CA         Find a seminar in Los Angeles CA
12/2/2019-12/6/2019 in Modesto, CA         Find a seminar in Modesto CA
12/2/2019-12/6/2019 in Oakland, CA         Find a seminar in Oakland CA
12/9/2019-12/13/2019 in Riverside, CA         Find a seminar in Riverside CA
12/2/2019-12/6/2019 in Sacramento, CA         Find a seminar in Sacramento CA
12/9/2019-12/13/2019 in San Bernardino, CA         Find a seminar in San Bernardino CA
12/9/2019-12/13/2019 in San Diego, CA         Find a seminar in San Diego CA
12/2/2019-12/6/2019 in San Francisco, CA         Find a seminar in San Francisco CA
12/2/2019-12/6/2019 in San Jose, CA         Find a seminar in San Jose CA
12/9/2019-12/13/2019 in Santa Clarita, CA         Find a seminar in Santa Clarita CA
12/9/2019-12/13/2019 in Santa Monica, CA         Find a seminar in Santa Monica CA
12/9/2019-12/13/2019 in Temecula, CA         Find a seminar in Temecula CA

Connecticut (Find training in Connecticut)
11/4/2019-11/8/2019 in Fairfield, CT         Find a seminar in Fairfield CT
11/4/2019-11/8/2019 in Hartford, CT         Find a seminar in Hartford CT
11/4/2019-11/8/2019 in New Haven, CT         Find a seminar in New Haven CT
11/4/2019-11/8/2019 in Stamford, CT         Find a seminar in Stamford CT

Washington DC (Find training in Washington DC)
10/28/2019-11/1/2019 in Washington, DC         Find a seminar in Washington DC
12/16/2019-12/20/2019 in Washington, DC         Find a seminar in Washington DC

Iowa (Find training in Iowa)
11/18/2019-11/22/2019 in Cedar Rapids, IA         Find a seminar in Cedar Rapids IA
11/18/2019-11/22/2019 in Des Moines, IA         Find a seminar in Des Moines IA

Illinois (Find training in Illinois)
11/18/2019-11/22/2019 in Chicago, IL         Find a seminar in Chicago IL
11/18/2019-11/22/2019 in Schaumburg, IL         Find a seminar in Schaumburg IL
11/18/2019-11/22/2019 in Springfield, IL         Find a seminar in Springfield IL

Indiana (Find training in Indiana)
11/18/2019-11/22/2019 in Indianapolis, IN         Find a seminar in Indianapolis IN

Kansas (Find training in Kansas)
12/16/2019-12/20/2019 in Wichita, KS         Find a seminar in Wichita KS

Kentucky (Find training in Kentucky)
11/11/2019-11/15/2019 in Louisville, KY         Find a seminar in Louisville KY

Louisiana (Find training in Louisiana)
12/16/2019-12/20/2019 in Shreveport, LA         Find a seminar in Shreveport LA

Massachusetts (Find training in Massachusetts)
11/4/2019-11/8/2019 in Boston, MA         Find a seminar in Boston MA
11/4/2019-11/8/2019 in Chelmsford, MA         Find a seminar in Chelmsford MA
11/4/2019-11/8/2019 in Quincy, MA         Find a seminar in Quincy MA
11/4/2019-11/8/2019 in Springfield, MA         Find a seminar in Springfield MA
11/4/2019-11/8/2019 in Waltham, MA         Find a seminar in Waltham MA
11/4/2019-11/8/2019 in Woburn, MA         Find a seminar in Woburn MA
11/4/2019-11/8/2019 in Worcester, MA         Find a seminar in Worcester MA

Manitoba (Find training in Manitoba)
11/25/2019-11/29/2019 in Winnipeg, MB         Find a seminar in Winnipeg MB

Maryland (Find training in Maryland)
10/28/2019-11/1/2019 in Baltimore, MD         Find a seminar in Baltimore MD
12/16/2019-12/20/2019 in Baltimore, MD         Find a seminar in Baltimore MD
10/28/2019-11/1/2019 in Columbia, MD         Find a seminar in Columbia MD
12/16/2019-12/20/2019 in Columbia, MD         Find a seminar in Columbia MD

Michigan (Find training in Michigan)
11/18/2019-11/22/2019 in Detroit, MI         Find a seminar in Detroit MI
11/18/2019-11/22/2019 in Lansing, MI         Find a seminar in Lansing MI

Minnesota (Find training in Minnesota)
11/18/2019-11/22/2019 in Minneapolis, MN         Find a seminar in Minneapolis MN

Missouri (Find training in Missouri)
11/18/2019-11/22/2019 in Kansas City, MO         Find a seminar in Kansas City MO
11/18/2019-11/22/2019 in Springfield, MO         Find a seminar in Springfield MO
11/18/2019-11/22/2019 in St Charles, MO         Find a seminar in St Charles MO

North Carolina (Find training in North Carolina)
10/28/2019-11/1/2019 in Charlotte, NC         Find a seminar in Charlotte NC
12/16/2019-12/20/2019 in Charlotte, NC         Find a seminar in Charlotte NC
10/28/2019-11/1/2019 in Raleigh-Durham, NC         Find a seminar in Raleigh-Durham NC
12/16/2019-12/20/2019 in Raleigh-Durham, NC         Find a seminar in Raleigh-Durham NC
10/28/2019-11/1/2019 in Winston-Salem, NC         Find a seminar in Winston-Salem NC
12/16/2019-12/20/2019 in Winston-Salem, NC         Find a seminar in Winston-Salem NC

Nebraska (Find training in Nebraska)
11/18/2019-11/22/2019 in Omaha, NE         Find a seminar in Omaha NE

New Hampshire (Find training in New Hampshire)
11/4/2019-11/8/2019 in Manchester, NH         Find a seminar in Manchester NH
11/4/2019-11/8/2019 in Nashua, NH         Find a seminar in Nashua NH

New Jersey (Find training in New Jersey)
10/28/2019-11/1/2019 in Jersey City, NJ         Find a seminar in Jersey City NJ
12/16/2019-12/20/2019 in Jersey City, NJ         Find a seminar in Jersey City NJ
10/28/2019-11/1/2019 in Newark, NJ         Find a seminar in Newark NJ
12/16/2019-12/20/2019 in Newark, NJ         Find a seminar in Newark NJ
10/28/2019-11/1/2019 in Princeton, NJ         Find a seminar in Princeton NJ
12/16/2019-12/20/2019 in Princeton, NJ         Find a seminar in Princeton NJ

New Mexico (Find training in New Mexico)
12/9/2019-12/13/2019 in Albuquerque, NM         Find a seminar in Albuquerque NM
12/9/2019-12/13/2019 in Las Cruces, NM         Find a seminar in Las Cruces NM

Nevada (Find training in Nevada)
12/9/2019-12/13/2019 in Las Vegas, NV         Find a seminar in Las Vegas NV

New York (Find training in New York)
11/4/2019-11/8/2019 in Albany, NY         Find a seminar in Albany NY
11/11/2019-11/15/2019 in Binghamton, NY         Find a seminar in Binghamton NY
11/11/2019-11/15/2019 in Buffalo, NY         Find a seminar in Buffalo NY
11/11/2019-11/15/2019 in Ithaca, NY         Find a seminar in Ithaca NY
10/28/2019-11/1/2019 in Manhattan, NY         Find a seminar in Manhattan NY
12/16/2019-12/20/2019 in Manhattan, NY         Find a seminar in Manhattan NY
11/11/2019-11/15/2019 in Rochester, NY         Find a seminar in Rochester NY
11/11/2019-11/15/2019 in Syracuse, NY         Find a seminar in Syracuse NY

Ohio (Find training in Ohio)
11/11/2019-11/15/2019 in Cincinnati, OH         Find a seminar in Cincinnati OH
11/11/2019-11/15/2019 in Cleveland, OH         Find a seminar in Cleveland OH
11/11/2019-11/15/2019 in Columbus, OH         Find a seminar in Columbus OH
11/11/2019-11/15/2019 in Dayton, OH         Find a seminar in Dayton OH

Oklahoma (Find training in Oklahoma)
12/16/2019-12/20/2019 in Oklahoma City, OK         Find a seminar in Oklahoma City OK
12/16/2019-12/20/2019 in Tulsa, OK         Find a seminar in Tulsa OK

Ontario (Find training in Ontario)
11/11/2019-11/15/2019 in Kingston, ON         Find a seminar in Kingston ON
11/11/2019-11/15/2019 in Mississauga, ON         Find a seminar in Mississauga ON
11/11/2019-11/15/2019 in Ottawa, ON         Find a seminar in Ottawa ON
11/11/2019-11/15/2019 in Toronto, ON         Find a seminar in Toronto ON

Pennsylvania (Find training in Pennsylvania)
10/28/2019-11/1/2019 in Harrisburg, PA         Find a seminar in Harrisburg PA
12/16/2019-12/20/2019 in Harrisburg, PA         Find a seminar in Harrisburg PA
10/28/2019-11/1/2019 in Philadelphia, PA         Find a seminar in Philadelphia PA
12/16/2019-12/20/2019 in Philadelphia, PA         Find a seminar in Philadelphia PA
11/11/2019-11/15/2019 in Pittsburgh, PA         Find a seminar in Pittsburgh PA

Quebec (Find training in Quebec)
11/11/2019-11/15/2019 in Montreal, QC         Find a seminar in Montreal QC
11/11/2019-11/15/2019 in Quebec City, QC         Find a seminar in Quebec City QC

Rhode Island (Find training in Rhode Island)
11/4/2019-11/8/2019 in Providence, RI         Find a seminar in Providence RI

Saskatchewan (Find training in Saskatchewan)
11/25/2019-11/29/2019 in Regina, SK         Find a seminar in Regina SK

Tennessee (Find training in Tennessee)
11/11/2019-11/15/2019 in Memphis, TN         Find a seminar in Memphis TN
11/11/2019-11/15/2019 in Nashville, TN         Find a seminar in Nashville TN

Texas (Find training in Texas)
12/16/2019-12/20/2019 in Austin, TX         Find a seminar in Austin TX
12/16/2019-12/20/2019 in Corpus Christi, TX         Find a seminar in Corpus Christi TX
12/16/2019-12/20/2019 in Dallas, TX         Find a seminar in Dallas TX
12/9/2019-12/13/2019 in El Paso, TX         Find a seminar in El Paso TX
12/16/2019-12/20/2019 in Ft Worth, TX         Find a seminar in Ft Worth TX
12/16/2019-12/20/2019 in Houston, TX         Find a seminar in Houston TX
12/16/2019-12/20/2019 in San Antonio, TX         Find a seminar in San Antonio TX

Virginia (Find training in Virginia)
10/28/2019-11/1/2019 in Alexandria, VA         Find a seminar in Alexandria VA
12/16/2019-12/20/2019 in Alexandria, VA         Find a seminar in Alexandria VA
10/28/2019-11/1/2019 in Arlington, VA         Find a seminar in Arlington VA
10/28/2019-11/1/2019 in Fairfax, VA         Find a seminar in Fairfax VA
12/16/2019-12/20/2019 in Fairfax, VA         Find a seminar in Fairfax VA
10/28/2019-11/1/2019 in Norfolk, VA         Find a seminar in Norfolk VA
12/16/2019-12/20/2019 in Norfolk, VA         Find a seminar in Norfolk VA
10/28/2019-11/1/2019 in Richmond, VA         Find a seminar in Richmond VA
12/16/2019-12/20/2019 in Richmond, VA         Find a seminar in Richmond VA
10/28/2019-11/1/2019 in Williamsburg, VA         Find a seminar in Williamsburg VA
12/16/2019-12/20/2019 in Williamsburg, VA         Find a seminar in Williamsburg VA

Wisconsin (Find training in Wisconsin)
11/18/2019-11/22/2019 in Milwaukee, WI         Find a seminar in Milwaukee WI