Microsoft SQL Server 2012 Certification Training Exam 70-461
4.5 (1,421 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9,759 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft SQL Server 2012 Certification Training Exam 70-461 to your Wishlist.

Add to Wishlist

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
Bestselling
4.5 (1,421 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9,759 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 12.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE
View Curriculum
Requirements
  • A Desire To Learn
Description

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.

Who is the target audience?
  • IT Professionals who wish to gain Microsoft Certification
Students Who Viewed This Course Also Viewed
Curriculum For This Course
148 Lectures
12:19:32
+
Introduction
7 Lectures 24:46




Transact-SQL Basics
04:22

Microsoft SQL Certification
05:03

How To Access Your Working Files
02:45
+
Course Setup
8 Lectures 39:18
SQL Server 2012 Evaluation
04:38

SQL Server 2012 Installation
06:05

Windows 8 Server 2012 Interface
02:57

Windows 7 Interface
03:19

SQL Server Sample Database
04:47

Attaching The Sample Database
05:21

Getting Help
05:26

Installing SQL Books Online
06:45
+
SQL Server 2012 Interface
8 Lectures 36:02
Management Studio Basics
06:13

Connecting To SQL Server
04:09

Customizing SSMS
06:04

Utilizing Diagrams
05:34

Saving Diagrams
03:07

Text And Graphical Tools
04:26

Using Sample Code Files
03:22

About the Semicolon
03:07
+
Database Objects And Data
11 Lectures 53:53
0401 What Are Objects?
03:44

0402 Understanding Tables
05:16

0403 Understanding Data Integrity
04:01

0404 Understanding Data Types
06:06

0405 Understanding Primary Keys
03:52

0406 Understanding Constraints
05:05

0407 Understanding NULL
05:10

0408 Understanding Views
05:43

0409 Understanding Stored Procedures
05:30

0410 Understanding Triggers
03:16

0411 Understanding Synonyms
06:10
+
Working With Tables
7 Lectures 36:55
0501 Creating A Table
06:22

0502 Graphical Table Creation
04:07

0503 Changing A Table
05:48

0504 Graphical Table Alterations
05:53

0505 Deleting A Table
05:43

0506 Graphical Table Deletion
03:22

0507 Creating A Primary Key
05:40
+
SQL Query Basics
7 Lectures 35:03
0601 Four Basic Queries
04:55

0602 Thinking In SQL
06:08

0603 Options And More Options
06:03

0604 Good Query Structure
06:03

0605 Comments
05:09

0606 The USE Command
02:34

0607 The GO Command
04:11
+
The Basic SELECT Statement
7 Lectures 34:22
0701 SELECT Basics
03:56

0702 SELECT Structure
05:01

0703 Using WHERE
04:35

0704 Using TOP To Limit Rows
05:02

0705 Ordering Results
06:41

0706 Working With NULLs
04:39

0707 T-SQL Concatenation
04:28
+
Advanced SELECT Statements
17 Lectures 01:31:17
0801 Column Aliasing
04:35

0802 Using DISTINCT
05:38

0803 Using SUM
05:36

0804 Using AVG
04:32

0805 Using COUNT
05:16

0806 Using Group By
05:58

0807 Using HAVING
04:30

0808 SELECT INTO
05:11

0809 Using LIKE And IN
06:20

0810 Understanding UNION
06:16

0811 INTERSECT And EXCEPT
05:44

0812 Using Synonyms - Part 1
04:41

0813 Using Synonyms - Part 2
03:47

0814 Offset-Fetch
05:26

0815 What Is Ranking?
05:42

0816 Using Ranking
05:32

0817 More Ranking Examples
06:33
+
Using Joins
7 Lectures 38:29
0901 Understanding Joins
06:12

0902 Join Query Structure
06:20

0903 Creating Inner Joins - Part 1
05:37

0904 Creating Inner Joins - Part 2
04:15

0905 Join Creation Through GUI
05:40

0906 Creating Outer Joins
05:37

0907 Creating Cross Joins
04:48
+
Modifying Data
8 Lectures 40:09
1001 The INSERT Statement
06:07

1002 Using INSERT - Part 1
05:54

1003 Using INSERT - Part 2
04:33

1004 The UPDATE Statement
05:37

1005 Using UPDATE
05:13

1006 The DELETE Statement
03:31

1007 Using DELETE - Part 1
05:42

1008 Using DELETE - Part 2
03:32
10 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
42,474 Reviews
714,159 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.