0% Interest on finance options up to 12 months

Black Friday Sale On Selected Courses

1Course Overview

MCSA SQL Server

Course code: LE004

Pay up front:

£279.00

Save £150 by
paying up front

Free UK delivery

Looking to crack into the world of computing 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 50,000 students who have chosen Open Study College to improve their career prospects.

Black Friday discounts on selected courses - Until 23rd November
2Course Content

Course Content

Microsoft Exam 70-461: Querying Microsoft SQL Server 2012 
  • Introduction to SQL Server 2012
  • T-SQL Overview 
  • SELECT Statements
  • Filtering
  • Join and Set Operators 
  • Subqueries and Table Expressions
  • Functions 
  • T-SQL Programming
  • Transactions 
  • Query Performance
Microsoft Exam 70-462 - Administering Microsoft SQL Server 2012
  • Introduction to SQL Server 2012 
  • Installing SQL Sercer
  • 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
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
3Other Information

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. Fun quizzes and exam simulations after each module reinforce your confidence and aid progression to the next stage. This course also includes the use of social networking forums so you chat and gain friendly advice and support from other students. 

Course Outcomes

Upon successful completion of each of the courses in this bundle, you will receive a Learn365 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. 

4Q&As

Course Questions & Answers

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.

Are there any additional costs?

No. Everything you need is included in the price!

What do i do if i still have questions?

For further information please contact us.

Additional Discounts Available on selected courses until 23rd November
  • Days
  • Hours
  • Mins
  • Secs

Finance options

Provided by
Duration Of Your Repayment
Your Deposit
Monthly payment:

Deposit to pay:

  • Cash Price:
  • Loan Amount:
  • Loan Repayments:
  • Cost of Loan:
  • Number of Monthly Payments:
  • Total Amount Payable:

Only available to UK residents over 18 and in part or full-time employment subject to terms and conditions.

Rates of finance offered in this calculator are based on this specific product and can be applied for once this item has been added to the basket. When adding multiple items to the basket it is possible that promotional rates may change or that non-financeable products will be added to your deposit in full, depending on the items added.