O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Querying Microsoft SQL Server 2012 (Exam 70-461)

Video Description

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription 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