Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012
by Mark Long
Start the free chapterMicrosoft's Designing Database Solutions for Microsoft SQL Server 2012 70-465 certification exam is intended for database professionals who design and build database solutions in the organization. They are responsible for the creation of plans and designs for database structure, storage, objects, and servers. They create the plan for the environment in which the database solution runs. The exam is part of Microsoft's MCSE: Data Platform certification track. In this VTC course, author Mark Long walks you through the technologies, terms, and functionalities you need to know to prepare for the 70-465 exam. To begin learning today, simply click on the movie links.
Course content
Welcome7 lessons
SQL Server 2012 Essentials3 lessons
Installing SQL Server 20127 lessons
- Getting a Copy of SQL Server 20125:031 credit or ad
- Understanding Instances5:501 credit or ad
- Installing SQL Server 2012 pt. 16:231 credit or ad
- Installing SQL Server 2012 pt. 26:091 credit or ad
- SQL Books Online Goes Online4:181 credit or ad
- Downloading Books Online4:011 credit or ad
- SSMS Tour6:351 credit or ad
Designing Database Structure11 lessons
- Determining Business Requirements6:001 credit or ad
- Database Types5:281 credit or ad
- The Relational Model5:471 credit or ad
- Normalization Basics5:121 credit or ad
- Basic Architectural Decisions4:541 credit or ad
- Understanding File Groups3:391 credit or ad
- Understanding Partitioning4:251 credit or ad
- Authentication Modes3:331 credit or ad
- Windows Authentication3:181 credit or ad
- SQL Server Authentication5:051 credit or ad
- The SA Account2:461 credit or ad
Database Object Design11 lessons
- Logical Database Design4:291 credit or ad
- Physical Design Implications4:081 credit or ad
- Understanding Collation4:301 credit or ad
- Linked Servers5:151 credit or ad
- Understanding NULLs5:351 credit or ad
- ANSI NULLs5:571 credit or ad
- Handling Database Growth6:101 credit or ad
- Linked Servers or Openrowset4:591 credit or ad
- CPU Affinity3:541 credit or ad
- Memory Allocation3:071 credit or ad
- Managing SQL Server Memory5:281 credit or ad
Designing Tables12 lessons
- Table Basics4:571 credit or ad
- Temp Tables4:251 credit or ad
- Table Variables5:031 credit or ad
- Common Table Expressions5:341 credit or ad
- Transaction Basics5:391 credit or ad
- Explicit & Implicit Transactions6:041 credit or ad
- Transaction Impact on Performance3:511 credit or ad
- Planning with Concurrency in Mind6:491 credit or ad
- Locking Basics5:051 credit or ad
- Lock Types & Escalation5:271 credit or ad
- Schema Basics5:231 credit or ad
- Creating Schemas4:351 credit or ad
Indexing11 lessons
- Understanding Indexes3:211 credit or ad
- Understanding Data Distribution6:331 credit or ad
- Clustered Indexes3:481 credit or ad
- Non-Clustered Indexes3:191 credit or ad
- Indexing Best Practices3:391 credit or ad
- Reorganizing & Rebuilding Indexes4:131 credit or ad
- Which Should I Use?2:221 credit or ad
- Understanding Index Fragmentation3:431 credit or ad
- Understanding Index Internals pt. 15:441 credit or ad
- Understanding Index Internals pt. 23:571 credit or ad
- Understanding Fillfactor5:151 credit or ad
Programming Objects5 lessons
Database Server Maintenance14 lessons
- SQL Server Agent4:491 credit or ad
- Understanding Jobs3:271 credit or ad
- Understanding Alerts3:231 credit or ad
- Understanding Operators3:081 credit or ad
- Understanding Schedules3:391 credit or ad
- Creating a Job4:311 credit or ad
- Database Maintenance Plans3:581 credit or ad
- Creating a Maintenance Plan6:011 credit or ad
- Maintenance Plan Design Surface6:381 credit or ad
- Multiserver Administration4:351 credit or ad
- Ensuring Good Database Health6:201 credit or ad
- DMVs4:581 credit or ad
- SQL Server 2012 DMVs4:321 credit or ad
- Getting to Know Your DMVs5:501 credit or ad
Monitoring Performance6 lessons
Designing Backup & Recovery7 lessons
- Backup & Recovery Planning6:031 credit or ad
- Transaction Log Basics4:441 credit or ad
- Understanding Recovery Models4:481 credit or ad
- Setting the Recovery Model2:231 credit or ad
- Understanding Database Snapshots4:501 credit or ad
- Using Database Snapshots4:251 credit or ad
- High Availability Options5:241 credit or ad