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/IntroCourse Overview
Understanding SQL
Understanding TSQL
Microsoft SQL Server Certifications
SQL Server 2014 Essentials
SQL Server 2014 EditionsHardware Requirements
Software Requirements
What\\\\\\\'s New in 2014
Installing SQL Server
Getting Hands on with SQL Server 2014Installing 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 InstancesSQL 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 DiagramsWorking 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 BasicsClustered 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 ProceduresCreating 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 ConcurrencyNormalization and Concurrency
Transaction Isolation Levels
Monitoring and Managing Locking
Automation
Database Maintenance Plans pt. 1Database Maintenance Plans pt. 2
Monitoring Server Health
Security
Basic Security Design pt. 1Basic Security Design pt. 2
New Server Level Permissions
No comments:
Post a Comment