Skillsoft
Skillsoft

MCSA: SQL Server 2012

Course description

Duration

duration

52 hrs

Study mode

studyMode

Online

Next start date

date

Anytime

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.


Campus options

1 campus available

CampusStudy modeDurationNext start date
Online

Online (self paced)

52 hrs

Anytime

Course details

Entry requirements

None

Recognition
Location
Online
Next start date
Anytime
Duration
52 hrs
Study mode
Online
Education institution
Skillsoft
Price
$1795
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)

Course content

  • 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)