ADVANCE YOUR CAREER. TRANSFORM YOUR LIFE WITH IN-DEMAND SKILLS FOR AN ON.DEMAND WORLD. EARN MINIMUM £50K WITH YOUR ORACLE AND MICROSOFT DATABASE SKILLS.


EXCELLENT SELF-TEACH TRAINING COURSE . IDEAL FOR ORACLE AND MICROSOFT DATABASE DEVELOPERS & ADMINISTRATORS, OLAP AND ANALYTICS CONSULTANTS.  ALSO GOOD FOR ON THE JOB TRAINING OR THOSE PREPARING FOR ORACLE AND MICROSOFT BI CERTIFICATION EXAMS; AS WELL AS THOSE WHO WORK WITH OTHER DATABASE TOOLS LOOKING TO CROSS SKILL/UPSKILL TO A ORACLE AND MICROSOFT ENVIRONMENT.


PERFECT TRAINING MATERIAL WITH REAL-LIFE BASED SCENARIOS. PACKED WITH TASKS, ACTIVITIES AND EXERCISES.


GOOD FOR ORACLE 12c/19c &  SQL SERVER 2014 TO 2019 ENVIRONMENTS


ORACLE 19c AND SQL SERVER 2019 DATABASE DEVELOPMENT & ADMINISTRATION SELF-STUDY CBT

How This Course Is Organised

The Oracle and Microsoft Database Administration bundle combines the Oracle Database 19c Administration Certified Associate courses with the Microsoft® SQL Server 2019 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 organisations behind your name.




Audience:
Database Developers
Database Designers
Data Warehouse Administrator
Database Administrators
Technical Administrator


Prerequisites:
Familiarity with SQL or Database Management Systems



Course Objectives:

Describe Oracle and Microsoft Database Architecture
Manage the Oracle and Microsoft  Database Instance
Manage Oracle and Microsoft Database Storage structures
Create and Administer User Accounts
Monitor the Database
Manage Database Performance
Implement Database Auditing
Configure Oracle and Microsoft Database Instance
Configure Oracle Net Services
Configure Database For Backup and Recovery Operations
Schedule Jobs to Run Inside or Outside of the Database



Course Outline

Oracle Database 19c Certified Associate course:

Based on the latest Oracle database, the internationally recognised Oracle Database 19c Certified Associate qualification will instill in the student the essential skills and knowledge needed to develop and maintain Oracle Database 19c environments. 

Upon achieving this certification you will have gained the ability to work in numerous database environments.


Oracle Database 19c Certified Associate :
Part I – Oracle® Database 19c: SQL Fundamentals - Exam - 1Z0-071
Part II – Oracle® Database 19c: Administration - Exam - 1Z0-082


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



Microsoft SQL 2019:
Part I  –  Querying Microsoft SQL Server
Part II  –  Administering SQL Server Databases


Audience:
Database Developers
Database Designers
Report Writers
Business Intelligence Developers
Data Warehouse Administrator
Database Administrators
Technical Administrator



Course Objectives:

Understand Oracle and SQL Server Data Tools
Learn  Data Definition Language - DDL
Learn Data Manipulation Language - DML
Learn Data Control Language - DCL
Configure Oracle Net Services
Describe Oracle and Microsoft Database Architecture
Manage the Oracle and Microsoft Database Instance
Manage Oracle and Microsoft Database Storage structures
Create and Administer User Accounts
Monitor the Database
Manage Database Performance
Implement Database Auditing
Configure the Database Instance
Schedule Jobs to Run Inside or Outside of the Database
Configure your Database For Backup and Recovery Operations



Courses Topics:

I: Oracle Database: Certified Associate - SQL Fundamentals  - Certified Associate - 1Z0-071

Oracle and Structured Query Language (SQL) 
Restricting and Sorting Data 
Using Single-Row Functions to Customize Output 
Using Conversion Functions and Conditional Expressions 
Reporting Aggregated Data Using the Group Functions 
Displaying Data from Multiple Tables 
Using Subqueries to Solve Queries 
Using the Set Operators 
Manipulating Data 
Using DDL Statements to Create and Manage Tables 
Managing Objects with Data Dictionary Views 
Controlling User Access 
Managing Schema Objects 
Manipulating Large Data Sets



II: Oracle Database Administration I Certified Associate - 1Z0-082

Basics of the Oracle® Database Architecture 
Oracle® Server Architecture 
Shared Memory Areas 
Universal Installer 
Managing an Oracle® Instance 
Oracle® Managed Files 
Server Side Parameter File 
Oracle® Data Dictionary 
Control Files 
Redo Log Files 
Managing the Physical Database Structure 
Managing Tablespaces and Datafiles 
Temporary Segments 
Storage Structures and Undo Data 
Block Utilization 
Undo Space Management 
Managing Database Objects 
Indexes 
Integrity Constraints 
Managing Database Users 
System Privileges 
Object Privileges 
Roles 



I: Querying Microsoft SQL Server Databases

Writing SELECT queries
Sorting and filtering data
Using SQL aggregate functions
Using SET operators
Writing joins to query multiple tables
Using built-in functions
Using Subqueries
Inserting, updating, deleting and merging rows
Transaction control
Creating and using views
Using table expressions
Enhanced Grouping and Pivoting data
Using Windowing ranking, offset and ranking functions
Creating and using Stored Procedures
Controlling Program Flow
Using Dynamic SQL
Implementing Error Handling
Improving Query Performance


II: Administering SQL Server Databases

Learn to Administer SQL Server Database
Understand SQL Server Data Tools
Describe Microsoft Database Architecture
Manage the Microsoft  Database Instance
Manage Microsoft Database Storage structures
Understand SQL Server Security
Create and Administer User Accounts
Monitor the Database
Understand SQL Server Database Performance Tuning
Manage Database Performance
Implement Database Auditing
Configure Microsoft Database Instance
Implement the industry's best practices for SQL Server

     

NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY E-LEARNING, CBT OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR CBT LEARNING  FORMATS. PRICES DIFFER


What is Computer Based Training - CBT?

CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice.

Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

NOTE: WebLearning Publishing CBT and Training Guides products are now delivered with FULL LICENCE KEY.

The WebLearning unique Methodology

All WebLearning® Training Guide courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: ANEW, very effective and proven way of learning. You need to register your product to qualify for FREE UPGRADES.


FACT:

  • ·        Material retention with CBT’S are 45% better than with conventional training methods
  • ·        Your learning curve with CBT is 25%-55% less than conventional methods
  • ·        The cost of CBT training is over 65% less than Classroom training
  • ·         CBT’S are self pacing, interactive and simulate the actual software being studied