Database Training - Philippines

Prerequisites

There are no prerequisites for attending this course.

Audience

Any developer who wants to upgrade there skill set and willing to build large scale applications can attend this course.

Redis Cluster Database Training​ Course Overview

Redis is an open-source data structure allowing the developer to solve a large amount of data using the key-value method. Redis supports many data structure such as strings, lists, sets, hashes, bitmaps, geospatial index and many more. As Redis is written in ANSI C, it works perfectly with the POSIX system without any dependency.

In this 1-day course, delegates will learn how to use Redis in large applications by understanding the philosophy behind each concept. At the end of this course, delegates will be able to use Redis easily by integrating Redis with any programming language like PHP, Python and many more.

• Delegate pack consisting of course notes and exercises
• Manual
• Experienced Instructor

Prerequisites

There are no prerequisites for attending this course.

Audience

This course is suitable for developers who are interested in building fast APIs to increase the speed of an application.

GraphQL Database Training with React Course Overview

GraphQL is an open-source server-side query language used for APIs and runtime to perform the queries in your existing data.

GraphQL is very advance query language helping developers to define the data what they need. The developers can send a GraphQL query to API and get data corresponding to it. GraphQL applications are much faster as they control the data they received, not the entire server.

Apart from this, you can get data not only for one resource, but the client can also communicate with multiple resources very smoothly. There are many other features in GraphQL that provide a quick way to get and process data from your API.

The Knowledge Academy’s GraphQL Database Training with React course will provide delegates with a strong understanding of GraphQL and serves them with the way of building fast and convenient APIs very quickly.

• Delegate pack consisting of course notes and exercises
• Manual
• Experienced Instructor

Prerequisites

There are no prerequisites to attend this course.

Audience

Anyone interested in learning the working of InfluxDB and is interested in gaining knowledge of this intensifying technology can attend this course.

InfluxDB Training​ Course Overview

InfluxDB is a high-performance time-series database that can store hundreds of thousands of points per second. The InfluxDB SQL-like query language was built specifically for time series. It is an open-source, big data, No SQL database allowing massive scalability, fast write and read, as well as high availability. This InfluxDB Training is designed to provide comprehensive knowledge of InfluxDB.

In this InfluxDB Training course, delegates will get an understanding of how to install and configure InfluxDB OSS. Delegates will learn about schema design and data layout, in-memory indexing, time-structured merge tree (TSM), and Time Series Index (TSI). In addition, they will learn how to enable HTTPS with InfluxDB and how to back up and restore in InfluxDB OSS.

During this 2-days training, delegates will be equipped with the knowledge of InfluxDB command-line interface, graphs and dashboards. Delegates will be introduced to the concepts of data and schema exploration. Furthermore, delegates will acquire knowledge of InfluxDB line protocol, CollectD, OpenTSDB, and UDP.

• Delegate pack consisting of course notes and exercises
• Manual
• Experienced Instructo

Prerequisites

There are no prerequisites for this course.

Audience

Anyone can take this course who wants to learn about databases or RDMS.

Relational Databases & Data Modelling Training​ Course Overview

A relational database management system (RDMS) is a collection of programs and capabilities enabling delegates to create, update, administer and interact with a relational database. RDBMS (relational database) stores data in the form of tables and every table in a relational database comprises rows and columns. In computer science terminology, rows are called tuples and columns are called attributes, and the tables themselves called relation. RDBMS provides a dependable method to store and retrieve large amounts of data.

This course provides knowledge of the structure of the Relational Database Management System (RDBMS) and Data Modelling using entity and relationship diagrams and data normalisation, also in designing relational databases using the normalised entity model. Data modelling and data normalisation are essential topics to be covered in this course.

In this course, delegates will learn about database approach, database management systems and the logic of database architectures. They will also gain an understanding of entity modelling, constraints and assumptions. This course will teach delegates about normalisation’s first form, second form, and third form. They will also learn about logical data structure, relational schema, and database constraints. This course describes the concept of views and de-normalisation techniques. In addition, they will learn about simple queries in structured query language (SQL).

• Delegate pack consisting of course notes and exercises
• Manual
• Experienced Instructor

Prerequisites

For attending this training, the delegates should have basic Knowledge in SQL and general relational database along with basic UNIX commands.

Audience

This course is designed for:

• Developers/Testers
• Analytics Managers
• Individual contributors in the field of Enterprise Business Intelligence

Teradata Training​ Course Overview

Teradata is a data warehousing application which is mainly used to manage large data warehousing operations.

In this 1-day Teradata certification course, delegates will gain in-depth knowledge about the database architecture of Teradata as well as its features and benefits of the product. This Teradata course will help them with getting expertise in creating applications of data warehousing with Teradata while working on use cases and projects.

During this training, delegates will get familiar with the advanced concepts of Teradata. Starting from basic relational concepts of Teradata, other advance topics such as SQL advanced, DML statements, fallback tables, database objects, Teradata utilities - FastExport, TPT and more will be taught by our experienced trainers which will help them to import and export data.

At the end of this Teradata training, delegates will be able to develop business-led data strategies, architect and implement diverse analytic ecosystems as well as they will learn how to work with Teradata effectively.

• Delegate pack consisting of course notes and exercises
• Manual
• Experienced Instructor
• Refreshments

Prerequisites

There are no formal prerequisites to attend this MariaDB Standard DBA Training course.

Audience

This MariaDB Standard DBA Training course is ideal for anyone who wants to gain knowledge of MariaDB. However, this will be more beneficial for:

• Database Administrators
• Support Engineers
• Technical Consultants

MariaDB Standard DBA​ Training Course Overview

MariaDB Server is one of the most widely used open-source database servers. It is utilised for data warehousing, enterprise-level functionality, e-commerce, and logging applications. MariaDB helps organisations by providing high uptime, scalability for growth, and preventing data loss. It assists individuals by making descending and ascending number sequences with given incrementing, starting, and ending values. Pursuing this training will help individuals to gain the knowledge and skills required to administer the MariaDB database and enhance their career prospects.

This 2-day MariaDB Standard DBA Training covers all the essential topics by which delegates will become fully familiar with the MariaDB. During this training, they will learn about how to evaluate data types and character sets. They will also learn about data locking, scaling and partitioning, MariaDB MaxScale database proxy, fundamentals of high availability, temporal tables, Mariabackup, and many more. Our highly professional trainer with years of experience in teaching such courses will conduct this training course and help delegates get a comprehensive understanding of administering MariaDB.

This training will cover various essential topics, such as:

• MariaDB server logs​
• Data types​
• Triggers​
• Useful functions​
• Fast ethernet

After attending this MariaDB Standard DBA Training course, delegates will be able to install and configure the MariaDB server effectively. They will also be able to perform the MariaDB start and shutdown operations and performance tuning to enhance database performance.

• Delegate pack consisting of course notes and exercises
• Experienced Instructor