Microsoft MCSA: SQL 2012 Certification Bundle

MCSA Distance Learning Course Logo

Course Details

Microsoft SQL Server is a cloud-ready information platform that will help organisations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.

This course includes the following features:

  • Instructor-led demonstrations and visual presentations to develop your skills based on real world scenarios.
  • Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.
  • Flash Cards and Education Games are also provided throughout the course.
  • Practice exams prepare you for your exams. These exams are on average 100 questions to ensure you are 100% prepared if you are taking a certification exam.
  • You can also interact and collaborate with other students through our forums, student contributions and announcement features.
Who should complete this course?
  • The course is suited to the following IT roles: Database Analyst, Infrastructure Engineer, Technical Support, Database Developer, Network Engineer, Service Analyst, Support Engineer, Administrator.
Entry Requirements / Prerequisites
  • You must have a basic working knowledge of Microsoft Windows and access to the internet to complete the course.
How CMIT eLearning Works…

Topics covered in this Course

This exam is intended for SQL Server database administrators, implementers, system engineers, and developers. Primary responsibilities for this role may include but are not limited to:

  • Apply built-in scalar functions.
  • Apply ranking functions.
  • Combine datasets.
  • Create and alter DML triggers.
  • Create and alter indexes.
  • Create and alter stored procedures.
  • Create and alter tables.
  • Create and alter user-defined functions (UDFs).
  • Create and alter views.
  • Create and modify constraints.
  • Design T-SQL stored procedures.
  • Design views.
  • Implement aggregate queries.
  • Implement data types.
  • Implement error handling.
  • Implement subqueries.
  • Implement the sequence generator.
  • Manage transactions.
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Modify data by using MERGE statements.
  • Optimize queries.
  • Query and Manage XML data.
  • Query data by using SELECT statements.
  • Return data by using the OUTPUT clause.
Assessment
  • Following successful completion of the course, you will receive a Certificate in SQL Server 2012 from CMIT.
  • You may optionally take exams to receive MCSA  SQL Server 2012 certification. This is assessed through multiple choice exams (70-461, 70-462, 70-463). Exam fees are not included in the course price.
Technical Requirements
  • Broadband internet connection of at least 10Mbps.
  • Browser – we recommend Chrome or Safari for Tablet or Apple Mac; and Firefox or Internet Explorer for PC hardware.
  • Operating System – PC (Windows 7 or later), Mac or Android.
Accreditation
  • Following completion of the online assessment, you will receive a Certificate in MCSA  SQL Server 2012 from College of Management and IT (CMIT).
  • You may optionally take exams to receive MCSA  SQL Server 2012 certification. This is assessed through multiple choice exams (70-461, 70-462, 70-463). Exam fees are not included in the course price.
  • This programme does not lead to an award in the Irish National Framework of Qualifications (NFQ).
  • Click here for Accreditation Details
Student Reviews of this Course
{{ reviewsOverall }} / 5 Users (0 votes)
Rating0
What students say... Leave your rating
Order by:

Be the first to leave a review.

Verified
{{{review.rating_comment | nl2br}}}

Show more
{{ pageNumber+1 }}
Leave your rating