Skillsoft
Skillsoft

MCSA: SQL Server 2012

Course description

Duration

duration

2 yrs

Study mode

studyMode

Online

Start date

date

Enrol anytime. Have a question about this course? Contact the course provider.

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.


Course details

Entry requirements

None

Recognition
Location
Online
Start dates
Enrol anytime. Have a question about this course? Contact the course provider.
Duration
Self paced. 52 hours (e.g. 8 hours a week = finish in 7 weeks). Complete within 2 years.
Study mode
Online
Education institution
Skillsoft
Price
The course price can vary depending on a few factors, including your citizenship or whether you have completed any other courses. To find out more, contact the course provider.
Payment options
Credit cardsSSL Security
You can pay for this course upfront securely online via credit card.

Ready to start?

Skillsoft

MCSA: SQL Server 2012

  1. Enrol in a few steps and pay via credit card
  2. Receive access to the course by email
  3. Support is available as you study
Enrol now
Price: $1,795AUD (GST Exempt)

Career insights

Explore roles related to this qualification

Course content

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

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

Recognition

Certification is awarded by Microsoft and is globally recognised. 

Payment options

There is 1 way you can pay for this course:

Upfront payment
Credit cardsSSL Security

You can pay for this course upfront securely online via credit card.

Ready to start?

Skillsoft

MCSA: SQL Server 2012

  1. Enrol in a few steps and pay via credit card
  2. Receive access to the course by email
  3. Support is available as you study
Enrol now
Price: $1,795AUD (GST Exempt)

Undecided about this course?

Browse courses by area of interest