Microsoft Certified Solutions Expert (MCSE) courses are offered by computer learning centers, community colleges and universities in conjunction with Microsoft. Courses offered as part of a college or university certificate program in networking or computer technology can last an entire semester. Standalone courses designed for continuing education can be completed in as few as five days.
Microsoft recommends prospective students have experience working with server hardware, Windows operating systems and relational databases before enrolling in MCSE courses. Most, if not all, courses will change after the release of Microsoft's Windows Server 2016 and SQL Server 2016.
Typical course topics include the following:
- Installing Windows Server 2012 using server images
- Managing users and permissions
- Creating Active Directory Domain Services (AD DS) forests
- Designing server infrastructure
- Troubleshooting networks
- Protecting network and user data
List of MCSE Courses and Classes
Installing and Configuring Windows Servers
Students in this course learn the steps required to install and deploy Windows Server 2012. Lessons also introduce them to available management tools and show them how to install domain controllers, create user accounts, manage storage space and configure firewalls to ensure operating system security.
Administering Microsoft SQL Server Databases
Server tools, services and architecture for SQL Server 2012 are among this course's introductory topics of discussion. Students also learn how to perform pre-installation testing and install server components, create databases and employ various backup strategies. Additional course topics delve into steps required to restore databases, import and export data, create and authorize database users and assign permissions. Students also learn how to perform server audits and troubleshoot connectivity or service issues.
Implementing Desktop Infrastructure
Students in this course learn how to deploy desktop operating systems for a business or organization. Topics of discussion can include tips for using Windows Deployment Services to deploy an operating system over a network using server images. Students also find out how to manage desktop security and software updates and monitor desktop infrastructures to ensure proper performance.
Operating a Private Cloud
In addition to learning about the infrastructure required for cloud computing, students in this course explore the System Center 2012 components designed to configure security or deploy services and applications over these computing networks. They can also learn how to monitor network infrastructure and applications and set up a private cloud.
Designing Business Intelligence Solutions
Students in this course learn about the Microsoft hardware and software designed to help an organization mine and interpret data. Introductory topics of discussion cover planning considerations for business intelligence solutions. Students also learn steps for designing data warehouses, extracting data and creating reports using Excel or Power View. Strategies for monitoring and maintaining these solutions are included as well.