Seminar Microsoft SQL Server 2014 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 class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2014 database engine.

Course Description


This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2014 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2014. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server performance as well as assuring high data availability. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2014. 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.

Emphasis is placed on how SQL Server 2014 is architected, so that you will be able to make the proper decisions in configuring and managing your SQL Server instances. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at HOTT's SQL Programming course or Microsoft Transact-SQL Programming course is highly recommended although not required.

Follow-up Courses: SQL Server 2014 Reporting Services, SQL Server 2014 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2014 Business Intelligence: Integration Services and Analysis Services


What Students Will Learn

  • Configuring and Installing SQL Server 2014
  • SQL Server Database Engine Architecture
  • Replication, Backup and Restore
  • Securing SQL Server
  • Performance Optimization
  • Maintaining Data Integrity
  • Creating and Populating Databases
  • Automating Tasks
  • Full-Text Search Architecture
  • High Availability Solutions


Workshop Agenda

An Overview of SQL Server 2014
  • SQL Server 2014 Architecture
  • Available Features and Tools
  • New Capabilities
  • SQL Services
  • Product Licensing
  • Product Editions
Installing SQL Server 2014
  • Preparing for Installation
    • Creating Users for Service Accounts
    • Choosing Appropriate File Locations
    • Choosing Instance Names
  • Installing SQL Server 2014
    • Choosing Appropriate Features
    • Specifying Service User Accounts
    • Choosing Licensing Mode
    • Choosing Appropriate Collation
    • Installing Multiple Instances
  • Upgrading to SQL Server 2014
Configuring SQL Server 2014
  • Registering Servers
  • Using Metadata Views to Obtain Object Properties
  • Using Object Explorer
    • Configuring a SQL Server Instance
    • Configuring Object Properties
  • Using the Query Window
  • Creating Transact SQL Projects
  • Managing Services
  • Configuring Server Network Connections
  • Configuring Client Connections and Aliases
  • Configuring the Surface Area of SQL Server
  • Configuring Policy-Based Management
  • Creating a Central Management Server
  • Using the Dedicated Administrator Connection
  • Configuring Data Replication
  • Creation and Maintenance of Full-Text Catalogs
  • Describing Full-Text Search
Using SQL Server 2014 Management Tools
  • SQL Server Management Studio
  • SQL Server Configuration Manager
  • SQL Server Books Online
  • SQLCMD
Monitoring Data Structures
  • Creating DDL Triggers
  • Creating Event Notifications
  • Configuring SQL Server Audit
Creating and Configuring a Database
  • Creating Databases
  • Creating a Contained Database
  • Creating Tables
  • Memory Optimized Tables
  • Specifying Data Types
  • Creating Indexes
  • Describing Data File Structure
  • Describing Log File Structure and Function
  • Creating Filegroups
  • Configuring Filestream Storage
  • Configuring FileTables
  • Creating and Using Database Snapshots
  • Moving a Database to Another SQL Server
Monitoring SQL Server Performance
  • Using the Windows Performance Tool to Detect the Cause of a Bottleneck
  • Using SQL Server Profiler
  • Configuring Extended Events
  • Using Dynamic Management Functions
  • Interpreting Management Studio Reports
  • Using Activity Monitor
Optimizing SQL Server Performance
  • Describing Index Structures
    • Clustered Indexes
    • Nonclustered (NC) Indexes
    • Columnstore Indexes
    • Clustered Columnstore Indexes
  • Choosing Appropriate Clustered Index
  • Choosing Appropriate NC Indexes
  • Detecting Index Fragmentation
  • Rebuilding and Reorganizing Indexes
  • Using the Database Engine Tuning Advisor
  • Generating and Interpreting Query Plans
  • Configuring the Resource Governor
Securing SQL Server
  • SQL Server Security Architecture
  • Defining Principals and Securables
  • Using the Security Hierarchy
  • Creating Logins and Users
  • Applying Password Policies to SQL Logins
  • Creating Server and Database Roles
  • Granting Permissions
  • Using SQLCMD to Test Permissions
  • Creating and Using Certificates
  • Setting Execution Context
  • Encrypting Data
  • Encrypting Databases
Automating Tasks
  • Creating Maintenance Plans
  • Job Creation and Execution
  • Creating Schedules for Jobs
  • Creating and Using Proxies
  • Configuring Alerts
  • Creating and Using Operators
  • Configuring and Using Database Mail
Importing and Exporting Data
  • Using bcp and BULK INSERT
  • Using the Import/Export Wizard
  • Using Integration Services to Import Data
Maintaining High Availability of Data
  • Windows Clustering
  • AlwaysOn Availability Groups
  • Implementing Database Mirroring
  • Implementing Log Shipping
Maintaining Data Reliability
  • Maintaining Data Integrity
    • Creating Constraints
    • Describing and Using DML Triggers
    • Using Data Quality Services
  • Configure Data Compression
  • Setting Transaction Isolation Levels
  • Capturing Changed Data
Backing Up and Restoring Databases
  • Choosing Appropriate Database Recovery Model Option
  • Describing Automatic Recovery
  • Choosing an Appropriate Backup Strategy
  • Determining Backup File Contents
  • Designing a Database Recovery Plan
  • Using Backup Compression
  • Use of Filegroups in a Backup Strategy
  • Restoring the Master Database
  • Rebuilding System Databases
  • Encrypting Backup Files
  • Using Backup to URL to Backup or Restore from Windows Azure BLOB
 

 

More Seminar Information

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

Summary

This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2014 database engine.

Delivery Method

Seminar Seminar

Also Available As

On-Site Training On-Site Training

Who Should Attend

Microsoft SQL Server 2014 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