SQL Server Administration

Description

The administration of Microsoft SQL Server, regardless of the edition chosen, is not only about its installation and creating backup regularly. Even though the server’s unique feature is its ability to respond automatically to the occurring situations, and to work correctly in default configuration, it is only by an experienced administrator’s care, that  maximum performance, reliability and security of a database system can be ensured. The training prepares administrators (including “accidental” administrators, i.e. persons who have been tasked with its administration) for the skillful management of SQL Server. Effective management of SQL Server takes the knowledge of its basic working mechanisms, its key functions, and being able to use its administration tools. While putting together this comprehensive course, we had in mind not only our many years’ experience, but also comments offered and real-life problems reported by our customers and course participants. In effect, we have designed a training which helps to manage SQL Server independently and effectively, respond adequately in critical moments, and troubleshoot  in advance.

Options

  • Course level: 300
  • Start date: as required
  • Duration time: 5 days

Price: 5000 zł

  • Open training
  • On-site (costumer's premises)
  • Customer’s computer

Class

The course has been designed for database administrators, as well as all those who would like to get familiarized with the architecture and functioning of SQL Server.  The participants will gain the practical skills necessary for independent management of SQL Server, both Express and Enterprise edition. The training is available in three versions, devoted to SQL 2005, 2008 and 2008 R2, and 2012 respectively.

Plan

The basic training is comprised of 14 modules. Just like all the other courses on our offer, it has been designed by our experts, therefore we can freely customize it to suit the individual needs of the participants.  We would like to encourage you not only to choose modules which you find relevant for your needs, but also to feel free to contact us with your suggestions and questions you would like to hear answered throughout the course.
Our trainings are unique also because we limit the time set aside for laboratory type classes customarily conducted after the completion of each module, to the benefit of exercises done with the assistance of the trainer and demonstrations. We believe in this manner we can equip you with substantially more practical information and tips, and focus on dealing with the issues directly within your scope of interest. However, each day of the training is finished with a laboratory class of approximately 1hr, so that you can do self-practice and do exercises of your choice.

Modules

Duration: Level:
Module 1

SQL Server Installation
  • Business Requirements Assessment
  • Analysis of Performance Requirements for Hardware (Input-Output and Processors Subsystems)
  • Choosing Hardware Configuration
  • Partition Alignment
  • Hardware and Software Requirements of SQL Server
  • SQL Server Licensing. How to Choose the Right Edition?
  • Collation Considerations (Code Pages and Sorting Orders)
  • Installation and its Assessment

90 minutes 300
Module 2

SQL Server Upgrade
  • Preparing Database Upgrade
  • Database and Client Application Compatibility with the Target SQL Server Version
  • Update Strategies
  • Activities to Perform after Upgrade Has Been Completed

60 minutes 300
Module 3

SQL Server Architecture and Configuration
  • Architecture and Functioning of SQL Server
  • SQLOS
  • Managing Memory
  • Managing Requests
  • Transaction Logging and Recovering
  • SQL Server Work Monitoring Using System Views and Dynamic Management Views (DMV)
  • Configuration and Management of Tempdb
  • SQL Server Configuration

150 minutes 400
Module 4

Databases and Data Storage Formats
  • System Databases
  • Database Configuration
  • Files and File Groups
  • Filestream Attribute
  • File Tables
  • Pages and Extents
  • Database Snapshots

90 minutes 400
Module 5

Data Structures
  • Types of Data
  • Rows and Tables
  • Sparse Attribute
  • Partitioning Tables and Indexes
  • Data Compression

60 minutes 300
Module 6

Indexing Strategies
  • Heaps and B-Trees
  • Recommendations for Clustered Indexes
  • Design Strategies and Strategies for Creating Effective Indexes
  • Methods of Detecting and Preventing Logical and Physical Fragmentation of Indexes
  • Methods of Detecting Missing and Unused Indexes
  • Filtered Indexes

180 minutes 400
Module 7

Preventing Data Loss
  • Database Recovery from Backup Strategies.
  • Creating User Database Backup
  • Recovering User Databases
  • Recovering Databases from a Given Time
  • Single Page Restore
  • Online Restore
  • Recovering Databases from a Snapshot
  • Creating and Recovering System Database Backups
  • Checking Data Integrity and Diagnosing Damage
  • Fixing Damaged Databases

240 minutes 400
Module 8

Security and Data Protection
  • SQL Server Security Model
  • Windows System Level Security
  • Instance Level Security
  • Database Level Security
  • Client Program Level Security
  • Data Level Security
  • Security Audits

180 minutes 300
Module 9

Managing Server Resources and Databases
  • Monitoring SQL Server Work
  • Resource Governor ( Enterprise Edition)
  • Controlling the Work Of Query Optimizer (Statistics, Hints, Plan Guides)
  • Caching and Recompilation of Execution Plans
  • Concurrence - Managing Locks and Row Versions

120 minutes 400
Module 10

Monitoring And Troubleshooting
  • Database System Performance Evaluation Methodology
  • SQL Server Wait Types
  • Identifying Bottlenecks
  • SQL Server Tools (Perfmon, SSMS Reports, Database Tuning Advisor, Performance Studio, Dynamic Management Views and Functions, SQL Server Profiler & Trace, Extended Events Mechanism)
  • Additional Tools (SQL Diag, SQLDiag Configuration Tool, Performance Analysis of Logs, SQL Nexus)

210 minutes 400
Module 11

Automating Administration Tasks
  • SQL Server Agent and its Objects
  • Alerts
  • Database Maintenance Plans
  • Centralized Administration Techniques
  • Sql Server Management Policies
  • T-SQL Scripts (Sys2 DMV, SQL Server Maintenance Solution, DBCC Checkdb For Very Large Databases)
  • Powershell

120 minutes 300
Module 12

High Availability
  • Preventing Failure Results
  • Service Level Agreement (SLA )
  • Failover Clustering
  • Log Shipping
  • Database Mirroring
  • AlwaysOn Technology

90 minutes 300
Module 13

Replication Overview
  • SQL Server Roles in Replication
  • Replication Mechanism Components
  • Replication Types
  • Replication Agents
  • Creating and Managing Publications and Subscriptions
  • Replication Monitoring

90 minutes 300
Module 14

Data Importing and Exporting
  • ETL Process
  • SSMS Console Tools and Creators
  • Bulk Data Import/Export Tools
  • Server Integration Services (SSIS) - Overview
  • Data Profiling
  • Creating and Managing SSIS Packages

120 minutes 300

Form

Ask Question

Register