Data Platforms - III (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
-
29 hours 50 minutesof self-paced video lessons -
33 Programscrafting your path to success -
Completion Certificateawarded on course completion
Leadership Toolkit: Running a Team Debrief
Price on Request
20 minutes
Successful leadership in today's business world requires a multitude of skills and competencies. Among them is the ability to manage diverse teams of individuals with different backgrounds, experiences and expertise. Running an effective team debrief helps business teams more fully understand both the positive outcomes and shortcomings of team events and what needs to be done to rectify missteps and make similar future events even more successful. In this course, you will learn specific techniques and strategies for running a successful team debriefing while handling the challenges of diverse personalities and perspectives. You'll also learn how to keep your business team focused on improving processes, mitigating potential future risks, and finding solutions while avoiding the temptation of assigning blame or abdicating responsibility.
Perks of Course
Certificate: Yes
CPD Points: 19
Compliance Standards: AICC
Map Reduce, Atomic Counters, & Binary Data
Price on Request
40 minutes
MongoDB has some very powerful features to allow you to query and manipulate data. Explore the use of MapReduce and Atomic Counters, as well as how to store binary data using BSON.
Perks of Course
Certificate: Yes
CPD Points: 39
Compliance Standards: AICC
Measuring SQL Performance
Price on Request
1 hour 10 minutes
Once poorly performing SQL is identified and changes are proposed, you need to ensure that they will yield the desired effect. Discover how tools such as the SQL Performance Analyzer and SQL Tuning Advisor can be used to achieve this goal.
Perks of Course
Certificate: Yes
CPD Points: 68
Compliance Standards: AICC
Memory Tuning Techniques
Price on Request
45 minutes
The SGA a key component to the effective working of the Oracle database engine. Learn about SGA tuning, including tuning the buffer cache and I/O.
Perks of Course
Certificate: Yes
CPD Points: 45
Compliance Standards: AICC
Metrics & Monitoring
Price on Request
45 minutes
Metrics are used for system health monitoring, problem detection, and self tuning in Oracle Database 12c. Explore how to establish and manage performance baselines and work with real-time SQL monitoring.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
Models & Applications
Price on Request
1 hour 10 minutes
NoSQL databases offer a data retrieval and storage alternative to RDBMS. Explore the different NoSQL data models, including Cassandra, MongoDB, and Riak. In addition, learn about polyglot persistence and JSON.
Perks of Course
Certificate: Yes
CPD Points: 70
Compliance Standards: AICC
Models & Data Stores
Price on Request
40 minutes
Increase your NoSQL knowledge by learning about the various replication models, key-value data stores and permutations, and working with document, column, graph, object, and XML data stores.
Perks of Course
Certificate: Yes
CPD Points: 38
Compliance Standards: AICC
MongoDB with Spark
Price on Request
55 minutes
MongoDB is a powerful NoSQL database that can use Spark to perform real-time analytics on its data. Examine how to integrate and use MongoDB and Spark together using Java and Python.
Perks of Course
Certificate: Yes
CPD Points: 54
Compliance Standards: AICC
MVC & Server Management
Price on Request
45 minutes
RavenDB is a document-based database for .Net. Learn how to integrate RavenDB into an MVC application, and how to manage your server, including importing and exporting data, performing backups, and implementing authentication.
Perks of Course
Certificate: Yes
CPD Points: 44
Compliance Standards: AICC
NoSQL In-Depth
Price on Request
55 minutes
NoSQL databases are attractive to developers due to their simplicity of design, but data security is always a concern. Learn about security issues and how to address them, as well as HL7, HIPAA, and PCI considerations.
Perks of Course
Certificate: Yes
CPD Points: 53
Compliance Standards: AICC
Objects & Retrieving Data
Price on Request
1 hour 30 minutes
PostgreSQL is an open-source DBMS that supports most SQL constructs. Learn about downloading, installing and configuring the PostgreSQL RDBMS, as well as creating a database, using database objects, and retrieving data.
Perks of Course
Certificate: Yes
CPD Points: 87
Compliance Standards: AICC
Performance Tuning
Price on Request
1 hour 5 minutes
Performance tuning is an important aspect of Oracle Database 12c administration. Learn how to monitor and tune both database and memory performance in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 65
Compliance Standards: AICC
Performance Tuning Methodology
Price on Request
45 minutes
Broaden your knowledge of Oracle Database 12c performance tuning by examining a series of commonly occurring real-world performance problems and the typical solutions for those scenarios.
Perks of Course
Certificate: Yes
CPD Points: 43
Compliance Standards: AICC
Performance Tuning Summary
Price on Request
30 minutes
To fully tune your database, you need a solid understanding of manipulating SGA components and Automatic Memory Management Maintenance. Learn about these Oracle Database 12c concepts.
Perks of Course
Certificate: Yes
CPD Points: 30
Compliance Standards: AICC
Performance, Migration, & Compression
Price on Request
45 minutes
Better tune your Oracle 12c database by understanding index maintenance, extent management, database blocks, Automatic Segment Space Management, migration and chaining, and data compression.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
Performing & Managing Backups
Price on Request
1 hour 10 minutes
As an Oracle database administrator, it is vital that you perform regular backups of the databases. Learn how to perform and manage different types of backups, including incremental, full, block media recovery, and encrypted.
Perks of Course
Certificate: Yes
CPD Points: 70
Compliance Standards: AICC
Performing Joins
Price on Request
55 minutes
Introduce yourself to joins in Teradata! Discover how to use ANSI SQL and Teradata extensions to perform a number of different joins, including inner, outer, self, and cross joins.
Perks of Course
Certificate: Yes
CPD Points: 53
Compliance Standards: AICC
Performing PITR
Price on Request
35 minutes
In Oracle Database 12c, Point-in-Time Recovery lets you recover one or more objects to an earlier time without affecting other objects within the database. Learn how to perform tablespace Point-in-Time recovery and table recovery.
Perks of Course
Certificate: Yes
CPD Points: 35
Compliance Standards: AICC
Performing Subqueries & Correlated Subqueries
Price on Request
50 minutes
A subquery is simply a query contained within another query. Discover how to use ANSI SQL and Teradata extensions to perform subqueries and correlated subqueries in Teradata.
Perks of Course
Certificate: Yes
CPD Points: 49
Compliance Standards: AICC
Primary & Partitioned Indexes
Price on Request
55 minutes
Teradata databases use indexes to store and access rows of data from tables. Discover how to create the various primary and partitioned indexes used by Teradata.
Perks of Course
Certificate: Yes
CPD Points: 53
Compliance Standards: AICC
Programming Essentials
Price on Request
1 hour 10 minutes
NoSQL databases are attractive to developers due to their simplicity of design and finer control over availability. Learn about how to install CouchDB, as well as MapReduce, RESTFul, and some basic programming using Java and JavaScript.
Perks of Course
Certificate: Yes
CPD Points: 71
Compliance Standards: AICC
Quality of Service
Price on Request
50 minutes
Quality of Service management is a component of Oracle RAC that ensures that the most critical business workloads are prioritized for database resources. Explore QoS management, policy sets, server pools, and more.
Perks of Course
Certificate: Yes
CPD Points: 52
Compliance Standards: AICC
Queries in Snowflake: Getting Started with Performance Optimizations
Price on Request
1 hour 50 minutes
Partitioning data based on a column is a common technique for performance query optimization in many database technologies. Snowflake is a highly-performant, big-data technology that uses its own form of data partitioning called micro-partitioning that stores data in columnar format. In this course, discover the advantages of Snowflake micro-partitions over regular, static partitioning. Next, examine how caching works in Snowflake. Finally, learn how to perform the clustering of Snowflake tables and how clustering helps the performance of filters, point-lookups, and range queries on the clustering key columns. Upon completion, you'll be able to leverage micro-partitioning in Snowflake, differentiate between retrieval optimization caching and local disk caching, and implement clustering with the correct clustering key.
Perks of Course
Certificate: Yes
CPD Points: 111
Compliance Standards: AICC
Queries in Snowflake: Search Optimization, External Table Partitions, & Views
Price on Request
1 hour 30 minutes
Search optimization service is a Snowflake feature used to create an auxiliary data structure optimized as a search access path to improve selective point lookup query performance. While search optimization is an extremely handy feature, it can also run up substantial storage and compute costs. In this course, learn how to implement search optimizations by measuring the cost of search optimizations for your table and adding the service to it. Next, differentiate between search optimizations and clustering and discover how to implement partitioning for external tables. Finally, practice working with views in Snowflake and differentiate between non-materialized, materialized, and secure views. Upon completion, you'll be able to leverage search optimization in Snowflake, implement external table partitioning, and use and analyze views.
Perks of Course
Certificate: Yes
CPD Points: 92
Compliance Standards: AICC
RAC Administration
Price on Request
1 hour
Enterprise Manager Cloud Control is a valuable tool in the day-to-day administration tasks of an Oracle RAC database. Explore Enterprise Manager and command-line utilities to manage an Oracle RAC database.
Perks of Course
Certificate: Yes
CPD Points: 62
Compliance Standards: AICC
RavenDB: Getting Started
Price on Request
25 minutes
RavenDB is the most popular NoSQL database for the .Net world. It's open source, extremely fast, and very intuitive. Explore RavenDB.
Perks of Course
Certificate: Yes
CPD Points: 23
Compliance Standards: AICC
Recovery & Availability
Price on Request
40 minutes
When an Oracle database fails, a restore or recovery operation will be needed. Examine how to perform different types of restore operations, including when the database is in ARCHIVELOG or NOARCHIVELOG mode.
Perks of Course
Certificate: Yes
CPD Points: 41
Compliance Standards: AICC
Recovery After Loss
Price on Request
50 minutes
In some cases, an Oracle database will lose files when a failure occurs. Discover how to recover from the loss of control, password, and redo log files, and how to restore a database to a new host and perform disaster recovery.
Perks of Course
Certificate: Yes
CPD Points: 49
Compliance Standards: AICC
Recovery Configuration
Price on Request
1 hour 10 minutes
The Oracle Recover Manager (RMAN) lets you backup, restore and recover Oracle databases. Learn how to configure Recovery Manager (RMAN), and how to create a recovery catalog for managing database backup, restore, and recovery processes.
Perks of Course
Certificate: Yes
CPD Points: 69
Compliance Standards: AICC
Relational Database & Data Warehouse Basics
Price on Request
1 hour 10 minutes
Teradata provides a relational database system that offers various tools and utilities for management, administration, and querying. Explore the basics of Teradata including what a data warehouse is along with its architecture and design.
Perks of Course
Certificate: Yes
CPD Points: 68
Compliance Standards: AICC
Relational Database Concepts
Price on Request
40 minutes
As an administrator or developer, it's important to understand the object-relational aspects of Oracle Database 12c. Learn about data models, the Entity Relationship Model, and the Oracle HR sample schema.
Perks of Course
Certificate: Yes
CPD Points: 38
Compliance Standards: AICC
Relational Database Management System (RDBMS)
Price on Request
35 minutes
Teradata offers a high quality system using a parallel database architecture providing a "share nothing" architecture. Explore a relational database system and the hardware and software used by Teradata for the database architecture.
Perks of Course
Certificate: Yes
CPD Points: 34
Compliance Standards: AICC
Replication & Security
Price on Request
55 minutes
It's important that data in a MongoDB database is available to users at all times and that it's secure. Discover how to configure replication and security for MongoDB.
Perks of Course
Certificate: Yes
CPD Points: 53
Compliance Standards: AICC