Redhill

<h3><b>Database fundamentals training course description</b></h3>
        <p>  This three-day training course 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. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                        <li>Describe core database concepts.</li>
                        <li>Create database objects.</li>
                        <li>Manipulate data.</li>
                        <li>Describe data storage.</li>
                        <li>Administer a database.</li>
                        <li>Create a relational database consisting of 3 related
tables.</li>
                  </ul>
        <h5>
        <b>Database fundamentals training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Those working with databases.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Database fundamentals training course contents</b></h3>
      <ul>
        <li>Understanding core database concepts </li><p>
Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements.

</p><li>Creating database objects </li><p>
Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections.

</p><li>Manipulating data </li><p>
Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity.

</p><li>Understanding data storage </li><p>
Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table.

</p><li>Administering a Database </li><p>
Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.
</p>
      </ul>

Database fundamentals training course description
 This three-day training course 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. 
What will you learn
Describe core database concepts.
Create database objects.
Manipulate data.
Describe data storage.
Administer a database.
Create a relational database consisting of 3 related
tables.
Database fundamentals training course details
Who will benefit:
Those working with databases.
Prerequisites:
None.
Duration
3 days
Database fundamentals training course contents
Understanding core database concepts

Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. 
Creating database objects

Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. 
Manipulating data

Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. 
Understanding data storage

Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. 
Administering a Database

Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.


Systems & Network Training

Network & Security

Network Engineer

Database fundamentals

General Admission

<h3><b>Database design training course description</b></h3>
        <p> Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                        <li>Name and give 3 types of database structure. </li>

<li>Explain the difference between standard SQL and different flavours.</li>

<li>Use SQL statements to query databases.</li>

<li>Use SQL statements to query and define databases.</li>

<li>Describe the principles of relational database
design and 3 types of relational joins.</li>

<li>Normalise a given flat file table into relational
tables.
</li>
                  </ul>
        <h5>
        <b>Database design training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Database design training course contents</b></h3>
      <ul>
        <li>Database structure and terminology. </li><p>
</p><li>Principles of Relational Database Design. </li><p>
</p><li>Types of relationship. </li><p>
</p><li>Normal Forms. </li><p>
</p><li>Practical examples of relational database design. </li><p>
</p><li>Hands-on creation of a database. </li><p>
</p><li>On paper design a relational database applicable to
the delegates work. </li><p>
</p>
      </ul>

Database design training course description
 Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates.
What will you learn
Name and give 3 types of database structure.
Explain the difference between standard SQL and different flavours.
Use SQL statements to query databases.
Use SQL statements to query and define databases.
Describe the principles of relational database
design and 3 types of relational joins.
Normalise a given flat file table into relational
tables.
Database design training course details
Who will benefit:
Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design.
Prerequisites:
None.
Duration
3 days
Database design training course contents
Database structure and terminology.


Principles of Relational Database Design.


Types of relationship.


Normal Forms.


Practical examples of relational database design.


Hands-on creation of a database.


On paper design a relational database applicable to
the delegates work.



Database design

<h3><b>Oracle Database 12c Admin training course description</b></h3>
        <p> This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                        <li>Administer an Oracle database instance.</li>
<li>Monitor an Oracle database.</li>
<li>Configure the Oracle network environment.</li>
<li>Create and manage database storage structures.</li>
<li>Manage users, profiles, privileges and roles.</li>
<li>Manage undo data and temporary segments.</li>
<li>Monitor and resolve lock conflicts.</li>
<li>Maintain database security.</li>
<li>Implement database auditing.</li>
<li>Monitor the performance of the Database.</li>
<li>Load and unload data.</li>
<li>Use the job scheduler.</li>
<li>Configure a database for backup and recovery.
</li>
                        
                  </ul>
        <h5>
        <b>Oracle Database 12c Admin training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. </p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended.</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Oracle Database 12c Admin training course contents</b></h3>
      <ul>
        <li>Introduction to Oracle database 12c </li><p>
Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks.

</p><li>Oracle Database 12c Architecture </li><p>
Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance.

</p><li>Administer a database instance </li><p>
Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files.

</p><li>Configure the Oracle network environment </li><p>
Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager.

</p><li>Storage Structures </li><p>
Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles.

</p><li>Manage users </li><p>
Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions.

</p><li>Manage profiles and resources </li><p>
Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles.

</p><li>Manage privileges </li><p>
Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles.

</p><li>Database auditing </li><p>
Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options.

</p><li>Data concurrency and lock conflicts </li><p>
Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts.

</p><li>Undo management </li><p>
Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size.

</p><li>Proactive database management </li><p>
Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/

</p><li>Performance management </li><p>
Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory.

</p><li>SQL tuning </li><p>
SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor.

</p><li>Moving data </li><p>
Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables.

</p><li>Automate tasks with the scheduler </li><p>
Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule.

</p><li>Managing resources with Resource Manager </li><p>
Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans.

</p><li>Manage space </li><p>
Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments.

</p><li>Backup and recovery configuration </li><p>
Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability

</p><li>Oracle support </li><p>
The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch</p>
      </ul>

Oracle Database 12c Admin training course description
 This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs.
What will you learn
Administer an Oracle database instance.
Monitor an Oracle database.
Configure the Oracle network environment.
Create and manage database storage structures.
Manage users, profiles, privileges and roles.
Manage undo data and temporary segments.
Monitor and resolve lock conflicts.
Maintain database security.
Implement database auditing.
Monitor the performance of the Database.
Load and unload data.
Use the job scheduler.
Configure a database for backup and recovery.
Oracle Database 12c Admin training course details
Who will benefit:
This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. 
Prerequisites:
An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended.
Duration
5 days
Oracle Database 12c Admin training course contents
Introduction to Oracle database 12c

Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. 
Oracle Database 12c Architecture

Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. 
Administer a database instance

Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. 
Configure the Oracle network environment

Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. 
Storage Structures

Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. 
Manage users

Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. 
Manage profiles and resources

Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. 
Manage privileges

Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. 
Database auditing

Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. 
Data concurrency and lock conflicts

Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. 
Undo management

Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. 
Proactive database management

Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ 
Performance management

Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. 
SQL tuning

SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. 
Moving data

Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. 
Automate tasks with the scheduler

Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. 
Managing resources with Resource Manager

Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. 
Manage space

Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. 
Backup and recovery configuration

Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability 
Oracle support

The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

Oracle database administration

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher.</p>Overview<p>Working in a hands-on learning environment led by our expert facilitator, you'll explore:<br />The Oracle Database Architecture<br />Query Optimizer<br />Tuning Container Databases and Pluggable Databases<br />Oracle 19c Tuning features<br />Evaluating Execution Plans<br />Oracle Tuning Tools<br />Using Automatic Workload Repository<br />Join Types<br />AWR Using Baselines<br />Additional AWR performance tools<br />Optimizer Statistics<br />Monitoring a Service<br />Bind Variables and database parameters<br />Oracle's Real Application Testing (RAT)<br />SQL Tuning Advisor<br />Automatic Sql Tuning<br />Sql Plan Management<br />Shared Pool Tuning<br />Tuning the database buffer cache<br />Tuning the PGA (Program Global Area)<br />Automatic Memory Management (AMM)<br />Tuning Segment Space Utilization (ASSM)<br />Automatic Storage Management</p><p>Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more.</p></div><div id="course-pills-2"><h4>Overview Oracle Database Architecture</h4><ul><li>Instance Definition</li><li>Define SGA</li><li>Define Background Processes</li><li>Datafile Definition</li></ul><h4>Query Optimizer</h4><ul><li>SQL Parsing</li><li>Optimizing Terms</li><li>Optimizing Methods</li><li>Query Plan Generation</li><li>Query Plan Control</li></ul><h4>Tuning Container Databases and Pluggable Databases</h4><ul><li>Pluggable tuning parameters</li><li>Define Container tuning structure</li><li>Using PDB$SEED</li><li>Create a new PDB</li><li>Plug and unplug a PDB</li></ul><h4>Oracle 12c Tuning features</h4><ul><li>Identifying and Using Oracle's Heat Map</li><li>12c Compression Levels and Types</li></ul><h4>Evaluating Execution Plans</h4><ul><li>Defining SQL execution plans</li><li>Automatic Workload Repository</li><li>Reading execution plans</li></ul><h4>Oracle Tuning Tools</h4><ul><li>Monitoring tools overview</li><li>Enterprise Manager</li><li>Dynamic Performance Views</li><li>Automatic Workload Repository</li><li>Automatic Database Diagnostic Monitor</li><li>Sql Tuning Advisor</li><li>SQL Access Advisor</li><li>Sql Access Advisor</li><li>DB operation Tuning</li><li>DB operation Active Reporting</li></ul><h4>Using Automatic Workload Repository</h4><ul><li>Defining AWR</li><li>AWR Settings</li><li>Creating AWR Baselines</li></ul><h4>Metrics, Alerts, and Thresholds</h4><ul><li>Defining Metrics</li><li>Setting Alerts</li><li>Setting Corrective Actions</li><li>User Defined Metrics</li><li>Metric Dynamic Views</li></ul><h4>Join Types</h4><ul><li>Nested Loops Join</li><li>Sort Merge join</li><li>Hash Join and Cartesian Join</li><li>Equijoins and Nonequijoins</li><li>Outer Joins</li><li>Semijoins</li></ul><h4>AWR Using Baselines</h4><ul><li>Creating AWR baselines</li><li>Creating AWR Repeating baselines</li><li>Moving Window Baseline</li></ul><h4>Additional AWR performance tools</h4><ul><li>Automatic Maintenance Tasks</li><li>Segment Advisor</li><li>Statistics Gathering</li><li>Automatic Tuning Optimizer</li><li>Automatic Database Diagnostic Monitor</li><li>Active Session History (ASH)</li></ul><h4>Optimizer Statistics</h4><ul><li>Optimizer Statistics Overview</li><li>Table and Index Statistics</li><li>Statistic Preferences</li><li>Statistics Gathering</li><li>e) Locking Statistics, Export/Import Statistics</li><li>Pending and published statistics</li><li>Optimizer Hints</li><li>Optimizer Paths</li><li>Cost Base Optimization</li></ul><h4>Monitoring a Service</h4><ul><li>Overview of what is an Oracle Service</li><li>Creating an Oracle Service for Single instance and RAC</li><li>Monitoring a Service</li><li>Resource Management and a Service</li><li>Enterprise Manager and a Service</li></ul><h4>Bind Variables and database parameters</h4><ul><li>Bind variable definition</li><li>Cursor_sharing parameter</li><li>Adaptive Cursor Sharing</li></ul><h4>Oracle's Real Application Testing (RAT)</h4><ul><li>Sql Performance Analyzer overview</li><li>Sql Performance Analyzer Options</li><li>Database Parameter changes</li><li>Database version changes</li><li>Creating SQL Tuning Sets</li><li>Database Replay Overview</li><li>Database Replay Configuration</li><li>Database Replay Options</li></ul><h4>SQL Tuning Advisor</h4><ul><li>SQL Tuning Advisor: Overview</li><li>SQL Tuning Advisor Limited Mode</li><li>Sql Tuning Advisor Comprehensive mode</li><li>Sql Tuning Profiles</li></ul><h4>SQL Access Advisor</h4><ul><li>SQL Access Advisor: Overview</li><li>Sql Access Advisor options</li><li>SQL Access Advisor and Sql Tuning Sets</li><li>Sql Access Advisor and AWR</li><li>Results and Implementation</li></ul><h4>Automatic Sql Tuning</h4><ul><li>Automatic Sql Tuning Maintenance Task</li><li>Automatic Tuning Optimization implementation(ATO)</li><li>Automatic Tuning Optimization Results</li><li>Enable/Disable Automatic Tuning Optimization</li></ul><h4>Sql Plan Management</h4><ul><li>Sql plan Management and baseline overview</li><li>Enable sql plan management</li><li>Loading Sql Plan baselines into the SGA</li><li>Adaptive plan management</li></ul><h4>Shared Pool Tuning</h4><ul><li>Shared pool architecture</li><li>Shared pool parameters</li><li>Library Cache</li><li>Dictionary cache</li><li>Large pool considerations and contents</li></ul><h4>Tuning the database buffer cache</h4><ul><li>Database buffer cache overview</li><li>Database buffer cache parameters</li><li>Oracle and Dirty reads and writes</li><li>Automatic Shared Memory Management (ASMM)</li><li>Buffer Cache goals and responsibility</li><li>Buffer Cache pools</li></ul><h4>Tuning the PGA (Program Global Area)</h4><ul><li>PGA Overview</li><li>PGA Database Parameters</li><li>Temporary Segments</li><li>Temporary Tablespace</li><li>Sizing the PGA</li></ul><h4>Automatic Memory Management (AMM)</h4><ul><li>Oracle's Automatic Memory Management Overview</li><li>Database Auto-tuned Parameters</li><li>Database Non Auto-tuned Parameters</li><li>Automatic Memory Management Hints and Sizing suggestions</li><li>AMM versus ASMM</li></ul><h4>Tuning Segment Space Utilization (ASSM)</h4><ul><li>Overview of Automatic Segment Space Management</li><li>Defining the DB_BLOCK_SIZE</li><li>Defining DB_nk_CACHE_SIZE parameter</li><li>The DB_BLOCK_SIZE Parameter</li><li>Overview of table compression, block chaining, and block migration</li></ul><h4>Automatic Storage Management</h4><ul><li>Overview of ASM</li><li>Definition of Grid Infrastructure</li><li>ASM Instance</li><li>ASM Diskgroups</li><li>ASM Diskgroup parameters and templates</li><li>ASMCMD</li></ul></div>

Duration
5 Days
30 CPD hours
This course is intended for
This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher.
Overview
Working in a hands-on learning environment led by our expert facilitator, you'll explore:
The Oracle Database Architecture
Query Optimizer
Tuning Container Databases and Pluggable Databases
Oracle 19c Tuning features
Evaluating Execution Plans
Oracle Tuning Tools
Using Automatic Workload Repository
Join Types
AWR Using Baselines
Additional AWR performance tools
Optimizer Statistics
Monitoring a Service
Bind Variables and database parameters
Oracle's Real Application Testing (RAT)
SQL Tuning Advisor
Automatic Sql Tuning
Sql Plan Management
Shared Pool Tuning
Tuning the database buffer cache
Tuning the PGA (Program Global Area)
Automatic Memory Management (AMM)
Tuning Segment Space Utilization (ASSM)
Automatic Storage Management
Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more.
Overview Oracle Database Architecture
Instance Definition
Define SGA
Define Background Processes
Datafile Definition
Query Optimizer
SQL Parsing
Optimizing Terms
Optimizing Methods
Query Plan Generation
Query Plan Control
Tuning Container Databases and Pluggable Databases
Pluggable tuning parameters
Define Container tuning structure
Using PDB$SEED
Create a new PDB
Plug and unplug a PDB
Oracle 12c Tuning features
Identifying and Using Oracle's Heat Map
12c Compression Levels and Types
Evaluating Execution Plans
Defining SQL execution plans
Automatic Workload Repository
Reading execution plans
Oracle Tuning Tools
Monitoring tools overview
Enterprise Manager
Dynamic Performance Views
Automatic Workload Repository
Automatic Database Diagnostic Monitor
Sql Tuning Advisor
SQL Access Advisor
Sql Access Advisor
DB operation Tuning
DB operation Active Reporting
Using Automatic Workload Repository
Defining AWR
AWR Settings
Creating AWR Baselines
Metrics, Alerts, and Thresholds
Defining Metrics
Setting Alerts
Setting Corrective Actions
User Defined Metrics
Metric Dynamic Views
Join Types
Nested Loops Join
Sort Merge join
Hash Join and Cartesian Join
Equijoins and Nonequijoins
Outer Joins
Semijoins
AWR Using Baselines
Creating AWR baselines
Creating AWR Repeating baselines
Moving Window Baseline
Additional AWR performance tools
Automatic Maintenance Tasks
Segment Advisor
Statistics Gathering
Automatic Tuning Optimizer
Automatic Database Diagnostic Monitor
Active Session History (ASH)
Optimizer Statistics
Optimizer Statistics Overview
Table and Index Statistics
Statistic Preferences
Statistics Gathering
e) Locking Statistics, Export/Import Statistics
Pending and published statistics
Optimizer Hints
Optimizer Paths
Cost Base Optimization
Monitoring a Service
Overview of what is an Oracle Service
Creating an Oracle Service for Single instance and RAC
Monitoring a Service
Resource Management and a Service
Enterprise Manager and a Service
Bind Variables and database parameters
Bind variable definition
Cursor_sharing parameter
Adaptive Cursor Sharing
Oracle's Real Application Testing (RAT)
Sql Performance Analyzer overview
Sql Performance Analyzer Options
Database Parameter changes
Database version changes
Creating SQL Tuning Sets
Database Replay Overview
Database Replay Configuration
Database Replay Options
SQL Tuning Advisor
SQL Tuning Advisor: Overview
SQL Tuning Advisor Limited Mode
Sql Tuning Advisor Comprehensive mode
Sql Tuning Profiles
SQL Access Advisor
SQL Access Advisor: Overview
Sql Access Advisor options
SQL Access Advisor and Sql Tuning Sets
Sql Access Advisor and AWR
Results and Implementation
Automatic Sql Tuning
Automatic Sql Tuning Maintenance Task
Automatic Tuning Optimization implementation(ATO)
Automatic Tuning Optimization Results
Enable/Disable Automatic Tuning Optimization
Sql Plan Management
Sql plan Management and baseline overview
Enable sql plan management
Loading Sql Plan baselines into the SGA
Adaptive plan management
Shared Pool Tuning
Shared pool architecture
Shared pool parameters
Library Cache
Dictionary cache
Large pool considerations and contents
Tuning the database buffer cache
Database buffer cache overview
Database buffer cache parameters
Oracle and Dirty reads and writes
Automatic Shared Memory Management (ASMM)
Buffer Cache goals and responsibility
Buffer Cache pools
Tuning the PGA (Program Global Area)
PGA Overview
PGA Database Parameters
Temporary Segments
Temporary Tablespace
Sizing the PGA
Automatic Memory Management (AMM)
Oracle's Automatic Memory Management Overview
Database Auto-tuned Parameters
Database Non Auto-tuned Parameters
Automatic Memory Management Hints and Sizing suggestions
AMM versus ASMM
Tuning Segment Space Utilization (ASSM)
Overview of Automatic Segment Space Management
Defining the DB_BLOCK_SIZE
Defining DB_nk_CACHE_SIZE parameter
The DB_BLOCK_SIZE Parameter
Overview of table compression, block chaining, and block migration
Automatic Storage Management
Overview of ASM
Definition of Grid Infrastructure
ASM Instance
ASM Diskgroups
ASM Diskgroup parameters and templates
ASMCMD

Nexus Human

Oracle Primavera

Oracle SQL

AWS Certified Database

Oracle

Oracle 1Z0-819

Oracle Database

Oracle 19c Database Tuning (TTOR21519)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Data Warehouse AdministratorDatabase AdministratorsDatabase DesignersSupport EngineerTechnical Administrator</p>Overview<p>Monitor the DatabaseManage Database PerformanceImplement Database AuditingConfigure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and TasksSchedule Jobs to Run Inside or Outside of the DatabaseConfigure Oracle Net ServicesConfigure your Database For Backup and Recovery OperationsDescribe Oracle Database ArchitectureManage the Oracle Database InstanceManage Oracle Database Storage structuresCreate and Administer User Accounts</p><p>The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.</p></div><div id="course-pills-2">The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.</div>

Duration
5 Days
30 CPD hours
This course is intended for
Data Warehouse AdministratorDatabase AdministratorsDatabase DesignersSupport EngineerTechnical Administrator
Overview
Monitor the DatabaseManage Database PerformanceImplement Database AuditingConfigure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and TasksSchedule Jobs to Run Inside or Outside of the DatabaseConfigure Oracle Net ServicesConfigure your Database For Backup and Recovery OperationsDescribe Oracle Database ArchitectureManage the Oracle Database InstanceManage Oracle Database Storage structuresCreate and Administer User Accounts
The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.
The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.

Oracle Fusion HCM

Database Administration

Oracle Database 12c - Administration Workshop

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is designed for students who need to learn database design essentials, typically in preparation for, or as a supplement to, a course on SQL such as SQL Querying: Fundamentals and courses on specific relational database platforms.</p>Overview<p>In this course, you will perform steps to design a relational database, including gathering requirements, data modeling, and planning implementation.<br /> <br />You will:<br /> - Follow an efficient process for designing a relational database<br />- Define the database conceptual model<br />- Define the database logical model<br />- Apply database normalization methods to improve the initial design of a database<br />- Complete the database design, including controls to ensure its referential integrity and data integrity</p><p>This course introduces you to a process for effectively planning and designing a functional, efficient database. Knowing how to plan a relational database is important to the success of the databases you create. Without planning, you cannot possibly know what the database needs to do, or even what information to include in the database. Planning a database is essential, and prevents the extra work of fixing data maintenance problems later on. The concepts are not specific to a particular software application and can be applied to any relational database management system.<br /></p></div><div id="course-pills-2"><h4>Getting Started with Relational Database Design</h4><ul><li>Identify Database Components</li><li>Identify Common Database Design Problems</li><li>Follow a Database Design Process</li><li>Gather Requirements</li></ul><h4>Defining the Database Conceptual Model</h4><ul><li>Create the Conceptual Model</li><li>Identify Entity Relationships</li></ul><h4>Defining the Database Logical Model</h4><ul><li>Identify Columns</li><li>Identify Primary Keys</li><li>Identify and Diagram Relationships</li></ul><h4>Normalizing Data</h4><ul><li>Avoid Common Database Design Errors</li><li>Comply with Higher Normal Forms</li></ul><h4>Finalizing the Database Design</h4><ul><li>Adapt the Physical Model for Different Systems</li><li>Ensure Referential Integrity</li><li>Ensure Data Integrity at the Column Level</li><li>Ensure Data Integrity at the Table Level</li><li>Design for the Cloud</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Database Design - A Modern Approach training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Database Design - A Modern Approach course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
1 Days
6 CPD hours
This course is intended for
This course is designed for students who need to learn database design essentials, typically in preparation for, or as a supplement to, a course on SQL such as SQL Querying: Fundamentals and courses on specific relational database platforms.
Overview
In this course, you will perform steps to design a relational database, including gathering requirements, data modeling, and planning implementation.
 
You will:
 - Follow an efficient process for designing a relational database
- Define the database conceptual model
- Define the database logical model
- Apply database normalization methods to improve the initial design of a database
- Complete the database design, including controls to ensure its referential integrity and data integrity
This course introduces you to a process for effectively planning and designing a functional, efficient database. Knowing how to plan a relational database is important to the success of the databases you create. Without planning, you cannot possibly know what the database needs to do, or even what information to include in the database. Planning a database is essential, and prevents the extra work of fixing data maintenance problems later on. The concepts are not specific to a particular software application and can be applied to any relational database management system.

Getting Started with Relational Database Design
Identify Database Components
Identify Common Database Design Problems
Follow a Database Design Process
Gather Requirements
Defining the Database Conceptual Model
Create the Conceptual Model
Identify Entity Relationships
Defining the Database Logical Model
Identify Columns
Identify Primary Keys
Identify and Diagram Relationships
Normalizing Data
Avoid Common Database Design Errors
Comply with Higher Normal Forms
Finalizing the Database Design
Adapt the Physical Model for Different Systems
Ensure Referential Integrity
Ensure Data Integrity at the Column Level
Ensure Data Integrity at the Table Level
Design for the Cloud
Additional course details:
Nexus Humans Database Design - A Modern Approach training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Database Design - A Modern Approach course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Database Design & Development

Design & Technology Courses (DT)

Service Design Courses (SDC)

Database Programming

Trainers Course

Database Design - A Modern Approach

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include:<br />Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features.<br />Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications.</p>Overview<p>Upon completing this course, database developers will be able to:<br />Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes.<br />Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes.<br />Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance.<br />Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness.<br />Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications.</p><p>PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency.</p></div><div id="course-pills-2"><h4>Installing &amp; Managing PostgreSQL</h4><ul><li>PostgreSQL installation process</li><li>Optimal configuration settings</li><li>User and role management</li><li>Database backup and restoration</li></ul><h4>Overview of PostgreSQL Database</h4><ul><li>PostgreSQL architecture overview</li><li>Understanding database objects</li><li>Efficient data storage</li><li>Transaction management basics</li></ul><h4>Using the psql client</h4><ul><li>Introduction to psql</li><li>Essential psql commands</li><li>Executing queries effectively</li><li>Managing databases with psql</li></ul><h4>Understanding PostgreSQL data types</h4><ul><li>Numeric data types explored</li><li>Character and binary types</li><li>Date, time, and boolean values</li><li>Array and other types</li></ul><h4>Understanding sequences</h4><ul><li>Sequence creation and usage</li><li>Customizing sequence behavior</li><li>Implementing auto-increment columns</li><li>Sequence manipulation and control</li></ul><h4>Creating &amp; managing indexes</h4><ul><li>PostgreSQL index fundamentals</li><li>Designing partial indexes</li><li>Utilizing expression-based indexes</li><li>Index management techniques</li></ul><h4>Using COPY to load data</h4><ul><li>COPY command overview</li><li>Importing and exporting data</li><li>Handling CSV and binary formats</li><li>Performance considerations</li></ul><h4>Working with Array Values</h4><ul><li>Array value basics</li><li>Array manipulation functions</li><li>Querying arrays efficiently</li><li>Multidimensional array handling</li></ul><h4>Advanced SQL Functions</h4><ul><li>Mastering Common Table Expressions</li><li>Utilizing Window Functions</li><li>Regular Expressions in SQL</li><li>Crafting Recursive Queries</li></ul><h4>Writing triggers &amp; stored procedures with PL/pgSQL</h4><ul><li>PL/pgSQL variables usage</li><li>Implementing loop operations</li><li>PERFORM and EXECUTE statements</li><li>Developing PostgreSQL triggers</li></ul><h4>Using the PostgreSQL query optimizer</h4><ul><li>Query analysis and optimization</li><li>EXPLAIN command insights</li><li>PostgreSQL query operators</li><li>Identifying performance bottlenecks</li></ul><h4>Improving query performance</h4><ul><li>Query performance tuning</li><li>Index optimization strategies</li><li>Efficient database partitioning</li><li>Connection and resource management</li></ul><h4>Wrap Up &amp; Additional Resources</h4><ul><li>Further learning opportunities</li><li>Staying up-to-date with PostgreSQL</li><li>Community engagement and support</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PostgreSQL for Database Developers (TTDB7024) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PostgreSQL for Database Developers (TTDB7024) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for
The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include:
Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features.
Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications.
Overview
Upon completing this course, database developers will be able to:
Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes.
Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes.
Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance.
Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness.
Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications.
PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency.
Installing & Managing PostgreSQL
PostgreSQL installation process
Optimal configuration settings
User and role management
Database backup and restoration
Overview of PostgreSQL Database
PostgreSQL architecture overview
Understanding database objects
Efficient data storage
Transaction management basics
Using the psql client
Introduction to psql
Essential psql commands
Executing queries effectively
Managing databases with psql
Understanding PostgreSQL data types
Numeric data types explored
Character and binary types
Date, time, and boolean values
Array and other types
Understanding sequences
Sequence creation and usage
Customizing sequence behavior
Implementing auto-increment columns
Sequence manipulation and control
Creating & managing indexes
PostgreSQL index fundamentals
Designing partial indexes
Utilizing expression-based indexes
Index management techniques
Using COPY to load data
COPY command overview
Importing and exporting data
Handling CSV and binary formats
Performance considerations
Working with Array Values
Array value basics
Array manipulation functions
Querying arrays efficiently
Multidimensional array handling
Advanced SQL Functions
Mastering Common Table Expressions
Utilizing Window Functions
Regular Expressions in SQL
Crafting Recursive Queries
Writing triggers & stored procedures with PL/pgSQL
PL/pgSQL variables usage
Implementing loop operations
PERFORM and EXECUTE statements
Developing PostgreSQL triggers
Using the PostgreSQL query optimizer
Query analysis and optimization
EXPLAIN command insights
PostgreSQL query operators
Identifying performance bottlenecks
Improving query performance
Query performance tuning
Index optimization strategies
Efficient database partitioning
Connection and resource management
Wrap Up & Additional Resources
Further learning opportunities
Staying up-to-date with PostgreSQL
Community engagement and support
Additional course details:
Nexus Humans PostgreSQL for Database Developers (TTDB7024) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the PostgreSQL for Database Developers (TTDB7024) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


PostgreSQL

PostgreSQL for Database Developers (TTDB7024)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Administrator<br />Architect<br />Database Administrator</p>Overview<p>To provide an acceptable response time to users and manage resources effectively, you learn how to monitor performance and manage resources within the multitenant container database and its pluggable databases, and within each pluggable database.<br />Another important aspect is the data movement between non-CDBs and pluggable databases, and between pluggable databases.<br />It is also important to understand the procedures of upgrading an Oracle Database multitenant container database or an Oracle Database pluggable database.<br />  Finally, students discover the way multitenant container database and pluggable databases are created and monitored in the Cloud.</p><p>This course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.</p></div><div id="course-pills-2"><h4>CDB Basics</h4><h4>CDB and Regular PDBs</h4><h4>Application PDBs and Application Installation</h4><h4>PDB Creation</h4><h4>CDB and PDB Management</h4><h4>Storage</h4><h4>Security</h4><h4>Backup and Duplicate</h4><h4>Recovery and Flashback</h4><h4>Performance Monitoring</h4><h4>Resources Allocation</h4><h4>Data Movement</h4><h4>Upgrade methods</h4></div>

Duration
5 Days
30 CPD hours
This course is intended for
Administrator
Architect
Database Administrator
Overview
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor performance and manage resources within the multitenant container database and its pluggable databases, and within each pluggable database.
Another important aspect is the data movement between non-CDBs and pluggable databases, and between pluggable databases.
It is also important to understand the procedures of upgrading an Oracle Database multitenant container database or an Oracle Database pluggable database.
 Finally, students discover the way multitenant container database and pluggable databases are created and monitored in the Cloud.
This course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.
CDB BasicsCDB and Regular PDBsApplication PDBs and Application InstallationPDB CreationCDB and PDB ManagementStorageSecurityBackup and DuplicateRecovery and FlashbackPerformance MonitoringResources AllocationData MovementUpgrade methods

Oracle Database: Managing Multitenant Architecture

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for Administrator, Database Administrator, Network Administrator, Systems Administrator.</p>Overview<p>Upon successful completion of this course, students will be able to Configure and use Transparent Data Encryption, Understand and use Oracle Key Vault, Understand Oracle Data Redaction, Understand and use Oracle Data Masking and Subsetting, Understand security risks and identify appropriate Oracle solutions, Configure general authentication and authorization, Understand and implement Global Users, Set up and maintain a simple wallet, Install and use Oracle Database Vault, and Configure and use Transparent Sensitive Data Protection.</p><p>In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization.</p></div><div id="course-pills-2">In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization.</div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Database Security - Preventive Controls training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Oracle Database Security - Preventive Controls course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
5 Days
30 CPD hours
This course is intended for
This course is intended for Administrator, Database Administrator, Network Administrator, Systems Administrator.
Overview
Upon successful completion of this course, students will be able to Configure and use Transparent Data Encryption, Understand and use Oracle Key Vault, Understand Oracle Data Redaction, Understand and use Oracle Data Masking and Subsetting, Understand security risks and identify appropriate Oracle solutions, Configure general authentication and authorization, Understand and implement Global Users, Set up and maintain a simple wallet, Install and use Oracle Database Vault, and Configure and use Transparent Sensitive Data Protection.
In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization.
In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization.
Additional course details:
Nexus Humans Oracle Database Security - Preventive Controls training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Oracle Database Security - Preventive Controls course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Oracle Database Security - Preventive Controls

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for Administrator, Database Administrator, End User, Network Administrator, and Systems Administrator.</p>Overview<p>Upon completion of this course, students will be able to Describe and determine database security requirements, Understand Oracle security solutions to help meet security requirements, Implement basic database security, Configure network security, and Discover basic security configuration issues.</p><p>This Introduction to Oracle Database Security Ed 1 training teaches you how to use Oracle Database features to help meet the security, privacy and compliance requirements of your organization.</p></div><div id="course-pills-2"><h4>Introduction</h4><ul><li>Course Objectives</li><li>Course Schedule</li><li>Detective Security Controls</li><li>Preventive Security Controls</li><li>Your Learning Aids</li><li>Basic Workshop Architecture</li><li></li></ul><h4>Understanding Security Requirements</h4><ul><li>Fundamental Data Security Requirements</li><li>Security Risks</li><li>Techniques to Enforce Security</li></ul><h4>Choosing Security Solutions</h4><ul><li>Database Access Control: Authentication</li><li>Protecting Against Database Bypass with Encryption</li><li>Protecting Sensitive Data</li><li>Protecting against Application Bypass</li><li>Detecting Threats</li><li>Compliance</li></ul><h4>Implementing Basic Database Security</h4><ul><li>Database Security Checklist</li><li>Reducing Administrative Effort</li><li>Principle of Least Privilege</li><li>Objects Protection</li><li></li></ul><h4>Configuring Network Security</h4><ul><li>Network Access Control</li><li>Listener Security</li><li>Listener Usage Control</li><li>Manage fine-grained access to external network services</li></ul><h4>Discovering Basic Configuration Issues</h4><ul><li>Accessing Enterprise Manager Security Reports</li><li>Using Various Security Reports</li></ul></div>

Duration
1 Days
6 CPD hours
This course is intended for
This course is intended for Administrator, Database Administrator, End User, Network Administrator, and Systems Administrator.
Overview
Upon completion of this course, students will be able to Describe and determine database security requirements, Understand Oracle security solutions to help meet security requirements, Implement basic database security, Configure network security, and Discover basic security configuration issues.
This Introduction to Oracle Database Security Ed 1 training teaches you how to use Oracle Database features to help meet the security, privacy and compliance requirements of your organization.
Introduction
Course Objectives
Course Schedule
Detective Security Controls
Preventive Security Controls
Your Learning Aids
Basic Workshop Architecture

Understanding Security Requirements
Fundamental Data Security Requirements
Security Risks
Techniques to Enforce Security
Choosing Security Solutions
Database Access Control: Authentication
Protecting Against Database Bypass with Encryption
Protecting Sensitive Data
Protecting against Application Bypass
Detecting Threats
Compliance
Implementing Basic Database Security
Database Security Checklist
Reducing Administrative Effort
Principle of Least Privilege
Objects Protection

Configuring Network Security
Network Access Control
Listener Security
Listener Usage Control
Manage fine-grained access to external network services
Discovering Basic Configuration Issues
Accessing Enterprise Manager Security Reports
Using Various Security Reports

Educators providing Database courses in Romsey delivered Live Online