Microsoft Sql Server 2012 Certification 70 461

  1. Home
  2. Sql-server
  3. Microsoft Sql Server 2012 Certification 70 461

Tags: SQL Server

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

Last updated 2022-01-10 | 4.7

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

What you'll learn

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

* 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 this course is for:

  • IT Professionals who wish to gain Microsoft Certification

Course content

20 sections • 148 lectures

Introduction 7 lectures

Important - Download These First - Working Files Preview 00:01

What To expect From This Course Preview 02:07

Course Overview Preview 03:44

Understanding Databases Preview 06:44

Transact-SQL Basics Preview 04:22

Microsoft SQL Certification Preview 05:03

How To Access Your Working Files Preview 02:45

Course Setup 8 lectures

SQL Server 2012 Evaluation Preview 04:38

SQL Server 2012 Installation Preview 06:05

Windows 8 Server 2012 Interface Preview 02:57

Windows 7 Interface Preview 03:19

SQL Server Sample Database Preview 04:47

Attaching The Sample Database Preview 05:21

Getting Help Preview 05:26

Installing SQL Books Online Preview 06:45

SQL Server 2012 Interface 8 lectures

Management Studio Basics Preview 06:13

Connecting To SQL Server Preview 04:09

Customizing SSMS Preview 06:04

Utilizing Diagrams Preview 05:34

Saving Diagrams Preview 03:07

Text And Graphical Tools Preview 04:26

Using Sample Code Files Preview 03:22

About the Semicolon Preview 03:07

Database Objects And Data 11 lectures

0401 What Are Objects? Preview 03:44

0402 Understanding Tables Preview 05:16

0403 Understanding Data Integrity Preview 04:01

0404 Understanding Data Types Preview 06:06

0405 Understanding Primary Keys Preview 03:52

0406 Understanding Constraints Preview 05:05

0407 Understanding NULL Preview 05:10

0408 Understanding Views Preview 05:43

0409 Understanding Stored Procedures Preview 05:30

0410 Understanding Triggers Preview 03:16

0411 Understanding Synonyms Preview 06:10

Working With Tables 7 lectures

0501 Creating A Table Preview 06:22

0502 Graphical Table Creation Preview 04:07

0503 Changing A Table Preview 05:48

0504 Graphical Table Alterations Preview 05:53

0505 Deleting A Table Preview 05:43

0506 Graphical Table Deletion Preview 03:22

0507 Creating A Primary Key Preview 05:40

SQL Query Basics 7 lectures

0601 Four Basic Queries Preview 04:55

0602 Thinking In SQL Preview 06:08

0603 Options And More Options Preview 06:03

0604 Good Query Structure Preview 06:03

0605 Comments Preview 05:09

0606 The USE Command Preview 02:34

0607 The GO Command Preview 04:11

The Basic SELECT Statement 7 lectures

0701 SELECT Basics Preview 03:56

0702 SELECT Structure Preview 05:01

0703 Using WHERE Preview 04:35

0704 Using TOP To Limit Rows Preview 05:02

0705 Ordering Results Preview 06:41

0706 Working With NULLs Preview 04:39

0707 T-SQL Concatenation Preview 04:28

Advanced SELECT Statements 17 lectures

0801 Column Aliasing Preview 04:35

0802 Using DISTINCT Preview 05:38

0803 Using SUM Preview 05:36

0804 Using AVG Preview 04:32

0805 Using COUNT Preview 05:16

0806 Using Group By Preview 05:58

0807 Using HAVING Preview 04:30

0808 SELECT INTO Preview 05:11

0809 Using LIKE And IN Preview 06:20

0810 Understanding UNION Preview 06:16

0811 INTERSECT And EXCEPT Preview 05:44

0812 Using Synonyms - Part 1 Preview 04:41

0813 Using Synonyms - Part 2 Preview 03:47

0814 Offset-Fetch Preview 05:26

0815 What Is Ranking? Preview 05:42

0816 Using Ranking Preview 05:32

0817 More Ranking Examples Preview 06:33

Using Joins 7 lectures

0901 Understanding Joins Preview 06:12

0902 Join Query Structure Preview 06:20

0903 Creating Inner Joins - Part 1 Preview 05:37

0904 Creating Inner Joins - Part 2 Preview 04:15

0905 Join Creation Through GUI Preview 05:40

0906 Creating Outer Joins Preview 05:37

0907 Creating Cross Joins Preview 04:48

Modifying Data 8 lectures

1001 The INSERT Statement Preview 06:07

1002 Using INSERT - Part 1 Preview 05:54

1003 Using INSERT - Part 2 Preview 04:33

1004 The UPDATE Statement Preview 05:37

1005 Using UPDATE Preview 05:13

1006 The DELETE Statement Preview 03:31

1007 Using DELETE - Part 1 Preview 05:42

1008 Using DELETE - Part 2 Preview 03:32

Using Subqueries 5 lectures

1101 Understanding Subqueries Preview 05:40

1102 Subquery Versus Join Preview 04:26

1103 Creating A Scalar Subquery Preview 03:30

1104 Creating A Multi-Valued Subquery Preview 04:12

1105 Creating A Correlated Subquery Preview 05:45

Advanced Table Utilization 7 lectures

1201 Utilizing Memory Preview 02:47

1202 What Is A Derived Table? Preview 06:38

1203 Creating A Derived Table Preview 05:58

1204 Table Variables - Part 1 Preview 05:52

1205 Table Variables - Part 2 Preview 05:56

1206 Common Table Expressions Preview 05:05

1207 Temporary Tables Preview 05:59

Programmability 21 lectures

1301 Programmability In T-SQL Preview 04:12

1302 What Is A Stored Procedure? Preview 05:03

1303 Why Use Stored Procedures? Preview 04:46

1304 A Simple Stored Procedure Preview 04:50

1305 Input Parameters Preview 05:06

1306 Multiple Input Parameters Preview 03:42

1307 Output Parameters - Part 1 Preview 05:59

1308 Output Parameters - Part 2 Preview 05:16

1309 Using Case Logic - Part 1 Preview 05:07

1310 Using Case Logic - Part 2 Preview 04:54

1311 Handling Errors Preview 06:02

1312 Stored Procedure Security Preview 04:46

1313 Working With Functions Preview 03:42

1314 Using Built-In Functions Preview 04:10

1315 Creating A Scalar Function Preview 05:00

1316 Creating A Table Valued Function Preview 04:29

1317 What Is Dynamic SQL? Preview 03:17

1318 Dynamic SQL Example Preview 04:53

1319 Understanding GUIDs Preview 05:41

1320 GUID Examples - Part 1 Preview 03:35

1321 GUID Examples - Part 2 Preview 04:50

Triggers 4 lectures

1401 Using Triggers Preview 04:58

1402 Inserted And Deleted Tables Preview 03:29

1403 Trigger Examples - Part 1 Preview 05:32

1404 Trigger Examples - Part 2 Preview 05:18

Transactions In T-SQL 5 lectures

1501 What Are Transactions? Preview 05:11

1502 Understanding Concurrency Preview 06:36

1503 Explicit And Implicit Transactions Preview 04:08

1504 Cross Platform Concerns Preview 03:22

1505 Transaction And Locking Example Preview 06:16

Under The Hood 4 lectures

1601 Using Metadata Preview 04:37

1602 Using Catalog Views Preview 06:06

1603 Using Information Schema Views Preview 05:05

1604 Using System Stored Procedures Preview 04:48

Working With XML 5 lectures

1701 XML Basics Preview 05:59

1702 Outputting XML From Queries Preview 04:51

1703 Using FOR XML RAW Preview 06:34

1704 Using FOR XML AUTO Preview 06:18

1705 Using FOR XML PATH Preview 06:38

Optimizing Queries 6 lectures

1801 Optimization Basics Preview 06:11

1802 Query Execution Plans - Part 1 Preview 04:36

1803 Query Execution Plans - Part 2 Preview 06:18

1804 SQL Server Extended Events - Part 1 Preview 03:01

1805 SQL Server Extended Events - Part 2 Preview 06:22

1806 SQL Server Profiler Preview 05:16

Taking The Exam 3 lectures

1901 Exam Basics Preview 05:38

1902 Taking Your Exam Preview 06:32

1903 When It Is Over Preview 04:55

Conclusion 1 lectures

2001 Wrap-Up Preview 03:35