MCSA SQL Server

Course code: LE004
Scroll to section...
Enrol now
Course overview
Course content
Extra info
Q&As

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.
This course is only available to study online.
Request a call back
Trustpilot
Course overview

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.

Course content
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
  • 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
  • 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
Extra info

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.

Q&As

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

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.

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.

You may also like

MOS Powerpoint 2019 and 365 Associate

MOS Powerpoint 2019 and 365 Associate

Single course

£219.00

View Course
MOS Access 2019 and 365 Expert

MOS Access 2019 and 365 Expert

Single course

£239.00

View Course
MOS Outlook 2019 and 365 Associate

MOS Outlook 2019 and 365 Associate

Single course

£219.00

View Course
Enrol now

If you are interested in and you’re looking for a more flexible approach to learning that fits around your life - this is the ideal course for you. Enrol online today by clicking below or speak to one of our advisers for more information.

Enrol on this course