Name: Oracle 11g PL/SQL Beginner
Price: 18 GBP
Availability: InStock

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This hands-on course is geared for experienced DBAs with basic Oracle 19c skills.</p>Overview<p>This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs andexercises. Working in a hands-on learning environment led by our expert facilitator, students will explore:<br />Creating CDBs and Regular PDBs<br />Managing CDBs and PDBs<br />Backup and Duplicate<br />Upgrading and Transporting CDBs and Regular PDBs<br />Backup Strategies and Terminology<br />Restore and Recovery Concepts<br />Using Flashback Technologies<br />Duplicating a Database<br />Installing Grid Infrastructure and Oracle Database<br />Patching Grid Infrastructure and Oracle Database<br />Upgrading to Oracle Grid Infrastructure<br />Using General Overall Database Enhancements<br />Monitoring and Tuning Database Performance<br />Managing Application PDBs<br />Managing Security in Multitenant databases<br />Recovery and Flashback<br />Configuring and Using RMAN<br />Diagnosing Failures<br />Performing Recovery<br />Transporting Data<br />RMAN Troubleshooting and Tuning<br />Creating an Oracle Database by using DBCA<br />Oracle Restart<br />Upgrading the Oracle Database<br />Installing Grid Infrastructure for a Standalone server<br />Using Availability Enhancements<br />Tuning SQL Statements</p><p>Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration II (Oracle DBA II) expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases.</p></div><div id="course-pills-2"><h4>Creating CDBs and Regular PDBs</h4><ul><li>Configure and create a CDB</li><li>Create a new PDB from the CDB seed</li><li>Explore the structure of PDBs</li></ul><h4>Manage CDBs and PDBs</h4><ul><li>Manage PDB service names and connections</li><li>Manage startup, shutdown and availability of CDBs and PDBs</li><li>Change the different modes and settings of PDBs</li><li>Evaluate the impact of parameter value changes</li><li>Performance management in CDBs and PDBs</li><li>Control CDB and PDB resource usage with the Oracle Resource Manager</li></ul><h4>Backup and Duplicate</h4><ul><li>Perform Backup and Recover CDBs and PDBs</li><li>Duplicate an active PDB</li><li>Duplicate a Database</li></ul><h4>Upgrading and Transporting CDBs and Regular PDBs</h4><ul><li>Upgrade an Oracle Database</li><li>Transport Data</li></ul><h4>Backup Strategies and Terminology</h4><ul><li>Perform Full and Incremental Backups and Recoveries</li><li>Compress and Encrypt RMAN Backups</li><li>Use a media manager</li><li>Create multi-section backups of exceptionally large files</li><li>Create duplexed backup sets</li><li>Create archival backups</li><li>Backup of recovery files</li><li>Backup non database files</li><li>Back up ASM meta data</li></ul><h4>Restore and Recovery Concepts</h4><ul><li>Employ the best Oracle Database recovery technology for your failure situation</li><li>Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery</li></ul><h4>Using Flashback Technologies</h4><ul><li>Configure your Database to support Flashback</li><li>Perform flashback operations</li></ul><h4>Duplicating a Database</h4><ul><li>Duplicate Databases</li></ul><h4>Install Grid Infrastructure and Oracle Database</h4><ul><li>Install Grid Infrastructure for a Standalone server<br />Install Oracle Database software</li></ul><h4>Patching Grid Infrastructure and Oracle Database</h4><ul><li>Patch Grid Infrastructure and Oracle Database</li></ul><h4>Upgrading to Oracle Grid Infrastructure</h4><ul><li>Upgrade Oracle Grid Infrastructure</li></ul><h4>Using General Overall Database Enhancements</h4><ul><li>Install Oracle Database software<br />Create, Delete and Configure Databases using DBCA<br />Creating CDBs and Regular PDBs<br />Use Miscellaneous 19c New Features</li></ul><h4>Monitoring and Tuning Database Performance</h4><ul><li>Managing Memory Components<br />Understanding the Automatic Workload Repository (AWR)<br />Understanding the Advisory Framework<br />Monitoring Wait Events, Sessions, and Services<br />Managing Metric Thresholds and Alerts<br />Understanding and Using the Performance Tuning Methodology<br />Performing Performance Planning<br />Understanding the Automatic<br />Database Diagnostic Monitor (ADDM)</li></ul><h4>Manage Application PDBs</h4><ul><li>Explain the purpose of application root and application seed<br />Define and create application PDBs<br />Install, upgrade and Patch applications <br />Create and administer Application PDBS<br />Clone PDBs and Application containers<br />Plug and unplug operations with PDBs and application containers<br />Comparing Local Undo Mode and Shared Undo Mode</li></ul><h4>Manage Security in Multitenant databases</h4><ul><li>Manage Security in Multitenant databases<br />Manage PDB lockdown profiles<br />Audit Users in CDBs and PDBs<br />Manage other types of policies in application containers</li></ul><h4>Recovery and Flashback</h4><ul><li>Restore and Recovering Databases with RMAN<br />Perform CDB and PDB flashback</li></ul><h4>Configuring and Using RMAN</h4><ul><li>Configure RMAN and the Database for Recoverability<br />Configure and Using an RMAN recovery catalog</li></ul><h4>Diagnosing Failures</h4><ul><li>Detect and repair database and database block corruption<br />Diagnosing Database Issues</li></ul><h4>Performing Recovery</h4><ul><li>Restore and Recovering Databases with RMAN<br />Perform Non RMAN database recovery</li></ul><h4>Transporting Data</h4><ul><li>Transport Data</li></ul><h4>RMAN Troubleshooting and Tuning</h4><ul><li>Interpret the RMAN message output<br />Diagnose RMAN performance issues</li></ul><h4>Creating an Oracle Database by using DBCA</h4><ul><li>Create, Delete and Configure<br />Databases using DBCA</li></ul><h4>Oracle Restart</h4><ul><li>Configure and use Oracle Restart to manage components</li></ul><h4>Upgrade the Oracle Database</h4><ul><li>Plan for Upgrading an Oracle Database<br />Upgrade an Oracle Database<br />Perform Post-Upgrade tasks</li></ul><h4>Install Grid Infrastructure for a Standalone server</h4><ul><li>Rapid Home Provisioning</li></ul><h4>Using Availability Enhancements</h4><ul><li>Use an RMAN recovery catalog<br />Use Flashback Database</li></ul><h4>Tuning SQL Statements</h4><ul><li>Understanding the Oracle Optimizer<br />Using the SQL Tuning Advisor<br />Managing Optimizer Statistics<br />Using the SQL Access Advisor<br />Understanding the SQL Tuning Process</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle 19c Database Administration II (DBA II) (TTOR20619) 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 19c Database Administration II (DBA II) (TTOR20619) 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>

Nexus Human

Oracle Primavera

Oracle SQL

AWS Certified Database

Oracle 1Z0-819

Database Administration

Oracle Database

Oracle 19c Database Administration II (DBA II) (TTOR20619)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Administrator<br />Developer<br />System Integrator<br />Systems Administrator</p>Overview<p>Install WebLogic Server 12c<br />Deploy applications to WebLogic Server<br />Deploy share libraries and application that use them to WebLogic Server<br />Backup and restore a WebLogic Server domain<br />Create a WebLogic Server domain<br />Configure and monitor WebLogic Server<br />Configure WebLogic Server database resources<br />Create and configure a WebLogic Server cluster<br />Configure WebLogic Server's authentication provider</p><p>This Oracle WebLogic Server 12c: Administration I training teaches you how to perform the most important Oracle WebLogic Server 12c administrative tasks., and gives an overview of the architecture and concepts of Oracle WebLogic Server 12c.</p></div><div id="course-pills-2"><h4>WebLogic Server Overview</h4><h4>Installing and Patching WebLogic Server</h4><h4>Creating Domains</h4><h4>Starting Servers</h4><h4>Using the Administration Console</h4><h4>Configuring JDBC</h4><h4>Monitoring a Domain</h4><h4>Node Manager</h4><h4>Deploying Applications</h4><h4>Shared Java EE Libraries</h4><h4>Network Channels and Virtual Hosts</h4><h4>Clusters: Overview, Create, &amp; Config</h4><h4>Clusters: Proxies &amp; Sessions</h4><h4>Clusters: Communication, Planning &amp; Troubleshooting</h4><h4>Transactions</h4><h4>WebLogic Server Security</h4><h4>Backing Up a Domain and Upgrading WebLogic Server</h4></div>

Oracle Business Intelligence

LPIC-1:Linux Administrator

Oracle Fusion HCM

Oracle WebLogic Server 12c: Administration I

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			<p><span>The </span><b>Oracle 11g PL/SQL Part 1</b><span> course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts.</span></p>
<p><span>Initially, you'll learn how to start programming in Oracle PL/SQL. You'll understand the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method. This course includes mostly practical examples with explanations which makes it more valuable. </span></p>
<p><span>Upon successful completion of this course, you can have the pleasure to code in PL/SQL which further help to boost your career.</span></p>
<p><span>From beginners to expert learner can benefit from this course. So enrol today and see what else is in the </span><b>Oracle 11g PL/SQL Part 1</b><span> course.</span></p>
<h3><strong>What Will I Learn?</strong></h3>
<ul>
<li><span>Prepare your environment</span></li>
<li>Work with Oracle database tools</li>
<li>Understand and work with language features</li>
<li><span>Work with the DECLARE clause</span></li>
<li><span>Work with the BEGIN clause</span></li>
<li><span>Work with the EXCEPTION clause</span></li>
<li><span>Use explicit cursors</span></li>
<li><span>Understand and use nested blocks</span></li>
<li><span>Understand the difference between nested blocks and subprograms</span></li>
</ul>
<h3><strong>Requirements</strong></h3>
<div>
<ul>
<li>Familiarity with database and programming principles</li>
</ul>
<h3><strong>Who is the target audience?</strong></h3>
<ul>
<li>Application designers and developers</li>
<li>Database administrators</li>
<li>Business users and non-technical senior end users</li>
</ul>
</div><table>				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Preparing Your Environment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course Setup</td>
					<td> </td>
					<td><span><i></i> 00:37:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Oracle Database Tools</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Selecting the Appropriate Database Tool</td>
					<td> </td>
					<td><span><i></i> 00:31:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Language Features</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding PL/SQL</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PL/SQL Blocks</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with SQL Plus</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The DECLARE Clause</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DECLARE Clause Objects</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PL/SQL Available Data Types</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Simple Data Types and Assignments</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex Data Types and Assignments</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex RowTypes and Assignments</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex Tables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex Records</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Declaring User-Defined Types</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The BEGIN Clause</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Can Be Included in the BEGIN Clause</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with CHAR and VARCHAR2 Variables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling String Literals</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Numeric Variables</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Date Variables</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assigning and Using Boolean Variables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Comparison Operators</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SQL Functions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL DML within PL/SQL</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SELECT</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exceptions and Embedded SQL</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Sequences</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Logic Control and Branching</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using GOTO</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with LOOPS</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Using the Indefinite Loop</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Using the Conditional Loop</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Nested Loops</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the If-Then-Else</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the CASE Statement</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The EXCEPTION Clause</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Are the Types of Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trapping Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Identify Exception Details</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating User-Defined Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SQLCODE and SQLERRM Objects</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understand the Implicit Cursor</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating User-Defined Events</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Explicit Cursors</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Concept and Purpose of Explicit Cursors</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Learn about Cursor Attributes</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Continue Statement</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Updateable Cursors</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Using Cursor Parameters</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FOR...LOOP Cursors</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Nested Blocks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding Nested Blocks</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Difference between Global vs Local Objects and Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Declared Subprograms</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Subprograms: How They Differ from Nested Blocks</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conclusion</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Course Certification </td>
				</tr>
				</tbody></table>

iStudy UK

Programming Fundamentals

Oracle

Computer Programming

Oracle 11g PL/SQL Part 1

General Admission

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			<p><span>This </span><b>Oracle 11g PL/SQL Part 2</b><span> course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP).</span></p>
<p><span>Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job!</span></p>
<h3><strong>What Will I Learn?</strong></h3>
<ul>
<li><span>Prepare your environment</span></li>
<li>Introducing Database Program Units</li>
<li>Creating and Maintaining Stored Procedures &amp; Functions</li>
<li><span>Creating and Maintaining Packages</span></li>
<li><span>Advanced Cursor Techniques</span></li>
<li><span>Using System-Supplied Packages</span></li>
<li><span>Creating and Maintaining Database Triggers</span></li>
<li><span>Implementing System Event Triggers</span></li>
</ul>
<h3><strong>Requirements</strong></h3>
<div>
<ul>
<li>Familiarity with database and programming principles</li>
</ul>
<h3><strong>Who is the target audience?</strong></h3>
<ul>
<li>Application designers and developers</li>
<li>Database administrators</li>
<li>Business users and non-technical senior end users</li>
</ul>
</div><table>				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Install Oracle XE</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Developer Installation</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Workstation Setup</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Database Program Units</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introducing the Database Program Unit</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Stored Procedures and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Stored Procedures and Functions</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Parameter Specification</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Executing Procedures and Functions</td>
					<td> </td>
					<td><span><i></i> 00:26:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Calling Functions from within SQL</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling Compilation Errors</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Maintaining Stored Procedures and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Recompiling and Dropping Programs</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Dictionary Storage</td>
					<td> </td>
					<td><span><i></i> 00:25:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Managing Dependencies</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tracking Dependencies</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Dependency Tracking Utility</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating and Maintaining Packages</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is a Package?</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Package</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package Definition Information</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Programming Techniques</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Persistent Global Objects</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Including Initialization Logic</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Object Oriented Support within Packages</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package Maintenance</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced Cursor Techniques</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Learning to Use Cursor Variables</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Cursor Techniques Weak Cursor Definitions</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>REFCURSOR Cursor Definition</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Cursor Expression</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using System Supplied Packages</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the DBMS OUTPUT() Package</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the UTL FILE() Package</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating Database Triggers</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Database Trigger</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Statement-Level Triggers</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row-Level Triggers</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 1</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 2</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 3</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with the INSTEAD OF Trigger</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Triggers within an Application</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Trigger Maintenance</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the CALL Statement</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trigger Maintenance Tasks</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Multiple Triggers for a Single Table</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling Mutating Table Issues</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Compound Trigger</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with System Event Triggers</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is a System Event Trigger</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Defining Scope</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Identifying Available System Events</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conclusion</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Course Certification</td>
				</tr>
				</tbody></table>

Database Programming

Oracle 11g PL/SQL Part 2

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Data Warehouse Administrator<br />Database Administrators<br />Support Engineer<br />Technical Administrator<br />Technical Consultant</p>Overview<p>Use Oracle Flashback Technologies to recover from human error<br />Use Recovery Manager (RMAN) to create backups and perform recovery operations<br />Use the Data Recovery Advisor to diagnose and repair failures<br />Plan effective backup and recovery procedures<br />Describe the Oracle Database architecture components related to backup and recovery operations<br />Perform an encrypted database backup and restore<br />Perform tablespace point-in-time recovery<br />Configure the database for recoverability<br />Describe Cloud Tooling for Backup and Recovery<br />Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure</p><p>In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.</p></div><div id="course-pills-2"><h4>Introduction</h4><ul><li>Curriculum Context</li><li>Assess your recovery requirements</li><li>Categories of failures</li><li>Oracle backup and recovery solutions</li><li>Oracle Maximum Availability Architecture</li><li>Oracle Secure Backup</li><li>Benefits of using Oracle Data Guard</li><li>Basic Workshop Architecture</li></ul><h4>Getting Started</h4><ul><li>Core Concepts of the Oracle Database, critical for Backup and Recovery</li><li>Oracle DBA Tools for Backup and Recovery</li><li>Connecting to Oracle Recovery Manager (RMAN)</li></ul><h4>Configuring for Recoverablility</h4><ul><li>RMAN commands</li><li>Configuring and managing persistent settings</li><li>Using the Fast Recovery Area (FRA)</li><li>Control File</li><li>Redo Log File</li><li>Archiving Logs</li></ul><h4>Using the RMAN Recovery Catalog</h4><ul><li>Creating and Configuring the Recovery Catalog</li><li>Managing Target Database Records in the Recovery Catalog</li><li>Using RMAN Stored Scripts</li><li>Maintaining and Protecting the Recovery Catalog</li><li>Virtual Private Catalogs</li></ul><h4>Backup Strategies and Terminology</h4><ul><li>Backup Solutions Overview and Terminology</li><li>Balancing Backup and Restore Requirements</li><li>Backing Up Read-Only Tablespaces</li><li>Data Warehouse Backup and Recovery: Best Practices</li><li>Additional Backup Terminology</li></ul><h4>Performing Backups</h4><ul><li>RMAN Backup Types</li><li>Incrementally Updated Backups</li><li>Fast Incremental Backup</li><li>Block Change Tracking</li><li>Oracle-Suggested Backup</li><li>Reporting on Backups</li><li>Managing Backups</li></ul><h4>Improving Your Backups</h4><ul><li>Compressing Backups</li><li>Using a Media Manager</li><li>Backup and Restore for Very Large Files</li><li>Creating RMAN Multi-section Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets</li><li>Creating and Managing Archival Backups</li><li>Backing Up Recovery Files</li><li>Backing Up the Control File to a Trace File</li><li>Cataloging Additional Backup Files</li></ul><h4>Using RMAN-Encrypted Backups</h4><ul><li>Creating RMAN-Encrypted Backups</li><li>Using Transparent-Mode Encryption</li><li>Using Password-Mode Encryption</li><li>Using Dual-Mode Encryption</li></ul><h4>Diagnosing Failures</h4><ul><li>Reducing Problem Diagnosis Time</li><li>Automatic Diagnostic Repository</li><li>Data Recovery Advisor</li><li>Handling Block Corruption</li></ul><h4>Restore and Recovery Concepts</h4><ul><li>Restoring and Recovering</li><li>Instance Failure and Instance/Crash Recovery</li><li>Media Failure</li><li>Complete Recovery (Overview)</li><li>Point-in-Time Recovery (Overview)</li><li>Recovery with the RESETLOGS Option</li></ul><h4>Performing Recovery, Part I</h4><ul><li>RMAN Recovery in NOARCHIVELOG Mode</li><li>Performing Complete Recovery (of critical and noncritical data files)</li><li>Restoring ASM Disk Groups</li><li>Recovery with Image Files</li><li>Performing Point-in-Time (PITR) or Incomplete Recovery</li></ul><h4>Performing Recovery, Part II</h4><ul><li>Recovery of Server Parameter File, Control File (One and All)</li><li>Redo Log File Loss and Recovery</li><li>Password Authentication File Re-creation</li><li>Index, Read-Only Tablespace, and Temp file Recovery</li><li>Restoring the Database to a New Host</li><li>Disaster Recovery</li><li>Restoring RMAN Encrypted Backups</li></ul><h4>RMAN and Oracle Secure Backup</h4><ul><li>Oracle Secure Backup Overview and Interface Options</li><li>RMAN and OSB: Overview and Basic Process Flow</li><li>Starting with Oracle Secure Backup</li><li>Configuring Oracle Secure Backup for RMAN</li><li>RMAN Backup and Restore Operations</li><li>Oracle Secure Backup Jobs</li><li>Displaying OSB log files and transcripts for RMAN activities</li></ul><h4>Using Flashback Technologies</h4><ul><li>Flashback Technology: Overview and Setup</li><li>Using Flashback Technology to Query Data</li><li>Flashback Table</li><li>Flashback Transaction (Query and Back out)</li><li>Flashback Drop and the Recycle Bin</li><li>Flashback Data Archive</li></ul><h4>Using Flashback Database</h4><ul><li>Flashback Database Architecture</li><li>Configuring Flashback Database</li><li>Performing Flashback Database</li><li>Best Practices for Flashback Database</li></ul><h4>Transporting Data</h4><ul><li>Transporting Data Across Platforms</li><li>Transporting Data with Backup Sets</li><li>Database Transport: Using Data Files</li></ul><h4>Performing Point-in-Time Recovery</h4><ul><li>When to use TSPITR</li><li>TSPITR Architecture</li><li>Performing RMAN TS Point-in-time Recovery</li><li>Recovering Tables from Backups</li></ul><h4>Duplicating a Database</h4><ul><li>Using a Duplicate Database</li><li>Duplicating Database with 'push' and 'pull' techniques</li><li>Choosing Database Duplication Techniques</li><li>Creating a Backup-up Based Duplicate Database</li><li>Understanding the RMAN Duplication Operation</li></ul><h4>RMAN Troubleshooting and Tuning</h4><ul><li>Interpreting RMAN Message Output</li><li>Tuning Principles</li><li>Diagnosing Performance Bottlenecks</li><li>RMAN Multiplexing</li><li>Restore and Recovery Performance Best Practices</li></ul><h4>Cloud Tooling for Backup and Recovery</h4><ul><li>Backup Destinations</li><li>Customize Backup Configuration</li><li>On-Demand Backup and Recovery</li><li>Oracle Backup Cloud Service</li><li>Installing the Backup Module</li></ul><h4>Backup and Recovery Workshop</h4><ul><li>Workshop Structure and Approach</li><li>Business Requirements for Database Availability and Procedures</li><li>Diagnosing the Failures</li></ul></div>

Oracle Database 12c R2 - Backup and Recovery Workshop Ed 3

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>Architect<br />Database Administrators</p>Overview<p>Configure and use Policy-Based Cluster Management in conjunction with Policy-Managed Database and Oracle<br />Multitenant Architecture<br />Migrate from a standard cluster to a Flex Cluster and configure highly available application resources on Flex Cluster<br />Leaf Nodes<br />Implement Oracle Database In-Memory on an existing Oracle RAC database<br />Configure an Oracle RAC database to use Application Continuity<br />Configure and use Global Data Services in conjunction with Oracle RAC and Data Guard<br />Upgrade an existing database to use Oracle ASM Filter Driver<br />Migrate from standard ASM to Flex ASM and examine the effect of using Flex ASM<br />Perform a database rolling upgrade, from Oracle Database 11gR2 to Oracle Database 12c, using a transient logical standby database</p><p>Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure.</p></div><div id="course-pills-2">Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure.</div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Database 12c - RAC and Grid Infra Deployment Workshop 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 12c - RAC and Grid Infra Deployment Workshop 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>

Trainers Course

Oracle Database 12c - RAC and Grid Infra Deployment Workshop

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>AdministratorDatabase Administrators</p>Overview<p>Describe the components of ASMExplain and apply Automatic Storage Management (ASM) initialization parametersManage ASM instances and associated processesMonitor ASM using the V$ASM dynamic performance viewsUnderstand Flex ASM architecture and componentsUnderstand ASM Deployment AlternativesInstall and configure Flex ASMManage Flex ASMEmploy ASM space management techniquesCreate and delete Automatic Storage Management (ASM) disk groupsSet the attributes of an existing ASM disk groupPerform ongoing maintenance tasks on ASM disk groupsExplain key performance and scalability considerations for ASM disk groupsDescribe the Automatic Storage Management (ASM) architectureUse different client tools to access ASM filesDescribe the format of a fully qualified ASM file name</p><p>This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications.</p></div><div id="course-pills-2">This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications.</div>

Oracle Database 12c - ASM Administration Ed 1

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Application DevelopersBusiness AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystReports DeveloperTechnical Consultant</p>Overview<p>Build and run analyses to test and validate a repositorySet up query logging for testing and debuggingSet up a multiuser development environmentUse the Administration Tool wizards and utilities to manage, maintain, and enhance repositoriesEnable usage tracking to track queries and database usage, and improve query performancePerform a patch merge in a development-to-production scenarioDescribe Exalytics machine and the Summary Advisor tool used in the machineBuild simple and calculated measures for a fact tableCreate logical dimension hierarchies and level-based measuresCheck the model and then model aggregate tables to speed query processingModel partitions and fragments to improve application performance and usabilityUse variables to streamline administrative tasks and modify metadata content dynamicallyUse time series functions to support historical time comparison analysesSet up security to authenticate users and assign appropriate permissions and privilegesBuild the Physical, Business Model and Mapping, and Presentation layers of a repositoryApply cache management techniques to maintain and enhance query performance</p><p>This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository.</p></div><div id="course-pills-2">This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository.</div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle BI 11g R1 - Build Repositories 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 BI 11g R1 - Build Repositories 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>

Business Analytics & Intelligence

Microsoft BI

Business Intelligence (BI)

Oracle BI 11g R1 - Build Repositories

<div>
	<h3><strong>Description</strong></h3>
<p><span>The Oracle Database server composes PL/SQL units and stores it in the database.  Mainly, PL/SQL functions to hold to hold SQL declaration within its sentence structure. Do you want to know more about SL/SQL function? How does it bring optimal proficiency in 'procedural language'? if so, take a look at the Oracle 11g PL/SQL Intermediate course. It will assist you in understanding all you need to know about Oracle 11g PL/SQL. </span></p>
<p><span>The course designs to help the learners to know its function incorporation with different strings, numbers, table row record, and error management. The Oracle 11g PL/SQL Intermediate course teaches the fundamental form and structure of the program unit saved within database, creating and managing stored methods, functions, packaged programs, and database prompts. Its contents aim to take you further in your quest to teach the effective methods including variables and cursor expressions. </span></p>
<h3><b>Assessment:</b></h3>
<p>This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.</p>
<h3><strong>Certification:</strong></h3>
<p>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</p>
<h3><b>Who is this Course for?</b></h3>
<p><strong>Oracle 11g PL/SQL Intermediate</strong> is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</p>
<p>As there is no experience and qualification required for this course, it is available for all students from any academic background.</p>
<h3><b>Requirements</b></h3>
<p>Our<b> Oracle 11g PL/SQL Intermediate</b> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</p>
<h3><b>Career Path</b></h3>
<p>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Preparing Your Environment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Install Oracle XE</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Developer Installation</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Workstation Setup</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Database Program Units</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introducing the Database Program Unit</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Stored Procedures and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Stored Procedures and Functions</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Parameter Specification</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Executing Procedures and Functions</td>
					<td> </td>
					<td><span><i></i> 00:26:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Calling Functions from within SQL</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling Compilation Errors</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Maintaining Stored Procedures and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Recompiling and Dropping Programs</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Dictionary Storage</td>
					<td> </td>
					<td><span><i></i> 00:25:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Managing Dependencies</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tracking Dependencies</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Dependency Tracking Utility</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating and Maintaining Packages</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is a Package?</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Package</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package Definition Information</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Programming Techniques</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Persistent Global Objects</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Including Initialization Logic</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Object Oriented Support within Packages</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package Maintenance</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced Cursor Techniques</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Learning to Use Cursor Variables</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Cursor Techniques Weak Cursor Definitions</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>REFCURSOR Cursor Definition</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Cursor Expression</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using System Supplied Packages</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the DBMS OUTPUT() Package</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the UTL FILE() Package</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating Database Triggers</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Database Trigger</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Statement-Level Triggers</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row-Level Triggers</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 1</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 2</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 3</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with the INSTEAD OF Trigger</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Triggers within an Application</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Trigger Maintenance</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the CALL Statement</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trigger Maintenance Tasks</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Multiple Triggers for a Single Table</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling Mutating Table Issues</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Compound Trigger</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with System Event Triggers</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is a System Event Trigger</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Defining Scope</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Identifying Available System Events</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conclusion</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Order Your Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Order Your Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Microsoft PL-900

Oracle 11g PL/SQL Intermediate

<div>
	<h3><strong>Description</strong></h3>
<p><span>PL/SQL is program units which are composed by the Oracle Database server and stored in the database.  The main function of PL/SQL is to hold SQL proclamation within its syntax. If you are interested to know more about SL/SQL function, and how it brings optimal competence in terms of 'procedural language', you may have a look at the Oracle 11g PL/SQL Beginner course.</span></p>
<p><span>The course is designed in such a way that will assist the learners to know how it works with various strings, numbers, table row record, and error management. It also teaches the learner how to use different key data lexicon to synopsize and maintain the data. The learners will also be able to know about portability, productivity, and manageability of this most widely manipulative language.</span></p>
<h3><b>Assessment:</b></h3>
<p>This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.</p>
<h3><strong>Certification:</strong></h3>
<p>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</p>
<h3><b>Who is this Course for?</b></h3>
<p><strong>Oracle 11g PL/SQL Beginner</strong> is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</p>
<p>As there is no experience and qualification required for this course, it is available for all students from any academic background.</p>
<h3><b>Requirements</b></h3>
<p>Our<b> Oracle 11g PL/SQL Beginner</b> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</p>
<h3><b>Career Path</b></h3>
<p>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Preparing Your Environment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course Setup</td>
					<td> </td>
					<td><span><i></i> 00:37:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Oracle Database Tools</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Selecting the Appropriate Database Tool</td>
					<td> </td>
					<td><span><i></i> 00:31:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Language Features</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding PL/SQL</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PL/SQL Blocks</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with SQL Plus</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The DECLARE Clause</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DECLARE Clause Objects</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PL/SQL Available Data Types</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Simple Data Types and Assignments</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex Data Types and Assignments</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex RowTypes and Assignments</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex Tables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex Records</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Declaring User-Defined Types</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The BEGIN Clause</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Can Be Included in the BEGIN Clause</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with CHAR and VARCHAR2 Variables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling String Literals</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Numeric Variables</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Date Variables</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assigning and Using Boolean Variables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Comparison Operators</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SQL Functions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL DML within PL/SQL</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SELECT</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exceptions and Embedded SQL</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Sequences</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Logic Control and Branching</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using GOTO</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with LOOPS</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Using the Indefinite Loop</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Using the Conditional Loop</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Nested Loops</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the If-Then-Else</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the CASE Statement</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The EXCEPTION Clause</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Are the Types of Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trapping Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Identify Exception Details</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating User-Defined Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SQLCODE and SQLERRM Objects</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understand the Implicit Cursor</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating User-Defined Events</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Explicit Cursors</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Concept and Purpose of Explicit Cursors</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Learn about Cursor Attributes</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Continue Statement</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Updateable Cursors</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Using Cursor Parameters</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FORLOOP Cursors</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Nested Blocks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding Nested Blocks</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Difference between Global vs Local Objects and Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Declared Subprograms</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Subprograms: How They Differ from Nested Blocks</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conclusion</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Microsoft PL-200

Oracle 11g PL/SQL Beginner

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is for analysts, developers, and administrators of IBM Watson Explorer Deep Analytics Edition oneWEX.</p>Overview<p>Identify oneWEX platformsIdentify the process and data flows of oneWEX projectsExplore the oneWEX user interfaceExplain ingestion and conversionUtilize Content MinerDefine enrichmentIdentify advanced features of oneWEX</p><p>This course is designed to teach students core concepts of IBM Watson Explorer Deep Analytics Edition oneWEX. Students will learn to identify the oneWEX platforms as well as the process flow and data flow of oneWEX projects. Students will explore oneWEX tools, such as Content Miner and the Admin Console, while gaining hands-on experience in data acquisition and enrichment. Finally, students will be exposed to more advanced topics, such as Application Builder, Content Analytics Studio, and API usage.</p></div><div id="course-pills-2"><h4>Overview of oneWEX</h4><ul><li>Introduction to oneWEX</li><li>Explore oneWEX architecture</li><li>Identify installation options</li></ul><h4>Navigation in oneWEX</h4><ul><li>Explore the Admin Console</li><li>Explore navigation using Content Miner</li><li>The Collection detail view</li><li>The REST API</li></ul><h4>Data flow</h4><ul><li>Explore the data flow of oneWEX</li><li>Search and Analytics collection templates</li></ul><h4>Identify data acquisition</h4><ul><li>Data ingestion</li><li>Work with datasets</li><li>Work with crawlers</li><li>Use an importer</li><li>Explore conversion</li><li>Data ingestion log files</li></ul><h4>Analysis using oneWEX Content Miner</h4><ul><li>Explore analysis using Content Miner</li><li>The Guided Analysis Experience</li><li>The Guided Analysis view</li></ul><h4>Explore Annotators</h4><ul><li>Enrichment using Annotators</li><li>Annotator types</li></ul><h4>Enrichment using Labeler</h4><ul><li>Identify enrichment</li><li>Identify document classification</li><li>Classify using training data</li><li>Classification versus clustering</li><li>The document classification process</li></ul><h4>Enrichment using Ranker</h4><ul><li>Identify enrichment using Ranker</li><li>The ranking process</li></ul><h4>Migrate annotators from Content Analytics Studio</h4><ul><li>Migrate Content Analytics Studio annotators</li><li>Identify the UIMA pipeline configuration for oneWEX</li><li>Update annotators</li></ul><h4>Using Application Builder with oneWEX</h4><ul><li>Application Builder and user roles</li><li>Explore Application Builder</li><li>Set up a oneWEX data source</li><li>Functionality for oneWEX data sources</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans O3201 Fundamentals of IBM Watson Explorer Deep Analytics Edition oneWEX (V12.0.x) 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 O3201 Fundamentals of IBM Watson Explorer Deep Analytics Edition oneWEX (V12.0.x) 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>

O3201 Fundamentals of IBM Watson Explorer Deep Analytics Edition oneWEX (V12.0.x)

<strong>Learn how to deploy, manage, and secure Oracle WebLogic in an enterprise environment.</strong>
        <p>Oracle WebLogic 12c for Administrators is designed to teach systems administrators and developers how to deploy, configure and manage the leading enterprise application server in an enterprise environment. This course takes a pragmatic step-by-step approach and uses a combination of video lectures and hands-on labs to easily break down complex and confusing topics into an easy-to-understand format. Oracle WebLogic 12c for Administrators will teach you how to deploy and manage an Oracle WebLogic 12c environment by introducing you to a variety of topics from architectural concepts and best practices, to domain configuration, runtime management, and (of course) how to secure WebLogic. 

By the end of this course, you will have gained the skills you need to securely deploy WebLogic in an enterprise environment. 

If you have been hesitant to check out WebLogic or if you want to learn more about WebLogic features and best practices, then this course is for you. It supplies easy-to-understand lectures and hands-on lab work.

All the codes and supporting files for this course are available at - https://github.com/PacktPublishing/Oracle-WebLogic-12c-for-Administrators</p>
        <h2>What You Will Learn</h2><p>Satisfy system prerequisites for deploying Oracle WebLogic 12c<br>Install Oracle WebLogic<br>Create WebLogic domains <br>Configure WebLogic JDBC and JMS resources<br>Secure a WebLogic domain using best practices<br>Script common WebLogic management tasks using WLST</p>
        <h2>Audience</h2><p>This course has been designed for systems administrators and DevOps engineers who need to support Oracle WebLogic in an enterprise environment; however, anyone who is interested in learning about WebLogic and its features will find this course greatly beneficial.</p>
        <h2>Approach</h2><p>Oracle WebLogic 12c for Administrators is broken up into a series of topics that cover each core aspect of WebLogic. Each topic comprises a video lecture that clearly explains and illustrates one aspect of WebLogic and is followed by a hands-on lab exercise.</p>
        <h2>Key Features</h2><p>Install and configure WebLogic resources (JMS and JDBC) and deploy applications in a production environment * Covers all major areas of Oracle WebLogic 12c, from design to deployment to security * A practical course designed to help you understand architectural and technical concepts.</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/oracle-weblogic-12c-for-administrators</p>
        <h2>About the Author</h2><h3>Chris Parent</h3><p>Chris Parent has nearly 20 years of software development, architecture and IT management experience in defence and commercial industries with a focus on enterprise and cloud architectures. He has consulted as an architect and consultant with companies such as Lockheed Martin, Northrop Grumman, Raytheon, and Oracle on the implementation and use of Oracle Fusion Middleware products including Oracle WebLogic Server, SOA Suite, and Identity and Access Management. He received his undergraduate and graduate degrees in Computer Science and Systems Engineering from Rensselaer Polytechnic University in Troy, NY and Penn State University respectively. Chris resides with his family in Denver, Colorado USA.</p>
        <h2>Course Outline</h2><h4>1. Welcome to the Course!</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video includes overview of the course, topics, audience, and any prerequisites or requirements.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab Guide Overview - here you will find the Lab Guide and files you need</p><p style='margin: 0'>In this video author introduces the Lab Guide and how the labs are organized and put together for this course.</p></td></tr></tbody></table><br><h4>2. WebLogic Domain</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Installing WebLogic</p><p style='margin: 0'>This video introduces the first step to learning WebLogic and that is installing the product.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #1 Installing WebLogic</p><p style='margin: 0'>In this lab you will download and install JDK7 and WLS 12.1.3.</p></td></tr><tr><td style='padding: 15px;'><p>3. Creating a Domain</p><p style='margin: 0'>This video will briefly discuss the various options for creating WebLogic domains, specifically Configuration Wizard, Template Builder, and WLST.</p></td></tr><tr><td style='padding: 15px;'><p>4. Lab #2 Creating a Domain</p><p style='margin: 0'>In this lab you will use the Configuration Wizard, Template Builder and WLST to create domains. Refer to the Lab Guide found under Lecture 1 Introduction.</p></td></tr></tbody></table><br><h4>3. WebLogic Servers</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Admin Server and Admin Console</p><p style='margin: 0'>Learn the function and purpose of the WebLogic admin server and the key role it plays within a WebLogic domain.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #3 Admin Server</p><p style='margin: 0'>In this lab you will learn how to start the admin server and how to access the admin console. Refer to the Lab Guide found under Lecture 1 Introduction.</p></td></tr><tr><td style='padding: 15px;'><p>3. Managed Servers</p><p style='margin: 0'>In this video you will learn what a WebLogic managed server and its role within a domain.</p></td></tr><tr><td style='padding: 15px;'><p>4. Lab #4 Managed Servers Part 1</p><p style='margin: 0'>In this lab you will create a managed server using the admin console. You'll then start this managed server and monitor it via the admin console.</p></td></tr><tr><td style='padding: 15px;'><p>5. Lab #4 Managed Servers Part 2</p><p style='margin: 0'>Part 2 concludes with basic server monitoring using the admin console.</p></td></tr></tbody></table><br><h4>4. JDBC Data Sources</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Data Sources</p><p style='margin: 0'>This lecture introduces WebLogic data sources and discusses Generic, GridLink, and Multi-datasources and XA versus non-XA JDBC drivers</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #5 Data Sources Part 1</p><p style='margin: 0'>In this lab you will learn how to create, configure, and monitor a WebLogic data source using the admin console. The lab is broken up into 2 parts. Part 1 covers the configuration of Derby database.</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #5 Data Sources Part 2</p><p style='margin: 0'>In Part 2 of this lab you will learn how to create and connect a data source to an instance of Derby created in Part 1</p></td></tr></tbody></table><br><h4>5. JMS</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. JMS</p><p style='margin: 0'>Learn basic WebLogic JMS concepts such as Publish/subscribe versus Point-to-Point, JMS architecture, JMS servers and JMS system and application modules</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #6 JMS Part 1</p><p style='margin: 0'>In Part 1 of this lab you will learn how to create and configure file-based persistent storage and a JMS server.</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #6 JMS Part 2</p><p style='margin: 0'>In Part 2 of this lab you will create JMS system models containing a connection factory and a JMS destination. You will then test the destination by generating a JMS message using the admin console.</p></td></tr></tbody></table><br><h4>6. Application Deployment</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Application Deployment</p><p style='margin: 0'>Understand the concepts and tools behind deploying applications to WebLogic. This lecture introduces the student to using the admin console and command line tools for deployment.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #7 Application Deployment Part 1</p><p style='margin: 0'>In Part 1 of this lab you will learn how to use the admin console to deploy an enterprise application.</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #7 Application Deployment Part 2</p><p style='margin: 0'>In Part 2 of this lab teaches the student how to use command-line tools for deploying applications to WebLogic.</p></td></tr><tr><td style='padding: 15px;'><p>4. Production Application Deployment</p><p style='margin: 0'>In this lecture you will learn about various techniques and strategies for deploying applications in a production environment, specifically Deployment plans, Application installation directories and In-place and Zero-downtime upgrades</p></td></tr><tr><td style='padding: 15px;'><p>5. Lab #8 Production Application Deployment Part 1</p><p style='margin: 0'>In this lab you will learn how to deploy an application using deployment plans and an application installation directory.</p></td></tr><tr><td style='padding: 15px;'><p>6. Lab #8 Production Application Deployment Part 2</p><p style='margin: 0'>Part 2 of this lab covers versioning and upgrading applications for deployment using weblogic.Deployer</p></td></tr></tbody></table><br><h4>7. Security</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. WebLogic Security Part 1</p><p style='margin: 0'>In Part 1 you will be introduced to WebLogic-related security concepts and general security guidelines such as Secure installation of WebLogic, Domain creation, Securing a WebLogic domain, Domain-wide administration port and SSL</p></td></tr><tr><td style='padding: 15px;'><p>2. WebLogic Security Part 2</p><p style='margin: 0'>In Part 2 of this lecture we will discuss Security realms, Users, groups, roles, and security policies, Security providers and Security provider database</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #9 WebLogic Security Part 1</p><p style='margin: 0'>In this lab you will learn how to protect a weblogic domain by configuring the administration port.</p></td></tr><tr><td style='padding: 15px;'><p>4. Lab #9 WebLogic Security Part 2</p><p style='margin: 0'>In Part 2 of this lab you will create a SQL Authentication Provider using Derby DB.</p></td></tr><tr><td style='padding: 15px;'><p>5. Lab #9 WebLogic Security Part 3</p><p style='margin: 0'>In Part 3 of this lab you will learn how to configure Password complexity, User lockout and Auditing provider</p></td></tr><tr><td style='padding: 15px;'><p>6. Lab #9 WebLogic Security Part 4</p><p style='margin: 0'>In this lab you will learn how to protect an application using groups, roles, and a security policy.</p></td></tr></tbody></table><br><h4>8. High Availability and Failover</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. WebLogic Clusters Part 1</p><p style='margin: 0'>Part 1 of this lecture will cover Benefits and capabilities, Cluster communications and Basic cluster architectures</p></td></tr><tr><td style='padding: 15px;'><p>2. WebLogic Clusters Part 2</p><p style='margin: 0'>Part 2 of this lecture will cover Load balancing, Failover and Server and Service Migration</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #10 Clusters Part 1</p><p style='margin: 0'>In Part 1 of this lab you will learn how to create and configure a cluster. You'll also deploy some resources to the cluster, including a data source and an application.</p></td></tr><tr><td style='padding: 15px;'><p>4. Lab #10 Clusters Part 2</p><p style='margin: 0'>In Part 2 of this lab you will cluster an application by deploying it to a cluster.</p></td></tr><tr><td style='padding: 15px;'><p>5. Lab #10 Clusters Part 3</p><p style='margin: 0'>In Part 3 of this lab you will configure and deploy a proxy service using the HttpClusterServlet. Be sure to download the Lab Files.zip from Lecture 2. The zip file contains the proxy web application you will need for the lab.</p></td></tr></tbody></table><br><h4>9. Node Manager</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Node Manager</p><p style='margin: 0'>In this lecture you will learn about WebLogic's Node Manager utility for controlling server lifecycle. The lecture will cover key terms and concepts, architecture, data flows, and basic configuration.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #11 Node Manager Part 1</p><p style='margin: 0'>In this lab you will Configure Node Manager to run securely, Create WebLogic Machines and Connect WLST using SSL</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #11 Node Manager Part 2</p><p style='margin: 0'>In Part 2 of this lab you will Generate Node Manager startup and boot properties for the Admin Server, Start the Admin Server using WLST, Start Managed Servers using the Admin Console and Simulate a restart of a failed server</p></td></tr></tbody></table><br><h4>10. Distributed Deployment</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Distributed Deployment</p><p style='margin: 0'>Understand how to scale out WebLogic deployments using managed server templates and Node Manager.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #12 Distributed Deployment Part 1</p><p style='margin: 0'>In Part 1 of this lab, you will learn about distributed deployment.</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #12 Distributed Deployment Part 2</p><p style='margin: 0'>In Part 2 of this lab, you will learn about distributed deployment.</p></td></tr></tbody></table><br><h4>11. WebLogic Scripting Tool</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Intro to WLST</p><p style='margin: 0'>This video introduces you to WLST.</p></td></tr><tr><td style='padding: 15px;'><p>2. WLST Command Types</p><p style='margin: 0'>This video is about WLST Command types</p></td></tr><tr><td style='padding: 15px;'><p>3. Online versus Offline Modes</p><p style='margin: 0'>This video is about Online versus Offline modes.</p></td></tr><tr><td style='padding: 15px;'><p>4. MBeans Part 1</p><p style='margin: 0'>Learn about MBeans here.</p></td></tr><tr><td style='padding: 15px;'><p>5. MBeans Part 2</p><p style='margin: 0'>This video is about MBeans.</p></td></tr><tr><td style='padding: 15px;'><p>6. Interactive Mode</p><p style='margin: 0'>This video is about Interactive Mode.</p></td></tr><tr><td style='padding: 15px;'><p>7. WLS Example</p><p style='margin: 0'>This video is WLS Example</p></td></tr><tr><td style='padding: 15px;'><p>8. Lab 13.1 - Launching WLST</p><p style='margin: 0'>Learn how to launch WLST interactively.</p></td></tr><tr><td style='padding: 15px;'><p>9. Lab 13.2 - Creating a Domain using WLST</p><p style='margin: 0'>Create a domain using WLST and a domain template.</p></td></tr><tr><td style='padding: 15px;'><p>10. Lab 13.3 - Using Online Mode</p><p style='margin: 0'>This video is about connect the admin server using online mode</p></td></tr><tr><td style='padding: 15px;'><p>11. Lab 13.4 - Creating a Managed Server, Deploying a Web application and Monitoring Application Deployment Status</p><p style='margin: 0'>This video shows to create a managed server using WLST, how to deploy a web application to Weblogic using WLST and shows monitoring a domain using WLST.</p></td></tr><tr><td style='padding: 15px;'><p>12. Lab 13.7 - Recording WLST Scripts</p><p style='margin: 0'>Learn how to generate WLST scripts by recording your interactions within the WebLogic administration console.</p></td></tr><tr><td style='padding: 15px;'><p>13. Lab 13.8 - WLST Security</p><p style='margin: 0'>Learn how to connect to the admin server using a private key. In this lab you will create a symmetric key that will be used to authenticate against WebLogic. This is a safer alternative than using named credentials when executing connect () statements.</p></td></tr></tbody></table>

Packt

AWS Certified Developer

Linux Administration

Cloud Computing

AWS Certified Cloud Practitioner

Learn how to deploy, manage, and secure Oracle WebLogic in an enterprise environment.

Oracle WebLogic 12c for Administrators

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This intermediate course is for Business and Technical Specialist working with the Matching, Linking, and Search services of InfoSphere MDM Virtual module.</p>Overview<p> Understand how Matching and Linking work for both the Virtual Implementations of InfoSphere MDM<br />Understand the MDM configuration project and database tables used by the PME<br />Understand the PME Algorithms (Standardization, Bucketing and Comparison steps) and how to create and customize the algorithms using the workbench<br />Understand how to analyze the Bucketing steps in an algorithm<br />Understand how to generate weights for a given algorithm and how those weights are generated based on a sample database set<br />Understand how to analyze the weights that are generated using the workbench<br />Understand how to deploy the PME configuration for the Virtual implementations of InfoSphere MDM</p><p>The InfoSphere MDM Virtual Module Algorithms V.11 course prepares students to work with and customize the algorithm configurations deployed to the InfoSphere MDM Probabilistic Matching Engine (PME) for Virtual MDM implementations.</p></div><div id="course-pills-2"><h4>PME and Virtual Overview</h4><ul><li>Virtual MDM Overview<br />Terminology (Source, Entity, Member, Attributes)<br />PME and Virtual MDM ( Algorithms, Weights, Comparison Scores, Thresholds)<br />Virtual MDM Linkages and Tasks </li></ul><h4>Virtual MDM Algorithms</h4><ul><li>Standardization<br />Bucketing<br />Comparison Functions</li></ul><h4>Virtual PME Data Model</h4><ul><li>Algorithm configuration tables<br />Member Derived Data<br />Bucketing Data</li></ul><h4>Bucket Analysis</h4><ul><li>Analysis Overview<br />Attribute Completeness<br />Bucket Analysis</li></ul><h4>Weights</h4><ul><li>Weights Overview (Frequency-based weights, Edit Distance weights and Parameterize weights)<br />The weight formula<br />Running weight generation<br />Analyzing weights<br />Bulk Cross Match process<br />Pair Manager<br />Threshold calculations</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans ZZ880 IBM Virtual Module Algorithms for InfoSphere MDM V11 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 ZZ880 IBM Virtual Module Algorithms for InfoSphere MDM V11 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>

Microsoft Virtual Academy (MVA)

IMS Productivity Analyst

IBM MQ

ZZ880 IBM Virtual Module Algorithms for InfoSphere MDM V11

<div id="course-pills-1">Duration<p>4.5 Days</p><p>27 CPD hours</p>This course is intended for<p>This is an intermediate course for experienced data professionals such as z/OS system programmers, who are responsible for the installation and maintenance of z/OS UNIX.</p>Overview<p>Execute the tasks required to prepare a z/OS installation for implementing z/OS UNIXExecute the tasks to install the z/OS UNIX software featuresUse the information provided in this class to perform the basic customization necessary to fully implement the z/OS UNIX kernel, the file system, the shell and utilities, and z/OS UNIX applicationsPut in place the RACF security required for z/OS UNIX resources and applicationsMake appropriate definitions for the activation of TCP/IP sockets by z/OS UNIXIdentify and use the processes and data required for monitoring and tuning the z/OS UNIX environment</p><p>This course is designed to provide you with the skills required to install and customize z/OS UNIX (full name z/OS UNIX System Services), and to manage and monitor the z/OS UNIX environment.</p></div><div id="course-pills-2"><h4>Day 1</h4><ul><li>Welcome</li><li>Unit 1: z/OS UNIX implementation overview</li><li>Unit 2: z/OS UNIX services initial installation</li><li>Exercise 1: Move from default to full mode function</li><li>Exercise 2: IPL in full function mode and enable a nonvolatile root HFS</li><li>Unit 3: File system customization</li></ul><h4>Day 2</h4><ul><li>Exercise 3: Customizing the file system</li><li>Unit 4: Security customization</li><li>Exercise 4: Defining and managing UNIX users, OMVS security</li></ul><h4>Day 3</h4><ul><li>Unit 5: Shell customization</li><li>Exercise 5: UNIX System Services and shell customization</li><li>Unit 6: Customizing applications, daemons, and servers</li><li>Exercise 6: UNIX processes</li><li>Exercise 7: Access control list and enhanced ASCII support</li></ul><h4>Day 4</h4><ul><li>Unit 7: File system management and system maintenance</li><li>Exercise 8: Managing HFS and zFS data sets</li><li>Unit 8: Managing z/OS UNIX operations</li><li>Unit 9: Exploiting TCP/IP with z/OS UNIX</li><li>Exercise 9: Managing z/OS UNIX</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans OP25 IBM z/OS UNIX System Services Implementation 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 OP25 IBM z/OS UNIX System Services Implementation 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>

Operating Systems & Services

OP25 IBM z/OS UNIX System Services Implementation

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The course provides an intensive hands-on experience for key system administration tasks with the goal of making the system administrator job-ready.</p>Overview<p>Administer the Oracle Solaris 11 Host on an Existing Network<br />Administer Oracle Solaris Zones<br />Control Access to Systems and Files<br />Install Oracle Solaris 11 Operating System<br />Administer User Accounts<br />Administer System Processes and Schedule System Tasks<br />Manage Data by Using ZFS<br />Manage Boot and Shutdown of a System<br />Administer Services by Using SMF<br />Administer Software Packages by Using IPS and Manage Boot Environments<br />Describe the use of IPS in packaging the Oracle Solaris OS<br />Manage boot environments<br />Updating the OS by using IPS</p><p>The Oracle Solaris 11 System Administration training covers the full range of introductory system administration tasks on Oracle Solaris 11.3 OS. The topics covered range from installing the operating system on a single system, to monitoring and basic troubleshooting. The Oracle Solaris 11 System Administration course is designed to provide new system administrators, as well as enterprise system administrators who are new to the Oracle Solaris 11 Operating System, with the skills they need to perform their job tasks successfully and efficiently.</p></div><div id="course-pills-2"><h4>Installing Oracle Solaris 11 Operating System</h4><ul><li>Introduction to Oracle Solaris 11 OS</li><li>Planning for Oracle Solaris 11 OS installation</li><li>Installing Oracle Solaris 11 OS by Using the Live Media Installer</li><li>Installing Oracle Solaris 11 OS Using the Text Installer</li><li>Verifying the OS Installation</li></ul><h4>Managing Boot and Shutdown of Systems</h4><ul><li>Analyze the boot design and boot process</li><li>Boot a SPARC-based system</li><li>Boot an x86-based system</li><li>Shut down a system</li></ul><h4>Administering Services by Using SMF</h4><ul><li>Describing SMF and its components</li><li>Administering SMF Services</li></ul><h4>Administering Software Packages by Using IPS and Managing Boot Environments</h4><ul><li>Describing IPS, its components, and interfaces</li><li>Configuring an IPS Client to Access the Local IPS Repository</li><li>Managing Package Publishers</li><li>Managing Software Packages</li><li>Managing Signed Packages and Package Properties</li><li>Describe the use of IPS in packaging the Oracle Solaris OS</li><li>Manage boot environments</li><li>Updating the OS by using IPS</li></ul><h4>Managing Data by Using ZFS</h4><ul><li>Introducing ZFS</li><li>Administering ZFS Storage Pools</li><li>Administering ZFS File Systems</li><li>Administering ZFS Properties</li><li>Administering ZFS Snapshots and Clones</li></ul><h4>Administering the Network</h4><ul><li>Reviewing Networking Fundamentals</li><li>Administering Datalink Configuration</li><li>Administering a Network Interface</li><li>Administering Profile-Based Network Configuration</li><li>Configuring a Virtual Network</li><li>Verifying the Network Operations</li><li>Managing Resources on the Virtual Network</li></ul><h4>Administering Oracle Solaris Zones</h4><ul><li>Introducing Oracle Solaris Zones</li><li>Configuring an Oracle Solaris Zone</li><li>Determining an Oracle Solaris Zone Configuration</li></ul><h4>Controlling Access to Systems and Files</h4><ul><li>Controlling Access to Systems</li><li>Controlling Access to Files</li><li>Securing Access to Remote Host</li></ul><h4>Administering User Accounts</h4><ul><li>Getting Started with the User Administration</li><li>Setting Up User Accounts</li><li>Maintaining User Accounts</li><li>Configuring User Disk Quotas</li></ul><h4>Managing System Processes and System Tasks</h4><ul><li>Managing System Processes</li><li>Scheduling System Administration Tasks</li></ul></div>

Oracle Solaris 11 System Administration

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This basic course is for IT personnel with a theoretical background of z/OS.</p>Overview<p>Review the main concepts of z/OS Log on to TSO and start ISPF/PDF Navigate through ISPF/PDF dialogs and use the basic ISPF/PDF functions and the ISPF Editor Use ISPF/PDF to allocate data sets and edit data sets (including hierarchical file system (HFS) files) via the ISPF Editor primary and line commands Use ISPF to create and manipulate (copy, rename, delete, list, sort and merge) data sets Identify security considerations for Multiple Virtual Storage (MVS) data sets and HFS files Describe and use TSO/E commands Perform simple modifications to existing ISPF/PDF panels Invoke a REXX exec and TSO CLIST Tailor existing JCL and submit batch jobs Review job status and job output using SDSF Invoke UNIX processes Manipulate HFS directories and file systems using the UNIX System Services ISHELL</p><p>This course is designed to teach students the fundamental practical skills to navigate and work in a z/OS environment. This includes the use of ISPF/PDF dialogs, TSO/E commands, JCL, UNIX System Services shell, and BookManager.</p></div><div id="course-pills-2"><h4>Review of the z/Architecture and z/OS </h4><h4>An Introduction to ISPF, ISPF/PDF, and RACF </h4><ul><li>System familiarization </li></ul><h4>Working with ISPF/PDF (Part 1 &amp; 2) </h4><ul><li>Allocate new data sets </li><li>ISPF editor primary commands </li><li>ISPF editor line command </li><li>Copy/move/rename/delete data sets and members </li><li>Data set lists </li></ul><h4>Working with TSO/E </h4><ul><li>Using TSO/E commands </li></ul><h4>Working with JCL</h4><ul><li>Submit a job </li><li>JCL exercises</li></ul><h4>Working with UNIX System Services </h4><ul><li>Procedures</li><li>ISHELL and hierarchical file system</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans ES10 IBM Fundamental System Skills in z/OS 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 ES10 IBM Fundamental System Skills in z/OS 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>

Computing Skills

IT Skills

Core Skills Training Framework (CSTF)

Professional Skills Course (PSC)

ES10 IBM Fundamental System Skills in z/OS

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Technical Administrator<br />Java EE Developer<br />System Administrator</p>Overview<p>Configure WebLogic Server's authentication provider<br />Deploy applications to WebLogic Server<br />Backup and restore a WebLogic Server domain<br />Create a WebLogic Server domain<br />Configure and monitor WebLogic Server<br />Configure WebLogic Server database resources<br />Create and configure a WebLogic Server cluster<br />Install WebLogic Server 12c</p><p>This Oracle WebLogic Server 12c: Administration I training teaches administrators to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server.</p></div><div id="course-pills-2">This Oracle WebLogic Server 12c: Administration I training teaches administrators to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server.</div>

Oracle WebLogic Server 12c - Administration I

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>System Administrator<br />Administrator<br />Java EE Developer<br />Web Administrator<br />Technical Consultant<br />Security Administrators<br />Technical Administrator</p>Overview<p>Configure WebLogic features including domain templates, system start up, crash recovery, work managers, multi data sources, security policies, and automatic JTA migration<br />Configure Coherence features<br />Perform a rolling upgrade of WebLogic Server<br />Write and run WLST scripts<br />Deploy shared libraries and applications using deployment plans and versioning<br />Configure SSL for WebLogic Server</p><p>This Oracle WebLogic Server 12c: Administration II is a continuation of the Oracle WebLogic Server 12c: Administration I course.</p></div><div id="course-pills-2">This Oracle WebLogic Server 12c: Administration II is a continuation of the Oracle WebLogic Server 12c: Administration I course.</div>

Oracle WebLogic Server 12c - Administration II

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This hands-on course is geared for experienced DBAs new to Oracle 19c, who can work in Linux and have basic experience with SQL scripting.</p>Overview<p>This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to:<br />How to use tools to access an Oracle Database<br />Generate database creation scripts by using DBCA<br />How to create a container database (CDB) by using the CREATE DATABASE command<br />Learn about Startup and shut down Oracle databases<br />Initialization parameter files and initialization parameters<br />Tools that are used to administer Oracle Net Services<br />How to use the Oracle Connection Manager Control utility to administer Oracle Connection Manager<br />How to create a new PDB from the PDB seed.<br />Logical and physical storage structures in an Oracle database<br />Usage of Oracle Database features that save space<br />Explanation of DML and undo data generation<br />Learn about general architecture of Oracle Data Pump and SQL*Loader<br />How to use SQL*Loader to load data from a non-Oracle database (or user files)<br />Bonus Content / Time Permitting: Explanation of maintenance windows<br />Bonus Content / Time Permitting: Employ basic monitoring procedures and manage performance</p><p>Oracle 19C Database Administration I (Oracle DBA I) is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies, however you should have incoming experience working with SQL, and be comfortable with Linux and working from the command line. This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas.</p></div><div id="course-pills-2"><h4>Introduction to Oracle Database</h4><ul><li>Oracle Multitenant Container Database</li><li>Oracle Database Instance Configurations</li><li>Database Sharding</li><li>Oracle Database Server</li></ul><h4>Accessing an Oracle Database</h4><ul><li>Oracle Database Tools</li><li>Database Tool Choices</li><li>SQL Developer</li><li>Enterprise Manager Database Express</li></ul><h4>Creating an Oracle Database by Using DBCA</h4><ul><li>Planning the Database</li><li>Choosing a Database Template</li><li>Configuration Assistant</li></ul><h4>Creating an Oracle Database by Using a SQL Command</h4><ul><li>Creating a Container Database</li><li>Enable Pluggable Database</li></ul><h4>Starting Up and Shutting Down a Database Instance</h4><ul><li>Starting the Oracle Database Instance</li><li>Shutting Down an Oracle Database Instance</li><li>Opening and Closing PDBs</li></ul><h4>Managing Database Instances</h4><ul><li>Investigating Initialization Parameter Files</li><li>Viewing Initialization Parameters by Using SQL*Plus</li><li>Modifying Initialization Parameters by Using SQL*Plus</li><li>Viewing Diagnostic Information</li></ul><h4>Oracle Net Services Overview</h4><ul><li>Oracle Net Services Components</li><li>Oracle Net Listener</li></ul><h4>Configuring Naming Methods</h4><ul><li>Configuring the Oracle Network to Access a Database</li><li>Creating a Net Service Name for a PDB</li></ul><h4>Configuring and Administering the Listener</h4><ul><li>Exploring the Default Listener</li><li>Creating a Second Listener</li><li>Connecting to a Database Service Using the New Listener</li></ul><h4>Configuring a Shared Server Architecture</h4><ul><li>Configuring Shared Server Mode<br />Configuring Clients to Use a Shared Server</li></ul><h4>Configuring Oracle Connection Manager for Multiplexing and Access Control</h4><ul><li>Oracle Connection Manager Processes</li><li>Filtering Rules</li><li>Session Multiplexing</li></ul><h4>Creating PDBs</h4><ul><li>Creating a New PDB from the PDB Seed</li><li>Cloning Remote PDBs in Hot Mode</li><li>Relocating PDBs</li></ul><h4>Managing PDBs</h4><ul><li>Renaming a PDB</li><li>Setting Parameter Values for PDBs</li></ul><h4>Database Storage Overview</h4><ul><li>Logical and Physical Database Structures</li><li>Tablespaces and Data Files</li><li>Types of Segments</li><li>Monitoring Tablespace Space Usage</li></ul><h4>Creating and Managing Tablespaces</h4><ul><li>Viewing Tablespace Information</li><li>Creating a Tablespace</li><li>Managing Temporary and Permanent Tablespaces</li></ul><h4>Improving Space Usage</h4><ul><li>Managing Space in Tablespaces</li><li>Using Compression</li><li>Enabling the Resumable Space Allocation Feature</li></ul><h4>Creating and Managing User Accounts</h4><ul><li>Creating Common and Local Users</li><li>Creating a Local User for an Application</li><li>Exploring OS and Password File Authentication</li></ul><h4>Configuring Privilege and Role Authorization</h4><ul><li>Granting a Local Role (DBA) to PDBADMIN</li><li>Using SQL*Developer to Create Local Roles</li></ul><h4>Configuring User Resource Limits</h4><ul><li>Using SQL*Developer to Create a Local Profile &amp; Users</li><li>Configuring a Default Role for a User</li></ul><h4>Implementing Oracle Database Auditing</h4><ul><li>Enabling Unified Auditing</li><li>Creating Audit Users</li><li>Creating an Audit Policy</li></ul><h4>Introduction to Loading and Transporting Data</h4><ul><li>General Architecture</li><li>Oracle Data Pump</li><li>SQL Loader</li><li>Loading Data into a PDB from an External File</li><li>Moving Data from One PDB to Another PDB</li><li>Transporting a Tablespace</li></ul><h4>Using External Tables to Load and Transport Data</h4><ul><li>Querying External Tables</li><li>Unloading External Tables</li></ul><h4>Automated Maintenance Tasks Overview</h4><ul><li>Automated Maintenance Tasks</li><li>Maintenance Windows</li><li>Predefined Maintenance Windows</li></ul><h4>Bonus: Managing Tasks and Windows</h4><ul><li>Enabling and Disabling Automated Maintenance Tasks</li><li>Modifying the Duration of a Maintenance Window</li></ul><h4>Bonus: Database Monitoring and Performance Tuning Overview</h4><ul><li>Performance Planning Considerations</li><li>Automatic Workload Repository (AWR)</li><li>Advisory Framework</li></ul><h4>Bonus: Monitoring Database Performance &amp; Processes</h4><ul><li>Server-Generated Alerts</li><li>Setting Metric Thresholds</li><li>Performance Monitoring</li><li>Examining the Database Background Processes</li></ul><h4>Bonus: Tuning Database Memory</h4><ul><li>Viewing Memory Configurations</li></ul><h4>Bonus: Analyzing SQL and Optimizing Access Paths</h4><ul><li>Using the Optimizer Statistics Advisor</li></ul></div>

Oracle 19c Database Administration I (DBA I) (TTOR20519)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for all Oracle Professionals.  Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and  other IT Management Professionals.</p>Overview<p>Upon successful completion of this course, students will be able to understand configuration for installation, configuration of a host system, using Oracle Restart framework, troubleshooting tips, how the database fits with other systems, internals of the database, database failures and other topics.</p><p>In this course, students will focus on configuration on supported systems.  Also how the database fits in with other systems.</p></div><div id="course-pills-2"><h4>Oracle Database Architercture Overview</h4><ul><li>The Database Instance</li><li>Database Memory Structures</li><li>Database Process Structures</li><li>Database Storage Architecture</li><li>Oracle Clusterware</li></ul><h4>Configuring the Host for Standalone Installlation</h4><ul><li>Host Configuration Overview</li><li>Choosing a Database Host</li><li>Choosing an Operating System</li><li>Proprietary Unix vs Open-Source Linux</li><li>Making the OS Selection</li><li>Prepare an Oracle LINUX Installation</li><li>Perform Oracle LINUX Installation</li><li>Configure the LINUX Host</li><li>Step 1 - Confirm General System Requirements</li><li>Step 2 - Confirm The Operating System Platform</li><li>Step 3 - Confirm LINUX Package Requirements</li><li>Step 4 - Confirm Network Configuration</li><li>Configure Host for Virtualization</li><li>VM Technologies</li><li>Configure Oracle Linux for Virtualization</li><li>Step 1 - Download Linux Updates</li><li>Step 2 - Check Linux Kernel</li><li>Step 3 - Download Latest yum Configuration File</li><li>Step 4 - Enable Oracle Linux Add-ons</li><li>Step 5 - Install VirtualBox</li><li>Oracle Optimal Flexible Architecture</li><li>OFA Goals</li><li>ORACLE_BASE</li><li>ORACLE_HOME</li><li>Database Files</li><li>Multiple ORACLE_HOMEs</li><li>Databse Software Upgrades</li><li>Mutliple Oracle Software Installations</li></ul><h4>GRID Infrastructure Configuration</h4><ul><li>Configure the Linux Installation</li><li>About ASM Devices</li><li>Configure Linux Devices for ASM</li><li>Partioning a Device</li><li>Oracle ASMLib</li><li>Configue MS Windows Devices</li></ul><h4>GRID Infrastructure Installation</h4><ul><li>Perform the Installation</li><li>Download</li><li>Unpack the Installation Package</li><li>Launch the Installation Session</li><li>The Installation Dialog</li><li>Verify the Installation</li><li>Operating System Confirmation</li><li>Oracle Utilities Setup</li><li>SQL*Plus Confirmation</li><li>Using EM Cloud Control</li><li>Troubleshooting Problems</li></ul><h4>DATABASE Installation Configuraion</h4><ul><li>Configure a Linux Installation</li><li>System Groups &amp; Users</li><li>Configure Kernel Parameters</li><li>Create the Physical Directories</li><li>Configure MS Windows Installation</li><li>Prerequisite Checks &amp; Fixup Utility</li></ul><h4>DATABASE Installation</h4><ul><li>ABOUT THE INSTALLATION</li><li>The Installation Tools </li><li>About The Installation Dialog </li><li>The Installation Session Log </li><li>PERFORM INSTALLATION ON LINUX </li><li>Download</li><li>Unpack The Installation Files</li><li>Set Environment Variables </li><li>Launch The Installation</li><li>SERVER CLASS INSTALLATION DIALOG </li><li>More About The Global Database Name</li><li>About Enterprise Manager Cloud Control</li><li>Secure The New Database </li><li>PERFORM INSTALLATION ON WINDOWS </li><li>Launch The Installation </li><li>POST---INSTALLATION CONFIGURATION </li><li>Required Environment Variables</li><li>Defining The Environment Variables</li><li>About SSH</li><li>VERIFY THE INSTALLATION</li><li>SQL*PlusConfirmation   </li><li>Operating System Confirmation</li><li>Firewall Configuration</li><li>Accessing EM Database Express</li></ul><h4>Creating Databses Using DBCA</h4><ul><li>About DBCA</li><li>DBCA Templates</li><li>Are You Sure? </li><li>DEFAULT CONFIGURATION DATABASE </li><li>ADVANCED MODE DATABASE </li><li>File Location Variables</li><li>Database Vault and Label Security </li><li>CONFIGURE AN EXISTING DATABASE </li><li>DELETE A DATABASE</li><li>MANAGE TEMPLATES </li><li>MANUALLY CREATE A DATABASE </li><li>The CREATE DATABASE Command</li></ul><h4>Using Oracle Restart</h4><ul><li>WHAT IS ORACLE RESTART?</li><li>What Oracle Restart Does</li><li>Is Oracle Restart Deprecated?</li><li>Registering With Oracle Restart</li><li>More About srvctl </li><li>Terminal Session Configuration </li><li>COMPONENT STATUS USING SRVCTL </li><li>Database Status</li><li>Grid Infrastructure Status </li><li>Oracle Home Status </li><li>CONFIGURATION USING SRVCTL </li><li>Examining A Database Configuration </li><li>Examining The Listener Configuration </li><li>Examining The ASM Configuration </li><li>Manual Registration </li><li>ListenerConfiguration Modification </li><li>Database ConfigurationModification</li><li>STARTUP/SHUTDOWN USING SRVCTL</li><li>Why Use srvctl? </li><li>MANAGING ORACLE RESTART </li><li>Obtaining Oracle Restart Status </li><li>Start/Stop Oracle Restart</li></ul><h4>Preparing for a Database Upgrade</h4><ul><li>What is a Database Upgrade?</li><li>Database Upgrade Methods</li><li>Real World Database Upgrade</li><li>Develop A Database Upgrade Plan </li><li>ABOUT THE DATABASE VERSION </li><li>Direct Upgrade </li><li>The COMPATIBLE Database Parameter </li><li>PRE-UPGRADE PREPARATIONS </li><li>Oracle Warehouse Builder</li><li>Oracle Label Security (OLS)</li><li>Oracle Database Vault </li><li>Locating The Older Database Installations</li><li>THE PRE-UPGRADE INFORMATION TOOL</li><li>Pre-Upgrade Information Tool Files</li><li>Run The Pre---Upgrade Information Tool </li><li>Examining The Pre---Upgrade Information Tool Results</li></ul><h4>Upgrade to Oracle Databse 12c</h4><ul><li>Launch DBUA</li><li>Database Upgrade Dialog</li></ul><h4>Post-Upgrade Tasks</h4><ul><li>Post-Upgrade Checklist</li><li>Enable Unified Auditing</li><li>Migrate to Unified Auditing</li><li>Database Parameter Changes</li><li>Enable New Features</li><li>Source Destination Specific Post-Upgrade Tasks</li></ul><h4>Oracle Architecture: The Systems Infrastructure</h4><ul><li>About Enterprise Architectures</li><li>The Relational Database </li><li>Legacy Computing Models </li><li>The Multi-Tiered Computing Model </li><li>Scaling Up </li><li>Cloud-Based Deployment </li><li>ORACLE INFRASTRUCTURE ECOSYSTEM</li><li>USING ORACLE ENTERPRISE MANAGER</li><li>More About EM </li><li>Using EM Database Express </li><li>Using EM Cloud Control</li></ul><h4>Oracle Architecture: The Database Host</h4><ul><li>The Database Server Stack</li><li>PROCESSOR LAYER </li><li>CPU Resources</li><li>Memory Resources </li><li>I/O &amp; STORAGE PROCESSING </li><li>OS LAYER PROCESSING MODES </li><li>DATABASE SERVER VIRTUALIZATION </li><li>STORAGE VIRTUALIZATION </li><li>ORACLE DATABASE SERVER STACK </li><li>ORACLE ENGINEERED SYSTEMS </li><li>Oracle Exadata Database Platform </li><li>Exalogic Cloud Machine </li><li>Exalytics BI Machine</li></ul><h4>Oracle Architecture: Princilples &amp; Technology Concepts</h4><ul><li>Grid Computing Principles</li><li>Why Grid Computing? </li><li>What Is Grid Computing? </li><li>PARALLELIZATION PRINCIPLES</li><li>Hardware Parallelization </li><li>Grid Computing Devices </li><li>Clustered Database Servers</li><li>CLOUD COMPUTING PRINCIPLES </li><li>Multi-Tenancy</li></ul><h4>Oracle Architecture: The RDBMS Installation &amp; the Database Instance</h4><ul><li>The Database Server Software</li><li>Database Versions &amp; Releases</li><li>Database Editions </li><li>Using PRODUCT_COMPONENT_VERSION View </li><li>The Core Database Components </li><li>Using V$VERSION View</li><li>Understanding The Database Version Number</li><li>The COMPATIBLE Database Parameter </li><li>DATABASE INSTANCE ELEMENTS</li><li>Individual Elements Of A Database Instance </li><li>Physical Database Elements </li><li>An Operational Database installation </li><li>DATABASE INSTANCE CONFIGURATIONS</li><li>Single Instance </li><li>Parameter Files &amp; Instance Configuration </li><li>MAX_STRING_SIZE Parameter Example </li><li>Independent Instances</li><li>Clustered Instances </li><li>The Database Instance In A Multi-tenant Configuration </li><li>RECONFIGURING A DATABASE INSTANCE </li><li>Static Vs. Dynamic Parameters </li><li>Dynamic Parameter Setting</li><li>Parameter Setting Scope </li><li>Parameter Setting Level </li><li>Setting Upgrade Related Parameters </li><li>DATABASE COMPONENTS</li><li>Advanced Data Functionality Components</li><li>Security Components </li><li>High-Performance Components</li><li>Administration Components </li><li>Database F</li></ul></div>

60 Oracle 1Z0-819 courses delivered Online

Oracle 19c Database Administration II (DBA II) (TTOR20619)

By Nexus Human

Oracle WebLogic Server 12c: Administration I

By Nexus Human

Oracle 11g PL/SQL Part 1

By iStudy UK

Oracle 11g PL/SQL Part 2

By iStudy UK

Oracle Database 12c R2 - Backup and Recovery Workshop Ed 3

By Nexus Human

Oracle Database 12c - RAC and Grid Infra Deployment Workshop

By Nexus Human

Oracle Database 12c - ASM Administration Ed 1

By Nexus Human

Oracle BI 11g R1 - Build Repositories

By Nexus Human

Oracle 11g PL/SQL Intermediate

By John Academy

Oracle 11g PL/SQL Beginner

By John Academy