Basic to Advanced
Database Developer
Training Package
- Contact UsView Certifications
- The cornerstone for Database Development certifications.
Would you like us to send you information on this certification and be informed of any future updates and retirements?
Certification summary
The Database Developer learning package involves a mixture of both courseware and exam-based assignments, including Database Fundamentals and more sophisticated modules such as the Oracle database programmes and the SQL server pathways, including querying, administering and implementing SQL databases. If you wish to learn how to apply specific database tools, techniques and concepts as well as using methods for managing successful databases to improve the way you can contribute value towards your business, then please read on.
Course summary
All the following modules are covered within this course package:
MTA - Database Fundamentals
Courseware - Oracle 10g
Courseware - Oracle 11g
Courseware - Oracle Database SQL Expert
MCSA - SQL Server 2012
70-461 - Querying Microsoft SQL Server 2012
70-462 - Administering Microsoft SQL Server 2012 Databases
70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012
A closer look...
The first part of this package includes the fundamentals and understanding of accessing databases. Once this understanding has been achieved, students may then progress onto the area of Oracle certifications which inlcudes how to resitrct and sort data within an Oracle environement; using both single and group functions for customizing output as well as displaying data from multiple areas and manipulating various data sets.
Lastly, this package focuses heavily on SQL (Structured Query Language) and concerns Microsoft certifications. In today's digitalized world with massive amounts of data being gathered every day and stored into a database, knowing how to program with SQL is imperative. Whether you're a marketer or an aspiring developer, SQL is a great language to learn and is the vital asset in understanding how to access databases.
Career & Job Opportunities
Our Database Developer training course is an internationally recognised SQL qualification. It's the only
performance-based certification that validates the skills needed in order to obtain the best value out of your business. The
Database Developer role has an average wage of £50,078pa in the UK (as of currently 2015).
Below are some of the lucrative careers available associated with this certification:
- Data Analyst
- Database Administrator (DBA)
- Senior Business Analyst
- Senior Data Analyst
- Senior Software Engineer
- Information Technology Consultant
Start the Database Developer Package with a trial
We are offering a trial of this course for free with no purchase necessary, just sign up below to instantly receive your login details.
We will work with you to ensure that you can find work in IT after completing your Database Developer course
Working with JobcentrePlus and our Recruitment Partners across the UK, we will work with you to ensure that you can find work in IT (an not in any job) through job interviews and applications. We aim to get you in an IT job role on completion of your Database Developer course package. If you have no qualification or background in IT, we will provide you with the necessary training for the experience required. For existing Database Developer specialists, we can upgrade your qualifications and improve your career prospects. Do not allow your lack of experience or self-confidence deny you from a career in I.T - it is a lot easier (and enjoyable too) than most people think, once you learn the basics.
- ↘ Take on a new adventure with the Database Developer interactive video demos
- ↘ Contact us about our Database Developer student placement service
Promotions. Gain access to the Database Developer learning library for 10 days.
If your aim is employment/career advancements through IT training, see how you can achieve this together with your tutor.
84.70%
The exams and courseware
The Database Developer Package involves the latest generation in the Database learning technology and as such there is no current retirement plan for its exams. Below is a breakdown of the exams and courseware for these certifications and how they are made up.
Database Fundamentals
98-364
This course is set out in the following modules:
- Understanding core database concepts.
- Create database objects.
- Manipulate Data.
- Understand Data Storage.
- Administer a Database.
SQL Database Fundamentals
Microsoft Technology Associate Exam 98-364 helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. Here are the percentages that make up the final mark for this exam using these technical tasks:
- Understanding core database concepts (20-25%)
- Understand how data is stored in tables
- Understand relational database concepts
- Understand data manipulation language (DML)
- Understand data definition language (DDL)
- Create database objects (20-25%)
- Choose data types
- Understand tables and how to create them
- Create views
- Create stored procedures and functions
- Manipulate Data (25-30%)
- Select data
- Insert data
- Update data
- Delete data
- Understand data storage (15-20%)
- Understand normalization
- Understand primary, foreign, and composite keys
- Understand indexes
- Administer a database (10-15%)
- Understand database security concepts
- Understand database backups and restore
Try this course online, login via providing some basic student details below
Oracle Database 10g
New Space Management Features
This course is set out in the following modules:
- Installation of Oracle 10G.
- Create an Oracle Database.
- Interfaces for Accessing an Oracle Database.
- Taking Control.
- Storage Structures.
Oracle Database 10g
Oracle Database 10g was the first database designed for grid computing, the most flexible and cost-effective way to manage enterprise information. It cut costs of management while providing the highest possible quality of service. This exam measures your ability to accomplish the technical tasks listed:
- Installation of Oracle 10G
- 10G Install
- Configuration and Setup
- Install Oracle
- Switch the Oracle Home
- Review Questions
- Create an Oracle Database
- DBCA
- Create an Oracle Database
- Review Questions
- Interfaces for Accessing an Oracle Database
- SQL+ and ISQL+
- ISQL+ Interface
- Structured Query Language
- Transactions
- Use ISQL PLUS
- Use SQL PLUS
- Taking Control
- Starting and Stopping iSQL Plus
- Controlling Oracle
- Review Questions
- Storage Structures
- Tablespaces and Data Files
- Review Questions
- Database Users
- Database Accounts, Permissions and Roles
- Create an Oracle
- Review Questions
- Schema Objects
- Tables and Constraints
- Review Questions
- Data Management
- Data Pump
- SQL Loader
- Summary
- Export Data
- Import Data
- Review Questions
- PL/SQL
- PL/SQL Demo
- Summary
- Review Questions
- Security
- GUI Security
- Auditing
- Summary
- Create a User Profile
- Review Questions
- Oracle Networking
- Oracle Home
- Listener Command Line
- TNSping and Listener Control
- Summary
- Network Configuration
- Shared Servers
- Shared Server Connections Setup
- Summary
- Check Shared Servers
- Review Questions
- Database Performance
- ADDM
- Gather Optimizer Statistics
- Summary
- Performance Graphs
- Review Questions
- Proactive Maintenance
- Metric Baseline Setup
- Tuning and Diagnostic
- Advisors
- AWR
- Summary
- Enterprise Manager Advisors
- Review Questions
- Managing Undo
- Undo Advisor
- Summary
- Review Questions
- Detecting Locks
- Locks
- Problems
- Deadlocks
- Summary
- Blocking Sessions
- Deadlocks
- Review Questions
- Backup and Recovery
- Instance Recovery
- Tuning Instance Recovery
- Multiplexing and Archive Log Mode
- Summary
- Review Questions
- Backups
- RMAN
- Summary
- Database Backup
- Review Questions
- Recovery
- Recover Lost Files Demo
- Summary
- Database Recovery
- Review Questions
- Advanced Topics
- The /ETC Directory
- Controlling Oracle
- Oracle Scripts
- Creating Groups
- DOT Profile
- Installing 2nd Release of Oracle
- Creating Scripts
- Creating RMAN Repository
- Summary
- Review Questions
- Final Review
- Exam Preparation and Closing
- Review Questions
Try this course online, login via providing some basic student details below
Oracle Database 11g
Certified Associate
This course is set out in the following modules:
- Database Architecture
- Installing the Oracle Software
- Creating an Oracle Database
- The Oracle Instance
- Oracle Network Environment
Oracle Database 11g
The next generation of the world's most popular database. Oracle Database 11g is a database platform that is easy to develop, deploy and distribute and is simple to administer. This exam measures your ability to accomplish the technical tasks listed:
- Database Architecture
- Architectural Components of the Oracle Database
- Memory Structures
- Server Processes and Background Processes
- Logical and Physical Storage Structures
- Module Summary
- Review Quiz
- Installing the Oracle Software
- Database Administrator Tasks and Tools
- Planning an Oracle Database Installation
- Using Optimal Flexible Architecture
- Installing the Oracle Software using OUI
- Module Summary
- Review Quiz
- Generic Concepts
- Utility and warranty
- Assets, resources and capabilities
- Service portfolio
- Service catalogue (both two-view and three-view types)
- Governance
- Business case
- Risk management
- Service provider
- Supplier
- Service level agreement (SLA)
- Operational level agreement (OLA)
- Underpinning contract
- Service design package
- Availability
- Service knowledge management system (SKMS)
- Configuration item (CI)
- Configuration management system
- Definitive media library (DML)
- Change
- Change types (standard, emergency and normal)
- Event
- Alert
- Incident
- Impact, urgency and priority
- Service request
- Problem
- Workaround
- Known error
- Known error database (KEDB)
- The role of communication in service operation
- Release policy
- Types of services
- Change proposals
- CSI register
- Outcomes
- Patterns of business activity
- Customers and users
- The Deeming Cycle (plan, do, check, act)
- Key Principles and Models
- Describe value creation through services
- Understand the importance of people, processes, products and partners for service management
- Understand the five major aspects of service design
- Explain the continual service improvement approach
- Understand the role of measurement for continual service improvement
- Selected Processes
- Service portfolio management
- Financial management for IT services
- Business relationship management
- Service level management (SLM)
- Service catalogue management
- Availability management
- Information security management (ISM)
- Supplier management
- Supplier management
- Capacity management
- IT service continuity management
- Design coordination
- Change management
- Release and deployment management
- Knowledge management
- Service asset and configuration management (SACM)
- Transition planning and support
- Incident management
- Problem management
- Event management
- Request fulfilment
- Access management
- Selected Functions
- Explain the role, objectives and organizational structures for the service desk function
- State the role and objectives of the The technical management function
- The application management function
- The IT operations management function (IT operations control and facilities management)
- Selected Roles
- Account for the role and the responsibilities of the process owner, process manager, process practitioner
- Recognize the responsible, accountable, consulted, informed (RACI) responsibility model and explain its role in determining organizational structure
- Technology and Architecture
- Understand how service automation assists with expediting service management processes
- ITIL Qualification Scheme
- Competence and skills for service management
- Competence and skills framework
- Training
Try this course online, login via providing some basic student details below
Oracle Database SQL Expert
Courseware
This course is set out in the following modules:
- Introduction to Oracle SQL.
- Select Statements.
- Where and Order By Clauses.
- Single Row Functions.
- Group Functions.
Oracle Database SQL Expert
This course uses engaging activity screens, questions and assessments in conjunction with videos and animations which set the scene for fun, interactive learning. Students will work through real-world management challenges and will learn how to overcome them. Authentic screenshots, interactive activities and videos feature throughout. The training is delivered through a secure, privacy controlled application, so you can jump in and out of any course whenever you sign in.
This course measures your ability to accomplish the technical tasks listed:
- Introduction to Oracle SQL
- Relational Database Systems
- Examining SQL
- SQL Developer and SQL Plus
- Examining the Database and Schema
- Module Summary
- Select Statements
- Basic Select Statements
- Selecting Columns and Using Arithmetic Operators
- Operator Precedence
- Concatenation Operator
- Displaying the Table Structure
- Module Summary
- Review Quiz
- Where and Order By Clauses
- Implementing the Where Clause
- Comparison Operators
- Logical Operators
- Rules of Prcedence
- Substitution Variables
- Module Summary
- Review Quiz
- Single Row Functions
- Types of Single Row Functions
- Working with Dates
- Module Summary
- Review Quiz
- Group Functions
- Types of Group Functions
- Creating Groups of Data
- Multi Column Grouping
- Module Summary
- Review Quiz
- Joins
- Natural Joins
- Nonequijoins and Outer Joins
- Cartesian Joins
- Module Summary
- Review Quiz
- Sub-Queries
- Single Row Subqueries
- Multiple Row Subqueries
- Null Values
- Module Summary
- Review Quiz
- Set Operators
- Union and Union All Operators
- Intersect and Minus Operators
- Select Statements and the Order By Clause
- Module Summary
- Review Quiz
- Data Manipulation Language
- Insert Statements
- Update Statement
- Delete Statement
- Database Transactions
- Module Summary
- Review Quiz
- Data Definition Language
- Creating Tables
- Data Types and Constraints
- Altering a Table Statement
- Module Summary
- Review Quiz
- Schema Objects
- Views
- Sequences
- Indexes
- Synonyms
- Module Summary
- Review Quiz
- User Privileges
- Creating a User
- System Privileges
- Role and Object Privileges
- Granting and Revoking Privileges
- Module Summary
- Review Quiz
- Schema Objects
- Altering a Table
- Adding Constraints
- Dropping Constraints
- Indexes
- Dropping Tables and Flashback Table
- Create and Use External Tables
- Module Summary
- Review Quiz
- Oracle Data Dictionary Views
- Using the Oracle Data Dictionary
- Types of Views and Querying the Data Dictionary
- View Information
- Module Summary
- Review Quiz
- Large Data Sets
- Using Subqueries
- Default Values and Copying Rows
- Multi Table Insert
- Merge Statement
- Flash Back Version Query
- Module Summary
- Review Quiz
- Time Zones
- Time Zone Functions
- Time Stamp Data Types
- Interval Data Types
- Available Functions
- Module Summary
- Review Quiz
- Advanced Sub-Queries
- Pairwise and Nonpairwise Comparison Queries
- Scalar Subquery
- Correlated Subquery
- Exist Operator and With Clause
- Module Summary
- Review Quiz
- Regular Expressions
- Using Regular Expressions
- Using Subexpressions and Check Constraint Expressions
- Module Summary
- Review Quiz
- Course Review
Try this course online, login via providing some basic student details below
SQL Server 2012
MCSA
This course is set out in the following modules:
- Create Database Objects.
- Work with Data.
- Modify Data.
- Troubleshoot and Optimize.
SQL Server 2012
This exam measures your ability to accomplish the technical tasks listed: Create database objects, Work with data, Modify data, Troubleshoot and optimize. Here are the percentages that make up the final mark for this exam using these technical tasks:
- Create database objects (24%)
- Create and alter tables using T-SQL syntax (simple statements)
- Create and alter views (simple statements)
- Design views
- Create and modify constraints (simple statements)
- Create and alter DML triggers
- Work with data (27%)
- Query data by using SELECT statements
- Implement sub-queries
- Implement data types
- Implement aggregate queries
- Query and manage XML data
- Modify data (24%)
- Create and alter stored procedures (simple statements)
- Modify data by using INSERT, UPDATE, and DELETE statements
- Combine datasets
- Work with functions
- Troubleshoot and optimize (25%)
- Optimize queries
- Manage transactions
- Evaluate the use of row-based operations vs. set-based operations
- Implement error handling
Try this course online, login via providing some basic student details below
Querying SQL Server 2012
70-461
This course is set out in the following modules:
- Install and Configure.
- Maintain instances and Databases.
- Optimize and Troubleshoot.
- Manage Data.
- Implement Security.
Querying SQL Server 2012
This exam measures your ability to accomplish the technical tasks listed: Install and configure, Maintain instances and databases, Optimize and troubleshoot, Manage data, Implement security, Implement high availability. Here are the percentages that make up the final mark for this exam using these technical tasks:
- Install and configure (19%)
- Plan installation
- Install SQL Server and related services
- Implement a migration strategy
- Configure additional SQL Server components
- Manage SQL Server Agent
- Maintain instances and databases (17%)
- Manage and configure databases
- Configure SQL Server instances
- Implement a SQL Server clustered instance
- Manage SQL Server instances
- Optimize and troubleshoot (14%)
- Identify and resolve concurrency problems
- Collect and analyse troubleshooting data
- Audit SQL Server instances
- Manage data (19%)
- Configure and maintain a back-up strategy
- Restore databases
- Implement and maintain indexes
- Import and export data
- Implement security (18%)
- Manage logins and server roles
- Manage database permissions
- Manage users and database roles
- Troubleshoot security
- Implement high availability (12%)
- Implement AlwaysOn
- Implement database mirroring
Try this course online, login via providing some basic student details below
Administering Microsoft SQL Server 2012 Databases
70-462
This course is set out in the following modules:
- Introduction to SQL Server 2012.
- Installing SQL Server.
- Backup and Restore a Database.
- Tracing Access to SQL Server.
- Importing and Exporting Data.
Administering Microsoft SQL Server 2012 Databases
This course uses engaging activity screens, questions and assessments in conjunction with videos and animations which set the scene for fun, interactive learning. Students will work through real-world management challenges and will learn how to overcome them. Authentic screenshots, interactive activities and videos feature throughout. The training is delivered through a secure, privacy controlled application, so you can jump in and out of any course whenever you sign in.
This course measures your ability to accomplish the technical tasks listed:
- Introduction to SQL Server 2012
- SQL Server
- SQL Server Tools
- Management Studio Demo
- Data Tools
- Exam Scenarios
- Module Review
- Installing SQL Server
- SQL Architecture
- Hardware Requirements
- Software Requirements
- Installing Process
- Troubleshooting Installation
- Upgrading and Unattended Installations
- Configuration Demo
- Exam Scenarios
- Module Review
- Backup and Restore a Database
- Database Architecture
- Database Backup
- Restoration Process
- Restoring System Database
- Backup and Recovery Demo
- Exam Scenarios
- Module Review
- Tracing Access to SQL Server
- Auditing Options
- Introduction to SQL Audit
- Audit Objects and Implementation
- Extended Events
- Tracing Activity Demo
- Exam Scenarios
- Importing and Exporting Data
- Introduction to Data Transfer
- ETL Tools
- Improving Data Transfer
- Copying Database Methods
- Transferring Data Demo
- Exam Scenarios
- Module Review
- SQL Server Security
- Security and Authentication
- Server and Database Roles
- Permissions
- Securing SQL Server Demo
- Exam Scenarios
- Module Review
- Automating SQL Server
- SQL Server Agent
- Database Mail
- Operators, Alerts and Jobs
- Database Configuration Demo
- Exam Scenarios
- Module Review
- Monitoring SQL Server
- Dynamic Management Views and Functions
- Profiler Trace
- Database Tuning Advisor
- Activity and Performance Monitor
- Data Collection
- Monitoring Demo
- Exam Scenarios
- Module Review
- Maintaining SQL Server
- Checking Database Integrity
- Indexing
- Ongoing Maintenance
- Managing and Maintaining Demo
- Exam Scenarios
- Module Review
- Troubleshooting SQL Server
- Service Issues
- Connectivity Issues
- Locking Issues
- Troubleshooting Demo
- Exam Scenarios
- Module Review
- Program Review
Try this course online, login via providing some basic student details below
Implementing a Data Warehouse with Microsoft SQL Server 2012
70-463
This course is set out in the following modules:
- Introduction to Data Warehousing.
- Designing a Data Warehouse.
- ETL with SSIS.
- SSIS Control Flow.
- Troubleshooting Packages.
Implementing a Data Warehouse with Microsoft SQL Server 2012
This course uses engaging activity screens, questions and assessments in conjunction with videos and animations which set the scene for fun, interactive learning. Students will work through real-world management challenges and will learn how to overcome them. Authentic screenshots, interactive activities and videos feature throughout. The training is delivered through a secure, privacy controlled application, so you can jump in and out of any course whenever you sign in.
This course measures your ability to accomplish the technical tasks listed:
- Introduction to Data Warehousing
- OLTP vs. OLAP
- Data Warehouse
- Data Warehouse Architecture
- Creating a Data Warehouse
- Presenting OLAP Data
- OLTP and OLAP Comparison Demonstration
- Exam Scenarios
- Module Review
- Designing a Data Warehouse
- Data Modelling
- Data Warehouse Schemas
- Time Dimensions
- Data Modelling Considerations
- Implementing a Data Model
- Logical Model
- Physical Model
- Dimensions and Facts
- Exam Scenarios
- Module Review
- ETL with SSIS
- Introduction to SSIS
- Upgrading SSIS Packages
- SSIS Tools
- Data Flow Tasks
- Data Sources
- Transformations
- Utilizing SQL Server Data Tools
- Data Flow Task
- Exam Scenarios
- Module Review
- SSIS Control Flow
- Control Flow Tasks
- Integration Services Variables
- Expressions
- Precedence
- Containers and Annotation
- Transactions
- Checkpoints
- Control Flow Tasks and Precedence
- Exam Scenarios
- Module Review
- Troubleshooting Packages
- Overview of Troubleshooting
- Debugging
- Breakpoints
- Error Handling
- SSIS Log Providers
- Custom Logging
- Troubleshooting and Logging
- Exam Scenarios
- Module Review
- Advanced Packages
- Maintaining a Data Warehouse
- Change Data Capture
- Slowly Changing Dimensions
- Script Components
- Incremental Updates
- Exam Scenarios
- Module Review
- Data Quality Services
- Introduction to Data Quality Services
- Data Quality Services Components
- Working with Data Quality Services
- Exam Scenarios
- Module Review
- Master Data Services
- Introduction to Master Data Services
- MDS vs. DQS
- How MDS Works
- Exam Scenarios
- Module Review
- Deployment and Security
- Deployment Options
- Package Deployment
- Securing Packages
- Deploying SSIS Packages and Projects
- Exam Scenarios
- Module Review
- Program Review
Try this course online, login via providing some basic student details below
Buy the Database Developer learning package at £1960.
Includes all eight courses shown above.
Buy the Database Developer Learning Package without Exams
Buy the Database Developer learning package at £2170 with exams.
Includes all eight courses shown above including the official MTA Database Fundamentals examination.
Buy the Database Developer Learning Package with 1 Exam
This course is suitable for...
School leavers
A fun and enjoyable way to build a fresh career
Teachers & IT professionals
A prestigious qualification which will distinguish you from the crowd of 21st century geeks
Anyone else...
Looking to start a healthy, rewarding & lucrative career in I.T
But is this course right for you?
Will it provide you with the skills that you need, or the career you'd like to explore? If you are not 100% sure that it's correct for you then we highly recommend that you experience our trial courses and assessments to get an accurate insight to the Database Developer Package and its certifications. You can sign up for this below or use it to ask our lecturers some questions. You can also call us on 0800 622 69 69 and speak to one of our course advisers and they will help you choose the perfect certification tailored to your needs.
More Information
Request more info on the Database Developer Package
Exam tips and syllabus
Get the Database Developer Package exam syllabus aswell as helpful tips
What our students say
See what our students have to say about the Database Developer Package