Save for later

SQL Server 2012

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 Details and Enroll Now

OpenCourser is an affiliate partner of LinkedIn Learning.

Get a Reminder

Send to:
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

Send to:

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.

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
Enroll Now