30% OFF Marked Prices & FREE Shipping!   -   ENDS 4PM FRIDAY!   -   Use Discount Code 303

Microsoft SQL Server 2012 Certification Exam 70-461 Tutorial

A professionally created, self-study video training course
Includes 12 hours of easy to follow Microsoft SQL Server 2012 Certification Exam 70-461 video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Microsoft SQL Server 2012 Certification Exam 70-461 tutorial videos by clicking a blue link below:
  • Tutor: Mark Long
  • Duration: 12 hours
  • Video lessons: 148
  • Product code: 01873
  • In stock: YES
Gain a detailed understanding of the steps involved in Querying Microsoft SQL Server 2012 with the help of these practical tutorial videos that are geared towards the MS Exam 70-461. This successful completion of this test is required in order to achieve the MCSA: SQL Server certification.

Commencing from the basics, certified IT instructor Mark Long uses step by step training videos to cover the main topics and principles of the SQL Server 2012 70-461 exam.

Through over twelve hours of professionally created video training, the first few topis explain the basic concepts with an explanation of databases and the SQL Server 2012 workspace explored. Throughout the course, Mark frequently refers to and makes use of SQL files that are included with the DVD, download and online purchase making it easy to keep pace with Mark's instruction. Once the fundamentals have been explained, the courses provides lessons on creating and altering tables with T-SQL, the basic SELECT statement, understanding subqueries, learning to use triggers, querying: SQL basics, working with XML, how to optimize queries and so much more.

The complete course contents are listed below and you can start preparing for the 70-461 test right away. Click any blue linked lesson to sample free video tutorials and get on the right path to your MCSA SQL Server certification.
What Our Customers Are Saying

"Your Products are the best example of CD and internet computer training I've seen."Christine Maggio Abacus Technology, Inc., NJ
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via DVD or Download.
Paid Content
Section

Get all lessons with purchase
Introduction
What To Expect From This Course
Course Overview
Understanding Databases
Transact-SQL Basics
Microsoft SQL Certification
How To Access Your Working Files

Course Set Up
SQL Server 2012 Evaluation
SQL Server 2012 Installation
Windows 8 Server 2012 Interface
Windows 7 Interface
SQL Server Sample Database
Attaching The Sample Database
Getting Help
Installing SQL Books Online

SQL Server 2012 Interface
Management Studio Basics
Connecting To SQL Server
Customizing SSMS
Utilizing Diagrams
Saving Diagrams
Text And Graphical Tools
Using Sample Code Files
About The Semicolon

Database Objects And Data
What Are Objects?
Understanding Tables
Understanding Data Integrity
Understanding Data Types
Understanding Primary Keys
Understanding Constraints
Understanding NULL
Understanding Views
Understanding Stored Procedures
Understanding Triggers
Understanding Synonyms

Working With Tables
Creating A Table
Graphical Table Creation
Changing A Table
Graphical Table Alterations
Deleting A Table
Graphical Table Deletion
Creating A Primary Key

SQL Query Basics
Four Basic Queries
Thinking In SQL
Options And More Options
Good Query Structure
Comments
The USE Command
The GO Command

The Basic SELECT Statement
SELECT Basics
SELECT Structure
Using WHERE
Using TOP To Limit Rows
Ordering Results
Working With NULLs
T-SQL Concatenation

Advanced SELECT Statements
Column Aliasing
Using DISTINCT
Using SUM
Using AVG
Using COUNT
Using Group By
Using HAVING
SELECT INTO
Using LIKE And IN
Understanding UNION
INTERSECT And EXCEPT
Using Synonyms - Lesson 1
Using Synonyms - Lesson 2
Offset-Fetch
What Is Ranking?
Using Ranking
More Ranking Examples

Using Joins
Understanding Joins
Join Query Structure
Creating Inner Joins - Lesson 1
Creating Inner Joins - Lesson 2
Join Creation Through GUI
Creating Outer Joins
Creating Cross Joins

Modifying Data
The INSERT Statement
Using INSERT - Lesson 1
Using INSERT - Lesson 2
The UPDATE Statement
Using UPDATE
The DELETE Statement
Using DELETE - Lesson 1
Using DELETE - Lesson 2

Using Subqueries
Understanding Subqueries
Subquery Versus Join
Creating A Scalar Subquery
Creating A Multi-Valued Subquery
Creating A Correlated Subquery

Advanced Table Utilization
Utilizing Memory
What Is A Derived Table?
Creating A Derived Table
Table Variables - Lesson 1
Table Variables - Lesson 2
Common Table Expressions
Temporary Tables

Programmability
Programmability In T-SQL
What Is A Stored Procedure?
Why Use Stored Procedures?
A Simple Stored Procedure
Input Parameters
Multiple Input Parameters
Output Parameters - Lesson 1
Output Parameters - Lesson 2
Using Case Logic - Lesson 1
Using Case Logic - Lesson 2
Handling Errors
Stored Procedure Security
Working With Functions
Using Built-In Functions
Creating A Scalar Function
Creating A Table Valued Function
What Is Dynamic SQL?
Dynamic SQL Example
Understanding GUIDs
GUID Examples - Lesson 1
GUID Examples - Lesson 2

Triggers
Using Triggers
Inserted And Deleted Tables
Trigger Examples - Lesson 1
Trigger Examples - Lesson 2

Transactions In T-SQL
What Are Transactions?
Understanding Concurrency
Explicit And Implicit Transactions
Cross Platform Concerns
Transaction And Locking Example

Under The Hood
Using Metadata
Using Catalog Views
Using Information Schema Views
Using System Stored Procedures

Working With XML
XML Basics
Outputting XML From Queries
Using FOR XML RAW
Using FOR XML AUTO
Using FOR XML PATH

Optimizing Queries
Optimization Basics
Query Execution Plans - Lesson 1
Query Execution Plans - Lesson 2
SQL Server Extended Events - Lesson 1
SQL Server Extended Events - Lesson 2
SQL Server Profiler

Taking The Exam
Exam Basics
Taking Your Exam
When It Is Over

Conclusion
Wrap-Up
About The Author
Purchase Info - 30% OFF MARKED PRICE!
The DVD and Download options include the same training contents and both priced as below:
PRICE
CURRENCY
   
 
Item(s):
   
Once purchased, you will receive 148 Microsoft SQL Server 2012 Certification Exam 70-461 training videos (listed left), lasting a total of 12 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)

CD/DVDs No shipping charges. Please allow 2-3 days for UK, Europe, US & Canada. 3-5 days rest of world.
WE AIM TO PLEASE
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
|
Need to Train Multiple Users?
This Microsoft SQL Server 2012 Certification Exam 70-461 course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Microsoft SQL Server 2012 Certification Exam 70-461 course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
PRICE
(Per 10 user concurrent licence)
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Microsoft SQL Server 2012 Certification Exam 70-461. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"Thank you so much, this tutorial is incredible! I have never learned how to use a software package so fast and in such a fun way before, presenter Andy has a style and sense of humour that is bang on. thank you!"Tadgh Creed, Texas