Join Martin Guidry for an in-depth discussion in this video What you should know before watching this course, part of SQL Server 2012: Designing Database Solutions.
- To get the most out of this course, you should have a little background knowledge. Certainly a basic understanding of Microsoft SQL server is required. If you feel you need that introductory knowledge, you can view SQL Server Essential Training with Simon Allardice here on Lynda.com. You will also need to have some familiarity with SQL Server Management Studio and some knowledge of the T-SQL language, things like select statements and views. A great way to pick up this knowledge is Querying Microsoft SQL Server 2012 with Gerry O'Brien here on Lynda.com.
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.