I have been asked to help a development team with training so that they can all take and pass the SQL Queries 70-461 Microsoft certification.

After looking it over and understanding all the topics needed for the 70-461 SQL Queries certification, Aaron Buma and I we have worked out a plan to get everyone on the development team through this training.

Based on the amount of value that I have received from the SQL Server community, I have been able to get approval to share this training with anyone who wants to participate.

Free Training

Since we will be doing all this training, the prep work to train one team or hundreds of people doesn’t change much, it’s still the same amount of work. So we have decided to open up the training to anyone who wants to attend via a webcast using Google On Air Broadcasts.

There are two options to access this training. One is to participate in the live training, and the other option is to follow my YouTube channel.

Schedule / Plan

Over the next 45 weeks we will be teaching one or two topics each week on Thursdays at 9:00am (pacific time) for about 70 to 90 minutes each week.

Each week when we cover a topic, we will be covering in detail as to be ready to address any questions that might be asked as part of the 70-461 exam.

Here is the plan for the next few weeks.

The following topics will be covered week over week until we get through them all.

Stored Procedures – Stored Procedure Techniques

Table Data Actions

Database Schemas and Synonyms

SQL Error Messages

Error Handling

Data Type Usage

Special Data Type Options

Dynamic SQL

Transactions and Locking

Isolation Levels and Concurrency

Spatial Data Types

Spatial Aggregates

XML Modes

Shredding XML

Shredding, attributes, elements and levels

Creating Indexes

Creating Indexes with Code

Index Analysis

XML Queries

Xquery

XML Data Binding

The GUID Data Type

Constraints

Importing and Exporting XML

XML Namespaces

XML Schemas and Processing

After Triggers

Other Triggers

XML Indexes

Views

Updating and Maintaining Views

This schedule is subject to change, but that’s our best guess at the plan for now.

About the Instructors

Steve Stedman … That’s me, for more information on me, just visit my blog at SteveStedman.com. I have spoken at many SQL Saturdays, other development conferences and local events. 25 years of SQL Server experience starting in 1990.

Aaron Buma. About 10 years of SQL Server experience in high availability environments. Aaron is also known for building and flying RC quadcopters / small UAV’s for aerial photography.

How to participate

Contact either of us through LinkedIn, Youtube, or Google Plus and let us know you want to participate, or just follow me on Twitter or Google Plus to get notified of upcoming sessions.

Just check my Google Plus profile every Thursday at 9:00am (pacific time) or a few minutes early to join in the weekly training.

Getting Help from Steve and the Stedman Solutions Team

We are ready to help. Steve and the team at Stedman Solutions are here to help with your SQL Server needs. Get help today by contacting Stedman Solutions through the free 30 minute consultation form.