on-demand course

MCSA Querying Microsoft SQL Server 2012 (Exam 70-461): Required Knowledge for SQL Server 2012 and 2014

with Marilyn White

December 2014

Advanced

11h 37m

English

Pearson

Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)

Watch now

Unlock full access

Includes

Earns Badge

Course outline

MCSA Querying Microsoft SQL Server 2012 (Exam 70-461) LiveLessons: Introduction
8m 50s
Create Database Objects
36s
Learning Objectives
26s
1.1 Creating Tables Using the CREATE Statement
5m 23s
1.2 Specifying Schema in Database, Table, and Column Names
4m 13s
1.3 Choosing Column Data Types
12m 26s
1.4 Altering Tables and Columns
4m 40s
1.5 Dropping Tables
2m 21s
1.6 Demo – Examining the Syntax of the CREATE TABLE Statement and Comparing with a Sample
11m 57s
1.7 Demo – Best Practices in Naming Tables and Columns
2m 55s
1.8 Demo – Guideline Samples for Selecting Column Types
5m 15s
1.9 Demo – Using ALTER TABLE to Add and Modify Columns
3m 11s
1.10 Demo – Using DROP TABLE and Noting Consequences
1m 13s
Learning Objectives
26s
2.1 Analyzing the CREATE VIEW Statement and Options
6m 8s
2.2 Demo – Comparing the CREATE VIEW Syntax with a Sample VIEW Statement and Options
3m 13s
2.3 Creating and Implementing Indexed Views
4m 41s
2.4 Using ALTER VIEW and DROP VIEW
2m 53s
2.5 Using a View to Modify Data
2m 27s
2.6 Demo – Altering a View Using ORDER BY
4m 23s
2.7 Demo – Updating a Table Using a View
4m 5s
Learning Objective
30s
3.1 Creating a Primary Key Constraint
6m 13s
3.2 Demo – Defining a Primary Key Constraint Using CREATE TABLE and ALTER TABLE
1m 43s
3.3 Defining and Creating Unique Constraints
3m 5s
3.4 Defining and Creating Foreign Key Constraints
5m 58s
3.5 Defining and Creating Check Constraints
3m 14s
3.6 Defining and Creating Default Constraints
4m 4s
3.7 Demo – Working with Constraints to Enforce Data Integrity
4m 14s
Learning Objectives
26s
4.1 Using DML Triggers
6m 28s
4.2 Creating and Using AFTER Triggers
5m 2s
4.3 Demo - Using AFTER Trigger
4m 27s
4.4 Defining Nested AFTER Triggers
1m 57s
4.5 Creating and Using INSTEAD OF triggers
3m 37s
4.6 Using Trigger Update Functions
1m 53s
4.7 Handling Multiple Rows in a Session
2m 25s
4.8 Understanding the Performance Implications of Triggers
2m 37s
4.9 Demo - Understanding Inserted and Deleted Tables When Using an AFTER Trigger
4m 33s
Work With Data
38s
Learning Objectives
36s
5.1 Creating Queries That Filter Data Using Predicates
4m 3s
5.2 Creating Queries to Correctly Handle NULLs
1m 41s
5.3 Writing Queries That Combine Predicates
3m 58s
5.4 Demo - Reviewing Non-Efficient and Efficient Sample Queries
5m 57s
5.5 Controlling the Order of the Query Result Using Best Practices
2m 30s
5.6 Demo - Using ORDER BY, DISTINCT, and Aliases
5m 10s
5.7 Creating Deterministic Query Results
2m 14s
5.8 Ranking Query Results Using TOP(x) and OFFSET – FETCH
2m 29s
5.9 Demo - Using TOP(x) and OFFSET – FETCH to Filter Data
3m 59s
5.10 Using Joins to Query Data over Multiple Tables
7m 37s
5.11 Writing Complex Queries – Joins versus Derived Tables
4m 33s
5.12 Demo - Using Joins to Access Data
7m 42s
5.13 Accessing Data Using CASE, COALESCE, and ISNULL
4m 36s
5.14 Using Statements That Load a Table – INSERT VALUES, INSERT SELECT, INSERT EXEC, and SELECT INTO
5m 30s
5.15 Demo - Using Statements That Load or Create Tables
7m 22s
Learning Objectives
33s
6.1 Using Self-Contained and Correlated Subqueries
5m 2s
6.2 Using Table Expressions – Derived Tables and Common Table Expressions (CTEs)
5m 0s
6.3 Using the APPLY Operator
3m 37s
6.4 Demo – Using Subqueries and Table Expressions in Queries
3m 46s
6.5 Pivoting and Unpivoting Data
6m 20s
6.6 Demo – Using PIVOT and UNPIVOT Operators in Queries
4m 33s
Learning Objectives
31s
7.1 Understanding the Uses and Limitations of Each Data Type
8m 7s
7.2 Using Data Types for Columns and Keys
4m 51s
7.3 Using Numeric Data Types
4m 51s
7.4 Using Date and Time Functions
10m 39s
7.5 Demo - Using Data Types for Columns, Keys, and Dates
10m 42s
7.6 Using Binary String Data Types
5m 2s
7.7 Working with Other Data Types such as Uniqueidentifier and XML
1m 8s
7.8 Demo - Using Binary String and Other Data Types
10m 6s

Content preview from MCSA Querying Microsoft SQL Server 2012 (Exam 70-461): Required Knowledge for SQL Server 2012 and 2014

2.2 Demo – Comparing the CREATE VIEW Syntax with a Sample VIEW Statement and Options

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

SQL Server 70-762: Developing SQL Databases: Required Knowledge for SQL Server 2012 and 2014

Marilyn White

Microsoft SQL Server 2012 Certification - Exam 70-461

Mark Long

Microsoft SQL Server 2014 Unleashed

Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein

Microsoft SQL Server 2012 Certification Training - Exam 70-462

Denny Cherry

Publisher Resources

ISBN: 9780133995473Supplemental Content

MCSA Querying Microsoft SQL Server 2012 (Exam 70-461): Required Knowledge for SQL Server 2012 and 2014

with Marilyn White

Introduction

Module 1: Create Database Objects

Lesson 1: Create and Alter Tables Using T-SQL Syntax

Lesson 2: Design, Create, and Alter Views

Lesson 3: Create and Modify Constraints

Lesson 4: Create and Alter DML Triggers

Module 2: Work With Data

Lesson 5: Query Data by Using SELECT Statements

Lesson 6: Implement Subqueries

Lesson 7:Implement Data Types

Lesson 8: Implement Aggregate Queries

Lesson 9: Query and Manage XML Data

Module 3: Modify Data

Lesson 10: Modify Data by Using INSERT, UPDATE, and DELETE Statements

Lesson 11: Combine Datasets

Lesson 12: Create and Alter Stored Procedures

Lesson 13: Work with Functions

Module 4: Troubleshoot and Optimize

Lesson 14: Optimize Queries

Lesson 15: Manage Transactions

Lesson 16: Evaluate the Use of Row-based Operations vs. Set-Based Operations

Lesson 17: Implement Error Handling

Summary

Content preview from MCSA Querying Microsoft SQL Server 2012 (Exam 70-461): Required Knowledge for SQL Server 2012 and 2014

2.2 Demo – Comparing the CREATE VIEW Syntax with a Sample VIEW Statement and Options

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

SQL Server 70-762: Developing SQL Databases: Required Knowledge for SQL Server 2012 and 2014

Microsoft SQL Server 2012 Certification - Exam 70-461

Microsoft SQL Server 2014 Unleashed

Microsoft SQL Server 2012 Certification Training - Exam 70-462

Publisher Resources

Introduction

Module 1: Create Database Objects

Lesson 1: Create and Alter Tables Using T-SQL Syntax

Lesson 2: Design, Create, and Alter Views

Lesson 3: Create and Modify Constraints

Lesson 4: Create and Alter DML Triggers

Module 2: Work With Data

Lesson 5: Query Data by Using SELECT Statements

Lesson 6: Implement Subqueries

Lesson 7:Implement Data Types

Lesson 8: Implement Aggregate Queries

Lesson 9: Query and Manage XML Data

Module 3: Modify Data

Lesson 10: Modify Data by Using INSERT, UPDATE, and DELETE Statements

Lesson 11: Combine Datasets

Lesson 12: Create and Alter Stored Procedures

Lesson 13: Work with Functions

Module 4: Troubleshoot and Optimize

Lesson 14: Optimize Queries

Lesson 15: Manage Transactions

Lesson 16: Evaluate the Use of Row-based Operations vs. Set-Based Operations

Lesson 17: Implement Error Handling

Summary

Content preview from MCSA Querying Microsoft SQL Server 2012 (Exam 70-461): Required Knowledge for SQL Server 2012 and 2014

2.2 Demo – Comparing the CREATE VIEW Syntax with a Sample VIEW Statement and Options

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

SQL Server 70-762: Developing SQL Databases: Required Knowledge for SQL Server 2012 and 2014

Microsoft SQL Server 2012 Certification - Exam 70-461

Microsoft SQL Server 2014 Unleashed

Microsoft SQL Server 2012 Certification Training - Exam 70-462

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.