SQL Server 2014 (Exam 70-465)
by Mark Long
Start the free chapterSQL 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. rnrnIn 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).
Course content
Welcome/Intro5 lessons
SQL Server 2014 Essentials4 lessons
Installing SQL Server12 lessons
- Getting Hands on with SQL Server 20143:501 credit or ad
- Installing SQL Server 2014 pt. 16:061 credit or ad
- Installing SQL Server 2014 pt. 26:041 credit or ad
- Validating A SQL Server Installation pt. 14:581 credit or ad
- Validating A SQL Server Installation pt. 22:531 credit or ad
- Uninstalling SQL Server 20144:451 credit or ad
- SQL Books Online Goes Online3:541 credit or ad
- Downloading BOL4:211 credit or ad
- No TSQL Reference?4:031 credit or ad
- Attaching AdventureWorks Sample dB pt. 14:111 credit or ad
- Attaching AdventureWorks Sample dB pt. 23:361 credit or ad
- Using MMC Snap-Ins4:561 credit or ad
SQL Server Design Basics25 lessons
- SQL Server Instances4:511 credit or ad
- SQL Server Configuration Manager4:511 credit or ad
- SQL Server Management Studio6:311 credit or ad
- Refreshing Intellisense3:231 credit or ad
- Understanding Databases4:231 credit or ad
- Database Types5:491 credit or ad
- Table Basics5:421 credit or ad
- Table Design Options5:431 credit or ad
- Data Types3:211 credit or ad
- Understanding Primary Keys5:061 credit or ad
- Understanding Normalization4:141 credit or ad
- Understanding Foreign Keys4:421 credit or ad
- Denormalization4:401 credit or ad
- Virtual Denormalization5:191 credit or ad
- Database Files4:031 credit or ad
- Database File Locations3:581 credit or ad
- Filegroups and File Placement5:511 credit or ad
- Understanding Filestream5:201 credit or ad
- Understanding FileTables5:591 credit or ad
- FileTable Design Considerations5:191 credit or ad
- Understanding Schemas4:071 credit or ad
- Understanding Transaction Logs3:191 credit or ad
- Four Part Naming2:571 credit or ad
- Linked Servers3:061 credit or ad
- Distributed Transactions6:531 credit or ad
Working with Tables18 lessons
- Database Diagrams3:381 credit or ad
- Working With Diagrams7:041 credit or ad
- Physical Tables4:431 credit or ad
- Understanding Temporary Tables6:201 credit or ad
- Understanding Table Variables6:221 credit or ad
- Temp Table vs. Table Variable3:381 credit or ad
- Common Table Expressions pt. 13:311 credit or ad
- Common Table Expressions pt. 27:191 credit or ad
- Calculated Columns3:111 credit or ad
- Calculated Column Example6:091 credit or ad
- Data Compression5:371 credit or ad
- Enabling Compression4:371 credit or ad
- GUIDs and SQL Server pt.14:291 credit or ad
- GUIDs and SQL Server pt.25:511 credit or ad
- NEWID() and NEWSEQUENTIALID()4:051 credit or ad
- Understanding Table Partitioning6:291 credit or ad
- In-Memory OLTP6:121 credit or ad
- In-Memory OLTP Demo6:541 credit or ad
Indexes11 lessons
- Index Basics5:021 credit or ad
- Clustered Indexes5:381 credit or ad
- Nonclustered Indexes5:041 credit or ad
- Pages and Extents5:511 credit or ad
- Understanding Fill Factor4:431 credit or ad
- Creating Indexes7:041 credit or ad
- Optimizing Indexes6:161 credit or ad
- Reorganizing and Rebuilding Indexes5:541 credit or ad
- Checking Index Fragmentation5:281 credit or ad
- Columnstore Indexes6:251 credit or ad
- Columnstore Index Characteristics3:421 credit or ad
Programming Objects12 lessons
- Understanding Stored Procedures5:531 credit or ad
- Creating Stored Procedures4:111 credit or ad
- Using Parameters With SPs5:301 credit or ad
- Using Output Parameters6:341 credit or ad
- Natively Compiled Stored Procedures4:191 credit or ad
- Understanding Transactions4:211 credit or ad
- Explicit and Implicit Transactions4:171 credit or ad
- Transactions and Locking6:191 credit or ad
- Creating Views pt. 16:261 credit or ad
- Creating Views pt. 23:321 credit or ad
- Partitioned Views4:451 credit or ad
- Common Partitioned View Usage3:591 credit or ad