Data Platforms - I (Online Courses)
Elevate your career trajectory with our premier online course, designed to sharpen your competitive edge. Explore our curated selection of top-tier digital programs to hone your skills and propel your professional journey forward. Experience transformative learning tailored to empower your career advancement in today's dynamic landscape.
Price on Request
Start Learning
This Course Includes
-
34 hours 0 minutesof self-paced video lessons -
35 Programscrafting your path to success -
Completion Certificateawarded on course completion
ADDM & ASH
Price on Request
40 minutes
The Automatic Database Diagnostic Monitor allows you to analyze AWR data for performance problems. Active Session History can assist in more granular problem solving situations. Learn about using these two tools in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 38
Compliance Standards: AICC
Administration & Development
Price on Request
50 minutes
Proper database management helps ensure your data is valid and secure. Explore database administration and development using Cassandra in a distributed framework.
Perks of Course
Certificate: Yes
CPD Points: 51
Compliance Standards: AICC
Advanced Analytics: Performing Analytics Using Snowflake
Price on Request
1 hour 50 minutes
Data analytics is the systematic, computational analysis of data or statistics used to discover and communicate meaningful patterns. In business, analytics can be used to extract insights for a business strategy or identify new business opportunities. Snowflake is a managed data platform for big data storage, processing, and analytics that allows for common SQL operations and additional operations. In this course, explore various types of Snowflake join operations and data sampling. Next, learn how to use common table expressions (CTEs) and construct queries. Finally, work with functions related to partitioning, windowing, and ranks. Upon completion, you'll be able to use joins, perform row-based and block-based sampling, construct CTEs, and perform windowing and partitioning operations in Snowflake.
Perks of Course
Certificate: Yes
CPD Points: 109
Compliance Standards: AICC
Aggregating Data
Price on Request
45 minutes
Grouping data according to specific conditions allows you to create more effective reports and analyze data in more productive ways. Explore group functions, grouping data, and the clauses used for grouping in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 45
Compliance Standards: AICC
Application Failover & Continuity
Price on Request
35 minutes
Managing connections to a database ensures that the most important business workloads get the highest priority in the database. Explore application failover and continuity in RAC database connections.
Perks of Course
Certificate: Yes
CPD Points: 35
Compliance Standards: AICC
Application Monitoring
Price on Request
25 minutes
Oracle Database 12C includes services that organize work execution within the database, and make execution that much more manageable, measurable, tunable, and recoverable. Learn about working with and scheduling these services.
Perks of Course
Certificate: Yes
CPD Points: 27
Compliance Standards: AICC
Assessing Recovery Requirements
Price on Request
25 minutes
It is crucial that a database can be recovered in the event of a failure. Explore the different backup and recovery solutions available in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 23
Compliance Standards: AICC
Auditing Features & Configuration
Price on Request
1 hour
Monitoring database access is part of the process involved in securing an Oracle Database 12c system. Discover how to detect and resolve lock conflicts, and how to enable and manage auditing of database activity.
Perks of Course
Certificate: Yes
CPD Points: 59
Compliance Standards: AICC
Authentication & Security
Price on Request
40 minutes
As with any RDBMS, the database needs to be secured to ensure only authorized users can access it. Discover how to configure security, including logging on, views, macros, and UDFs.
Perks of Course
Certificate: Yes
CPD Points: 41
Compliance Standards: AICC
Automatic Storage Management
Price on Request
35 minutes
Oracle Automatic Storage Management (ASM) is designed to simplify management of data, control, and log files. Explore Automatic Storage Management, and the Oracle Cloud File System.
Perks of Course
Certificate: Yes
CPD Points: 33
Compliance Standards: AICC
Automatic Workload Repository
Price on Request
25 minutes
The Automatic Workload Repository provides services to database components to collect, maintain, and use statistics for issue detection and self-tuning. Explore AWR in Oracle Database 12c, including administration and reporting.
Perks of Course
Certificate: Yes
CPD Points: 25
Compliance Standards: AICC
Backup & Recovery Options
Price on Request
40 minutes
What makes Oracle Database 12c tick? Explore the Oracle Database Server architecture, process architecture, grid infrastructure, and DBA tools.
Perks of Course
Certificate: Yes
CPD Points: 41
Compliance Standards: AICC
Backup Strategies
Price on Request
30 minutes
You can backup, restore and recover Oracle databases using the Oracle Recover Manager (RMAN). Explore backup requirements and different strategies that you can employ.
Perks of Course
Certificate: Yes
CPD Points: 31
Compliance Standards: AICC
Backups, Monitoring, & Stats
Price on Request
1 hour 30 minutes
MongoDB tends to be heavily used in performance-critical and large-scale environments. This means monitoring and backup solutions are important. Discover how to monitor MongoDB stats, and work with backup and restore methods.
Perks of Course
Certificate: Yes
CPD Points: 36
Compliance Standards: AICC
Big Data Solutions, Architecture, CQL, & DDL
Price on Request
1 hour 25 minutes
Apache Cassandra is an open-source NoSQL database management system for handling large amounts of data. Explore the mechanics and architecture of Cassandra, data modeling, and the Cassandra Query Language (CQL).
Perks of Course
Certificate: Yes
CPD Points: 86
Compliance Standards: AICC
Client Communication
Price on Request
20 minutes
As with any RDBMS the database needs to be secure and accessible. Teradata is no exception and requires workstation and mainframe access. Explore the workstation and mainframe attachment communication methods.
Perks of Course
Certificate: Yes
CPD Points: 22
Compliance Standards: AICC
Cloud & Hadoop Deployments
Price on Request
55 minutes
One of MongoDB's best strengths is its ability to scale. Examine cloud deployments of MongoDB using Cloud Manager and how MongoDB can integrate with Hadoop.
Perks of Course
Certificate: Yes
CPD Points: 56
Compliance Standards: AICC
Clustering & Admin Tools
Price on Request
1 hour 10 minutes
Apache Cassandra is designed to meet a scaling challenge that traditional database management systems aren't capable of handling. Discover clustering and admin tools and how to install, manage, and access data programmatically.
Perks of Course
Certificate: Yes
CPD Points: 70
Compliance Standards: AICC
Communication & Database Security
Price on Request
1 hour 10 minutes
As with any RDBMS, the database needs to be secured to ensure only authorized users can access it. Discover workstation and mainframe attachment communication methods and how to configure users, profiles, and roles.
Perks of Course
Certificate: Yes
CPD Points: 69
Compliance Standards: AICC
Concepts & Background
Price on Request
1 hour 15 minutes
NoSQL databases provide a mechanism for data retrieval and storage other than relational databases. Learn about NoSQL data stores, queries and updates, and why NoSQL may be a better choice than a traditional relational database model.
Perks of Course
Certificate: Yes
CPD Points: 74
Compliance Standards: AICC
Configuring Flashback Technologies
Price on Request
40 minutes
The Oracle Flashback technologies let you view past states of database objects or return objects to a previous state. Examine various Flashback technologies, and how to configure and use them.
Perks of Course
Certificate: Yes
CPD Points: 41
Compliance Standards: AICC
Connecting to & Configuring a Database Instance
Price on Request
40 minutes
One key aspect of administering Oracle Database 12c includes managing client connections to database servers. Discover how to manage Oracle Net Services and server configurations.
Perks of Course
Certificate: Yes
CPD Points: 39
Compliance Standards: AICC
Connectivity & Space Management
Price on Request
1 hour 15 minutes
Optimizing how data is stored in Oracle Database 12c conserves space and improves system performance. Explore tablespaces and data files, and learn how to manage the space used by data blocks and segments.
Perks of Course
Certificate: Yes
CPD Points: 77
Compliance Standards: AICC
Continuous Data: Automating Data Ingestion from Cloud Storage into Snowflake
Price on Request
1 hour 25 minutes
The Snowpipe feature allows Snowflake to input micro-batches of data as it becomes available, generally within minutes of the data being added to a stage and submitted for ingestion. In this course, you will implement the auto-ingestion of CSV files from external Snowflake stages located on the AWS and Azure cloud platforms. You will begin by setting up a continuous data ingestion pipeline where the data source is located in an Azure Storage Container. This pipeline will include several components, such as queues, enterprise applications, and storage integrations as well as the permissions required to get these pieces to talk to one another. You will then implement something similar with an Amazon S3 bucket as the source of data. This set-up will involve AWS services such as IAM roles, SNS topics, as well as Snowflake objects such as notification integrations and pipes.
Perks of Course
Certificate: Yes
CPD Points: 87
Compliance Standards: AICC
CouchDB, cURL, & Futon
Price on Request
30 minutes
CouchDB database management systems provides a lot of flexibility for storing and accessing your data. Learn about using CouchDB with NoSQL, including how to work with the API, using and installing cURL, and using Futon.
Perks of Course
Certificate: Yes
CPD Points: 31
Compliance Standards: AICC
Creating Documents
Price on Request
40 minutes
RavenDB is a document-based database designed for storing, retrieving, and managing semi-structured data. Discover how to create, manage, read, and query documents.
Perks of Course
Certificate: Yes
CPD Points: 42
Compliance Standards: AICC
Customizing Output
Price on Request
55 minutes
In Oracle Database 12c, you have the ability to use functions to return and analyze data in a large variety of ways. Learn about character, case-conversion, numeric, nesting, date, and numeric functions.
Perks of Course
Certificate: Yes
CPD Points: 57
Compliance Standards: AICC
Data Conversion
Price on Request
50 minutes
Frequently when retrieving data stored in an Oracle database it needs to be converted, manipulated, or aggregated. Learn about the Oracle conversion functions and conditional expressions.
Perks of Course
Certificate: Yes
CPD Points: 52
Compliance Standards: AICC
Data Loading in Snowflake: Fundamentals of Stages
Price on Request
2 hour 10 minutes
Snowflake is a modern data cloud solution/ platform that uses an abstraction known as a stage to provide bulk loading of data for analysis, resulting in faster query processing. Begin this course by exploring the internal and external stages in Snowflake. Then, you will load data using Snowflake's classic user interface (UI). Next, examine erroneous data and discover how to query the data and download the results. You will also load data from the stage into an actual table using the SnowSQL command-line interface. Finally, you will create and use table stages, as well as named stages. When you have completed this course, you will be able to differentiate between internal and external stages, list types and features of internal stages, and load data using the classic Snowflake UI.
Perks of Course
Certificate: Yes
CPD Points: 129
Compliance Standards: AICC
Data Loading in Snowflake: Unloading Data
Price on Request
1 hour 15 minutes
Snowflake supports the bulk unloading, or export, of batch data using both internal and external stages. Begin this course by unloading data to all three types of internal stages - user, table, and named. Then, unload data to external stages on the Google Cloud Platform, Microsoft Azure, and Amazon Simple Storage Service (S3). Finally, query data directly from staged files, focusing on the syntax and restrictions of querying data in this manner. When you have completed this course, you will be able to unload data from Snowflake to all three types of internal storage, as well as externally to Google Cloud Storage buckets, Amazon S3 bucket, and Azure Blob Storage.
Perks of Course
Certificate: Yes
CPD Points: 73
Compliance Standards: AICC
Data Loading in Snowflake: Using External Stages
Price on Request
1 hour 35 minutes
Snowflake can load data from the Google Cloud Platform (GCP), Microsoft Azure, and Amazon Simple Storage Service (S3) using external stages. Each cloud platform has one or more techniques for integrating with Snowflake. One method of integration that is supported across all three of the major cloud platforms is storage integration objects. Begin this course by loading data from Google Cloud Storage buckets. Create a Snowflake storage integration object and a GCP cloud storage service account for your Snowflake account. Then, load data from Azure Blob Storage using both the storage integration method and the SAS token method. Finally, integrate with Amazon S3 via storage integrations and using an access key and access key ID credentials. When you have completed this course, you will be able to easily integrate Snowflake with Google Cloud Storage, Azure Blob Storage, and Amazon S3.
Perks of Course
Certificate: Yes
CPD Points: 93
Compliance Standards: AICC
Data Manipulation Language
Price on Request
1 hour 5 minutes
Oracle Database 12c objects contain data, and that data needs to be managed. Learn about manipulating tables by inserting, updating, deleting, and truncating rows.
Perks of Course
Certificate: Yes
CPD Points: 63
Compliance Standards: AICC
Data Manipulation, Queries, Collections, & Indexing
Price on Request
1 hour 15 minutes
Big data is the analysis of massive amounts of data, finding relationships that might not otherwise be apparent. Explore data manipulation, queries, collections, and indexing using Cassandra in a distributed framework.
Perks of Course
Certificate: Yes
CPD Points: 77
Compliance Standards: AICC
PSPO I: Professional Scrum Product Owner Level I Exam Prep - Session 2 Replay
Price on Request
2 hour 20 minutes
This is a recorded Replay of the PSPO I: Professional Scrum Product Owner Level I Live session that ran on August 31st, 2022 at 11 AM ET.
Perks of Course
Certificate: Yes
CPD Points: 142
Compliance Standards: AICC
Working Well with Others
Price on Request
20 minutes
At some point, all of us will encounter competing personalities at work, all vying to get things done their own way. Interpersonal differences and personal perspectives, whether with a manager or a colleague, can increase stress, drain energy, impact morale, and affect productivity and happiness. But there are strategies for mitigating tension and building stronger, more trusting relationships, such as adjusting our own behavior and understanding the situations and behavior of others that can challenge us. In this course, you'll learn how to assess, identify, and manage your own behavioral style to help you avoid and control conflict before it happens. You'll also investigate how to handle common situations that provoke conflict at work, how to work effectively with different personality types, and how to build habits to help you handle interpersonal conflict in the workplace with grace and patience.
Perks of Course
Certificate: Yes
CPD Points: 22
Compliance Standards: AICC