close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Database Training

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Introduction to Database Training​ Course Outline

Introduction to Database

  • What is Database?
  • Characteristics of the Database
  • DBMS: Introduction
  • Advantage of Using DBMS

Database System and Architecture

  • Data Models and Scheme
  • Three Scheme Architecture
  • Data Independence
  • The Database System Environment
  • Client-Server Architecture for DBMS
  • Classification of the Database Management System

Database Modeling

  • Entities in Database
  • Entity Types
  • Entity Sets
  • Relationship and its Types
  • Relationships Sets
  • Roles and Structure

Relational Model

  • Relation Model Concept
  • Relation Database Scheme
  • Operations on Database

Basic Constraints and Queries

  • SQL Data Definition and Data Types
  • Basic Constraints
  • Basic Queries SQL
  • Insert, Delete and Update Statement in SQL.

Functional Dependencies and Normalization

  • Functional Dependencies
  • Normal Form Based on Primary Key
  • Boyce Codd Normal Form

Show moredown

Prerequisites

There are no prerequisites for attending this course.

Audience

Anyone with any level of skill can join this course and enhance their skills in database.

Introduction to Database Training​ Course Overview

Database act like a backbone for every application. It is used from web application to the mobile app, offline to online, single-page applications (SPA) to extensive application database.

Every application has one common task that is process data. For example, a web application process web pages, a social application process posts and story, a food ordering application use its orders data for their business. Every app commonly fetches and process data and modify according to its needs and functionality.

The Knowledge Academy’s 1-day course will help the delegate to enhance their skills to manage the data produced by their remarkable applications. This course is beneficial for anyone who wants to make their carrier in different roles like full stack developer, database administrator(DBA), data analyser, data scientist, and database operator. This Course will serve the delegates with all the primary understanding of every concept of the database from scratch.

Show moredown

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

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Redis Cluster Database Training​ Course Outline

Getting Started With Redis

  • Introduction to Redis
  • Applications of Redis
  • Redis Environment
  • Redis Configuration

Redis Data Type

  • String
  • Hash
  • List
  • Set and Sorted Set

Redis Commands

Keys in Redis

  • What is Key in Redis?
  • Key’s Commands

Strings in Redis

  • Redis Strings
  • Redis String’s Commands

Lists in Redis

  • Lists in Redis
  • Redis List’s Commands

Redis Hashes

  • Hashes: Behind the Concept
  • Commands for Hashes

Redis Sets

Public Subscribe

Redis Transaction

Scripting in Redis

Redis Security

Redis Pipelining

Show moredown

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.

Show moredown

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

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

GraphQL Database Training with React Course Outline

Introduction To GraphQL

  • What is GraphQL?
  • Why We Need GraphQL?

Environment Setup

  • Build Graph SQL Server with node.js

GraphQL Architecture

  • GraphQL with Connected Database
  • Server Integrating
  • Hybrid Approach

Application Components

  • Server-Side Component
  • Client-Side Component

Type System in GraphQL

  • Scalar Type
  • Object Type
  • Query Type
  • Mutation Type
  • Enum Type
  • List type

Integration with React

  • Setting Up the Server
  • Setting Up the Client

Query

  • What is the Query Variable?
  • Uses of the Query Variable

Caching in GraphQL

  • InMemory Cache
  • Illustration

Show moredown

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.

Show moredown

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

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

InfluxDB Training​ Course Outline

Introduction to InfluxDB

  • InfluxDB Installation Requirements
  • Installing InfluxDB OSS
  • Configure InfluxDB OSS
  • Hosting InfluxDB OSS on AWS
  • Getting Started with InfluxDB OSS
  • Create a Database
  • Write and Explore Data

InfluxDB Concepts

  • InfluxDB Key Concepts
  • Comparing InfluxDB to SQL Databases
  • Design Insights and Tradeoffs
  • Schema Design and Data Layout
  • In-memory Indexing and The Time-Structured Merge Tree (TSM)
  • Overview of Time Series Index (TSI)

Administering InfluxDB

  • InfluxDB Authentication and Authorisation
  • Enable HTTPS with InfluxDB
  • InfluxDB Logging and Tracing
  • Backing Up and Restoring in InfluxDB OSS
  • Manage InfluxDB Security

Introduction to InfluxDB Tools

  • InfluxDB Command Line Interface
  • Inspect Disk Shard Utility
  • Graphs and Dashboards

Influx Query Language (InfluxQL)

  • Data Exploration
  • Schema Exploration
  • Database Management
  • Functions
  • Continuous Queries
  • Mathematical Operators

Exploring InfluxDB Protocols

  • InfluxDB Line Protocol
  • CollectD
  • Graphite
  • OpenTSDB
  • Prometheus
  • UDP

Show moredown

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.

Show moredown

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

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Relational Databases & Data Modelling Training​ Course Outline

Module 1: Introduction to Relational Databases

  • The Database Approach
  • Database Management Systems
  • The Function of a Database Management System
  • The Processing, Schema, and Storage Architecture
  • An Overview of Database System Development
  • An Overview of General Database Principles

Module 2: Conceptual Data Models

  • Overview of Entity Models
  • Entities and How to Identify Them
  • Attributes and How to Identify Them
  • Relationships and Their Qualities
  • Building an Entity Relationship Diagram
  • Resolving Many-to-Many Relationships
  • Sub-Type and Super-Type Relationships
  • Arc Relationships
  • Recursive Relationships
  • Constraints and Assumptions
  • Normalisation to the First Normal Form (1NF)
  • Normalisation to the Second Normal Form (2NF)
  • Normalisation to the Third Normal Form (3NF)
  • Exercises:
    • Analysing a Specification
    • Creating an Entity Relationship Diagram from the Specification
  • Exercises: Data Normalisation Producing Table Specifications and Entity Diagrams

Module 3: The Relational Model

  • Relational Structure
  • Relational Terminology
  • Domains
  • A Relational Schema
  • Candidate Keys and Primary Keys
  • Foreign Keys
  • Key Constraints
  • Attribute Constraints
  • Implementing Sub-Type/Super-Type Relationships
  • Views
  • Denormalisation Using Pre-joined Tables
  • Denormalisation Using Derived Data
  • An Introduction to Structured Query Language (SQL)
  • Simple Queries
  • Simple Updates of the Data
  • Exercise: Data Modelling from an Invitation to Tender

Show moredown

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).

Show moredown

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

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Teradata Training​ Course Outline

Teradata - An Overview

  • Basic Relational Concepts
  • Introduction to Teradata
  • Competitive Benefits over Other RDBMS
  • Teradata Architecture and Components
  • How to Store and Retrieve Data
  • Teradata How Components Interact with Each Other
  • Connectivity with Mainframe and Network Applications
  • Tools and Utilities
  • Teradata Unified Data Architecture

Teradata SQL

  • Data Types
  • DML Statements (Insert, Delete, Update)
  • DCL Statements (Grant, Revoke)
  • DDL Statements (CREATE, ALTER, DROP)
  • Order by, Group by, Distinct, SET Operators
  • Logical & Conditional Operators
  • String Functions
  • HELP and Show Functions
  • Cast & Format Functions
  • Date and Built-In Functions
  • Joins (INNER and OUTER)
  • Aggregation

Teradata Indexes and Join Strategies

  • Difference between Primary Key and Primary Index
  • Primary Index and Types
  • How Primary Index is used in Data Distribution and Retrieval
  • Secondary Index
  • Types of Secondary Index
  • Data Retrieval using Secondary Index
  • Partition Primary Index and its Types
  • Advantage of PPI
  • Join Strategies
  • How Data is Redistributed for Join Processing

SQL Advanced

  • Introduction to Subqueries
  • Upsert, Case, Coalesce, Nullif, OLAP Functions
  • Transaction Modes
  • Rank & Row Number
  • Temporary Tables (Derived, Volatile and Global Temporary)
  • Explain and Collect Statistics

Data Protection

  • Introduction to Transaction Locks
  • Fallback Tables
  • Clusters
  • Permanent Journal
  • Down AMP Recovery Journal
  • Transient Journal
  • Cliques
  • Data Dictionary
  • Hot Standby Nodes
  • RAID 1 & RAID 5

Advanced Database Objects and Performance Optimisation

  • Views and Macros
  • Stored Procedure
  • Join Index
  • Performance Tuning tips

Teradata Utilities - FastLoad, MultiLoad, BTEQ

  • What is FastLoad
  • How FastLoad Loads Data
  • How to Restart Failed FastLoad Jobs
  • What is MultiLoad and how MultiLoad Works
  • Using MultiLoad to insert/update/delete data from Teradata tables
  • Using BTEQ to import/export data

Teradata Utilities - FastExport, TPT

  • FastExport - Exporting Data from Teradata
  • TPT Overview
  • TPT Export
  • TPT Load
  • TPT Update Comparison of Load/Unload Utilities
  • TPT SQL Selector

Show moredown

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.

Show moredown

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

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

MariaDB Standard DBA​ Training Course Outline

Module 1: Install and Configure MariaDB Server​

  • Steps to Install and Configure MariaDB Server​

Module 2: Perform the MariaDB Start and Shutdown Operations​

  • MariaDB Start and Shutdown Operations​

Module 3: Activate and Manage MariaDB Server Logs​

  • MariaDB Server Logs​

Module 4: MariaDB Server Internals ​

  • MariaDB Server Internals

Module 5: Evaluate Data Types and Character Sets​

  • Data Types​
  • Character Sets​

Module 6: MariaDB Schema Objects​

  • Views​
  • Triggers​
  • Table Partitioning​

Module 7: Compare and Understand Various Storage Engines in MariaDB​

  • Storage Engines for General Purpose​
  • Scaling and Partitioning​
  • Compression / Archive​
  • Connecting to Other Data Sources​
  • Search Optimised

Module 8: Understand Transactions and Data Locking in MariaDB​

  • Transactions​
  • Data Locking​

Module 9: Manage Users, Roles, and Security​

  • Data-At-Rest Encryption ​
  • Useful Functions​

Module 10: Mariabackup​

  • Overview of Mariabackup
  • Run Command in MariaDB Shell
  • Creating Backup Using Mariabackup

Module 11: Regular Expression

  • Regular Expression

Module 12: Performance Tuning Techniques​

  • Memory
  • Disks
  • Fast Ethernet
  • CPU
  • Setting Your Disk I/O Scheduler​
  • Increase Open Files Limit​

Module 13: Fundamentals of High Availability​

  • Fundamentals of High Availability

Module 14: Configure and Monitor MariaDB Replication​

  • MariaDB Monitor​

Module 15: Understand the MariaDB MaxScale Database Proxy

  • MariaDB MaxScale Database Proxy​

Module 16: Advanced Features in MariaDB

  • Window Functions​
  • Common Table Expressions (CTEs)​
  • Temporal Tables 
 

Show moredown

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.

Show moredown

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

Show moredown

Not sure which course to choose?

Speak to a training expert for advice if you are unsure of what course is right for you. Give us a call on +44 1344 203999 or Enquire.

Database Training FAQs

FAQ's

Please arrive at the venue for 08:45 am.
DB stands for Database, which refers to a particular place where developers store the data to process. On the other hand, DBMS is used as a software to manage those stored data and perform the various operations on it.
Structured query language (SQL) is a way to communicate with the Database management system (DBMS) to perform operations on the database.
The database is used in almost every application like Web Application, Mobile Application, Desktop application.
Our database courses are designed especially for all developers with any skill level. So anyone who wants to enhance their skills can learn database.
Our Database Training is at its best to serve the courses from beginners to advance level. If you do not know anything about the database, we have number of courses that will teach you from scratch. On the other hand, if you are already familiar with the database concepts, then you can learn advanced topics as well.
The Knowledge Academy provides various delivery methods comprising Onsite, Classroom, Virtual, Online to serve the courses to the delegates.
After Successfully completion of course, delegates can integrate their application to a database and will be able to operate a popular database management system efficiently.
There are several roles in an organisation where delegates can build their carrier in a database like Database Administrator, Data Analyser, Database operator, and Data scientist.
RDBMS means Relational database management system and all DBMS like SQL, MS SQL Server, IBM DB2, My-SQL, Oracle and Microsoft Access are based on it.
Please see our Database Training courses available in Philippines
The Knowledge Academy is the Leading global training provider for Database Training.
The price for Database Training certification in Philippines starts from $.

Why we're the go to training provider for you

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

We are accredited by PeopleCert on behalf of AXELOS

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo

Looking for more information on Database Training