4.58 out of 5
4.58
2813 reviews on Udemy

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
Instructor:
Infinite Skills
14,104 students enrolled
English More
To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE

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.

Introduction

1
Important - Download These First - Working Files
2
What To expect From This Course
3
Course Overview
4
Understanding Databases
5
Transact-SQL Basics
6
Microsoft SQL Certification
7
How To Access Your Working Files

Course Setup

1
SQL Server 2012 Evaluation
2
SQL Server 2012 Installation
3
Windows 8 Server 2012 Interface
4
Windows 7 Interface
5
SQL Server Sample Database
6
Attaching The Sample Database
7
Getting Help
8
Installing SQL Books Online

SQL Server 2012 Interface

1
Management Studio Basics
2
Connecting To SQL Server
3
Customizing SSMS
4
Utilizing Diagrams
5
Saving Diagrams
6
Text And Graphical Tools
7
Using Sample Code Files
8
About the Semicolon

Database Objects And Data

1
0401 What Are Objects?
2
0402 Understanding Tables
3
0403 Understanding Data Integrity
4
0404 Understanding Data Types
5
0405 Understanding Primary Keys
6
0406 Understanding Constraints
7
0407 Understanding NULL
8
0408 Understanding Views
9
0409 Understanding Stored Procedures
10
0410 Understanding Triggers
11
0411 Understanding Synonyms

Working With Tables

1
0501 Creating A Table
2
0502 Graphical Table Creation
3
0503 Changing A Table
4
0504 Graphical Table Alterations
5
0505 Deleting A Table
6
0506 Graphical Table Deletion
7
0507 Creating A Primary Key

SQL Query Basics

1
0601 Four Basic Queries
2
0602 Thinking In SQL
3
0603 Options And More Options
4
0604 Good Query Structure
5
0605 Comments
6
0606 The USE Command
7
0607 The GO Command

The Basic SELECT Statement

1
0701 SELECT Basics
2
0702 SELECT Structure
3
0703 Using WHERE
4
0704 Using TOP To Limit Rows
5
0705 Ordering Results
6
0706 Working With NULLs
7
0707 T-SQL Concatenation

Advanced SELECT Statements

1
0801 Column Aliasing
2
0802 Using DISTINCT
3
0803 Using SUM
4
0804 Using AVG
5
0805 Using COUNT
6
0806 Using Group By
7
0807 Using HAVING
8
0808 SELECT INTO
9
0809 Using LIKE And IN
10
0810 Understanding UNION
11
0811 INTERSECT And EXCEPT
12
0812 Using Synonyms - Part 1
13
0813 Using Synonyms - Part 2
14
0814 Offset-Fetch
15
0815 What Is Ranking?
16
0816 Using Ranking
17
0817 More Ranking Examples

Using Joins

1
0901 Understanding Joins
2
0902 Join Query Structure
3
0903 Creating Inner Joins - Part 1
4
0904 Creating Inner Joins - Part 2
5
0905 Join Creation Through GUI
6
0906 Creating Outer Joins
7
0907 Creating Cross Joins

Modifying Data

1
1001 The INSERT Statement
2
1002 Using INSERT - Part 1
3
1003 Using INSERT - Part 2
4
1004 The UPDATE Statement
5
1005 Using UPDATE
6
1006 The DELETE Statement
7
1007 Using DELETE - Part 1
8
1008 Using DELETE - Part 2

Using Subqueries

1
1101 Understanding Subqueries
2
1102 Subquery Versus Join
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.6
4.6 out of 5
2813 Ratings

Detailed Rating

Stars 5
1512
Stars 4
955
Stars 3
267
Stars 2
55
Stars 1
24
acb80f3d11a56c75bf63cc430dfa18df
30-Day Money-Back Guarantee

Includes

12 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion