Become a member

Online Access to 1000+ Courses!

SQL Server 2014 (Exam 70-465) Course

Author : Mark Long

6.24hrs (96 Lessons) 2015-01-05

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

Transcription not available

Course: SQL Server 2014 (Exam 70-465)
Author: Mark Long
SKU: 34543
ISBN: 978-1-61866-029-9
Work Files: Yes
Captions: No
Subject: Certification
The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

Download WorkFiles

Implementing Data Models with SQL Server
Author : Mark Long

8.27 / 93 2015-08-03
SQL Server 2014 (Exam 70-465)
Author : Mark Long

6.24 / 96 2015-01-05
SQL Server 2014 (Exam 70-464)
Author : Mark Long

8.47 / 102 2014-09-11
MCSE: SQL Server 2012 Bundle
Author : Mark Long

41.5 / 499 2013-12-19
MCSA: SQL Server 2012 Bundle
Author : Mark Long

25.5 / 305 2013-12-19
Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012
Author : Mark Long

8 / 96 2013-05-02
Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463)
Author : Mark Long

8 / 96 2013-04-19
Querying Microsoft SQL Server 2012 (Exam 70-461)
Author : Mark Long

8.5 / 110 2012-10-09
Microsoft SQL Server 2012 Admin (Exam 70-462)
Author : Mark Long

9 / 99 2012-06-18
MySQL 5 Administration (Part 1)
Author : David Swain

16 / 171 2012-12-31
PostgreSQL
Author : Dima Kassab

8 / 95 2012-02-06
MySQL 5 Development (Part 2)
Author : David Swain

17.5 / 184 2011-11-22
MySQL 5 Development (Part 1)
Author : David Swain

11 / 129 2011-05-27
QuickStart! - MySQL 5
Author : John Mangino

3 / 30 2010-06-25
Microsoft SQL Server 2008 Development
Author : Mark Long

6 / 69 2010-05-20
Microsoft SQL Server 2008 Administration
Author : Mark Long

6 / 70 2010-03-24
Microsoft SQL Server 2005 Administration
Author : Mark Long

7 / 92 2006-03-16
Oracle: Introduction to Oracle SQL and PL/SQL
Author : Gavin Powell

12 / 165 2003-03-12
Microsoft Transact SQL
Author : Mark Long

7.5 / 102 2002-10-15
Microsoft SQL Server 2000 Database Programming
Author : Mark Long

8 / 102 2002-08-20
Microsoft SQL Server 2000 Admin
Author : Mark Long

9.5 / 154 2002-07-31
MySQL
Author : Joshua Mostafa

7 / 72 2002-07-25

Pricing & availability

Lifetime online access to this course

US$ 39.00

Download for offline access

US$ 79.95

Subscribe to 1000+ courses

Starting at $30/month

Course outline

Welcome/Intro

Welcome/Intro (00:53)

Course Overview (04:25)

Understanding SQL (04:40)

Understanding TSQL (04:02)

Microsoft SQL Server Certifications (04:02)

SQL Server 2014 Essentials

SQL Server 2014 Editions (03:58)

Hardware Requirements (02:48)

Software Requirements (04:22)

What\\\\\\\'s New in 2014 (04:49)

Installing SQL Server

Getting Hands on with SQL Server 2014 (03:50)

Installing SQL Server 2014 pt. 1 (06:06)

Installing SQL Server 2014 pt. 2 (06:04)

Validating A SQL Server Installation pt. 1 (04:58)

Validating A SQL Server Installation pt. 2 (02:53)

Uninstalling SQL Server 2014 (04:45)

SQL Books Online Goes Online (03:54)

Downloading BOL (04:21)

No TSQL Reference? (04:03)

Attaching AdventureWorks Sample dB pt. 1 (04:11)

Attaching AdventureWorks Sample dB pt. 2 (03:36)

Using MMC Snap-Ins (04:56)

SQL Server Design Basics

SQL Server Instances (04:51)

SQL Server Configuration Manager (04:51)

SQL Server Management Studio (06:31)

Refreshing Intellisense (03:23)

Understanding Databases (04:23)

Database Types (05:49)

Table Basics (05:42)

Table Design Options (05:43)

Data Types (03:21)

Understanding Primary Keys (05:06)

Understanding Normalization (04:14)

Understanding Foreign Keys (04:42)

Denormalization (04:40)

Virtual Denormalization (05:19)

Database Files (04:03)

Database File Locations (03:58)

Filegroups and File Placement (05:51)

Understanding Filestream (05:20)

Understanding FileTables (05:59)

FileTable Design Considerations (05:19)

Understanding Schemas (04:07)

Understanding Transaction Logs (03:19)

Four Part Naming (02:57)

Linked Servers (03:06)

Distributed Transactions (06:53)

Working with Tables

Database Diagrams (03:38)

Working With Diagrams (07:04)

Physical Tables (04:43)

Understanding Temporary Tables (06:20)

Understanding Table Variables (06:22)

Temp Table vs. Table Variable (03:38)

Common Table Expressions pt. 1 (03:31)

Common Table Expressions pt. 2 (07:19)

Calculated Columns (03:11)

Calculated Column Example (06:09)

Data Compression (05:37)

Enabling Compression (04:37)

GUIDs and SQL Server pt.1 (04:29)

GUIDs and SQL Server pt.2 (05:51)

NEWID() and NEWSEQUENTIALID() (04:05)

Understanding Table Partitioning (06:29)

In-Memory OLTP (06:12)

In-Memory OLTP Demo (06:54)

Indexes

Index Basics (05:02)

Clustered Indexes (05:38)

Nonclustered Indexes (05:04)

Pages and Extents (05:51)

Understanding Fill Factor (04:43)

Creating Indexes (07:04)

Optimizing Indexes (06:16)

Reorganizing and Rebuilding Indexes (05:54)

Checking Index Fragmentation (05:28)

Columnstore Indexes (06:25)

Columnstore Index Characteristics (03:42)

Programming Objects

Understanding Stored Procedures (05:53)

Creating Stored Procedures (04:11)

Using Parameters With SPs (05:30)

Using Output Parameters (06:34)

Natively Compiled Stored Procedures (04:19)

Understanding Transactions (04:21)

Explicit and Implicit Transactions (04:17)

Transactions and Locking (06:19)

Creating Views pt. 1 (06:26)

Creating Views pt. 2 (03:32)

Partitioned Views (04:45)

Common Partitioned View Usage (03:59)

Concurrency and Locking

Understanding Concurrency (05:11)

Normalization and Concurrency (03:39)

Transaction Isolation Levels (04:50)

Monitoring and Managing Locking (06:36)

Automation

Database Maintenance Plans pt. 1 (06:50)

Database Maintenance Plans pt. 2 (06:20)

Monitoring Server Health (06:15)

Security

Basic Security Design pt. 1 (06:14)

Basic Security Design pt. 2 (06:23)

New Server Level Permissions (01:54)

Course Wrap-Up

Course Wrap-Up (05:44)

About the Author

About the Author (04:00)