Request Info

Salutation

First Name

Last Name

Job Title

Department

Mailstop

Company

Address

P.O. Box

City

Province

Postal Code

Country
List

Work Telephone

Ext.

E-mail Address

Information provided will be used to communicate with you about our products.
Privacy Statement

A representative will contact you to follow up your request.

 
Special offer: Training Vouchers - Free Courses with purchase.

 

SQL Server® 2012 Database Administration: Hands-On

Course 2108 • 4 Days

 E-mail E-mail  Print Print  Q&A Q&A  PDF PDF  Facebook Facebook  Twitter Twitter

Quick Enrol

You Will Learn How To

  • Administer SQL Server 2012 with SQL Server Management Studio and Transact-SQL
  • Employ proven techniques to upgrade databases from earlier SQL Server versions
  • Ensure tight SQL Server security with logins, roles, users and permissions
  • Develop backup strategies, perform backups and recover from disasters
  • Leverage SQL Server Agent to automate administrative tasks and generate alerts
  • Isolate and repair fragmentation and database corruption

Course Benefits

SQL Server 2012 offers a sophisticated platform for enterprise data management. Organizations rely on database administrators who know how to manage their mission-critical databases correctly. This hands-on course provides you with the essential skills you need to install this next generation of SQL Server, create and modify storage structures, back up and recover databases, and manage security.

Who Should Attend

Those responsible for administering SQL Server 2012. A basic understanding of SQL Server 2012 or experience at the level of Course 2107, "SQL Server 2012 Introduction," is assumed. Experienced SQL Server 2008 DBAs should take Course 2105, "SQL Server 2012: DBA Skills Upgrade."

Hands-On Training

Throughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server 2012. Exercises include:
  • Employing Transact-SQL and the graphical tools
  • Upgrading SQL Server 2005 and 2008 databases
  • Implementing security for logins, databases and objects
  • Creating contained databases
  • Backing up and restoring databases
  • Defining jobs and alerts
  • Repairing database corruption
  • Building a database maintenance plan

Course 2108 Content

Getting Started with SQL Server 2012

Setting up SQL Server 2012

  • 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

  • Creating databases and transaction logs
  • Spreading data among file groups

Upgrading and moving databases

  • Choosing between upgrade and migration
  • Taking advantage of the Upgrade Advisor
  • Detaching and attaching databases

Controlling database space

  • Permitting automatic database growth
  • Adding database files to expand databases
  • Specifying database options

Handling Server and Database Security

Implementing server security

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

Granting database access

  • Adding users
  • Defining new roles
  • Delegating privileges with predefined roles
  • Assigning users to roles
  • Repairing mismapped logins

Creating contained databases

  • Examining components and terminology
  • Enabling contained databases
  • Contrasting SQL and Windows users

Converting existing databases to contained databases

  • Discovering barriers to containment
  • Transforming current users

Granting and Revoking Permissions

Managing database-scoped privileges

  • Permitting object creation
  • Giving blanket permissions
  • Assigning a default schema

Defining object-level permissions

  • Limiting object access
  • Meeting complex permission requirements with roles
  • Examining permission hierarchies

Backup and Recovery

Backing up databases

  • Selecting a recovery model
  • Exploring transaction log architecture
  • Running full, log and differential backups
  • Reclaiming transaction log space

Restoring databases

  • Recovering user and system databases
  • Testing recovery scenarios

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
  • Associating alerts with jobs
  • Initiating multistep jobs

Database Maintenance and Monitoring

Handling fragmentation and database corruption

  • Identifying and curing fragmentation
  • Repairing database corruption
  • Updating optimizer statistics

Building database maintenance plans

  • Selecting maintenance tasks
  • Scheduling plan execution
  • Notifying operators of success or failure

Monitoring SQL Server

  • Pinpointing blocked users with Activity Monitor
  • Resolving contention problems

<< Back to SQL Server Course List
 

Related Courses

Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
  
SQL Server 2012 Database Administration: Hands-On

Training Dates

Live online classroom training.Most events below can be taken in-class or live, online from your home or office with AnyWare.
Aug 21 - 24Toronto enrol
Aug 28 - 31Ottawa enrol
Nov 20 - 23Toronto enrol
Jan 8 - 11Ottawa enrol

US Dates

Jun 26 - 29Reston, VA enrol
Jul 31 - Aug 3Rockville, MD enrol
Aug 21 - 24Los Angeles enrol
Sep 4 - 7New York enrol
Oct 23 - 26Reston, VA enrol
Dec 18 - 21New York enrol
Jan 15 - 18Rockville, MD enrol

For AnyWare enrolments, please register at least 7 days prior to the start of the course.

More Dates and Locations.

 

Bring this or any Learning Tree Course on-site to your location!

 

Certification Core Course