SQL Server 2012
Designing Database Solutions
Learn how to design databases, secure databases, and keep them in tip-top shape, with SQL Server 2012. Join Martin Guidry in this course, as he reviews each step in the process: from designing the infrastructure, a logical schema, and execution plan for the physical hardware, to using indexes to fine-tune performance and implementing policy-based management. He explains best practices for database design, shows where developers can bend the rules, and introduces techniques to manage your database throughout its lifecycle with PowerShell and other monitoring tools.
Contents:
- Introduction
- 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
- 8. Managing SQL Server with PowerShell
- Conclusion
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 1h 58m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Martin Guidry |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Programming IT & Networking Data Science |
Tags | Developer IT Databases IT and Hardware SQL Server Database Design Database Administration Microsoft SQL Server |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
SQL Server Administrator $77k
IT Conslutant - SQL Server $83k
SQL Server/Oracle DBA $95k
SQL Server Instructor $95k
PHP and SQL Server Developer $103k
SQL Server | BI SQL Server developer $108k
Microsoft SQL Server Developer $109k
Database Administrator SQL Server $115k
SQL Server DBA 5 $122k
SQL Server Architect $138k
SQL Server MVP 5 $156k
SQL Server MVP 3 $163k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 1h 58m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Martin Guidry |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Programming IT & Networking Data Science |
Tags | Developer IT Databases IT and Hardware SQL Server Database Design Database Administration Microsoft SQL Server |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course