Start Date Location Course Type Duration Fee
05 September 2015 Chicago,Illinois In Class 3 Days $800

Pay Now

Register Workshop

COURSE INTRODUCTION

For professionals managing mission-critical database environments, earning an SQL certification is a key step in your career. The certification validates the essential skills needed for administering and developing database solutions and for leveraging business intelligence (BI) tools.

USITplus offers an exclusive certification program which introduces students to the administration of a Database Management System (DBMS) using Microsoft's SQL Server in a Windows environment. The features, utilities and operations of a DBMS are examined. Students will install SQL Server, backup and recover data, monitor, tune and administer security for a SQL Server database.

COURSE OBJECTIVES

The course help the participants to:

·         Identify the basic features and utilities of a DBMS

·         Describe the responsibilities of a Database Administrator

·         Install, monitor and maintain the SQL Server DBMS

·         Import and export data for an SQL Server database

·         Backup and recover data for a SQL Server database

·         Administer security for a SQL Server database

·         Automate schedule to perform routine DBA tasks

·         Replicate data for a SQL Server database

 

 

 

 

COURSE OUTLINE

 

Description

Module 1

Getting Started with SQL Server

Setting up SQL Server

  • Selecting installation options
  • Installing a named instance

Leveraging essential tools

  • SQL Server Management Studio
  • Configuration Manager
  • Transact-SQL
  • sqlcmd
  • PowerShell
  • Dedicated Administrator Connection

 

Constructing and Managing Databases

Inspecting storage structures

·         Relating servers, databases and files

·         Creating databases and transaction logs

Designing file groups

·         Maximising storage utilisation

·         Placing tables on file groups

Upgrading and moving databases

·         Choosing between upgrade and migration

·         Detaching and attaching databases

Controlling database space

·         Permitting automatic database growth

·         Adding database files to expand databases

Module 2

Handling Server and Database Security

         Implementing server security

  • Comparing authentication modes
  • Defining logins
  • Creating user-defined server roles
  • Enforcing password policy

          Granting database access

  • Contrasting users and logins
  • Adding users
  • Defining new roles
  • Delegating privileges with predefined roles
  • Repairing mismapped logins

 

Granting and Revoking Permissions

Managing database-scoped privileges

  • Permitting object creation
  • Giving blanket permissions

Defining object-level permissions

  • Limiting object access
  • Meeting complex permission requirements with roles

Module 3

Backup and Recovery

Backing up databases

  • Selecting a recovery model
  • Investigating the transaction log
  • Running full, log and differential backups

Restoring databases

  • Performing a post-crash log backup
  • Rebuilding the master database
  • Recovering user and system databases

 

Streamlining Tasks with Jobs, Alerts and Database Mail

Configuring SQL Server Agent

  • Setting agent properties
  • Implementing database mail

Defining jobs to handle routine tasks

  • Creating alerts and operators
  • Initiating multi-step jobs
  • Associating alerts with jobs

 

Database Maintenance and Monitoring

          Handling fragmentation and database corruption

  • Identifying and curing fragmentation
  • Repairing database corruption

          Building database maintenance plans

  • Scheduling plan execution
  • Notifying operators of success or failure

           Resolving contention problems

  • Identifying blocked processes
  • Killing blockers

 

 * Full Tution fee is due and is non-refunded after attending 2nd class*

Reviewed By: Jason

Course material was informative, I really enjoyed the separation of content into modules. Great group of professionals in the class. I am ready for the exam :)

Submit a review