2014
VTC
Mark Long
8:22
English

SQL Server is the foundation of Microsoft's comprehensive data platform. SQL Server 2014, the latest version, introduces new in-memory capabilities and other improvements are gaining a lot of attention in the database world. SQL Server 2014 will continue the explosive growth in this product, 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 70-464 Developing Microsoft SQL Server Databases certification exam.

Welcome/Intro
Welcome/Intro
Course Overview
Understanding SQL
Understanding TSQL
Microsoft SQL Server Certifications
SQL Server 2014 Essentials
What\\\'s New in 2014
SQL Server 2014 Editions
Installing SQL Server
Getting 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 Books Online
Attaching Adventureworks Sample dB pt. 1
Attaching Adventureworks Sample dB pt. 2
Where\\\'s the TSQL Reference
SQL Server Basics
SQL Server Instances
SQL Server Configuration Manager
SQL Server Management Studio
Understanding Databases
Table Basics
Understanding Primary Keys
Understanding Data Types pt. 1
Understanding Data Types pt. 2
Understanding Normalization
Understanding Foreign Keys
Database Types
Understanding Transaction Logs
System Databases
Understanding Schemas
Four Part Naming
Understanding Synonyms Part One
Understanding Synonyms Part Two
Refreshing Intellisense
Table Basics
Table Design Basics
Creating a Database
Creating Tables Graphically
Creating Tables with TSQL
Temporary Tables
Table Variables
Temp Table vs. Table Variable
Advanced Table Functionalities
Calculated Columns
Column Collation pt. 1
Column Collation pt. 2
Understanding Filegroups
Understanding Table Partitioning
FileStream Basics
Enabling FileStream
FileTable Basics
In-Memory OLTP
In-Memory OLTP Demo
Next Steps on In-Memory OLTP
Indexes
Index Basics
Clustered Indexes
Nonclustered Indexes
Pages and Extents
Understanding Fill Factor
Creating Indexes
Checking Index Fragmentation
Reorganizing and Rebuilding Indexes
Aligning Indexes on Partitioned Tables
Identifying Index Usage pt. 1
Identifying Index Usage pt. 2
Columnstore Indexes pt. 1
Columnstore Indexes pt. 2
Columnstore Index Characteristics
Programming Objects
Stored Procedures
Natively Compiled Stored Procedures
Using Parameters With SPs pt. 1
Using Parameters with SPs pt. 2
Error Handling in SPs pt. 1
Error Handling in SPs pt. 2
OFFSET and FETCH
Creating Views
Partitioned Views
Indexed Views
Concurrency and Locking
Understanding Concurrency
Pessimistic and Optimistic Locking
Normalization and Concurrency
Transaction Isolation Levels
Snapshot Isolation
Understanding Transactions
Explicit and Implicit Transactions
Using Explicit Transactions
Design for Minimal Locking
Monitoring and Managing Locking
Optimization
SQL Server Profiler
Creating a Trace pt. 1
Creating a Trace pt. 2
Extended Events
Performance Monitor and Profiler pt. 1
Performance Monitor and Profiler pt. 2
Performance Monitor and Profiler pt. 3
Monitoring In-Memory OLTP
Execution Plans
Working With XML Data
XML in SQL Server 2014
Retrieving XML from Relational Data
FOR XML
FOR XML PATH
Course Wrap-Up
Course Wrap-Up
About the Author
About the Author

vtc.com/products/sqlexam464.htm

Download File Size:795.58 MB

---