ASP.NET, VB.NET, and C# Training Classes     
Accelebrate delivers SharePoint , ASP.NET, SQL Server, Java, and other training courses in the USAAccelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Canada     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the UK     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Ireland     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the Netherlands     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses internationally  
1 877 849 1850   0808 234 2132   1 800 550 311   0 800 022 6730   +1 678 648 3113  
Microsoft and .NET TrainingSQL Server TrainingSharePoint TrainingJava TrainingAdobe TrainingDatabase and Reporting TrainingXML, JavaScript, and Other TrainingWeb/Application Server Training
HomeAboutContact Us 


Please contact us
for GSA pricing.

GSA - Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
GS-35F-0307T



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Edmonton & Calgary, Alberta
  • Phoenix, Arizona
  • Tucson, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Amsterdam, The Netherlands / Brussels, Belgium
  • Vancouver, British Columbia
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • San Diego, California
  • Orange County / Los Angeles, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida 
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Boise, Idaho
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Wichita, Kansas
  • Lexington / Louisville, Kentucky
  • Baton Rouge/New Orleans, Louisiana
  • Portland, Maine
  • Hagerstown & Frederick, Maryland
  • Annapolis / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Ann Arbor / Detroit, Michigan
  • Grand Rapids, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • St. Louis, Missouri
  • Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Fredericton / Moncton / Saint John, New Brunswick
  • Albuquerque, New Mexico
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • Albany, New York
  • Buffalo, New York
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • San Juan, Puerto Rico
  • Providence, Rhode Island
  • Saskatoon / Regina, Saskatchewan
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Spartanburg & Greenville, South Carolina
  • Knoxville, Tennessee
  • Memphis / Nashville, Tennessee
  • Houston, Texas
  • El Paso, Texas
  • San Antonio / Austin, Texas
  • Dallas, Texas
  • Salt Lake City, Utah
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Charleston, West Virginia
  • Madison / Milwaukee, Wisconsin

 

SQL Server 2012 Administration Training: Introduction to SQL Server 2012 for Administrators

Print This Outline
E-mail This Outline
Get A Quote
Course Number: SQL-312
Duration: 4 days
view class outline

Looking for SQL Server 2008 for Administration training?

SQL Server 2012 Administration Training Overview

Accelebrate's SQL Server 2012 Administration training teaches administrators how to successfully administer SQL Server 2012.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=course&page=MOC10775.

SQL Server 2012 Administration Training Prerequisites

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 65% hands-on, 35% lecture, with the longest lecture segments lasting for 20 minutes.

SQL Server 2012 Administration Training Materials

All attendees receive a copy of Wrox's Professional Microsoft SQL Server 2012 Administration Administration.

Software Needed on Each Student PC

  • At least 3GB RAM.
  • SQL Server 2012 Developer with 32- or 64-bit Windows Vista, 7, or 2008 with the latest service packs, or SQL Server 2012 Enterprise or Business Intelligence with Windows Server 2008 SP2 or R2.  Please have the installer for one of these editions of SQL Server available for installation of SQL Server during the class.
  • Related sample databases and lab files that Accelebrate provides.

Important Note: If you have purchased this class, please contact us for detailed setup instructions.

SQL Server 2012 Administration Training Objectives

All attendees will learn to:

  • Install and configure Microsoft SQL Server 2012
  • Understand the new features of Microsoft SQL Server 2012
  • Manage and monitor SQL Server and automate administration
  • Create databases and tables
  • Implement indexes and partitions
  • Take database snapshots
  • Create and use full-text indexes
  • Secure SQL Server and implement policy-based management
  • Back up and recover data
  • Automate administrative tasks with the SQL Server Agent
  • Performance tune and monitor your SQL Server instance
  • Use Dynamic Management Views to monitor the database and troubleshoot problems
  • Configure SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication

SQL Server 2012 Administration Training Outline

  • SQL Server 2012 Architecture
    • SQL Server 2012 ecosystem
    • New important Features in 2012
    • SQL Server architecture
    • Editions of SQL Server
  • Installing SQL Server 2012 Best Practices
    • Planning the system
    • Installing SQL Server
    • Installing analysis services
    • Installing PowerPivot for SharePoint
    • Burning the system
    • Post-install configuration
    • Uninstalling SQL Server
    • Troubleshooting a failed install
  • Upgrading SQL Server 2012 Best Practices
    • Why upgrade to SQL Server 2012
    • Upgrading the SQL Server 2012
    • Pre-upgrade steps and tools
    • Backward compatibility
    • SQL Server component considerations
    • Post-upgrade checks
  • Managing and Troubleshooting the Database Engine
    • Configuration and administration tools
    • Troubleshooting tools
    • Management studio
    • Monitoring processes in T-SQL
    • Multiserver management
    • Trace flags
    • Getting help from support
  • Automating SQL Server
    • Maintenance plans
    • Automating SQL Server with SQL Server Agent
    • SQL Server Agent security
    • Configuring SQL Server Agent
    • Database mail
    • Multiserver administration
  • Service Broker in SQL Server 2012
    • Asynchronous messaging
    • Configuring SQL Server service broker
    • Using SQL Server service broker
  • SQL Server CLR Integration
    • Introduction to the CLR
    • Creating CLR assemblies
    • Securing CLR
    • Performance monitoring
  • Securing the Database Instance
    • Authentication types
    • Authorizing securables
    • Row level security
  • Change Management
    • Creating solutions and projects
    • Policy-based management
    • DDL trigger syntax
    • Trigger views
    • Scripting overview
    • Creating change scripts
    • Data-tier applications
  • Configuring the Server for Optimal Performance
    • What every DBA needs to know about performance
    • What the developer DBA needs to know about performance
    • What the production DBA needs to know about performance
    • CPU
    • Memory
    • I/O
  • Optimizing SQL Server 2012
    • Application optimization
    • The silent killer: I/O problems
    • Table and index partitioning
    • Data compression
    • CPU considerations
    • Memory considerations and enhancements
    • Resource governor
  • Monitoring Your SQL Server
    • The goal of monitoring
    • Choosing the appropriate monitoring tools
    • Performance monitor
    • Monitoring events
    • Monitoring with dynamic management views and functions
    • Monitoring logs
    • Management data warehouse
    • SQL Server standard reports
    • System center management pack
    • SQL Server best practice analyzer
    • System center advisor
  • Performance Tuning T-SQL
    • Physical query processing part 1: compilation and recompilation
    • Physical query processing part 2: execution
  • Indexing Your Database
    • Noteworthy index-related features in SQL Server
    • Partitioned tables and indexes
    • Index maintenance
    • Improving query performance with indexes
    • Database tuning advisor
    • Too many indexes?
  • Replication
    • Replication overview
    • Replication models
    • Implementing replication
    • Peer-to-peer replication
    • Scripting replication
    • Monitoring replication
  • Clustering SQL Server 2012
    • Clustering and your organization
    • Clustering: the big picture
    • Upgrading SQL Server clustering
    • Getting prepared for clustering
    • Clustering Windows Server 2008
    • Clustering Microsoft distributed transaction coordinator
    • Clustering SQL Server 2012
    • Managing and monitoring the cluster
    • Troubleshooting cluster problems
  • Backup and Recovery
    • Types of failure
    • Making plans
    • Overview of backup and restore
    • Preparing for recovery
    • Developing and executing a backup plan
    • Managing backups
    • Backup and restore performance
    • Performing recovery
    • Archiving data
  • SQL Server 2012 Log Shipping
    • Log shipping deployment deployment scenarios
    • Log shipping architecture
    • Log shipping process
    • System requirements
    • Deploying log shipping
    • Monitoring and troubleshooting
    • Managing changing roles
    • Database backup plan
    • Integrating log shipping with other high-availabilty solutions
    • Removing log shipping
    • Log shipping performance
    • Upgrading to SQL Server 2012 log shipping
  • Database Mirroring
    • Overview of database mirroring
    • Operating modes of database mirroring
    • Database mirroring in action
    • Database mirroring and SQL Server 2012 editions
    • Database mirroring catalogue views
    • Database mirroring role change
    • Database availability scenarios
    • Monitoring database mirroring
    • Troubleshooting database mirroring
    • Preparing the mirror server for failover
    • Mirroring multiple databases
    • Database Mirroring and other high-availabilty solutions
    • Mirroring event listener setup
    • Database snapshots
  • Conclusion
 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.

Accelebrate®
Focuses on You!


Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!



VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training  Adobe Training PHP Training XML Training Perl Training Sitemap

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | Albany, NY | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK