MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server 2012: Installation and Configuration

Course Summary

Learn how to correctly install and configure SQL Server 2012, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance. This course is applicable to anyone who is installing SQL Server for the first time and wants to avoid the common mistakes and pitfalls that are made so often.

  • +

    Course Syllabus

    - 16m 43s

    —Introduction 1m 47s
    —Main SQL Server 2012 Editions 2m 50s
    —Additional SQL Server 2012 Editions 1m 51s
    —Licensing Changes for SQL Server 2012 2m 44s
    —Why Install SQL Server 2012 Properly? 1m 9s
    —Why Configure SQL Server 2012 Properly? 0m 56s
    —Why Maintain SQL Server 2012 Properly? 3m 18s
    —Summary 1m 21s
    —Course Structure 0m 47s
    Pre-Installation Tasks for the Operating System
    - 30m 25s

    —Introduction 1m 58s
    —Getting Domain Accounts Provisioned 1m 39s
    —Install and Patch Windows Server 2012 2m 4s
    —BIOS and Firmware Updates 1m 32s
    —Demo: Dell Support Web site 2m 14s
    —Install or Update Your Device Drivers 1m 28s
    —Checking Your Power Management Settings 1m 27s
    —Windows Power Options 2m 6s
    —Demo:Task Manager and CPU-Z 3m 24s
    —Grant Windows Rights to the SQL Server Service 1m 2s
    —Perform Volume Maintenance Tasks 1m 59s
    —Lock Pages in Memory (LPIM) 1m 51s
    —Local Group Policy Editor 1m 2s
    —Demo: GPEDIT.MSC Usage 1m 51s
    —Final OS Configuration Tasks 2m 26s
    —Optimize Drives Dialog 0m 46s
    —Summary 0m 51s
    —What is Next? 0m 37s
    Pre-installation Tasks for SQL Server 2012
    - 28m 59s
    Installing SQL Server 2012
    - 21m 16s
    Post-Installation Tasks for SQL Server 2012
    - 28m 40s
    Automating Common Maintenance Tasks
    - 28m 47s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url