SQL Server 2014 (Exam 70-465)

SQL Server is the foundation of Microsoft\'s comprehensive data platform. With new functionalities like In-Memory OLTP and other features and improvements, SQL Server 2014 will continue the explosive growth it has experienced over the past few years. This growth continues to create more and more opportunities for those holding certifications on the Microsoft Data Platform. In this course, Mark Long brings his 20+ years of experience with SQL Server to you as he helps you prepare for Microsoft\'s Designing Database Solutions for Microsoft SQL Server 2014 certification exam (70-465).

Welcome/Intro

Welcome/Intro
Course Overview
Understanding SQL
Understanding TSQL
Microsoft SQL Server Certifications

SQL Server 2014 Essentials

SQL Server 2014 Editions
Hardware Requirements
Software Requirements
What\\\\\\\'s New in 2014

Installing SQL Server

Getting Hands on with SQL Server 2014
Installing SQL Server 2014 pt. 1
Installing SQL Server 2014 pt. 2
Validating A SQL Server Installation pt. 1
Validating A SQL Server Installation pt. 2
Uninstalling SQL Server 2014
SQL Books Online Goes Online
Downloading BOL
No TSQL Reference?
Attaching AdventureWorks Sample dB pt. 1
Attaching AdventureWorks Sample dB pt. 2
Using MMC Snap-Ins

SQL Server Design Basics

SQL Server Instances
SQL Server Configuration Manager
SQL Server Management Studio
Refreshing Intellisense
Understanding Databases
Database Types
Table Basics
Table Design Options
Data Types
Understanding Primary Keys
Understanding Normalization
Understanding Foreign Keys
Denormalization
Virtual Denormalization
Database Files
Database File Locations
Filegroups and File Placement
Understanding Filestream
Understanding FileTables
FileTable Design Considerations
Understanding Schemas
Understanding Transaction Logs
Four Part Naming
Linked Servers
Distributed Transactions

Working with Tables

Database Diagrams
Working With Diagrams
Physical Tables
Understanding Temporary Tables
Understanding Table Variables
Temp Table vs. Table Variable
Common Table Expressions pt. 1
Common Table Expressions pt. 2
Calculated Columns
Calculated Column Example
Data Compression
Enabling Compression
GUIDs and SQL Server pt.1
GUIDs and SQL Server pt.2
NEWID() and NEWSEQUENTIALID()
Understanding Table Partitioning
In-Memory OLTP
In-Memory OLTP Demo

Indexes

Index Basics
Clustered Indexes
Nonclustered Indexes
Pages and Extents
Understanding Fill Factor
Creating Indexes
Optimizing Indexes
Reorganizing and Rebuilding Indexes
Checking Index Fragmentation
Columnstore Indexes
Columnstore Index Characteristics

Programming Objects

Understanding Stored Procedures
Creating Stored Procedures
Using Parameters With SPs
Using Output Parameters
Natively Compiled Stored Procedures
Understanding Transactions
Explicit and Implicit Transactions
Transactions and Locking
Creating Views pt. 1
Creating Views pt. 2
Partitioned Views
Common Partitioned View Usage

Concurrency and Locking

Understanding Concurrency
Normalization and Concurrency
Transaction Isolation Levels
Monitoring and Managing Locking

Automation

Database Maintenance Plans pt. 1
Database Maintenance Plans pt. 2
Monitoring Server Health

Security

Basic Security Design pt. 1
Basic Security Design pt. 2
New Server Level Permissions

Course Wrap-Up

Course Wrap-Up

About the Author

About the Author

SharePoint

Windows SharePoint Services is an enterprise-grade web application platform that allows rapid development and deployment. VTC author Greg Dickinson will get you up and running with SharePoint, step you through the basic web development process, and show you how to manage SharePoint from a variety of client-side applications. You will also learn how to administer the server farm and perform basic maintenance tasks. To begin learning simply click the links.

Introduction

Introduction to Sharepoint
Sharepoint in the Enterprise
Topics Covered

Getting Started

Introduction to Sharepoint Terminology
Hardware & Software Requirements
Planning a SharePoint Implementation Pt.1
Planning a SharePoint Implementation Pt.2

Setting Up Sharepoint

Configuring the Database Server
Configuring the Front-End Web Server
Installing SharePoint
Basic Sharepoint Configuration
Microsoft Best Practices

Sharepoint Administration

Central Administration
Monitoring the Server Farm Pt.1
Monitoring the Server Farm Pt.2
Preparing a Backup Location
Backing Up & Restoring SharePoint Pt.1
Backing Up & Restoring SharePoint Pt.2

Creating a SharePoint Site

Creating a Web Application Pt.1
Creating a Web Application Pt.2
Creating a Site Collection
Creating a Sharepoint Site

Sites & Site Collections

Site Collection Maintenance Pt.1
Site Collection Maintenance Pt.2
Structuring SharePoint Pt.1
Structuring SharePoint Pt.2
Site Maintenance Pt.1
Site Maintenance Pt.2
Site Maintenance Pt.3

SharePoint Security

Security Overview Pt.1
Security Overview Pt.2
SharePoint Users & Groups Pt.1
SharePoint Users & Groups Pt.2
SharePoint Permissions
Site Security Pt.1
Site Security Pt.2

Customizing Sharepoint

Defining Site & List Columns Pt.1
Defining Site & List Columns Pt.2
Custom Content Types Pt.1
Custom Content Types Pt.2
Custom Content Types Pt.3
Customizing Web Pages Pt.1
Customizing Web Pages Pt.2
The User Experience Pt.1
The User Experience Pt.2

Workflows

Workflows Overview
Setting Up a Workflow Pt.1
Setting Up a Workflow Pt.2
Setting Up a Workflow Pt.3
Workflow Processing Pt.1
Workflow Processing Pt.2

Communicating With SharePoint

Overview/Outbound Email Setup
Inbound Email Setup Pt.1
Inbound Email Setup Pt.2
Directory Management Service Setup
Email Enabling Lists
Email Enabling Groups

Integrating SharePoint with Office 2007

Connecting Outlook to SharePoint Pt.1
Connecting Outlook to SharePoint Pt.2
Document Management in Office 2007
Document Workspace Sites
Importing Data Into Excel 2007
Linking Data to Access Pt.2007

Wrapping it up

Review of Topics Covered

About the Author

Greg Dickinson

Service Oriented Architecture

This training has been created to provide you with relevant and important information concerning SOA: Service Orientated Architecture. During this training we will be concentrating on the main points of applying design strategies to a service orientated architecture. You will also learn all there is to know about SOA, how to design and apply the best principles, tips and techniques with detailed practices and principles. We will also be covering various aspects of legacy systems and applications, providing information on security, and appropriate governance with clear details to help you achieve success with SOA, including the design and creation of services for implementation within your enterprise. By the end of this training you will have a high level overview of the benefits of SOA, how to design and implement SOA in your business today. Very little is discussed regarding APIs or code unless used to display the implications of certain technologies and standards. This is a technical training, which is focused on architects, designers, business analysts, IT managers and executives.

Welcome to SOA

Welcome
SOA Introduction
Course Terminology A
Course Terminology B
What is SOA
Who is SOA for?

The Promise of SOA

What History Tells Us
Problems
What We Learn
Challenges
Solutions

SOA Fundamentals

Architecture
SOA Architecture
Service Aspects
SOA Services
Service Definitions
Loose Coupling
Service Patterns
Service Types
SOA Business

Getting Started

SOA Reference
Reference Architectures
Minimum Architecture
Architecture Designs
Information Design
Service Specifications
Service Realization
Service Design Process
Service Design – Top Down
Service Design – Bottom Up
Service Design – Middle Out
Process Phase
Practical Steps

Business Beginnings

Business Architecture A
Business Architecture B
Value Chain A
Value Chain B
Business Motivation
Mission
Business and IT Alignment
Business Process Models A
Business Process Models B
Business Process and SOA
Business Process Creation A
Business Process Creation B
Service Organisation
Domain
Service Inventory

Common Semantics

Importance of Semantics
Objects, Classes, Attributes
Associations
Type Definition
Definition Types
Identifiers
Specialization

Structure Information

Structured Models
Documents A
Information Model Adaption
Documents B
XML
XML Schema
Derivation
XML Patterns
SOA Architect

Conclusion

SOA Part Two
Training Content
Author