MCSA SQL Server

Course code: LE004

Crack into the world of database development with this MCSA: SQL Server certification qualification.

Learn the fundamentals of SQL Server 2012.
Learn how to automate, monitor, maintain and troubleshoot an SQL server.
Learn how to install and trace access to a database.
Learn how to implement a data warehouse.

Course Options	Please choose a course option to see prices	Course Material
Study Options	This course is only available to study online.
Payment Options	Pay Upfront Pay Monthly Pay Monthly is not available in your currency.

Request a call back

Looking to crack into the world of database development?

With this course under your belt, there’s no stopping your career within the IT industry!

This MCSA: SQL Server certification qualification will enable you to qualify for a variety of IT database roles such as a database developer or database analyst.

With the flexibility to study at your own pace, you can qualify within a matter of weeks or months, without the stress of deadlines or timetabling. Enrol today and join the 90,000 students who have chosen Open Study College to improve their career prospects.

Course Duration

Up to 1 year.

Study Hours

Approximately 80 hours.

Course Outcome

MCSA SQL Server Certificate of Completion. You can choose to take your exams to receive the full qualification!

Entry Requirements

There are no specific entry requirements for this course.

Assessment

Exam simulations after each module.

Unit 1

Microsoft exam 70-461: Querying Microsoft SQL Server 2012

Introduction to SQL Server 2012
T-SQL Overview
SELECT Statements
Filtering
Join and Set Operators
Sub queries and Table Expressions
Functions
T-SQL Programming
Transactions
Query Performance

Unit 2

Microsoft Exam 70-462 - Administering Microsoft SQL Server 2012

Introduction to SQL Server 2012
Installing SQL Server
Backup and Restore a Database
Tracing Access to SQL Server
Importing and Exporting Data
SQL Server Security
Automating SQL Server
Monitoring SQL Server
Maintaining SQL Server
Troubleshooting SQL Server

Unit 3

Microsoft Exam 70-463 - Implementing a data warehouse with Microsoft SQL Server

Introduction to Data Warehousing
Designing a Data Warehouse
ETL with SSIS
SSIS Control Flow
Troubleshooting Packages
Advanced Packages
Data Quality Services
Master Data Services
Deployment and Security

Assessment

Fun quizzes and exam simulations after each module reinforce your confidence and aid progression to the next stage. Please note in order to achieve the official qualification you will have to successfully complete a Microsoft exam. This will be at an additional cost and It is your own responsibility to pay for these.

Course Duration

With this flexible home learning course you can fast-forward, rewind or repeat all the online classes so you can go at your own pace with no strict deadlines. Two weeks or twelve months, it’s completely up to you.

Study Method

This blended learning solution offers a highly interactive and engaging learning environment with video demonstrations, multimedia presentations and educational games to assist with your study. This course also includes the use of social networking forums so you chat and gain friendly advice and support from other students.

Course Outcome

Upon successful completion of each of the courses in this bundle, you will receive a certification of completion so you can showcase your achievement to future employers. Please note in order to achieve the official qualification you will have to successfully complete a Microsoft exam. This will be at an additional cost and It is your own responsibility to pay for these.

Awarding body

Microsoft has certification paths for many technical job roles. Each of these certifications consists of passing a series of exams to earn certification.

What skills do I need to enrol onto this course?

No previous knowledge is required to enrol onto this course, just a basic knowledge of IT.

What is included in the cost of my course?

Dedicated student support
FREE CV critique service
FREE employability guide to help you impress future employers
FREE XO Student Discounts card

Are there any additional costs?

To receive the full certification from Microsoft you will need to sit an exam, at the cost of around £100 at a Pearson Vue centre.

What if I still have questions?

That's not a problem. We want to make sure you’re 100% confident about enrolling on the course and starting your study. So, just give our Student Adviser Team a call on 03300 563 100 and they’ll do their best to help.