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

 


PERFECT INTERACTIVE TRAINING MATERIAL WITH VERY GOOD SIMULATIONS USING REAL-LIFE BASED SCENARIOS. PACKED WITH TASKS, ACTIVITIES AND EXERCISES.


IDEAL FOR THOSE DESIGNING AND DEVELOPING APPLICATIONS AND SOLUTIONS ON A ORACLE OR SQL SERVER PLATFORM ENVIRONMENT.





Oracle 21c & SQL Server 2022 Database Development & Administration Workshop CBT 



How This Course Is Organised
The Oracle and Microsoft Database Administration bundle combines the Oracle Database 21c Administration Certified Associate courses with the Microsoft® SQL Server 2022 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:
Suggested Prerequisites:
Knowledge of relational server technology



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



Prerequisites:
Familiarity with SQL or Database Management Systems



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



Microsoft SQL 2022:
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

Planning to Install and Configure SQL Server
Installation Decisions
Design the Storage for New Databases
Plan for Growth and Capacity
Service Account Configuration

Basic Administration
Installing SQL Server
Managing and Configuring SQL Server
Working with SQL Server Databases

Database and Instances
Terminology Concepts
Client Interaction with Database and Instance
Understanding Database Limits

Instance Architecture
Configuring a database server
Memory Architecture Overview
Understanding Processes and threads
Background Processes

Database Architecture
Schema and Data Storage
Tablespaces and Datafiles
Logging and Data Dictionary

Data Objects
Database Tables
Schema Objects
Data and data types
Non-Native Data Types- Beyone Relational

Data Access
Comparing Structured Query Language
Control and Procedural Statements
Developing Robust Queries

Managing Schema Operations
Managing Tables, Constraints, Objectifers, and Naming
Managing Triggers
Managing Indexes and Views

Data Protection and Security
Securing the Database
Managing Users
Understanding Privileges
Managing Roles

Data Transport
Getting Data Into and Out of SQL Server
Understanding SQL Server Integration Services
Other Transfer Methods

Backup and Recovery
Understanding Database Backups
Data Recovery
Backup and Recovery Tools and Solutions

Monitoring and Performance Tuning
SQL Server Performance Tuning
Managing Memory and Processes for SQL Server
Managing Database Interactions
Monitoring Availability and Errors
Monitoring Performance

Scalability and High Availability
Understanding Availability Features
Replicating Databases
Impact of Scale and Disaster Recovery


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


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. 

This Publisher's 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 Training Guide Learning formats are now 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. 


The WebLearning unique Methodology

All WebLearning® CBT and 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: A NEW, very effective and proven way of learning. 

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