SQL Server 2014 (Exam 70-464)
by Mark Long
Start the free chapterSQL 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.rnrnIn 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.
Course content
Welcome/Intro5 lessons
SQL Server 2014 Essentials2 lessons
Installing SQL Server11 lessons
- Getting SQL Server 20143:551 credit or ad
- Installing SQL Server 2014 pt. 16:061 credit or ad
- Installing SQL Server 2014 pt. 26:031 credit or ad
- Validating a SQL Server Installation pt. 14:061 credit or ad
- Validating a SQL Server Installation pt. 24:391 credit or ad
- Uninstalling SQL Server 20143:421 credit or ad
- SQL Books Online Goes Online4:101 credit or ad
- Downloading Books Online4:421 credit or ad
- Attaching Adventureworks Sample dB pt. 14:221 credit or ad
- Attaching Adventureworks Sample dB pt. 22:371 credit or ad
- Where\\\'s the TSQL Reference6:211 credit or ad
SQL Server Basics18 lessons
- SQL Server Instances3:551 credit or ad
- SQL Server Configuration Manager3:201 credit or ad
- SQL Server Management Studio6:361 credit or ad
- Understanding Databases4:401 credit or ad
- Table Basics4:401 credit or ad
- Understanding Primary Keys4:211 credit or ad
- Understanding Data Types pt. 16:081 credit or ad
- Understanding Data Types pt. 25:591 credit or ad
- Understanding Normalization4:541 credit or ad
- Understanding Foreign Keys4:331 credit or ad
- Database Types5:451 credit or ad
- Understanding Transaction Logs4:341 credit or ad
- System Databases5:571 credit or ad
- Understanding Schemas4:191 credit or ad
- Four Part Naming3:541 credit or ad
- Understanding Synonyms Part One3:341 credit or ad
- Understanding Synonyms Part Two3:501 credit or ad
- Refreshing Intellisense3:231 credit or ad
Table Basics7 lessons
Advanced Table Functionalities11 lessons
- Calculated Columns5:271 credit or ad
- Column Collation pt. 16:251 credit or ad
- Column Collation pt. 24:461 credit or ad
- Understanding Filegroups4:371 credit or ad
- Understanding Table Partitioning6:561 credit or ad
- FileStream Basics5:201 credit or ad
- Enabling FileStream6:321 credit or ad
- FileTable Basics2:551 credit or ad
- In-Memory OLTP6:231 credit or ad
- In-Memory OLTP Demo7:421 credit or ad
- Next Steps on In-Memory OLTP5:471 credit or ad
Indexes14 lessons
- Index Basics5:221 credit or ad
- Clustered Indexes4:551 credit or ad
- Nonclustered Indexes4:201 credit or ad
- Pages and Extents5:351 credit or ad
- Understanding Fill Factor4:321 credit or ad
- Creating Indexes7:251 credit or ad
- Checking Index Fragmentation6:511 credit or ad
- Reorganizing and Rebuilding Indexes7:091 credit or ad
- Aligning Indexes on Partitioned Tables5:231 credit or ad
- Identifying Index Usage pt. 16:061 credit or ad
- Identifying Index Usage pt. 23:141 credit or ad
- Columnstore Indexes pt. 16:021 credit or ad
- Columnstore Indexes pt. 24:181 credit or ad
- Columnstore Index Characteristics4:301 credit or ad
Programming Objects10 lessons
- Stored Procedures5:501 credit or ad
- Natively Compiled Stored Procedures6:291 credit or ad
- Using Parameters With SPs pt. 16:231 credit or ad
- Using Parameters with SPs pt. 26:371 credit or ad
- Error Handling in SPs pt. 16:131 credit or ad
- Error Handling in SPs pt. 26:101 credit or ad
- OFFSET and FETCH6:461 credit or ad
- Creating Views5:411 credit or ad
- Partitioned Views5:121 credit or ad
- Indexed Views5:261 credit or ad
Concurrency and Locking10 lessons
- Understanding Concurrency5:331 credit or ad
- Pessimistic and Optimistic Locking5:271 credit or ad
- Normalization and Concurrency4:331 credit or ad
- Transaction Isolation Levels6:231 credit or ad
- Snapshot Isolation6:011 credit or ad
- Understanding Transactions4:201 credit or ad
- Explicit and Implicit Transactions4:221 credit or ad
- Using Explicit Transactions4:311 credit or ad
- Design for Minimal Locking6:101 credit or ad
- Monitoring and Managing Locking6:141 credit or ad
Optimization9 lessons
- SQL Server Profiler5:181 credit or ad
- Creating a Trace pt. 15:491 credit or ad
- Creating a Trace pt. 25:551 credit or ad
- Extended Events6:561 credit or ad
- Performance Monitor and Profiler pt. 12:201 credit or ad
- Performance Monitor and Profiler pt. 23:061 credit or ad
- Performance Monitor and Profiler pt. 36:421 credit or ad
- Monitoring In-Memory OLTP4:301 credit or ad
- Execution Plans4:541 credit or ad