ASPE-IT offers a full line of hands-on SharePoint training for complete implementation, management and usability for all key functions in your enterprise.

 

ASPE-IT offers real-world, independent training on Windows technologies giving you unbiased hands-on knowledge of the products.

 

Implemented correctly, virtualization technologies have the potential to create vast improvements in the utilization of IT resources.

 

ASPE-IT offers networking courses that focus on skills and knowledge development. The course you take will dissect the technology, and teaching you the protocols that drive them.

 

ASPE-IT provides premier hands-on Linux skills and certification training through its partnership with Red Hat.

 

Organizing & managing a company's vital information is one of the most extreme challenges in the IT sector today. We'll give you the knowledge and skills to find actionable data.

 

Protecting a company's vital information is one of the most important responsibility of today's IT Department. Get skills to fight todays most common attacks.

 

ITIL's best practices in IT Service Management enhance the cost-effectiveness of IT organizations, improve reliability and alignment with the needs of each business.

 
 

Fees starting at


Regular Individual Fee: $1495

Group (3+): $1295

GSA Individual: $97 6.50


Terms & Conditions

Latest Blog Post from ASPE-IT

FREE Web Seminars from our Archives

Connect with ASPE-IT

  • ASPE RSS Feeds
  • ASPE Blog
  • ASPE on Twitter
  • ASPE on LinkedIn





COURSE 9580 | 2-DAY SESSION
Mastering SQL Server Administration & Optimization
Course Outline

I. SQL Server: An Introduction
    A. Understand relational databases
    B. Discover the SQL Server features and benefits
    C. Why SQL Server’s architecture must be understood
    D. Learn about the new features introduced in SQL Server 2005, 2008 and 2008 R2

II. Installing SQL Server
    A. Uncover the differing hardware requirements
    B. Discover the various installation methods
    C. Verify and troubleshoot installation problems
    D. Configure the SQL Server management environment
    E. Tune Windows Server for support of the SQL Server software

III. Managing Database Files
    A. Data structures demystified
    B. Create databases
    C. Manage databases with ease
    D. Work with database files and transaction logs
    E. Become skilled in database optimization techniques
    F. Capacity planning
    G. Performance considerations

IV. Administration Tasks
    A. Learn the 3 most important configuration tasks
    B. Automate mundane maintenance tasks
    C. Create maintenance plans that will save you hours of effort
    D. Use alerts to warn you of potential problems
    E. Troubleshoot SQL Server jobs, operators and alerts
    F. Understand policy-based management (PBM)

V. Back Up Your Databases
    A. Avoid data loss through effective backup and restoration plans
    B. Explore various methods used to back up databases
    C. Learn to recover SQL Server when it fails or will not start
    D. Understand the essential system databases and how to recover them

VI. SQL 101
    A. Understand the components of the SQL language
    B. Create SQL queries visually
    C. Learn the top 10 SQL commands and their syntax
    D. Uncover SQL tips and tricks of the gurus

VII.Security and SQL Server
    A. Understanding and implementing authentication
    B. Assigning logins to users and roles
    C. Assigning permissions to users and roles
    D. Managing security within SQL Server
    E. Managing security with views and stored procedures
    F. Managing application security
    G. Understanding SQL Server attacks (injection, brute force, data theft, etc.)

VIII. SQL Server Performance Tuning
    A. Learn why database monitoring is important
    B. Monitor with the System Monitor
    C. Use the SQL Profiler
    D. Take advanced of the Database Engine Tuning Advisor (DTA)
    E. Understand the recommendations of the DTA

IX. Data Transfer and Manipulation
    A. Introduction to ETL processes
    B. Understand the components of SQL Server Integration Services (SSIS)
    C. Exporting and importing data
    D. Introduction to distributed data
    E. Introduction to SQL Server replication
    F. SQL Server replication agents
    G. SQL Server replication types

X. High Availability Solutions in SQL Server
    A. Consider server virtualization for increased capabilities
    B. Use multiple servers for redundancy
    C. Learn about clustering an how it’s implemented
    D. Implement hardware redundancy within servers

 

Dynamic In-Class Demos

  • Installing SQL Server right the first time
  • Optimizing the Windows Server for SQL Server
  • Troubleshooting installation problems
  • Working with Jobs, Operators and Alerts
  • Using PowerShell for SQL Server administration
  • Working with command line as a DBA
  • Using the Surface Area Configuration Tool
  • Using SP_Configure
  • Central Management Server
  • Implementing Policy Based Management Server
  • Creating Tables, Databases, Views and Indexes
  • Tuning Inquiries
  • Using the SQL Profiler
  • Using Database Engine Tuning Advisor
  • Using the Resource Governor
  • The Performance Studio
  • The System Monitor in action
  • Performing SQL Injection Attacks
  • Securing SQL Server Service
  • Event Viewer Logs
  • Automating SQL Server Administration
  • Performing Backups and Restorations
  • Implementing Database Mirroring
  • Implementing Log Shipping