Filter by Topic
Filter by Vendor
Oracle Database 11g: RAC Administration eLearning
Course Description: In this course, you will be introduced to …
What you'll learn
Install Oracle Clusterware and RAC
Administer a RAC Database and Oracle Clusterware
RAC Performance Tuning
Configure, Manage, and Use Database Services in a RAC environment
Administer Oracle Clusterware
Diagnose Oracle Clusterware and Node Management
High Availability in RAC
Add/Remove a node to/from a cluster
Patch Oracle Clusterware and RAC software
Oracle11g Admin eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
Elements of the Oracle Database 11g architecture and the tools and steps required to install the Oracle Database 11g software
Steps for creating a new Oracle Database 11g database and then configuring it and managing the instance
Steps for configuring new Oracle Net Listeners and database connectivity
Steps for maintaining storage structures and automating storage management in Oracle Database 11g and for managing privileges, roles, and other security features for users
Steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency
Steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds
Steps for ensuring an Oracle Database 11g database is available to users when needed by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups
Ways to make use of Oracle Database 11g’s tools for moving and recovering data, reporting on problems, and installing updates to enhance a database
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
55298-A: Introduction to SharePoint 2019
Course Description: This Introduction to SharePoint 2019 class is for …
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create SharePoint lists.
Learn to customize SharePoint Lists.
Learn to create SharePoint libraries.
Learn to manage library document versions.
Learn to create SharePoint list and library views.
Learn to integrate Office Outlook and Excel applications with SharePoint 2019.
Understand the versions of SharePoint
Understand the SharePoint site hierarchy.
Understand Team Site layout.
Understand navigation with a Team Site.
Understand List Templates.
Work with default lists in a Team Site.
Create a new list from a List Template.
Create a custom list.
Add columns to a list.
Control and validate input into list fields.
Create new libraries using library templates.
Add columns to a library.
Check out documents for editing.
Delete and restore documents from document libraries.
Enable versioning on a library.
Revert a library document to an earlier version.
Use default views built into lists and libraries.
Create shared views.
Configure views.
Set the default view for a list or library.
Create a list from an Excel spreadsheet.
Create an alert in Outlook.
Understand what Site Templates are.
Understand different types of Site Templates that come “Out of the Box” with different versions
Create a new site using Site Templates.
Create a Project site.
Create a Team site.
Create a Community site.
Create a Blog site.
Manage the sites listed in the Top Link Bar.
DevOps Engineering on AWS
Manage a variety of DevOps Philosophies with DevOps Engineering on …
What you'll learn
List the advantages of small DevOps teams
List the roles and responsibilities of the members of a typical small DevOps team
Leverage AWS Cloud9 to write, run and debug your code as well as share your cloud-based IDE with your dev team.
Build continuous integration/continuous delivery (CI/CD) pipelines including testing and security
Develop Git branching strategies and integrate with CI/CD pipeline for various environments
Use AWS CloudFormation to deploy development, test, and production environments for a software development project
Design and implement an infrastructure on AWS that supports DevOps development projects
Build a CI/CD pipeline for AWS CloudFormation templates
Establish collaboration by bringing together the workflows and responsibilities of development and operations
Host secure, highly scalable private Git repositories with AWS CodeCommit
Leverage Amazon Elastic Container Registry (Amazon ECR) to securely store Docker container images and integrate with AWS CodeBuild and Amazon Elastic Container Service (Amazon ECS).
Automate build, test, and packaging code with AWS CodeBuild
Integrate security in the CI/CD pipelines tools and services
Implement common deployment strategies such as “all at once,” “rolling,” and “blue/green”
Automate software deployments to Amazon Elastic Compute Cloud (Amazon EC2), on-premises computes, AWS ECS (Amazon EC2 /AWS Fargate), and AWS Lambda with AWS CodeDeploy
Automate your release pipelines (build, test, deploy) with AWS CodePipeline
Monitor an application and environment using AWS tools and technologies
DP-203T00-A: Data Engineering on Microsoft Azure
Course Description: In this course, the student will learn about …
What you'll learn
Explore compute and storage options for data engineering workloads in Azure
Design and Implement the serving layer
Understand data engineering considerations
Run interactive queries using serverless SQL pools
Explore, transform, and load data into the Data Warehouse using Apache Spark
Perform data Exploration and Transformation in Azure Databricks
Ingest and load Data into the Data Warehouse
Transform Data with Azure Data Factory or Azure Synapse Pipelines
Integrate Data from Notebooks with Azure Data Factory or Azure Synapse Pipelines
Optimize Query Performance with Dedicated SQL Pools in Azure Synapse
Analyze and Optimize Data Warehouse Storage
Support Hybrid Transactional Analytical Processing (HTAP) with Azure Synapse Link
Perform end-to-end security with Azure Synapse Analytics
Perform real-time Stream Processing with Stream Analytics
Create a Stream Processing Solution with Event Hubs and Azure Databricks
Build reports using Power BI integration with Azure Synpase Analytics
Perform Integrated Machine Learning Processes in Azure Synapse Analytics
Microsoft Office OneNote 2016
Course Description: In our fast-paced digital world, the need to …
What you'll learn
In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.
Navigate and customize the OneNote interface and environment.
Add and format text, images, audio, links, and drawing objects to a notebook.
Embed Excel spreadsheets and attach other files to a notebook.
Categorize, organize, and search notebook content.
Check spelling in, print, and password-protect notebooks.
Use Outlook and OneDrive to send and share notebook content.
Export notebook content and manage notebook history and backups.
