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.5 (919 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.
7,716 students enrolled Bestselling in SQL Server
$19
$50
62% off
Take This Course
  • Lectures 148
  • Length 12.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2013 English Closed captions available

Course 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.

What are the requirements?

  • A Desire To Learn

What am I going to get from this course?

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

What is the target audience?

  • IT Professionals who wish to gain Microsoft Certification

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Important - Download These First - Working Files
Preview
Article
What To expect From This Course
Preview
02:07
Course Overview
Preview
03:44
Understanding Databases
Preview
06:44
Transact-SQL Basics
04:22
Microsoft SQL Certification
05:03
How To Access Your Working Files
02:45
Section 2: Course Setup
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
Section 3: SQL Server 2012 Interface
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
Section 4: Database Objects And Data
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
Section 5: Working With Tables
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
Section 6: SQL Query Basics
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
Section 7: The Basic SELECT Statement
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
Section 8: Advanced SELECT Statements
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
Section 9: Using Joins
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
Section 10: Modifying Data
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
Section 11: Using Subqueries
1101 Understanding Subqueries
05:40
1102 Subquery Versus Join
04:26

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, 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.

Ready to start learning?
Take This Course