Database Administrator with Oracle and Microsoft

ITonlinelearning

Program Description

Database Administrator with Oracle and Microsoft

ITonlinelearning

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 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 organisations behind your name.

Who is it for?

This course is ideal for anyone with aspirations to gaining a career as a Database Administrator. The average UK salary for a Database Administrator is £46,000 (ITJobswatch 2016).

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: Optimizing 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

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: Optimizing 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

There are no formal educational prerequisites to studying the courses included in this bundle.

This school offers programs in:
  • English


Last updated February 24, 2017
Duration & Price
This course is Online
Start Date
Start date
Open Enrollment
Duration
Duration
1 year
Part time
Full time
Price
Price
495 GBP
Information
Deadline
Locations
United Kingdom - Sittingbourne, England
Start date: Open Enrollment
Application deadline Request Info
End date Request Info
Dates
Open Enrollment
United Kingdom - Sittingbourne, England
Application deadline Request Info
End date Request Info