Past Webinars

The Benefits of using SQL Common Table Expressions

Common Table Expressions are a SQL coding technique supported by Oracle, Db2, SQL Server and others. 

Common Table Expressions are also referred to as CTEs, the WITH clause or Subquery Query Factoring clauses.

Think subquery, SQL within a SQL statement when thinking of CTEs. A CTE can be a useful SQL coding 

technique for code containing subqueries to make your code more readable and possibly to make your code 

more efficient, two great benefits.

 

Helpful Oracle 21c and 23c SQL and PL/SQL New Features

 

Oracle 21c and 23c offer us some interesting SQL and PL/SQL enhancements. What did we miss in 21c

and what can we look forward to in 23c? There is help in both versions. In this free webinar, 

Oracle Certified Professional DBA and Certified Technical Trainer John Mullins from ProTech Training 

presents a look at some of those new features and what benefits we might expect from them while discussing 

CyberSAFE

This Webinar is designed for all users of computers, mobile devices, networks, and the Internet, to enable them to use technology more securely and minimize digital risks, regardless of technical ability. Every employee that holds an email address for your organization should take this course. Vendors who are managing your marketing, human capital, or social platforms should take CyberSAFE. Hackers cast a wide net simply waiting for a single wrong click.

CyberSAFE

A single click can lead to a multimillion dollar breach in seconds, and the employee responsible may not even know they made a mistake. Many end users are not aware of the dangers accompanying today’s most common cybersecurity threats such as phishing, much less how to detect them. CyberSAFE helps ensure that all users can identify the common risks associated with using conventional end-user technology, as well as how to safely protect themselves and their organizations from security risks in the office or when working remotely.

Reporting Tips and Tricks with Webi v4.2

This presentation will provide Tips and tricks in he following topics!
Creating a Banner in your report
Ranking/Sorting on Sub Totals 
Removing/Adding Break header and Footers with Multiple Breaks
Shading Sub Total Rows
Hiding detail blocks in a Sectioned Report
Adding Stop Lights To your Sectioned Report
Using Conditional Formatting in a Sectioned Report         

It will also include a Q and A session as well.