Save for later

Microsoft SQL Server 2012 Certification Training Exam 70-461

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.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Udemy and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating 4.4 based on 789 ratings
Length 12.5 total hours
Starts On Demand (Start anytime)
Cost $15
From Udemy
Instructor Infinite Skills
Download Videos Only via the Udemy mobile app
Language English
Subjects Data Science Programming
Tags Databases Development Database Design & Development

Get a Reminder

Send to:

Similar Courses

What people are saying

easy to understand

Thank you Good and very much easy to understand... :-) This is very good course for someone who is really interested in knowing SQL from Basis to Advanced.

Good classes Great learning experience Keeps you up on your toes and excited with easy to understand language.

Very useful, thank you very much for providing a way to prepare for Microsoft exams that are easy to understand That was the best time and money that I've ever spent.

Easy to understand.

I do think it is not enough to pass the 70-461 exam on its own, but the instructor was fantastic, easy to understand and talked at a perfect pace.

It is easy to understand and follow the online course!

He did a good job of explaining the topics and making it easy to understand.

Easy to understand with concrete examples from the sample database.

It is easy to understand each concept.

Instructor is pleasant, easy to understand and engaging.

Every area is very thorough and easy to understand.

Course is great, short videos that are to the point and really easy to understand Good lectures, but they are all lectures, what about sample quizzes or test questions to pass the section?

The lecture is good, well structured and very easy to understand for beginners.

A really amazing course, it doesn't matter if you are an expert on SQL server or if it is the first time you use it (like me), the way is explained is easy to understand but never getting to be so easy that's boring.

Read more

so far so good

So far so good.

So far so good, just that i feel there should be more examples on a topic.

So far so good - Clear Instruction The instructor gave a very detail instruction for every step.

Nice So far so good :) very good Great introductory course for SQL especially getting one of your first certifications!

So far so good Loving the information thus far!

so far so good So Far lectures is easy to follow.

great explanations Por el momento esta bueno So far so good 5 start course impressivw Helping me understand the history and why things are nice Interesting discussions.

Read more

step by step

Great step by step, very informative and well planned course lecture material, really enjoyed it.

This is absolutely for a beginner who does not have any experience with Tsql Great step by step, easy to understand.

The course help me through the step by step demo to prepare the exam.

the sound is good and quality also good and shown step by step -wait to see what happen in the next materials ya really good -and I love it - I plan to take the exam Great!

Goes step by step, and can even initiate someone who has never touched a database before.

Great instructor who takes you step by step.

This is a great course, really keeping the concepts simple easy to understand it was fun learning Step by step, clear Instructions.

Clear and easy to follow i like the way that he gives explanations step by step.

Read more

clear and concise

Instructor is a gifted and experienced teacher who explains both the fundamental and more advanced concepts in a clear and concise manner.

The lecturer is clear and concise, with only a small amount of regionalism in his voice.

Explains everything thoroughly,in a clear and concise manner.

Concepts explained in a clear and concise way the lectures are ok, but the course is long and there's no opportunity to practice so I end up falling asleep!

Its a great overview preparation for the SQL exam He is so CLEAR and CONCISE.

very clear and concise.

Clear and concise.

Read more

books online

I was hoping the course would give me insight into all the topics needed to pass the exam, but often I found myself to be referred to Books Online and some topics were skipped.

Very easy to listen to and I am confident that combined with practice and homework (reading books online) that I will pass this exam!

Work the examples and read SQL Books Online!

It does not cover the advance but you can easily learn this by rading books online.

However, if you're trying to use this course as actual exam prep, you'd probably be better suited just looking up the objectives and reading about them in SQL Books online, as is suggested many times throughout this course.

There was a lot of "go look at Books Online".

While the content is valuable, don't expect anyone to answer your questions (except for a fellow student) since Infinite Skills is now part of Safari Books Online (www.safaribooksonline.com).

However, in order to really pass the exam, you will need follow the instructors recommendation of practicing and reading more on the topics on books online.

Die mitgelieferten Dokumente sind lediglich Ausdruck aus Books Online: Das ist doch recht schwach.

Read more

sense of humor

Good sense of humor and very encouraging.

He made everything very easy to understand and has a great sense of humor.

Explanation is perfect and the tutor got some good sense of humor.

Very exhaustive, well explained and a nice sense of humor to match!

Read more

management studio

What I have learned is that I should study and code using Server Management Studio.

This course explains a good deal about all important areas of the SQL Server Management Studio.

Good use of management studio as well as T-SQL code, excellent resources and references to MS Sites and pdfs Good course.

The course covers the topics in great depth, and mentions features of SQL Server Management Studio which even I hadn't acknowledged before.

I would like to see more performance and syntax tips, maybe a section on Management Studio.

Constantly wastes lesson time referring back to how to open management studio after you're more than halfway through the course.

Constantly referring to massive PDF documents that are available for free in SQL management studio anyway.

There are some good tips on how to use the MSS Management Studio that I did not know and are good productivity tips.

Read more

follow along

In-depth explanations and lots of examples to follow along.

I would follow along and had to pause the video sometimes to catch up.

A total beginner can follow along till the end.

I think this course Good refreshing course....lots of knowledge to gain Really easy to follow along.

Very informative and easy to follow along Very clear and easy to follow.

Very good course Easy to follow along clear, thorough, useful I like the video easy to understand and clear voice thanx Fair amount of basic knowledge to users that havent used SQL before Hasta el momento el nivel es muy básico y tiene cosas de mas demasiado obvias.

Read more

better understanding

This gave me a better understanding of the topic.

It has helped me get a better understanding for SQL programming.

However, the course is way too basic for the 70-461 exam and the instructor often points out that a real exam preparation course would need to take somewhat about 3 weeks.. Why not to create a longer one then to help students get a better understanding of SQL Server?

Excellent teaching in very simple way for better understanding complicated material.

Proivdes you with a better understanding of how to use the program.

The tutor himself says (too) often that you should google the subject yourself for better understanding... (so why did I enrolled and pay for the course?).

Read more

training kit

I suggest using this as a reference and getting a book or two: "Microsoft SQL Server 2012 T-SQL Fundamentals by Itzik Ben-Gan" and "Querying Microsoft SQL Server Training Kit".

I prepared for the 70-461 Exam mostly using the MS Training kit book and these videos.

People with minimal experience who are after passing this exam will need to use the 70-461 Microsoft Training Kit in conjunction with exam prep material, with courses like these, to give themselves the best chance at passing this tough exam and it is tough!

This will make the Microsoft 70-461 Training Kit less dry and more digestible.

Muy claro el curso, sería bueno que tuviera ejercicios Good review for Certification test it was ok. and the topics were not covered in depth Good explanation with examples This course was a welcome companion to the official Training Kit which is extremely dry and hard to follow in places.

Read more

mark long

Mark Long is very knowledgeable.

Instructor Mark Long is really good with explanations and content delivery.

If the exam is not much more complicated than what Mark Long makes it appear over here, I'll be fine.

I have enjoyed Mark Long's videos in the past and I am looking forward to completing this class.

Pro -He explains in a very simple and eficient way Cons - The need of a subtitle =) Mark Long is the best, he makes understanding easy!!!!

Read more

real world

Mark does a great job of going through real world examples and explanations.

Some of the lessons did drag a bit, and there weren't as many examples of real world application of the skills - especially in the last few chapters.

I also feel that Mark has real world experience with databases, and isn't just reading to me from a textbook.

I have learnt so much and feeling confident in using this in the real world.

Read more

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

SQL Server Administrator $77k

IT Conslutant - SQL Server $83k

SQL Server/Oracle DBA $95k

SQL Server Instructor $95k

PHP and SQL Server Developer $103k

SQL Server | BI SQL Server developer $108k

Microsoft SQL Server Developer $109k

Database Administrator SQL Server $115k

SQL Server DBA 5 $122k

SQL Server Architect $138k

SQL Server MVP 5 $156k

SQL Server MVP 3 $163k

Write a review

Your opinion matters. Tell us what you think.

Rating 4.4 based on 789 ratings
Length 12.5 total hours
Starts On Demand (Start anytime)
Cost $15
From Udemy
Instructor Infinite Skills
Download Videos Only via the Udemy mobile app
Language English
Subjects Data Science Programming
Tags Databases Development Database Design & Development

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now