Currently Unavailable

Choice of MCSA/MCSE Online Courses with Live Chat Tutor Support from Online City Training (94% Off)

Online City Training

Select Option

Highlights

Participants can study a range of online modules with this MCSA/MCSE SQL Server 2012, MCSA Server 2012 or MCSE Server Infrastructure course

About This Deal

Choose from Four Options

  • £49 for an MCSA SQL Server 2012 online course with live chat tutor support (94% off)
  • £49 for an MCSA Server 2012 online course with live chat tutor support (94% off)
  • £49 for an MCSE SQL Server 2012 business intelligence online course with live chat tutor support (94% off)
  • £49 for an MCSE Server Infrastructure online course with live chat tutor support (94% off)

The syllabus of the MCSA SQL Server 2012 online course includes:

  • Using the Transact-SQL scripting language to build efficient queries, stored procedures and views that return key information quickly
  • Optimising T-SQL statements for the most efficient operation
  • Extending reporting and data transfer capabilities using XML exports
  • Installing and using add-on components, instances and services
  • Protecting information using database backup routines
  • Advanced data management techniques
  • Using SSIS to manage package execution, task execution and scripts
  • Maintaining server health using auditing, logging and event handling

See the full syllabus.

The syllabus of the MCSA Server 2012 online course includes:

  • Basic hardware and permissions configuration
  • Configuring key OS services
  • Using built-in security tools to restrict access to data
  • Improving data security and access
  • Monitoring and auditing servers to identify and resolve potential problems
  • Installing and managing Windows Server in a VM environment

See the full syllabus.

The syllabus of the MCSE SQL Server 2012 business intelligence online course includes:

  • How to work with large datasets across multiple platforms
  • Building OLAP cubes and supporting structures such as pivot tables, PowerPivot solutions and MDX to deliver information quickly and efficiently
  • Developing complex SQL queries to mine multiple datasets and building reports using Crescent
  • Designing BI solutions that meet current and future performance and scalability needs
  • Data analysis
  • Designing, deploying and managing SSIS packages to extend BI application functionality and expose more data for reporting and modelling

See the full syllabus.

The syllabus of the MCSE Server Infrastructure online course includes:

  • Configuring key operating system services
  • Using built-in security tools to restrict unauthorised access to data, applications and other key network resources
  • Simplifying server and patch deployment using images
  • Networking concepts such as VPNs, NPS and NAP
  • Installing and managing Windows Server in a VM environment
  • Managing file storage and data backups, and designing effective disaster recovery plans
  • Securing enterprise network resources against unauthorised access
  • Performing successful server upgrades and migrations
  • Designing and maintaining the networking infrastructure required to support enterprise-class IT demands, including the use of domain infrastructure, name resolution, IP configuration and address management
  • Designing a high-availability infrastructure and accompanying business continuity strategy that will help to reduce downtime in the event of a localised IT disaster

See the full syllabus.

Completion of any of these courses does not result in a degree or qualify participants to practice professionally.

Fine Print

Validity: Must redeem by 31 Dec 2019. Course content available for 12 months from registration date. 
Purchase: Limit 1 per person. May buy 3 additional as gifts. 
Restrictions:  Register online: http://www.onlinecitytraining.com/redeem-voucher. No refunds or cancellation once log in details have been provided. Internet connection required. Course log in details and instructions will be sent via email within 3 working days of redemption. Students must have basic literacy and numeracy skills. Must be 16 or older. Merchant's certificate of completion is included. Training will work on any flash-based PC or handheld device. For further compatibility information, please visit the merchant’s product page. No software included. Browser settings need to be changed when using a Mac. For more information please visit http://www.onlinecitytraining.com/faq. Valid on option purchased only.

About Online City Training

Online City Training offers courses for those looking to move into a different career, or just add another feather to their cap. Online topics are as far-ranging as IT, accounting and photography, while courses covering issues such as smoking cessation or weight management aim to help boost participants' lifestyle.

Groupon Customer Reviews

This deal doesn't have any written reviews yet.