Data Platforms - IV (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
-
24 hours 10 minutesof self-paced video lessons -
29 Programscrafting your path to success -
Completion Certificateawarded on course completion
Restricting Output
Price on Request
45 minutes
Database tables often hold a large number of rows, which aren't necessarily sorted. Learn how to selectively return only a subset of rows, sorted and customized, using operators, conditions, wildcards, and clauses.
Perks of Course
Certificate: Yes
CPD Points: 44
Compliance Standards: AICC
Secondary & Join Indexes
Price on Request
45 minutes
Teradata offers various types of indexes which can be used based on the type of data and how it is accessed by the users. Discover how to create the secondary and join indexes used by Teradata.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
Secure Backup
Price on Request
25 minutes
To help recover from a failure, you can use Oracle Secure Backup with Recover Manager (RMAN). Learn about Oracle Secure Backup, and how to install and configure it for use with RMAN to perform backups and restores.
Perks of Course
Certificate: Yes
CPD Points: 24
Compliance Standards: AICC
Security & Administration
Price on Request
1 hour 15 minutes
Managing data and users are important tasks for a database administrator. Learn about administrative tasks like securing objects, managing groups, as well as command line management options, scripting, and reporting.
Perks of Course
Certificate: Yes
CPD Points: 74
Compliance Standards: AICC
SELECT Statement, Expressions, & Operators
Price on Request
40 minutes
SQL*Plus provides a convenient way to work with Oracle data. Learn to retrieve data using SELECT statements with arithmetic expressions, NULL values, column aliases, and literal strings. In addition, learn how to handle duplicate rows.
Perks of Course
Certificate: Yes
CPD Points: 42
Compliance Standards: AICC
SQL Developer
Price on Request
1 hour
Oracle offers a free integration development environment, SQL Developer. Learn about SQL Developer, including creating connections, using SQL Worksheet, debugging, modeling data, and linking to external tools.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
SQL Diagnostics
Price on Request
45 minutes
Increase your performance tuning knowledge by learning the basic phases of SQL processing and ways to extract detailed information about the actual execution of a SQL statement in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
SQL Memory Usage Tuning
Price on Request
25 minutes
The SGA is a key component to the effective working of the Oracle database engine. Explore SQL memory usage, the PGA and its role in sort operations, and temporary tablespaces.
Perks of Course
Certificate: Yes
CPD Points: 23
Compliance Standards: AICC
SQL Tuning
Price on Request
55 minutes
Proper monitoring and tuning of databases significantly improves system performance. Learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 53
Compliance Standards: AICC
SQL*Plus Commands
Price on Request
25 minutes
SQL*Plus is an interactive and batch query tool that is installed with every Oracle Server and client installation. Learn about the features and functionality of SQL*Plus, including editing, file, and output commands.
Perks of Course
Certificate: Yes
CPD Points: 24
Compliance Standards: AICC
System Management
Price on Request
35 minutes
Correctly managing a MongoDB allows for seamless storing and retrieval of data. Discover how to manage databases and collections, as well as use the GUI management tools.
Perks of Course
Certificate: Yes
CPD Points: 37
Compliance Standards: AICC
Tuning Instance Memory
Price on Request
50 minutes
When performance tuning in Oracle Database 12c, it's vital to include the System Global Area in your efforts. Explore SGA tuning, including using AWR reports, adaptive cursor sharing, and the SQL query result cache.
Perks of Course
Certificate: Yes
CPD Points: 50
Compliance Standards: AICC
Tuning Problem SQL Statements
Price on Request
50 minutes
SQL is at the heart of any relational database management system, and optimizing SQL typically provides the largest performance gains in real-world situations. Explore the Cost-Based Optimizer and optimizing data retrieval.
Perks of Course
Certificate: Yes
CPD Points: 48
Compliance Standards: AICC
Tuning RMAN
Price on Request
40 minutes
Because RMAN uses resources, you need to monitor and correct any performance issues that may occur. Learn to use the Oracle Database 12c tools for troubleshooting and tuning RMAN, and best practices for restore and recovery performance.
Perks of Course
Certificate: Yes
CPD Points: 41
Compliance Standards: AICC
Undo Feature Overview
Price on Request
25 minutes
An Oracle Database 12c administrator will, at some point in time, need to roll back changes made to the database. Learn how this is done using the Undo feature in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 25
Compliance Standards: AICC
Updating & Patching Documents
Price on Request
55 minutes
RavenDB is a document-oriented database designed for storing, retrieving, and managing semi-structured data. Discover how to update and patch documents, object relationships, asynchronous operations, and bulk inserts.
Perks of Course
Certificate: Yes
CPD Points: 53
Compliance Standards: AICC
User Security Features & Configuration
Price on Request
1 hour 5 minutes
Securing an Oracle Database 12c system involves controlling who can access the database and what they can do. Learn how to manage privileges, and use roles, profiles, quotas, and password security to make your databases secure.
Perks of Course
Certificate: Yes
CPD Points: 65
Compliance Standards: AICC
Using Flashback Technologies
Price on Request
50 minutes
The Oracle Flashback technologies let you view past states of database objects or return objects to a previous state. Discover how to use Flashback Data Archive and Flashback Database as part of your backup and recovery strategy.
Perks of Course
Certificate: Yes
CPD Points: 50
Compliance Standards: AICC
Working with Clauses, Operators, Expressions, & Aggregates
Price on Request
1 hour
Learn how to work with clauses, operators, expressions, and aggregates in Teradata using ANSI SQL and Teradata extensions.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
Working with Data Conversions & SET Operations
Price on Request
1 hour
You can use functions, expressions, and operators to perform operations on data in Teradata. Learn how to perform data conversions and computations, and use SET operators.
Perks of Course
Certificate: Yes
CPD Points: 62
Compliance Standards: AICC
Working with Data Definition Language (DDL)
Price on Request
1 hour 30 minutes
Teradata supports the use of SQLs data definition language (DDL) to create, modify, and remove objects in a database. Work with DDL to create and alter databases, tables, indexes, triggers, and more.
Perks of Course
Certificate: Yes
CPD Points: 91
Compliance Standards: AICC
Working with DDL
Price on Request
1 hour 10 minutes
There's a lot of flexibility available in how you create tables to store data in an Oracle 12c database. Learn about how to create tables, choose the proper data type for columns, set constraints, and change or delete existing tables.
Perks of Course
Certificate: Yes
CPD Points: 70
Compliance Standards: AICC
Working with DML, Optimization, & Temporal Concepts
Price on Request
1 hour 10 minutes
Teradata supports the use of SQLs data manipulation language (DML) to retrieve, insert, update, and delete data in a database. Explore DDL and DML operations in a database or temporal tables.
Perks of Course
Certificate: Yes
CPD Points: 71
Compliance Standards: AICC
Working with Functions, Times, Dates, & Intervals
Price on Request
1 hour 30 minutes
Teradata supports the use of functions, expressions, and operators to perform operations on data. Explore attribute, string, and analytical functions, as well as times, dates, and intervals in Teradata.
Perks of Course
Certificate: Yes
CPD Points: 91
Compliance Standards: AICC
Working with Joins
Price on Request
1 hour
It's important to minimize data redundancy in a relational database. Learn how to view information across multiple tables with joins and use advanced SELECT features to obtain values based on an unknown conditional value.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
Working with SET Operators
Price on Request
25 minutes
SET operators allow you to combine the results of two queries into one. Learn how to use SET operators and match SELECT statements in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 26
Compliance Standards: AICC
Working with Subqueries
Price on Request
40 minutes
It's not uncommon to need more than one query to get to the data results you require. Learn about using subqueries to solve problems in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 38
Compliance Standards: AICC
Working with Substitution
Price on Request
25 minutes
Learn how to build dynamic queries in Oracle Database 12c using substitution variables and the DEFINE and VERIFY commands.
Perks of Course
Certificate: Yes
CPD Points: 23
Compliance Standards: AICC
Write, Read, & Aggregate Data
Price on Request
50 minutes
MongoDB provides CRUD operations to read and write documents within collections. Discover how to create and manage documents, as well as how to query them using the find() method and aggregation.
Perks of Course
Certificate: Yes
CPD Points: 50
Compliance Standards: AICC