Filter by Topic
Filter by Vendor
Oracle 11g: Programing with PL/SQL eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules
Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.
Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters
Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables
Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules
Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures
Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters
Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables
Steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their ex
Steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code
Steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings
Steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies
Oracle 11g: Administration II eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
Structural elements in Oracle Database 11g’s architecture, including and Automatic Storage Management (ASM), and the steps for managing storage using disk groups
Steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog
Steps for preparing a database for backup and for performing various types of RMAN backups and monitoring them using reports and dynamic performance views
Steps for performing user-managed backups and recoveries
Ways to use RMAN to ensure that data is not lost in Oracle Database 11g by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time
Steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks and for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g’s flashback features
Steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and for enabling and configuring automatic memory management and automatic shared memory management
Steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces
Ways to ensure that resources are being put to best use and database jobs are performed when they should be using the Database Resource Manager and the Scheduler
Steps for utilizing Oracle Database 11g’s globalization support features to ensure that information and data is displayed in a user’s native language and that territory and language-dependent conventions are adhered to
Transitioning to Agile Project Management eLearning
Course Description: In this instructor led, online training course, students …
What you'll learn
About the differences in Agile
Roles and Responsibilities
User stories
About best practices
About agility within an organization
Practical Project Management with Microsoft Project eLearning
Course Description: Using best practices in project management can be …
What you'll learn
The proper set-up of your project plan from start dates to calendars
How to create an effective schedule that you are able to manage effectively
Working with durations and resources
Assigning costs to your resources
Updating your plan during execution to track performance
Monitoring and controlling your project plan and providing reports to stakeholders
Best practices in project management that align to software for better understanding of the inner working of MS Project 2016
Project Fundamentals for the Accidental Project Manager eLearning
Course Description: If you are amazing at your job and …
What you'll learn
Common best practices utilized by successful project managers
Common processes and documents, and how to utilize them
How organizational variables can affect which best practices to utilize
How to initiate, plan, execute, monitor and control in an effective manner
Managing a Project Team eLearning
Course Description: The human aspect of project management is usually …
What you'll learn
How to run an effective kick-off meeting
How to develop a comprehensive HR Management Plan for virtual and co-located resources
Team acquisition negotiaion skills
Motivational theories and team building
Holding the project closure meeting
Planning for Risk Management eLearning
Course Description: Risk happens on all projects, and how risk …
What you'll learn
How to determine your organizations’ risk thresholds and determine scoring for probability and impact
Risk identification techniques, the pros and cons
Creation and maintenance of a risk register
Contingency reserves and how to ask for them
Risk response categories and register updating
Balancing Time, Cost, and Scope eLearning
Course Description: How do you balance time, cost and scope …
What you'll learn
Best practices for scope, time, and cost
Planning effectively for the constraints
Effective change control functions
Project closure and formal acceptance of deliverables
