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

Los Angeles, CA
11/26/2018 - 11/30/2018
Tuition: $2795

El Paso, TX
11/26/2018 - 11/30/2018
Tuition: $2795

Albuquerque, NM
11/26/2018 - 11/30/2018
Tuition: $2795

Temecula, CA
11/26/2018 - 11/30/2018
Tuition: $2795

Santa Clarita, CA
11/26/2018 - 11/30/2018
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

Alabama (Find training in Alabama)
12/10/2018-12/14/2018 in Huntsville, AL         Find a seminar in Huntsville AL

Arkansas (Find training in Arkansas)
12/3/2018-12/7/2018 in Little Rock, AR         Find a seminar in Little Rock AR

Arizona (Find training in Arizona)
11/26/2018-11/30/2018 in Phoenix, AZ         Find a seminar in Phoenix AZ
11/26/2018-11/30/2018 in Tucson, AZ         Find a seminar in Tucson AZ

California (Find training in California)
11/26/2018-11/30/2018 in Irvine, CA         Find a seminar in Irvine CA
11/26/2018-11/30/2018 in Los Angeles, CA         Find a seminar in Los Angeles CA
11/26/2018-11/30/2018 in Riverside, CA         Find a seminar in Riverside CA
11/26/2018-11/30/2018 in San Bernardino, CA         Find a seminar in San Bernardino CA
11/26/2018-11/30/2018 in San Diego, CA         Find a seminar in San Diego CA
11/26/2018-11/30/2018 in Santa Clarita, CA         Find a seminar in Santa Clarita CA
11/26/2018-11/30/2018 in Santa Monica, CA         Find a seminar in Santa Monica CA
11/26/2018-11/30/2018 in Temecula, CA         Find a seminar in Temecula CA

Connecticut (Find training in Connecticut)
12/17/2018-12/21/2018 in Hartford, CT         Find a seminar in Hartford CT
12/17/2018-12/21/2018 in New Haven, CT         Find a seminar in New Haven CT
12/17/2018-12/21/2018 in Stamford, CT         Find a seminar in Stamford CT

Washington DC (Find training in Washington DC)
12/17/2018-12/21/2018 in Washington, DC         Find a seminar in Washington DC

Florida (Find training in Florida)
12/10/2018-12/14/2018 in Ft Lauderdale, FL         Find a seminar in Ft Lauderdale FL
12/10/2018-12/14/2018 in Jacksonville, FL         Find a seminar in Jacksonville FL
12/10/2018-12/14/2018 in Miami, FL         Find a seminar in Miami FL
12/10/2018-12/14/2018 in Orlando, FL         Find a seminar in Orlando FL
12/10/2018-12/14/2018 in Pensacola, FL         Find a seminar in Pensacola FL
12/10/2018-12/14/2018 in Sarasota, FL         Find a seminar in Sarasota FL
12/10/2018-12/14/2018 in Tampa, FL         Find a seminar in Tampa FL
12/10/2018-12/14/2018 in West Palm Beach, FL         Find a seminar in West Palm Beach FL

Georgia (Find training in Georgia)
12/10/2018-12/14/2018 in Atlanta, GA         Find a seminar in Atlanta GA
12/10/2018-12/14/2018 in Savannah, GA         Find a seminar in Savannah GA

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

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

Indiana (Find training in Indiana)
1/7/2019-1/11/2019 in Indianapolis, IN         Find a seminar in Indianapolis IN

Kansas (Find training in Kansas)
12/3/2018-12/7/2018 in Wichita, KS         Find a seminar in Wichita KS

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

Louisiana (Find training in Louisiana)
12/3/2018-12/7/2018 in Shreveport, LA         Find a seminar in Shreveport LA

Massachusetts (Find training in Massachusetts)
12/17/2018-12/21/2018 in Boston, MA         Find a seminar in Boston MA
12/17/2018-12/21/2018 in Chelmsford, MA         Find a seminar in Chelmsford MA
12/17/2018-12/21/2018 in Quincy, MA         Find a seminar in Quincy MA
12/17/2018-12/21/2018 in Springfield, MA         Find a seminar in Springfield MA
12/17/2018-12/21/2018 in Waltham, MA         Find a seminar in Waltham MA
12/17/2018-12/21/2018 in Woburn, MA         Find a seminar in Woburn MA
12/17/2018-12/21/2018 in Worcester, MA         Find a seminar in Worcester MA

Maryland (Find training in Maryland)
12/17/2018-12/21/2018 in Baltimore, MD         Find a seminar in Baltimore MD
12/17/2018-12/21/2018 in Columbia, MD         Find a seminar in Columbia MD

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

Minnesota (Find training in Minnesota)
1/7/2019-1/11/2019 in Minneapolis, MN         Find a seminar in Minneapolis MN

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

North Carolina (Find training in North Carolina)
12/17/2018-12/21/2018 in Charlotte, NC         Find a seminar in Charlotte NC
12/17/2018-12/21/2018 in Raleigh-Durham, NC         Find a seminar in Raleigh-Durham NC
12/17/2018-12/21/2018 in Winston-Salem, NC         Find a seminar in Winston-Salem NC

Nebraska (Find training in Nebraska)
1/7/2019-1/11/2019 in Omaha, NE         Find a seminar in Omaha NE

New Hampshire (Find training in New Hampshire)
12/17/2018-12/21/2018 in Manchester, NH         Find a seminar in Manchester NH
12/17/2018-12/21/2018 in Nashua, NH         Find a seminar in Nashua NH

New Jersey (Find training in New Jersey)
12/17/2018-12/21/2018 in Jersey City, NJ         Find a seminar in Jersey City NJ
12/17/2018-12/21/2018 in Newark, NJ         Find a seminar in Newark NJ
12/17/2018-12/21/2018 in Princeton, NJ         Find a seminar in Princeton NJ

New Mexico (Find training in New Mexico)
11/26/2018-11/30/2018 in Albuquerque, NM         Find a seminar in Albuquerque NM
11/26/2018-11/30/2018 in Las Cruces, NM         Find a seminar in Las Cruces NM

Nevada (Find training in Nevada)
11/26/2018-11/30/2018 in Las Vegas, NV         Find a seminar in Las Vegas NV

New York (Find training in New York)
12/17/2018-12/21/2018 in Albany, NY         Find a seminar in Albany NY
1/7/2019-1/11/2019 in Binghamton, NY         Find a seminar in Binghamton NY
1/7/2019-1/11/2019 in Buffalo, NY         Find a seminar in Buffalo NY
1/7/2019-1/11/2019 in Ithaca, NY         Find a seminar in Ithaca NY
12/17/2018-12/21/2018 in Manhattan, NY         Find a seminar in Manhattan NY
1/7/2019-1/11/2019 in Rochester, NY         Find a seminar in Rochester NY
1/7/2019-1/11/2019 in Syracuse, NY         Find a seminar in Syracuse NY

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

Oklahoma (Find training in Oklahoma)
12/3/2018-12/7/2018 in Oklahoma City, OK         Find a seminar in Oklahoma City OK
12/3/2018-12/7/2018 in Tulsa, OK         Find a seminar in Tulsa OK

Pennsylvania (Find training in Pennsylvania)
12/17/2018-12/21/2018 in Harrisburg, PA         Find a seminar in Harrisburg PA
12/17/2018-12/21/2018 in Philadelphia, PA         Find a seminar in Philadelphia PA
1/7/2019-1/11/2019 in Pittsburgh, PA         Find a seminar in Pittsburgh PA

Rhode Island (Find training in Rhode Island)
12/17/2018-12/21/2018 in Providence, RI         Find a seminar in Providence RI

South Carolina (Find training in South Carolina)
12/10/2018-12/14/2018 in Charleston, SC         Find a seminar in Charleston SC

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

Texas (Find training in Texas)
12/3/2018-12/7/2018 in Austin, TX         Find a seminar in Austin TX
12/3/2018-12/7/2018 in Corpus Christi, TX         Find a seminar in Corpus Christi TX
12/3/2018-12/7/2018 in Dallas, TX         Find a seminar in Dallas TX
11/26/2018-11/30/2018 in El Paso, TX         Find a seminar in El Paso TX
12/3/2018-12/7/2018 in Ft Worth, TX         Find a seminar in Ft Worth TX
12/3/2018-12/7/2018 in Houston, TX         Find a seminar in Houston TX
12/3/2018-12/7/2018 in San Antonio, TX         Find a seminar in San Antonio TX

Virginia (Find training in Virginia)
12/17/2018-12/21/2018 in Alexandria, VA         Find a seminar in Alexandria VA
12/17/2018-12/21/2018 in Fairfax, VA         Find a seminar in Fairfax VA
12/17/2018-12/21/2018 in Norfolk, VA         Find a seminar in Norfolk VA
12/17/2018-12/21/2018 in Richmond, VA         Find a seminar in Richmond VA
12/17/2018-12/21/2018 in Williamsburg, VA         Find a seminar in Williamsburg VA

Wisconsin (Find training in Wisconsin)
1/7/2019-1/11/2019 in Milwaukee, WI         Find a seminar in Milwaukee WI