Improve job skills - Become more efficient - Produce better results !

Learn Querying Microsoft SQL Server 2012 (Exam 70-461) (in only 8 hours)

Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.

Course Description: The 2012 Microsoft MCSA Certification track includes Exam 70-461 Querying Microsoft SQL Server 2012. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This VTC course is intended for SQL Server database administrators, implementers, system engineers, and developers who are preparing to take the 70-461 exam as well as those who are just beginning to learn Transact-SQL. Mark Long is the instructor and will take you through the various tools and concepts needed to help you get ready for the 70-461 exam. Online training videos are great for individuals and companies.


Click a play button below to view a free training video. Place your order online for full access.

 

Video Tutorials Included: 107 Free Video Video Time
(minutes)

Introduction

  • Understanding SQL 4.37
  • Understanding TSQL 3.35
  • SQL Server History 4.82
  • Microsoft SQL Server Certifications 2.85

Getting Set Up

SQL Server 2012 Management Studio

Creating Database Objects

Basic Select Queries

More Advanced Select Statements

SQL Server 2012 Data Types

Using Joins

Querying Metadata

Inserts / Updates / Deletes

Subqueries

Table Expressions

Stored Procedures

Functions

Transactions

Conclusion