Querying Microsoft SQL Server 2012 (Exam 70-461)

Video Description

The 2012 Microsoft MCSA Certification track includes Exam 70-461 Querying Microsoft SQL Server 2012. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This VTC course is intended for SQL Server database administrators, implementers, system engineers, and developers who are preparing to take the 70-461 exam as well as those who are just beginning to learn Transact-SQL. Mark Long is the instructor and will take you through the various tools and concepts needed to help you get ready for the 70-461 exam.

Table of Contents

  1. Introduction
    1. Welcome 00:01:11
    2. Course Overview 00:03:35
    3. Understanding SQL 00:04:22
    4. Understanding TSQL 00:03:21
    5. SQL Server History 00:04:49
    6. Microsoft SQL Server Certifications 00:02:51
  2. Getting Set Up
    1. Getting SQL Server 2012 00:03:36
    2. Installing SQL Server 2012 00:05:42
    3. Attaching the Sample Database 00:04:04
    4. Getting SQL Books Online Locally 00:03:34
    5. Code Examples 00:01:41
  3. SQL Server 2012 Management Studio
    1. SSMS Tour 00:06:09
    2. Graphical Queries 00:05:10
    3. SSMS Options 00:04:38
    4. Query Results Options 00:03:12
    5. Database Diagrams 00:05:18
  4. Creating Database Objects
    1. Table Design Basics 00:03:54
    2. Creating a Table 00:05:41
    3. Altering Tables 00:06:09
    4. Dropping Tables 00:04:21
    5. Understanding Views 00:04:24
    6. Creating Views pt. 1 00:04:44
    7. Creating Views pt. 2 00:06:12
    8. Dropping Views 00:02:40
    9. Understanding Constraints 00:05:17
    10. Creating Constraints 00:05:07
    11. Understanding Triggers 00:05:00
    12. Trigger Options 00:04:04
    13. Inserted and Deleted Tables 00:02:55
    14. Creating Triggers 00:05:40
  5. Basic Select Queries
    1. The Basic Select Statement 00:06:43
    2. Select Statement Structure 00:03:56
    3. The FROM Clause 00:03:27
    4. The WHERE Clause 00:04:23
    5. WHERE Clause Example 00:04:32
    6. The ORDER BY Clause 00:03:55
    7. ORDER BY Example 00:05:22
    8. The GROUP BY Clause pt. 1 00:05:56
    9. The GROUP BY Clause pt. 2 00:05:46
    10. The HAVING Clause 00:05:42
    11. The Power of LIKE 00:04:03
  6. More Advanced Select Statements
    1. Using Distinct 00:04:44
    2. Column Aliasing 00:05:34
    3. Using the Top Option 00:04:02
    4. Top Option Example 00:05:01
    5. Using the OFFSET-FETCH Option 00:05:02
    6. Understanding NULLs 00:05:24
    7. Working with NULLs 00:03:42
    8. Using the Case Statement 00:05:29
    9. SELECT INTO 00:03:27
    10. The UNION Statement 00:05:56
    11. Using INTERSECT 00:05:23
    12. Using EXCEPT 00:06:18
    13. Understanding Synonyms 00:03:21
    14. Creating and Using Synonyms 00:02:38
    15. Using Concatenation 00:04:00
    16. Dynamic Queries pt. 1 00:04:49
    17. Dynamic Queries pt. 2 00:05:55
    18. INSERT Into 00:04:09
  7. SQL Server 2012 Data Types
    1. Understanding GUIDs 00:05:50
    2. NEWID() vs. NEWSEQUENTTIALID() 00:05:09
    3. Using GUIDs 00:05:13
    4. Data Type Basics 00:05:44
    5. Numerical Data Types 00:04:50
    6. Character Data Types 00:04:49
    7. Date and Time Data Types 00:04:06
    8. Binary Data Types 00:03:02
  8. Using Joins
    1. Understanding Joins 00:03:58
    2. Table Aliasing 00:02:42
    3. Inner Joins 00:06:46
    4. Outer Joins 00:04:41
    5. Cross Joins 00:04:28
    6. The Merge Statement pt. 1 00:05:36
    7. The Merge Statement pt. 2 00:05:07
  9. Querying Metadata
    1. Catalog Views 00:05:55
    2. Information Schema Views 00:04:12
    3. System Stored Procedures 00:05:06
  10. Inserts / Updates / Deletes
    1. The Basic INSERT Statement 00:03:17
    2. INSERT Examples 00:05:17
    3. The Basic UPDATE Statement 00:02:39
    4. UPDATE Examples 00:04:42
    5. The Basic DELETE Statement 00:02:53
    6. DELETE Examples 00:03:39
    7. Using @@ROWCOUNT 00:05:03
  11. Subqueries
    1. Scalar Subqueries 00:03:42
    2. Multi-Valued Subqueries 00:04:23
    3. Correlated Subqueries 00:05:16
  12. Table Expressions
    1. Understanding Temporary Results Sets 00:03:21
    2. Understanding Derived Tables 00:04:22
    3. Understanding Common Table Expressions 00:02:43
    4. Using CTEs 00:04:15
    5. Understanding Temporary Tables 00:04:32
    6. Table Variables 00:05:29
    7. Temporary Table or Table Variable? 00:02:48
  13. Stored Procedures
    1. Understanding Stored Procedures 00:04:14
    2. Creating a Stored Procedure 00:04:10
    3. Using Input Parameters 00:05:33
    4. Stored Procedure Return Codes 00:04:06
    5. Stored Procedure Permissions 00:02:53
  14. Functions
    1. Understanding Functions 00:03:40
    2. Built-in Functions 00:04:13
    3. Scalar Functions Example 00:05:30
    4. Table Valued Functions Example pt. 1 00:05:30
    5. Table Valued Functions Example pt. 2 00:04:51
  15. Transactions
    1. Understanding Concurrency 00:03:52
    2. Understanding Transactions 00:04:36
    3. Coding Explicit Transactions 00:04:44
    4. Transactions and Locking 00:04:30
  16. Conclusion
    1. Course Wrap Up 00:03:13
  17. Credits
    1. About the Author 00:02:39

Product Information

  • Title: Querying Microsoft SQL Server 2012 (Exam 70-461)
  • Author(s): VTC
  • Release date: January 2017
  • Publisher(s): Virtual Training Company, Inc.
  • ISBN: 9781618660701