Hands On Training

Microsoft SQL Server 2012 Certification - Exam 70-461

O’Reilly

(9)

Course Features

Duration

12.2 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

12.2 hours

Course Description

In this video tutorial, expert author Mark Long provides comprehensive training for passing the Querying Microsoft SQL Server 2012 exam and earning the MCSA: SQL Server certification. Long covers all the topics needed to pass the exam, including setting up the interface, using TQL to alter tables, and executing SQL queries. He also covers advanced techniques such as joins, subqueries, XML, triggers, and query optimization. Long concludes by reviewing the exam basics and what to expect from it. After completing this course, learners will have the necessary knowledge and skills to pass the exam and continue their journey towards obtaining the SQL Server MCSA certification.

Course Overview

International Faculty

Post Course Interactions

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

You will learn how to setup the interface, create and alter tables using t-sql, and understand sql queries

You will learn about select statements, how to modify data, and use joins and subqueries

Will teach you about triggers and different trigger types, how to work with xml, and how to optimize queries

Course Content

Expand all sections

Module 1: Introduction

Module 2: Server 2012 Evaluation

Module 3: SQL Server 2012 Interface

Module 4: Database Objects And Data

Course Instructors

Mark Long

Instructor

Mark Long is the instructor for this course

Course Reviews

Average Rating Based on 9 reviews

4.0

56%

11%

22%

11%