Database Administrator with Oracle and Microsoft

Start your Database Administrator career here.



Enquire to get more info on pricing
Finance options

Interest-Free Finance Available

Study method
Online, self-paced
12 months
Access to content
1 year
Oracle Database 11g Administrator Certified Associate
MCSA: SQL Server 2012/2014
Professional certification What's this?
Additional info
  • Exam(s) / assessment(s) not included in price, and must be purchased separately

227 students enquired about this course

Add to basket or enquire

Enquire now


Which courses are included?

The Database Administrator with Oracle and Microsoft study bundle includes the Oracle Database 11g Certified Associate course as well as the Microsoft® accredited MCSA: SQL Server 2012 courses.

Database administration is a key role in any company as it involves the installation, configuration, upgrading, administration, monitoring, maintenance and security of an organisation’s databases.

The role also includes the developing and designing of database strategies, monitoring of systems, implementing database performance and capacity improvements, as well as ensuring that future expansion requirements are planned for. You may also be expected to plan, co-ordinate and implement security measures to ensure the safety of your organisation’s databases.

Adding these qualifications to your CV will see you become an in-demand professional with certifications from leading IT organisation's behind your name.


Oracle Database 11g Administrator Certified Associate
Awarded by Oracle
MCSA: SQL Server 2012/2014
Awarded by Microsoft


Oracle Database 11g Certified Associate course:

Based on the latest Oracle database, the internationally recognised Oracle Database 11g Certified Associate qualification will instil in the student the essential skills and knowledge needed to develop and maintain Oracle Database 11g environments. Upon achieving this certification you will have gained the ability to work in numerous database environments.

Oracle Database 11g Certified Associate Curriculum:

Part I – Oracle® Database 11g: SQL Fundamentals

  • Introducing SQL3
  • Using Single-Row Functions
  • Using Group Functions
  • Using Joins and Subqueries
  • Manipulating Data
  • Creating Tables and Constraints
  • Creating Schema Objects

Part II – Oracle® Database 11g: Administration

  • Introducing Oracle® Database 11g Components and Architecture
  • Creating an Oracle® 11g Database
  • Allocating Database Storage and Creating Schema Objectives
  • Understanding Network Architecture
  • Implementing Security and Auditing
  • Managing Data and Undo
  • Maintaining the Database and Managing Performance
  • Implementing Database Backups
  • Recovering the Database
  • Moving Data Using EM Tools

The Microsoft MCSA SQL 2012 courses:

The Microsoft Certified Solutions Associate SQL Server 2012 courses will provide you with the most recent skills and knowledge that is required to develop and maintain SQL Server 2012 environments. The SQL Server 2012 qualification will enable you to secure and maintain data, import, export and compress data, as well as monitor, troubleshoot and optimise databases.

The Microsoft MCSA SQL 2012 certification is also a prerequisite to certain MCSE (Microsoft Certified Solutions Expert) courses, opening up another dimension of career opportunities.

Microsoft MCSA SQL 2012 Curriculum:

Exam 70-461 Querying Microsoft SQL Server 2012

  • Lesson 1: Getting Started with SQL Server 2012
  • Lesson 2: Working with T-SQL
  • Lesson 3: Writing SELECT Queries
  • Lesson 4: Working with SQL Data Types
  • Lesson 5: Sorting and Filtering Data
  • Lesson 6: Querying Data from Multiple Tables
  • Lesson 7: Modifying Data
  • Lesson 8: Working with SQL Server Built-in Functions
  • Lesson 9: Programming in T-SQL
  • Lesson 10: Implementing Stored Procedures
  • Lesson 11: Working with Subqueries and Table Expressions
  • Lesson 12: Working with Set Operators, Conditional Operators and Window Functions
  • Lesson 13: Working with PIVOT, UNPIVOT and Grouping Sets
  • Lesson 14: Managing Error Handling and Transactions
  • Lesson 15: Querying SQL Server System
  • Lesson 16: Optimising Query Performance

Exam 70-462 Administering SQL Server 2012 Databases

  • Lesson 1: Identifying the SQL Server Platform
  • Lesson 2: Deploying SQL Server
  • Lesson 3: Configuring SQL Server
  • Lesson 4: Managing Databases in SQL Server 2012
  • Lesson 5: Managing SQL Server Security
  • Lesson 6: Implementing Advanced Security Settings
  • Lesson 7: Applying Encryption and Compression
  • Lesson 8: Working with Indexes and Log Files
  • Lesson 9: Working with Backup and Restore
  • Lesson 10: Implementing High Availability
  • Lesson 11: Optimizing Server Performance
  • Lesson 12: Troubleshooting Issues and Recovering Databases
  • Lesson 13: Performing Advanced Database Management Tasks

Exam 70-463 Implementing a Data Warehouse with SQL Server 2012

  • Lesson 1: Introduction to Data Warehouse
  • Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
  • Lesson 3: Creating Fact Tables and Column Store Indexes
  • Lesson 4: Implementing Data Warehouse in SQL Server 2012
  • Lesson 5: Working with Integration Services
  • Lesson 6: Managing Control Flow
  • Lesson 7: Working with Dynamic Variables
  • Lesson 8: Implementing Data Flow
  • Lesson 9: Managing Data Flow
  • Lesson 10: Managing SSIS Package Execution
  • Lesson 11: Debugging and Troubleshooting
  • Lesson 12: Deploying Packages
  • Lesson 13: Securing Packages and Databases
  • Lesson 14: Working with MDS and Windows

Who is this course for?

This course is ideal for anyone with aspirations to gaining a career as a Database Administrator. Feel free to contact our Course and Career Advisors to enquire about our free demos. This will give you an exact idea of how our superior training is delivered to you.


There are no prerequisites to studying the Oracle Database 11g Certified Associate or The Microsoft MCSA SQL 2012 courses.

Career path

  • Database Administrator
  • Database Developer
  • Junior Database Administrator

Questions and answers


Currently there are no reviews for this course. Be the first to leave a review.


What does study method mean?

Study method describes the format in which the course will be delivered. At courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.


Mobile Navigation