
Microsoft SQL Server 2012 Development (Exam 70-464)
Microsoft SQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights and quickly build solutions to extend data across on-premises and public clouds, backed by mission critical confidence. The latest version not only includes many of the same capabilities and characteristics that administrators have come to trust for over 10 years but it also introduces some new features that change how databases make data available across the enterprise. It continues the evolution and maturity of a trusted platform that leads in industry-relevant and real-world application performance benchmarks. In this VTC course, author Mark Long will introduce you to SQL Server 2012 from a development viewpoint and will help you prepare for the Microsoft 70-464 Development Certification exam. To begin learning today, simply click on the movie links.
Course content
Introduction7 lessons
SQL Server 2012 Essentials3 lessons
Installing SQL Server6 lessons
- Getting Your Hands on SQL Server 20122:371 credit or ad
- Installing SQL Server 20125:361 credit or ad
- Validate a SQL Server Installation pt. 13:551 credit or ad
- Validate a SQL Server Installation pt. 23:541 credit or ad
- Uninstalling SQL Server 20124:011 credit or ad
- SQL Books Online Goes Online4:271 credit or ad
SQL Server Basics17 lessons
- SQL Server Instances4:061 credit or ad
- SQL Server Configuration Manager3:501 credit or ad
- SQL Server Management Studio5:361 credit or ad
- Understanding Databases5:061 credit or ad
- Table Basics5:091 credit or ad
- Understanding Primary Keys6:221 credit or ad
- Understanding Data Types4:341 credit or ad
- Understanding Normalization5:521 credit or ad
- Understanding Foreign Keys5:101 credit or ad
- Creating a Database3:531 credit or ad
- Database Types7:411 credit or ad
- Understanding Transaction Logs5:371 credit or ad
- Refreshing Intellisense3:421 credit or ad
- Understanding Schemas3:201 credit or ad
- Four Part Naming3:211 credit or ad
- Understanding Synonyms pt. 14:321 credit or ad
- Understanding Synonyms pt. 24:391 credit or ad
Working with Tables22 lessons
- Attaching Adventureworks Sample DB4:251 credit or ad
- Database Diagrams5:431 credit or ad
- Working with Diagrams5:571 credit or ad
- Table Design Basics6:411 credit or ad
- Creating Tables Graphically4:401 credit or ad
- Creating Tables with TSQL4:311 credit or ad
- Altering Tables4:071 credit or ad
- Understanding Temporary Tables6:201 credit or ad
- Understanding Table Variables4:401 credit or ad
- Temp Table vs. Table Variable4:321 credit or ad
- GUIDs and SQL Server pt. 13:591 credit or ad
- GUIDs and SQL Server pt. 23:251 credit or ad
- NEWID() and NEWSEQUENTIALID()4:471 credit or ad
- Understanding Table Partitioning5:281 credit or ad
- Database Files4:381 credit or ad
- Understanding Filegroups4:411 credit or ad
- Working with BLOBs5:101 credit or ad
- FILESTREAM Basics5:531 credit or ad
- Using FILESTREAM3:391 credit or ad
- FileTable Basics4:361 credit or ad
- Understanding Constraints6:121 credit or ad
- Creating Constraints4:331 credit or ad
Indexes10 lessons
- Index Basics4:331 credit or ad
- Clustered Indexes4:181 credit or ad
- Nonclustered Indexes5:531 credit or ad
- Pages and Extents5:361 credit or ad
- Understanding Fill Factor6:291 credit or ad
- Creating Indexes Graphically6:071 credit or ad
- Creating Indexes with TSQL6:291 credit or ad
- Optimizing Indexes4:121 credit or ad
- Reorganizing and Rebuilding Indexes5:271 credit or ad
- Checking Index Fragmentation4:101 credit or ad
Programming Objects15 lessons
- Understanding Stored Procedures5:201 credit or ad
- Creating Stored Procedures5:481 credit or ad
- Using Parameters with SPs5:171 credit or ad
- Using Temp Tables with SPs6:281 credit or ad
- Types of Stored Procedures5:131 credit or ad
- Understanding Transactions5:361 credit or ad
- Explicit and Implicit Transactions6:271 credit or ad
- Using Explicit Transactions5:381 credit or ad
- Transactions and Locking4:311 credit or ad
- Creating Views6:171 credit or ad
- Partitioned Views5:551 credit or ad
- Common Partitioned View Usage3:471 credit or ad
- View Options4:591 credit or ad
- Understanding Functions4:051 credit or ad
- Scalar Function Example5:591 credit or ad
Concurrency and Locking4 lessons
Optimization9 lessons
- SQL Server Profiler4:181 credit or ad
- Creating a Trace pt. 16:081 credit or ad
- Creating a Trace pt. 24:491 credit or ad
- Querying a Trace Table6:391 credit or ad
- Database Engine Tuning Advisor3:441 credit or ad
- Query Execution Plans5:301 credit or ad
- Understanding Query Hints4:151 credit or ad
- Using System Views5:541 credit or ad
- Using Performance Monitor3:381 credit or ad