Online Course: The Accidental DBA: Understanding the Core Necessities with SQL Server

13 Sessions Brought to you by SSWUG.ORG


Course Overview

Have you found yourself in a situation where you’re managing SQL Server systems, but need some help determining what’s important and what you need to know?

Watch Video

In SSWUG.ORG’s virtual class, conducted by Microsoft SQL Server MVP Stephen Wynkoop, you will be able to receive the information need in the real world for working with SQL Server. For the non-formally trained “Accidental DBA”, Stephen will center on learning experiences, how-to information and specific demonstrations and labs that will let you explore the topics covered. By the end of the course, you will be ready to support and manage production databases when they are working well and when they are misbehaving.

This is the perfect workshop for many types of IT professionals, including SharePoint administrators, departmental database managers or simply those who have been asked to watch over systems while performing other duties.

 

Session Descriptions

  • Performance – Stephen will focus on management, tuning and optimization for your servers. Learn about counters to monitor, common pitfalls and native tools you can use to manage and monitor your performance, as well as view what’s happening on your server.
  • Management – Find out more about ongoing management of your systems and how to determine what you to be monitoring, what types of things you can do to troubleshoot and what are best practices for your systems.
  • Best Practices – Get answers to questions like, “What are your native options for monitoring and auditing your SQL Server?”, “What options best fit in your own implementations?” and “What is the impact or overhead of the various approaches?”
  • Security – Stephen will help you with planning and implementing an access control model as well as better understanding the threats to your system, all while providing insightful tips for managing your footprint and installation vulnerabilities.
  • Disaster Recovery – Learn about the key fundamental planning points for building a disaster recovery plan by finding out how disaster recovery works, seeing what options are available and exploring the steps to properly handle backups and restores.
  • T-SQL – Get started with understanding T-SQL by moving beyond the graphical tools to create queries, views, stored procedures. Stephen will provide information on how tools work, what you need to know about SELECT statements, DELETE, UPDATE and much more.

 

Course Structure/Cost

Once registered, you'll have instant access to all 13 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.
 

   Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form




 

Group Registration

  • Does your company have more than 1 person interested in this class? Take advantage of immediate savings by completing the group registration process. To start the group registration process downoad our form here.


Speakers

  • Stephen Wynkoop

    Stephen Wynkoop is the founder and editor for SSWUG.ORG – the SQL Server Worldwide User’s Group where ...