on-demand course

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

with Marilyn White

July 2018

Beginner to advanced

19h 26m

English

Pearson

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

Watch now

Unlock full access

Includes

Earns Badge

Course outline

SQL Server 70-762: Introduction
7m 10s
Module introduction
1m 39s
Learning objectives
43s
1.1 Designing Tables and Schemas Based on Business Requirements
3m 53s
1.2 Lab: Building the Design
3m 26s
1.3 Improving the Design of Tables by Using Normalization
2m 13s
1.4 Lab: Implementing Normalization
1m 47s
1.5 Writing Table Create Statements
9m 3s
1.6 Lab: Creating Tables
9m 0s
1.7 Determining the Most Efficient Data Types to Use: Categories, Precedence, Conversion, Considerations, and Keys
12m 23s
1.8 Determining the Most Efficient Data Types to Use: Identity and Sequence
10m 3s
1.9 Determining the Most Efficient Data Types to Use: Computed Columns, Numeric, and Date/Time
8m 1s
1.10 Determining the Most Efficient Data Types to Use: Character, Unicode, Binary String, and Other Data Types
5m 28s
1.11 Lab: Reviewing Data Types and Their Applications
23m 34s
1.12 Extending Security to Data Types by Using Dynamic Data Masking
6m 55s
1.13 Lab: Using DDM Functions
11m 39s
Lesson 1 Summary
1m 9s
Learning objectives
45s
2.1 Designing New Indexes Based on Provided Tables, Queries, or Plans
16m 24s
2.2 Lab: Implementing Indexes
8m 41s
2.3 Distinguishing Between Indexed Columns and Included Columns
6m 44s
2.4 Lab: Distinguishing Between Indexed Columns and Included Columns
4m 47s
2.5 Implementing Clustered Index Columns by Using Best Practices
7m 51s
2.6 Lab: Choosing the Clustered Index Columns Based on Best Practices
3m 35s
2.7 Recommending New Indexes Based on Query Plans
8m 3s
2.8 Lab: Analyzing Query Plans for Indexing Improvements
10m 56s
Lesson 2 Summary
42s
Learning objectives
49s
3.1 Designing a View Structure to Select Data Based on User or Business Requirements
12m 46s
3.2 Lab: Implementing a View Structure
10m 51s
3.3 Identifying the Steps Necessary to Design an Updatable View
8m 12s
3.4 Lab: Analyzing the Effects of DML Statements Using a VIEW Object
16m 30s
3.5 Implementing Partitioned Views
7m 35s
3.6 Lab: Configuring and Using Partitioned Views
6m 25s
3.7 Implementing Indexed Views
7m 36s
3.8 Lab: Configuring and Using Indexed Views
6m 37s
Lesson 3 Summary
35s
Learning objectives
46s
4.1 Determining Use Cases That Support the Use of Columnstore Indexes
14m 7s
4.2 Lab: Understanding the Conceptual Format of Columnstore Indexes
6m 15s
4.3 Identifying Proper Usage of Clustered and Non-clustered Columnstore Indexes
6m 42s
4.4 Lab: Using Clustered Columnstore Indexes in Dimensional Data Warehouse Structures
7m 27s
4.5 Lab: Using Non-clustered Columnstore Indexes in OLTP Tables to Support Analytics
5m 4s
4.6 Designing Standard Non-clustered Indexes in Conjunction with Clustered Columnstore Indexes
6m 32s
4.7 Lab: Adding Non-clustered Indexes to Clustered Columnstore Indexes
4m 58s
4.8 Implementing Columnstore Index Maintenance
8m 46s
4.9 Lab: Using the ALTER INDEX Statement
11m 30s
Lesson 4 Summary
1m 30s
Module introduction
1m 30s
Learning objectives
49s
5.1 Defining Table and Foreign Key Constraints to Enforce Business Rules
11m 42s
5.2 Lab: Using DEFAULT, UNIQUE, CHECK, and FOREIGN KEY Constraints
6m 51s
5.3 Writing Transact-SQL Statements to Add Constraints to Tables
8m 18s
5.4 Lab: Creating and Managing Constraints
16m 34s
5.5 Identifying Results of Data Manipulation Language (DML) Statements Given Existing Tables and Constraints
8m 34s
5.6 Lab: Writing INSERT, UPDATE, and DELETE Statements on Tables with Constraints
10m 16s
5.7 Identifying Proper Usage of PRIMARY KEY Constraints
4m 23s
5.8 Lab: Creating and Managing PRIMARY KEY Constraints
7m 31s
Lesson 5 Summary
1m 3s
Learning objectives
49s
6.1 Designing Stored Procedure Components and Structure Based on Business Requirements
7m 40s
6.2 Lab: Creating Stored Procedures
6m 43s
6.3 Implementing Input and Output Parameters
6m 34s
6.4 Lab: Creating and Calling Stored Procedures with Input and Output Parameters
7m 54s
6.5 Implementing Table-valued Parameters
3m 6s
6.6 Lab: Creating and Calling Stored Procedures Using Table-valued Parameters
6m 37s
6.7 Implementing Return Codes
2m 39s
6.8 Lab: Creating and Executing Stored Procedures with RETURN Statements
3m 28s
6.9 Streamlining Existing Stored Procedure Logic
3m 11s
6.10 Lab: Altering Stored Procedures to Streamline Logic
3m 55s
6.11 Implementing Error Handling and Transaction Control Logic Within Stored Procedures
15m 28s
6.12 Lab: Implementing Error Handling in Stored Procedures Using THROW, RAISERROR, and TRY‚Ä¶CATCH Statements
11m 55s
6.13 Lab: Using Transaction Control Logic Within Stored Procedures
18m 7s
Lesson 6 Summary
51s
Learning objectives
1m 2s
7.1 Designing Trigger Logic Based on Business Requirements
7m 29s
7.2 Lab: Creating and Implementing Triggers
5m 16s
7.3 Determining When to Use Data Manipulation Language (DML) Triggers, Data Definition Language (DDL) Triggers, or Logon Triggers
9m 50s
7.4 Lab: Implementing DML Triggers
7m 41s
7.5 Lab: Implementing DDL Triggers
5m 41s
7.6 Lab: Implementing Logon Triggers
4m 19s
7.7 Recognizing Results Based on Execution of AFTER Triggers
5m 25s
7.8 Recognizing Results Based on Execution of INSTEAD OF Triggers
5m 24s
7.9 Lab: Implementing AFTER and INSTEAD OF Triggers
6m 31s
7.10 Designing Scalar-valued and Table-valued User-defined Functions Based on Business Requirements
13m 41s
7.11 Lab: Creating and Implementing Scalar-valued User-defined Functions
6m 11s
7.12 Lab: Creating and Implementing Table-valued User-defined Functions
6m 15s
7.13 Identifying Differences Between Deterministic and Non-deterministic Functions
2m 46s
7.14 Lab: Implementing Deterministic and Non-deterministic Functions
4m 51s
Lesson 7 Summary
56s

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

1.9 Determining the Most Efficient Data Types to Use: Computed Columns, Numeric, and Date/Time

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

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

Marilyn White

SQL Server 2016 Database Reporting

Dallas Harold Snider

Microsoft SQL Server 2014 Unleashed

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

Inside Microsoft® SQL Server® 2008: T-SQL Querying

Lubor Kollar Itzik Ben-Gan Dejan Sarka, and Steve Kass

Publisher Resources

ISBN: 9780134769905Supplemental Content

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

with Marilyn White

Introduction

Module 1 Design and Implement Database Objects

Lesson 1: Design and Implement a Relational Database Schema

Lesson 2: Design and Implement Indexes

Lesson 3: Design and Implement Views

Lesson 4: Implement Columnstore Indexes

Module 2 Implement Programmability Objects

Lesson 5: Ensure Data Integrity with Constraints

Lesson 6: Create Stored Procedures

Lesson 7: Create Triggers and User-Defined Functions

Module 3 Manage Database Concurrency

Lesson 8: Implement Transactions

Lesson 9: Manage Isolation Levels

Lesson 10: Optimize Concurrency and Locking Behavior

Lesson 11: Implement Memory-Optimized Tables and Native Stored Procedures

Module 4 Optimize Database Objects and SQL Infrastructure

Lesson 12: Optimize Statistics and Indexes

Lesson 13: Analyze and Troubleshoot Query Plans

Lesson 14: Manage Performance for Database Instances

Lesson 15: Monitor and Trace SQL Server Baseline Performance Metrics

Summary

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

1.9 Determining the Most Efficient Data Types to Use: Computed Columns, Numeric, and Date/Time

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

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

SQL Server 2016 Database Reporting

Microsoft SQL Server 2014 Unleashed

Inside Microsoft® SQL Server® 2008: T-SQL Querying

Publisher Resources

Introduction

Module 1 Design and Implement Database Objects

Lesson 1: Design and Implement a Relational Database Schema

Lesson 2: Design and Implement Indexes

Lesson 3: Design and Implement Views

Lesson 4: Implement Columnstore Indexes

Module 2 Implement Programmability Objects

Lesson 5: Ensure Data Integrity with Constraints

Lesson 6: Create Stored Procedures

Lesson 7: Create Triggers and User-Defined Functions

Module 3 Manage Database Concurrency

Lesson 8: Implement Transactions

Lesson 9: Manage Isolation Levels

Lesson 10: Optimize Concurrency and Locking Behavior

Lesson 11: Implement Memory-Optimized Tables and Native Stored Procedures

Module 4 Optimize Database Objects and SQL Infrastructure

Lesson 12: Optimize Statistics and Indexes

Lesson 13: Analyze and Troubleshoot Query Plans

Lesson 14: Manage Performance for Database Instances

Lesson 15: Monitor and Trace SQL Server Baseline Performance Metrics

Summary

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

1.9 Determining the Most Efficient Data Types to Use: Computed Columns, Numeric, and Date/Time

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

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

SQL Server 2016 Database Reporting

Microsoft SQL Server 2014 Unleashed

Inside Microsoft® SQL Server® 2008: T-SQL Querying

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.