Filter by Topic
Filter by Vendor
Oracle 19c Database Tuning (TTOR21519)
Course Description: Dive into the world of database optimization with …
What you'll learn
Develop a solid understanding of Oracle 19c Database Architecture: By the end of this course, you'll be comfortable with the components of Oracle's database system, from Instance Definitions to Datafile Definitions.
Master the Query Optimizer: You'll gain a firm grasp of SQL Parsing, Optimizing Terms, and Query Plan Generation. You'll learn how to build efficient queries that provide the data you need without unnecessary strain on your systems.
Get comfortable with Tuning Container and Pluggable Databases: You'll learn how to optimize and manage pluggable databases, enhancing the performance of your data operations.
Explore Oracle Tuning Features: We'll get you familiar with Oracle's Heat Map and delve into the 19c Compression Levels and Types, boosting your database's efficiency.
Learn to Evaluate Execution Plans: You'll become proficient in defining SQL execution plans and using the Automatic Workload Repository, allowing you to monitor and improve the performance of your queries.
Gain hands-on experience with Oracle Tuning Tools: You'll practice with tools like the Enterprise Manager and Automatic Database Diagnostic Monitor, equipping you to handle real-world tuning tasks with confidence.
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.
55293-A: SharePoint End User 2019
Course Description: This SharePoint 2019 End User 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 lists and library views.
Learn to create sub sites using various SharePoint templates
Learn to create and edit Web page content.
Learn to create InfoPath Forms and Form libraries.
Learn to create Site columns and content types.
Learn to integrate Office applications with SharePoint 2019.
Learn to manage basic permissions of SharePoint 2019 resources.
Understand the versions of SharePoint.
Understand SharePoint site hierarchy.
Understand Team Site layout.
Understand navigation within 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.
Understand what Site Templates are.
Understand the 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.
Understand what site pages are.
Understand what wiki pages are.
Understand what Web Parts are.
Add content to the Site Home page.
Create a wiki page library
Add Web Parts.
Manage Web Parts.
Understand what a Form Library is.
Create a Form Library.
Use InfoPath Designer to design a basic form template.
Publish an InfoPath Designer form template to a Form Library
Designate for templates fields as library columns.
Create instances of documents in a Form Library.
Understand Site Columns.
Understand Content Types.
Create Site Columns.
Create Content Types.
Create a document template for a Content Type.
Assign a Content Type to a list or library.
Create new items based on a custom Content Type.
Create a list from an Excel Spreadsheet.
Create an alert in Outlook.
Understand SharePoint groups.
Create SharePoint groups.
Assign permission in SharePoint.
View permission levels.
Manage permission inheritance at the site level.
Manage permission inheritance at the list or library level.
Edit a personal profile.
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.
Featured
Microsoft Office Word 2019: Part 3
Course Description: Microsoft® Word enables you to do far more …
What you'll learn
Use images in a document.
Create custom graphic elements.
Collaborate on documents.
Add reference marks and notes.
Secure a document.
Create and manipulate forms.
Create macros to automate tasks.
Featured
Microsoft Office Word 2019: Part 2
Course Description: After you master the basics of creating, editing, …
What you'll learn
Organize content using tables and charts.
Customize formats using styles and themes.
Insert content using Quick Parts.
Use templates to automate document formatting.
Control the flow of a document.
Simplify and manage long documents.
Use mail merge to create letters, envelopes, and labels.
Featured
Microsoft Office Word 2019: Part 1
Course Description: These days, most people take electronic word processing …
What you'll learn
Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Create and format tables.
Format text and paragraphs.
Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
Microsoft Visio 2019: Part 2
Course Description: Microsoft® Visio® stands out among similar applications because …
What you'll learn
In this course, you will examine advanced features to make you more efficient and effective.
Design advanced plans and diagrams.
Enhance the look of drawings.
Create shapes, stencils, and templates.
Connect drawings to external data.
Leverage development tools.
Share drawings.
Microsoft Visio 2019: Part 1
Course Description: From the earliest eras of human existence, visual …
What you'll learn
In this course, you will design, modify, and manage basic diagrams.
Identify the basic elements of Visio and their use.
Create a workflow diagram.
Build organization charts.
Design a floor plan.
Build a cross-functional flowchart.
Design a network diagram.
Style a diagram.
Featured
Microsoft Office PowerPoint 2019: Part 2
Course Description: Meetings, instruction, training, pitches; these are all a …
What you'll learn
Customize design templates.
Use ink to hand draw elements.
Add tables.
Add charts.
Work with media.
Build advanced transitions and animations.
Finalize a presentation.
Customize presentation navigation.
Secure and distribute a presentation.
