Data Platforms - II (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
-
18 hours 35 minutesof self-paced video lessons -
22 Programscrafting your path to success -
Completion Certificateawarded on course completion
Data Retrieval
Price on Request
1 hour 25 minutes
Make your data work for you. Learn to ensure data integrity using constraints and analyze data using the SELECT command and WHERE, GROUP BY, DISTINCT, and ORDER BY clauses. And explore how to speed up searches using indexes and views.
Perks of Course
Certificate: Yes
CPD Points: 83
Compliance Standards: AICC
Data Transportation
Price on Request
30 minutes
Using Data Transport in Oracle Database 12c, you can transport tablespace to other databases or transport entire databases. Discover how to perform both tablespace and database transports.
Perks of Course
Certificate: Yes
CPD Points: 30
Compliance Standards: AICC
Database Maintenance
Price on Request
40 minutes
Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. Learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 40
Compliance Standards: AICC
Database Transactions
Price on Request
45 minutes
It's important to ensure that the SQL statements that make up a transaction succeed or fail as a group. Explore the concepts of database transaction control using the COMMIT, ROLLBACK, and SAVEPOINT commands.
Perks of Course
Certificate: Yes
CPD Points: 45
Compliance Standards: AICC
DDL, DML, & Constraints
Price on Request
1 hour 30 minutes
Data definition and data manipulation languages allow you to work with data in meaningful ways. Discover how to work with SQL DML commands, constraints, and datatypes in PostgreSQL.
Perks of Course
Certificate: Yes
CPD Points: 88
Compliance Standards: AICC
Deployment & Scaling
Price on Request
55 minutes
RavenDB has combined the best of relational databases with that of document databases. Discover how to deploy and accomplish scaling, embed RavenDB, shard, and implement replication.
Perks of Course
Certificate: Yes
CPD Points: 57
Compliance Standards: AICC
Distributed Systems & Big Data
Price on Request
30 minutes
NoSQL databases are increasingly used in real-time web applications and big data. Learn about distributed systems, issues, and models, as well as consistent hashing, big data, and analytics.
Perks of Course
Certificate: Yes
CPD Points: 29
Compliance Standards: AICC
Duplicating Databases
Price on Request
45 minutes
There may be times when you want to duplicate a database, such as for recovery or testing purposes. Examine various methods for duplicating a database in Oracle Database 12c, including using RMAN.
Perks of Course
Certificate: Yes
CPD Points: 44
Compliance Standards: AICC
Failure & Recovery Concepts
Price on Request
1 hour 5 minutes
The Data Recovery Advisor is an excellent tool to help protect data in your Oracle databases. Learn how to diagnose and repair failures using Data Recovery Advisor, and how various restores and recoveries are performed.
Perks of Course
Certificate: Yes
CPD Points: 64
Compliance Standards: AICC
Grid Infrastructure
Price on Request
1 hour 30 minutes
The Oracle Grid Infrastructure lays the foundation for highly available and scalable Oracle RAC systems. Explore the Oracle Grid Infrastructure, including Oracle Clusterware and Grid plug and play.
Perks of Course
Certificate: Yes
CPD Points: 21
Compliance Standards: AICC
Implementing Performance Tuning
Price on Request
30 minutes
Oracle Enterprise Manager gives you a central area for managing Oracle tools. Learn about OEM architecture and pages, as well as using alerts in tuning, user trace files, common tuning problems, and service requests.
Perks of Course
Certificate: Yes
CPD Points: 28
Compliance Standards: AICC
Indexes
Price on Request
1 hour 15 minutes
In Raven, an index is an optimized on-disk data structure that returns query results very quickly. Explore indexes, full text searches, paging results, and streaming large result sets.
Perks of Course
Certificate: Yes
CPD Points: 77
Compliance Standards: AICC
Indexes & Query Optimization
Price on Request
30 minutes
Administrating a MongoDB database includes ensuring queries respond fast enough for users to obtain the correct data from the database. Learn how to create indexes and perform query optimization in MongoDB.
Perks of Course
Certificate: Yes
CPD Points: 28
Compliance Standards: AICC
Installing MongoDB
Price on Request
35 minutes
MongoDB is an open-source documentation database that can be installed on various operating systems with minimum requirements. Explore MongoDB, and discover how to install it on Linux and Windows.
Perks of Course
Certificate: Yes
CPD Points: 33
Compliance Standards: AICC
Introducing SELECT Statement Queries
Price on Request
30 minutes
Teradata supports the use of ANSI SQL to query data housed in a database system, and with ANSI SQL, it supports Teradata extensions. Discover how to use the SELECT statement to perform queries.
Perks of Course
Certificate: Yes
CPD Points: 30
Compliance Standards: AICC
Introduction to Performance Tuning
Price on Request
30 minutes
There are many methodologies for troubleshooting performance problems in Oracle Database 12c. Learn about performance management techniques, including tuning goals and objectives, and working with waits, events, classes, and statistics.
Perks of Course
Certificate: Yes
CPD Points: 29
Compliance Standards: AICC
Java ASYNC Interface
Price on Request
35 minutes
The MongoDB Java Driver can be used to provide both synchronous and asynchronous interaction with MongoDB. Explore the Java Async Driver for making asynchronous connections in MongoDB.
Perks of Course
Certificate: Yes
CPD Points: 35
Compliance Standards: AICC
Java REST & GridFS
Price on Request
35 minutes
MongoDB includes a number of features to query and manipulate data. Discover how to use persistence, Java REST API, and GridFS in MongoDB.
Perks of Course
Certificate: Yes
CPD Points: 33
Compliance Standards: AICC
Locking & Data Protection
Price on Request
55 minutes
To control concurrency, Teradata uses different locking mechanisms. Discover the different locking mechanisms and performance availability features, such as RAID, failover, cliques, and hot standby.
Perks of Course
Certificate: Yes
CPD Points: 57
Compliance Standards: AICC
Maintaining SQL Performance
Price on Request
25 minutes
Database Replay can help with performance tuning by allowing you to capture a workload and replay it on a test system to see the effect of changes outside of the production database. Learn about Database Replay in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 25
Compliance Standards: AICC
Managing a Database Instance
Price on Request
1 hour 15 minutes
Discover how to get started with Oracle Database 12c, configure initialization parameters, start up a database instance, work with log files, and use the various database views.
Perks of Course
Certificate: Yes
CPD Points: 74
Compliance Standards: AICC
Managing Snowflake: Administering a Snowflake Account
Price on Request
1 hour 25 minutes
Snowflake is a powerful enterprise Software as a Service (SaaS) offering, and like all SaaS technologies, it is particularly important to administer it correctly, from the perspective of both security and access control and of monitoring and attributing resource usage. Otherwise, costs and security vulnerabilities can quickly pile up as users, roles, and accounts increasingly multiply. In this course, discover how to manage the accounts and users within an organization. Then, explore how Snowflake allows users to configure various properties on objects, using parameters. Next, use resource monitors to impose limits on the number of credits consumed by Snowflake and examine what happens if that limit is breached. Learn how to configure single sign-on using Otka and implement federated authentication. Finally, perform data masking and investigate how Snowflake allows you to redact and censor data at the column level using masking polices.
Perks of Course
Certificate: Yes
CPD Points: 87
Compliance Standards: AICC