MCSA (Microsoft Certified Solutions Associate) is a certification program intended for people who seek entry-level jobs in an IT (information technology) environment. MCSA is a prerequisite for more advanced Microsoft certifications.
The MCSA credential supplants the now defunct Microsoft Certified Systems Administrator certification. Students can select any of the following specialty areas:
- Windows Server 2008
- Windows Server 2012
- SQL Server 2012
- Windows 7
- Windows 8
As they advance in the MCP program, professionals can gain any or all of the following certifications:
- Microsoft Certified Systems Engineer (MCSE)
- Microsoft Certified Solutions Developer (MCSD)
- Microsoft Certified Product Specialist (MCPS)
- Microsoft Certified Trainer (MCT)
To prepare for the MCP exams, students can take courses at a certified training company location as MultiTech Bulls Technologies . Students who do not feel ready for MCSA can obtain the more basic MTA (Microsoft Technology Associate) certification first.
Now We can take a look at
Windows Server 2008,
Windows Server 2012,
SQL Server 2012,
Windows 7 ,
Windows Server 2008 : Windows Server 2008 R2 is a server operating system developed by Microsoft, which builds on the enhancements built into Windows Server 2008. The operating system (OS), which is highly integrated with the client edition of Windows 7, offers improvements in scalability and availability, as well as power consumption.
The key enhancement in the server OS ishypervisor technology in the form of Hyper-V. It affords the ability to deliver virtualized apps and operating systems. Hyper-V can also be used to build out Virtual Desktop Infrastructure (VDI).
Windows Server 2008 R2 also has enhancedRemote Desktop Services, which allows corporate management of desktops using virtualization and VDI.
Windows Server 2012 : Windows Server 2012, formerly codenamed Windows Server 8, is the latest version of Windows Server. The successor of Windows Server 2008 R2, its improvements include overall upgrades in cloud computing and storage infrastructure.
Windows Server 2012 include enhancements to the following:
- Graphical user interface (GUI) – Windows Server 2012 was created with the Metro design language so it has the same look and feel asWindows 8 unless installed in Server Coremode. Administrators can switch betweenServer Core and the Server with a GUI options without a full reinstallation.
- Address management – Windows Server 2012 has an IP address management (IPAM) role for discovering, monitoring, auditing and managing the network’s IP address space.
- Hyper-V- Hyper-V 3.0 offers a scalable, virtual extensible switch that allows a virtual network to extend its functionality in ways that were difficult or impossible to achieve in previous versions.
- Active Directory – Several changes have been made to Active Directory. The PowerShell-based Deployment Wizard can work remotely, allowing administrators to promote cloud-based servers to domain controllers without the Wizard running on the server itself. Following the completion of this process, PowerShell scripts containing copies of commands used in the process can assist with the automation of additional domain controllers, allowing for large-scale Active Directory deployments.
SQL Server 2012 : Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 2012 comprises a set of programming extensions to enhance the Structured Query Language (SQL), a standard interactive and programming language for getting information from and updating adatabase.
Microsoft SQL Server 2012, which supplants SQL Server 2008 R2, offers new capabilities, notable among them the following.
- ColumnStore indexes: Read-only indexes that group data, streamlining the processing of large data warehouse queries.
- Support for Windows Server Core: This is a stripped-down version that places a far lower demand on computer resources than a full install does.
- PowerView: Makes it possible to generate mash-ups of business intelligence (BI) reports.
Enhanced Auditing: Users can customize their audit logs to accommodate a wider range of events with greater flexibility than was previously possible.
- AlwaysOn: Users can fail over multiple databases and read secondary copies, enhancing disaster recovery (DR) operations.
- Distributed Replay: A workload can be taken from a production server and played on another server to test it under realistic conditions before deploying it.
The original SQL Server code was developed by Sybase. In the late 1980s, Microsoft, Sybase, and Ashton-Tate collaborated to produce the first version of the product, SQL Server 4.2 for OS/2. Subsequently, both Sybase and Microsoft have offered SQL Server products.
Windows 7 : Windows 7 is the Microsoft Windows operating system released commercially in October 2009. In development, Windows 7 was known by the code names “Blackcomb” and “Vienna.”
- Windows 7 is built on the Vista kernel. To many end users the biggest changes between Vista and Windows 7 are faster boot times, new user interfaces and the addition of Internet Explorer 8. The OS is widely available in three retail editions: Windows 7 Home Premium, Professional and Ultimate. Starter, OEM and Enterprise editions are available in some markets.
- Windows 7 features:Direct Access for Mobile Workers – Allows IT administrators to update Group Policy settings and distribute software updates any time the mobile device has Internet connectivity, whether or not the user is logged on. DA supports multi-factor authentication and encryption.
- XP mode – Allows older applications designed for Windows XP to use a virtualized version of the XP operating system. To the end user, the applications seem to be running right on the Windows 7 desktop.
Windows 8 : Windows 8 is a Microsoft operating system that was released in 2012 as part of the company’s Windows NT OS family.
Windows 8 represents a major departure from previous versions of Windows because it is based on the Metro design language, which facilitates a touchscreen UI (user interface) similar to the ones found in mobile phones and tablet computers. Microsoft’s Surface tablet, released in early 2013, runs Windows 8.
The basic version of Windows 8, suitable for most users, works with touch screen devices as well as with traditional keyboard-and-mouse systems. A version called Windows RT supports the ARM processor architecture. Another version, Windows 8 Pro, is aimed at business and technical professionals who desire encryption, virtualization, PC management and domain connectivity.
The Windows 8 screen is tile-based, with each tile representing a specific app. The taskbar has no Start button, although users can bring up a Start screen by touching or clicking the lower-left corner of the display. The Windows 8 Release Preview contains a Metro version of Internet Explorer 10, along with apps for news, sports, and travel. It also offers an updated Windows Explorer, an updated Task Manager, and picture password capability.
Major features of the basic Windows 8 OS, in addition to the ones noted above, include:
- Upgrades from Windows 7
- Windows Store
- Connected standby
- Microsoft account
- Language switching “on the fly”
- Windows Update
- Windows Defender (anti-malware program)
- Support for multiple displays
- Mobile broadband capability
- Reset and refresh.