Microsoft SQL Server 2012 Certification Training Exam 70-461

To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE

4.70 (3522 reviews)

Udemy

platform

English

language

Databases

What you will learn

To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE

Why take this course?

This Microsoft SQL Server 70-461 Exam training course by Infinite Skills teaches you everything you need to know to pass the Querying Microsoft SQL Server 2012 exam. It is required that you pass the 70-461 Exam in order to earn your MCSA: SQL Server certification from Microsoft.

The course takes you through each of the topics that you will need to master in order to pass the SQL Server 2012 70-461 exam. Throughout this video tutorial, 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. This course will teach you about triggers and different trigger types, how to work with XML, and how to optimize queries. Finally, you will run through the exam basics and what you can expect from the exam.

Once you have completed this computer based training course for the Microsoft SQL Server 70-461 exam, you will have developed the knowledge and skills necessary to pass the Querying Microsoft SQL Server 2012 Exam and continue towards earning your SQL Server MCSA certification.

How to take the Microsoft 70-461 Exam:

1. Find a test center near you to take the SQL Server 70-461 certification exam, their will provide details on test center locations and schedules. This exam is typically priced around $150 dollars.

2. Study the required material to pass the 70-461 examination. This course covers the material that is within the 70-461 certification exam, and will help put you in a great position to succeed in the exam

3. Pass your exam!

4) Take our Microsoft Windows Server 70-462 and 70-463 courses which will prepare you for the 70-462 and 70-463 exams. Upon passing the 70-461, 70-462, and 70-463 exams you will become a Microsoft Solutions Certified Associate in Microsoft SQL Server 2012.

5. Tell your friends how easy passing the Microsoft 70-461 exam was using Infinite Skills training courses

The information laid out above is given in good faith, we are not endorsing and third party company by offering a link to their site. You should always do your own research prior to making a purchase or using any service linked to via this website. Prices or details may alter and any information listed can not be guaranteed to be accurate. Note: While this course is comprehensive in regards to covering material on the exam, we do recommend using other aids to guide your study.

Content

Introduction

Important - Download These First - Working Files

What To expect From This Course

Course Overview

Understanding Databases

Transact-SQL Basics

Microsoft SQL Certification

How To Access Your Working Files

Course Setup

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

0401 What Are Objects?

0402 Understanding Tables

0403 Understanding Data Integrity

0404 Understanding Data Types

0405 Understanding Primary Keys

0406 Understanding Constraints

0407 Understanding NULL

0408 Understanding Views

0409 Understanding Stored Procedures

0410 Understanding Triggers

0411 Understanding Synonyms

Working With Tables

0501 Creating A Table

0502 Graphical Table Creation

0503 Changing A Table

0504 Graphical Table Alterations

0505 Deleting A Table

0506 Graphical Table Deletion

0507 Creating A Primary Key

SQL Query Basics

0601 Four Basic Queries

0602 Thinking In SQL

0603 Options And More Options

0604 Good Query Structure

0605 Comments

0606 The USE Command

0607 The GO Command

The Basic SELECT Statement

0701 SELECT Basics

0702 SELECT Structure

0703 Using WHERE

0704 Using TOP To Limit Rows

0705 Ordering Results

0706 Working With NULLs

0707 T-SQL Concatenation

Advanced SELECT Statements

0801 Column Aliasing

0802 Using DISTINCT

0803 Using SUM

0804 Using AVG

0805 Using COUNT

0806 Using Group By

0807 Using HAVING

0808 SELECT INTO

0809 Using LIKE And IN

0810 Understanding UNION

0811 INTERSECT And EXCEPT

0812 Using Synonyms - Part 1

0813 Using Synonyms - Part 2

0814 Offset-Fetch

0815 What Is Ranking?

0816 Using Ranking

0817 More Ranking Examples

Using Joins

0901 Understanding Joins

0902 Join Query Structure

0903 Creating Inner Joins - Part 1

0904 Creating Inner Joins - Part 2

0905 Join Creation Through GUI

0906 Creating Outer Joins

0907 Creating Cross Joins

Modifying Data

1001 The INSERT Statement

1002 Using INSERT - Part 1

1003 Using INSERT - Part 2

1004 The UPDATE Statement

1005 Using UPDATE

1006 The DELETE Statement

1007 Using DELETE - Part 1

1008 Using DELETE - Part 2

Using Subqueries

1101 Understanding Subqueries

1102 Subquery Versus Join

1103 Creating A Scalar Subquery

1104 Creating A Multi-Valued Subquery

1105 Creating A Correlated Subquery

Advanced Table Utilization

1201 Utilizing Memory

1202 What Is A Derived Table?

1203 Creating A Derived Table

1204 Table Variables - Part 1

1205 Table Variables - Part 2

1206 Common Table Expressions

1207 Temporary Tables

Programmability

1301 Programmability In T-SQL

1302 What Is A Stored Procedure?

1303 Why Use Stored Procedures?

1304 A Simple Stored Procedure

1305 Input Parameters

1306 Multiple Input Parameters

1307 Output Parameters - Part 1

1308 Output Parameters - Part 2

1309 Using Case Logic - Part 1

1310 Using Case Logic - Part 2

1311 Handling Errors

1312 Stored Procedure Security

1313 Working With Functions

1314 Using Built-In Functions

1315 Creating A Scalar Function

1316 Creating A Table Valued Function

1317 What Is Dynamic SQL?

1318 Dynamic SQL Example

1319 Understanding GUIDs

1320 GUID Examples - Part 1

1321 GUID Examples - Part 2

Triggers

1401 Using Triggers

1402 Inserted And Deleted Tables

1403 Trigger Examples - Part 1

1404 Trigger Examples - Part 2

Transactions In T-SQL

1501 What Are Transactions?

1502 Understanding Concurrency

1503 Explicit And Implicit Transactions

1504 Cross Platform Concerns

1505 Transaction And Locking Example

Under The Hood

1601 Using Metadata

1602 Using Catalog Views

1603 Using Information Schema Views

1604 Using System Stored Procedures

Working With XML

1701 XML Basics

1702 Outputting XML From Queries

1703 Using FOR XML RAW

1704 Using FOR XML AUTO

1705 Using FOR XML PATH

Optimizing Queries

1801 Optimization Basics

1802 Query Execution Plans - Part 1

1803 Query Execution Plans - Part 2

1804 SQL Server Extended Events - Part 1

1805 SQL Server Extended Events - Part 2

1806 SQL Server Profiler

Taking The Exam

1901 Exam Basics

1902 Taking Your Exam

1903 When It Is Over

Conclusion

2001 Wrap-Up

Reviews

Oumar

March 22, 2023

This guy is good. He explains very well, and I believe that if I continue listening to him, I should be able to know SQL before I retake my course at the University, and hopefully get an A.

James

September 5, 2022

I taught myself how to use SQL and wanted to take this to learn what I missed. It was very well done and I learned things I had no idea about.

Sue

October 19, 2021

Excellent! Easy to understand the speaker, just the right amount of time spent per topic. Highly recommended

Geetha

May 6, 2021

Good refreshment of the database skills.But this course didn't cover primary, composite key while creating table.

João

January 15, 2021

Good course for new SQL comers and a nice refresh for people whose already has some experience with SQL Sever. The professor is funny

Imadeddeen

January 2, 2021

I am a software development out of my experience I can briefly say this Instructor is proficient thanks Infinite Skills for organized and detailed course

Trainee

December 30, 2020

It was great. I learned a lot from it . Gained deeper knowledge on topics i work on and also new ones. This gave me a better understanding on my work!

Kenneth

August 5, 2019

The content is so easily explained in a friendly manner. I am enjoying a course I thought I would have to hunker down and bear through. Easily worth the $$.

Frank

August 2, 2019

So far so good. More like a refresher. I started at a higher level and always struggled to keep up so this is great.

Lot

July 25, 2019

The presenter is very clear in his explanations and doesn`t overlook any detail. This makes it much easier to understand.

Jenny-Lynn

June 26, 2019

Overall he made understanding some of the topics very easy, however, he often repeated unnecessary things. This time could have been spent going over other things on the exam.

Osman

June 5, 2019

This lecturer is wonderful than I thought. In fact he is very fast but very comprehensive and elaborate. Thank you Mr. Professor.

Karol

March 31, 2019

To me, all clear - great insight supported with lots of examples. Also, personally, I liked the way it was presented. What I learnt here definitely helped me to get around using SQL. Thanks a lot.

Julie

March 4, 2019

That was the best time and money that I've ever spent. Instructor is a gifted and experienced teacher who explains both the fundamental and more advanced concepts in a clear and concise manner. All the videos are less than 7 minutes and keep your momentum going. He included tips on how to use SQL Server 2012. Very satisfied. I only wish that I had found this course sooner.

Chengchieh

February 25, 2019

It is a very good summery about the Microsoft 70-461 Test. It helps a lot before everybody get into the detail on the books. These videos gave me an idea which part of the test that I should be more focus on.

Charts

Price

Rating

Enrollment distribution

Microsoft SQL Server 2012 Certification Training Exam 70-461 - Distribution chart

Microsoft SQL Server 2012 Certification Training Exam 70-461

What you will learn

To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE

Why take this course?

Content

Introduction

Course Setup

SQL Server 2012 Interface

Database Objects And Data

Working With Tables

SQL Query Basics

The Basic SELECT Statement

Advanced SELECT Statements

Using Joins

Modifying Data

Using Subqueries

Advanced Table Utilization

Programmability

Triggers

Transactions In T-SQL

Under The Hood

Working With XML

Optimizing Queries

Taking The Exam

Conclusion

Reviews

Charts

Price

Rating

Enrollment distribution

Related Topics