SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

SQL Server Training

Course has been tailored to our needs. We are learning what we need for everyday work.
Comment from Giant Tiger

1. Title

  • SQL Server Administration: The Complete Course (SQLADCP, 4 days)
    View PDF

2. Course Pre-requisites

  • Previous SQL Server experience

3. Target Audience

  • IT professionals who want to learn how to administer a production SQL Server environment

4. Dates and Pricing

Sep 5 to Sep 8, 2017$2,775.00/person
Nov 6 to Nov 9, 2017$2,775.00/person

5. Outline

Module 1: Introduction to SQL Server and its Toolset

Topic 1: Overview of SQL Server Services

Topic 2: SQL Server Services and Features

Topic 3: Working with SQL Server Tools

Topic 4: Designing the Environment: Creating Accounts and Configuring the Firewall

Topic 5: About Virtualizing SQL Server

Topic 6: Configuring Services in an Enterprise Environment

Topic 7: Configuring Protocols: Server and Client

Topic 8: Configuring DCOM Components for Enterprise Applications

Topic 9: Configuring SQL Server Browser

Topic 10: Modifying the Operating System for Performance

Topic 11: Installing SQL Server 2016

Topic 12: Tweaking SQL Server Memory

Topic 13: Configuring TempDB

Module 2: Working with Databases

Topic 1: About SQL Server Databases. Files and Filegroups

Topic 2: Planning for Space Usage

Topic 3: Creating Databases with TSQL

Topic 4: Creating Files and Filegroups

Topic 5: Attaching and Detaching Database Files

Topic 6: About Database Settings

Topic 7: Retrieving Key Database Information using TSQL

Module 3: Backup and Recovery

Topic 1: About SQL Server Recovery Models

Topic 2: About Full, Transactional and Incremental Backups

Topic 3: Delving Deeper into Transaction Logging

Topic 4: Planning a SQL Server Backup Strategy

Topic 5: Performing a Backup using TSQL

Topic 6: About Backup Options

Topic 7: Performing a Recovery using TSQL

Topic 8: About Recovery Options

Topic 9: Performing a Point in Time Recovery

Topic 10: Backup Strategies for System Databases

Module 4: Importing and Exporting Data

Topic 1: Overview of Import/Export Tools

Topic 2: Importing/Exporting Data using Graphical Tools

Topic 3: Importing/Exporting Data using TSQL

Topic 4: Importing/Exporting Data using Integration Services

Module 5: SQL Server Security

Topic 1: Understanding SQL Server Security Modes

Topic 2: Understanding SQL Server Logins, Users and Roles

Topic 3: Creating SQL Server Logins

Topic 4: Working with Server Roles

Topic 5: Working with Users and Database Roles

Topic 6: Creating Database Roles

Topic 7: Security and Stored Procedure Execution

Topic 8: Troubleshooting Data Access Issues

Module 6: SQL Server Event Management and Auditing

Topic 1: Enabling SQL Server Auditing

Topic 2: Auditing Data Access in SQL Server

Topic 3: Managing Auditing

Topic 4: Configuring SQL Server Agent

Topic 5: Creating and Scheduling Jobs and Alerts

Topic 6: Creating Operators and Notifications

Topic 7: Ensuring Database Integrity

Topic 8: Maintaining Indexes

Topic 9: Automating Routine Database Maintenance

Module 7: Working with indexes

Topic 1: Understanding the Anatomy of CRUD Operations

Topic 2: Understanding Page Internals

Topic 3: Understanding Indexes, Index Types and Table Storage

Topic 4: About Fragmentation and Data Storage

Topic 5: Creating Clustered Indexes

Topic 6: Creating Non-Clustered Indexes

Topic 7: Rebuilding Indexes

Topic 8: Managing Fragmentation

Topic 9: Tuning TSQL Statements

Module 8: Tracing Access to SQL Server

Topic 1: Capturing Activity using SQL Server Profiler

Topic 2: Improving Performance with the Database Engine Tuning Advisor

Topic 3: Working with Tracing Options

Topic 4: Monitoring Activity

Topic 5: Capturing and Managing Performance Data

Topic 6: Analyzing Collected Performance Data

Module 9: Troubleshooting Common SQL Server Issues

Topic 1: Complete SQL Server Troubleshooting Lab

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette