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

How do you configure Windows correctly for running SQL Server 2012? Which Edition of SQL Server 2012 should you select? How do you choose a RAID level for the SQL Server storage? Which installation options should you choose for SQL Server, and how do you


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Main SQL Server 2012 Editions
        ◦ Additional SQL Server 2012 Editions
        ◦ Licensing Changes for SQL Server 2012
        ◦ Why Install SQL Server 2012 Properly?
        ◦ Why Configure SQL Server 2012 Properly?
        ◦ Why Maintain SQL Server 2012 Properly?
        ◦ Summary
        ◦ Course Structure
    ● Pre-Installation Tasks for the Operating System
        ◦ Introduction
        ◦ Getting Domain Accounts Provisioned
        ◦ Install and Patch Windows Server 2012
        ◦ BIOS and Firmware Updates
        ◦ Demo: Dell Support Web site
        ◦ Install or Update Your Device Drivers
        ◦ Checking Your Power Management Settings
        ◦ Windows Power Options
        ◦ Demo:Task Manager and CPU-Z
        ◦ Grant Windows Rights to the SQL Server Service
        ◦ Perform Volume Maintenance Tasks
        ◦ Lock Pages in Memory (LPIM)
        ◦ Local Group Policy Editor
        ◦ Demo: GPEDIT.MSC Usage
        ◦ Final OS Configuration Tasks
        ◦ Optimize Drives Dialog
        ◦ Summary
        ◦ What is Next?
    ● Pre-installation Tasks for SQL Server 2012
        ◦ Introduction
        ◦ Uising a Standard Naming Scheme for Disks
        ◦ Considering Your Workload for Storage
        ◦ Additional Workload Considerations
        ◦ Choosing the Storage Type for SQL Server
        ◦ Tips for Requesting Storage
        ◦ RAID Basics
        ◦ RAID 1
        ◦ RAID 5
        ◦ RAID 50
        ◦ RAID 10
        ◦ RAID Level and SQL Server Workloads
        ◦ Provisioning Your Logical Drives
        ◦ Testing Your Logical Drive Performance
        ◦ CrystalDiskMark 3.0.1 x64
        ◦ Demo: CrystalDiskMark
        ◦ SQLIO Disk Benchmark
        ◦ Summary
        ◦ What is Next?
    ● Installing SQL Server 2012
        ◦ Introduction
        ◦ Selecting Which Features to Install
        ◦ Instance Configuration
        ◦ Specifying Service Accounts
        ◦ Server Configuration Screen
        ◦ Changing SQL Server Agent Properties
        ◦ Database Engine Configuration Tasks (1)
        ◦ Database Engine Configuration Tasks (2)
        ◦ Database Engine Configuration Tasks (3)
        ◦ Error Reporting
        ◦ Demo: Installing SQL Server 2012 (1)
        ◦ Demo: Installing SQL Server 2012 (2)
        ◦ Demo: Installing SQL Server 2012 (3)
        ◦ Summary
        ◦ What is Next?
    ● Post-Installation Tasks for SQL Server 2012
        ◦ Introduction
        ◦ How SQL Server 2012 Is Updated
        ◦ Optional Update in Microsoft Update
        ◦ The Importance of Updating SQL Server 2012
        ◦ Obtaining SQL Server 2012 Service Packs
        ◦ Installing SQL Server 2012 Service Packs
        ◦ Obtaining SQL Server 2012 Cumulative Updates
        ◦ Requesting a Specific Cumulative Update
        ◦ Demo: Requesting a SQL Server 2012 CU
        ◦ Installing a SQL Server 2012 Cumulative Update
        ◦ Install the Latest Service Pack and CU
        ◦ Setting Instance Properties with SSMS
        ◦ Demo: Setting Instance Properties with SSMS
        ◦ Setting Instance Properties with T-SQL
        ◦ Demo: Setting Instance Properties with T-SQL
        ◦ Configuring tembdb Files
        ◦ Summary
        ◦ What is Next?
    ● Automating Common Maintenance Tasks
        ◦ Introduction
        ◦ Confirming Network Connectivity


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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

Back to Top