helpdesk_courses

MCSA: SQL Server 2012

MCSA: SQL Server is the Associate level SQL Server 2012 certification for Microsoft products and technologies.

This Skillsoft course will train you in everything you need to know to pass the three exams to earn the Associate level SQL Server 2012 certification. You'll need to sit the exams separately.


Ready to start?

Price: $3,300 AUD

At a glance

Study mode

laptop
Online

Provider

Skillsoft
Career Opportunities
Recognition

Globally recognised

Prerequisites

None

Location

Online

Course length
3 months
Study mode

Online


Online

Study from anywhere, when it suits you best and graduate with the identical qualification as an on-campus student.

Blended

Study part of the course online. Combine your online learning with classes or practical sessions on-campus at a college or university.

In-class

Attend classes on-campus at a university, TAFE or college and interact face-to-face with teachers and fellow students.

Assessment
Exams 70-461, 70-462, 70-463 (by external provider)
Start date

Enrol anytime.

Provider
Skillsoft

Skillsoft is the premier global provider of online IT and project management certification training courses.

If you want to be an expert of a particular software package or project management practice, a Skillsoft course will prepare you completely for the certification exam.

The certifications include Microsoft, Cisco, Oracle, Six Sigma, PRINCE2 and more.

Skillsoft's award-winning training method combines affordable computer-based training with the personal attention of instructor-led training.

Read more about
Skillsoft

What you'll learn

You'll learn how to:

  • Install and configure
  • Maintain instances and databases
  • Optimise and troubleshoot
  • Manage data
  • Implement security
  • Implement high availability
  • Design and implement a data warehouse
  • Extract and transform data
  • Load data
  • Configure and deploy SSIS solutions
  • Build data quality solutions
  • Create database objects
  • Work with data
  • Modify data
  • Troubleshoot and optimise

Course structure

23 units

  • Creating database objects
  • Querying basics and modifying data
  • Manipulate data using operators and functions
  • Creating functions and triggers
  • Creating programming objects and optimising queries
  • Managing XML data
  • Installation and upgrade
  • Instance configuration and database creation
  • Managing databases and automating tasks
  • Security management
  • Managing database data
  • Managing indexes, full-text search and partitions
  • Backing up and restoring databases
  • Database monitoring and performance tuning
  • Configuring high availability
  • Design and deployment
  • Create basic packages
  • ETL solutions
  • Enhancing packages
  • Custom components
  • Installing SSIS
  • Troubleshooting
  • DQS and MDS solutions

Recognition

Certification is awarded by Microsoft and is globally recognised. 

Ready to start?

  • Enrol in a few steps
  • Receive access to the course by email
  • Support is available as you study

Price: $3,300 AUD