by | Released December 2013 | ISBN: 9781771371834

In this Microsoft SQL Server 70-461 Exam training course, expert author Mark Long 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.Mark Long 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. Mark 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. Show and hide more Publisher resources Download Example Code

1. Introduction
   • What To Expect From This Course 00:02:07
   • Course Overview 00:03:44
   • Understanding Databases 00:06:44
   • Transact-SQL Basics 00:04:22
   • Microsoft SQL Certification 00:05:03
2. Course Setup
   • SQL Server 2012 Evaluation 00:04:38
   • SQL Server 2012 Installation 00:06:05
   • Windows 8 Server 2012 Interface 00:02:57
   • Windows 7 Interface 00:03:20
   • SQL Server Sample Database 00:04:48
   • Attaching The Sample Database 00:05:21
   • Getting Help 00:05:26
   • Installing SQL Books Online 00:06:46
3. SQL Server 2012 Interface
   • Management Studio Basics 00:06:13
   • Connecting To SQL Server 00:04:09
   • Customizing SSMS 00:06:05
   • Utilizing Diagrams 00:05:34
   • Saving Diagrams 00:03:07
   • Text And Graphical Tools 00:04:26
   • Using Sample Code Files 00:03:23
   • About The Semicolon 00:03:07
4. Database Objects And Data
   • What Are Objects? 00:03:44
   • Understanding Tables 00:05:16
   • Understanding Data Integrity 00:04:02
   • Understanding Data Types 00:06:07
   • Understanding Primary Keys 00:03:52
   • Understanding Constraints 00:05:06
   • Understanding NULL 00:05:10
   • Understanding Views 00:05:44
   • Understanding Stored Procedures 00:05:31
   • Understanding Triggers 00:03:16
   • Understanding Synonyms 00:06:10
5. Working With Tables
   • Creating A Table 00:06:22
   • Graphical Table Creation 00:04:08
   • Changing A Table 00:05:49
   • Graphical Table Alterations 00:05:53
   • Deleting A Table 00:05:43
   • Graphical Table Deletion 00:03:22
   • Creating A Primary Key 00:05:40
6. SQL Query Basics
   • Four Basic Queries 00:04:56
   • Thinking In SQL 00:06:09
   • Options And More Options 00:06:03
   • Good Query Structure 00:06:03
   • Comments 00:05:10
   • The USE Command 00:02:35
   • The GO Command 00:04:11
7. The Basic SELECT Statement
   • SELECT Basics 00:03:56
   • SELECT Structure 00:05:01
   • Using WHERE 00:04:35
   • Using TOP To Limit Rows 00:05:02
   • Ordering Results 00:06:42
   • Working With NULLs 00:04:39
   • T-SQL Concatenation 00:04:28
8. Advanced SELECT Statements
   • Column Aliasing 00:04:36
   • Using DISTINCT 00:05:38
   • Using SUM 00:05:36
   • Using AVG 00:04:32
   • Using COUNT 00:05:16
   • Using Group By 00:05:58
   • Using HAVING 00:04:31
   • SELECT INTO 00:05:11
   • Using LIKE And IN 00:06:21
   • Understanding UNION 00:06:16
   • INTERSECT And EXCEPT 00:05:44
   • Using Synonyms - Part 1 00:04:41
   • Using Synonyms - Part 2 00:03:47
   • Offset-Fetch 00:05:26
   • What Is Ranking? 00:05:43
   • Using Ranking 00:05:33
   • More Ranking Examples 00:06:34
9. Using Joins
   • Understanding Joins 00:06:13
   • Join Query Structure 00:06:21
   • Creating Inner Joins - Part 1 00:05:38
   • Creating Inner Joins - Part 2 00:04:15
   • Join Creation Through GUI 00:05:40
   • Creating Outer Joins 00:05:37
   • Creating Cross Joins 00:04:48
10. Modifying Data
    • The INSERT Statement 00:06:07
    • Using INSERT - Part 1 00:05:55
    • Using INSERT - Part 2 00:04:33
    • The UPDATE Statement 00:05:38
    • Using UPDATE 00:05:13
    • The DELETE Statement 00:03:32
    • Using DELETE - Part 1 00:05:42
    • Using DELETE - Part 2 00:03:32
11. Using Subqueries
    • Understanding Subqueries 00:05:41
    • Subquery Versus Join 00:04:26
    • Creating A Scalar Subquery 00:03:31
    • Creating A Multi-Valued Subquery 00:04:12
    • Creating A Correlated Subquery 00:05:45
12. Advanced Table Utilization
    • Utilizing Memory 00:02:47
    • What Is A Derived Table? 00:06:38
    • Creating A Derived Table 00:05:59
    • Table Variables - Part 1 00:05:52
    • Table Variables - Part 2 00:05:56
    • Common Table Expressions 00:05:06
    • Temporary Tables 00:06:00
13. Programmability
    • Programmability In T-SQL 00:04:13
    • What Is A Stored Procedure? 00:05:04
    • Why Use Stored Procedures? 00:04:46
    • A Simple Stored Procedure 00:04:50
    • Input Parameters 00:05:06
    • Multiple Input Parameters 00:03:43
    • Output Parameters - Part 1 00:05:59
    • Output Parameters - Part 2 00:05:16
    • Using Case Logic - Part 1 00:05:08
    • Using Case Logic - Part 2 00:04:54
    • Handling Errors 00:06:02
    • Stored Procedure Security 00:04:46
    • Working With Functions 00:03:42
    • Using Built-In Functions 00:04:10
    • Creating A Scalar Function 00:05:00
    • Creating A Table Valued Function 00:04:29
    • What Is Dynamic SQL? 00:03:17
    • Dynamic SQL Example 00:04:53
    • Understanding GUIDs 00:05:41
    • GUID Examples - Part 1 00:03:36
    • GUID Examples - Part 2 00:04:51
14. Triggers
    • Using Triggers 00:04:58
    • Inserted And Deleted Tables 00:03:29
    • Trigger Examples - Part 1 00:05:33
    • Trigger Examples - Part 2 00:05:19
15. Transactions In T-SQL
    • What Are Transactions? 00:05:11
    • Understanding Concurrency 00:06:36
    • Explicit And Implicit Transactions 00:04:08
    • Cross Platform Concerns 00:03:22
    • Transaction And Locking Example 00:06:16
16. Under The Hood
    • Using Metadata 00:04:37
    • Using Catalog Views 00:06:06
    • Using Information Schema Views 00:05:05
    • Using System Stored Procedures 00:04:49
17. Working With XML
    • XML Basic 00:06:00
    • Outputting XML From Queries 00:04:51
    • Using FOR XML RAW 00:06:34
    • Using FOR XML AUTO 00:06:18
    • Using FOR XML PATH 00:06:39
18. Optimizing Queries
    • Optimization Basics 00:06:11
    • Query Execution Plans - Part 1 00:04:37
    • Query Execution Plans - Part 2 00:06:18
    • SQL Server Extended Events - Part 1 00:03:01
    • SQL Server Extended Events - Part 2 00:06:23
    • SQL Server Profiler 00:05:17
19. Taking The Exam
    • Exam Basics 00:05:39
    • Taking Your Exam 00:06:32
    • When It Is Over 00:04:55
20. Conclusion
    • Wrap-Up 00:03:36
    • About The Author 00:02:51
Show and hide more