Apache CouchDB for Developers Training Course

Audience

• Programmers
• Beginner IT professionals

Format of the course

•     Part lecture, part discussion, heavy hands-on practice

Pivotal Greenplum is a Massively Parallel Processing (MPP) Data Warehouse platform based on PostgreSQL.

This instructor-led, live training (online or onsite) is aimed at developers who wish to set up a multi-node Greenplum database.

By the end of this training, participants will be able to:

• Install and configure Pivotal Greenplum.
• Model data in accordance to current needs and future expansion plans.
• Carry out different techniques for distributing data across multiple nodes.
• Improve database performance through tuning.
• Monitor and troubleshoot a Greenplum database.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

MarkLogic Server adalah solusi data data multi-model yang membolehkan organisasi menyimpan, mengendalikan, aman, dan analisi data perusahaan. MarkLogic Server berfokus pada kemampuan pencarian dan akses data cepat.

Latihan yang dibicarakan, digunakan dalam instruktor ini (outline atau on site) bertujuan untuk administrator sistem, administrator database, arhitekt data, dan penyiar yang ingin memainkan, konfigurasi, dan mengatur MarkLogic Server untuk optimis sistem database mereka.

Pada akhir latihan ini, para penyebaran akan dapat melakukan, mengembangkan, mengatur, dan memastikan sistem data dan data data perusahaan mereka melalui MarkLogic Server.

Format Course

Ceramah interaktif dan diskusi. Banyak latihan dan latihan. Implementasi tangan dalam lingkungan live-lab.

Pilihan Kusuasi Kursus

Untuk meminta pelatihan yang dipakai untuk kursus ini, silakan menghubungi kita untuk mengatur.

SAP ASE (SAP Adaptive Server Enterprise), previously known as Sybase SQL Server, Sybase DB and Sybase ASE is a relational database for businesses.

In this instructor-led, live training, participants will learn the fundamentals of SAP ASE (SAP Adaptive Server Enterprise) Database Administration as they step through the creation and deployment of a sample SAP ASE Database System.

By the end of this training, participants will be able to:

• Install and configure SAP ASE for data storage as well as transactional operations.
• Understand and use SAP ASE components, tools, and utilities.
• Integrate SAP ASE with non-SAP ASE applications.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

The course participants will learn the terminology of relational databases, acquire the skills to design database applications, know the basic principles of creating forms and reports.

The training discusses issues related to programming in Visual Basic for Applications and presents ways of accessing data using VBA. The training participants also learn the mechanisms that allow them to write a professional database application.

The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA.

The course is designed for persons with pre-information databases using SQL queries or queries.

The Microsoft Access course is an intensive training in the use of this attractive database engine. The first module will introduce you to the world of relational databases, presenting the benefits of using them and the distinctive features of Access. Then we will focus on the practical aspects of maintaining existing Access databases, including record operations, creating queries and forms, as well as fixing errors. In the next module, you will learn the secrets of designing new tables and learn how to use the primary key effectively. The topic of relationships between tables, including both one-to-one and one-to-many, will also be in focus. The advanced module will be devoted to creating queries, presenting various types of queries and their applications. You'll also learn how to export and import data between Access and Excel, allowing the two programs to work together effectively. The course also includes creating forms, reports and automating work using macros. All this using practical examples and omitting unnecessary details to ensure effective knowledge acquisition. Prepare to dive into the world of Access and master key database management skills.

The course participants will learn how to design a database and how to adapt it to work with the end user.

This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:

• how to write SQL queries
• what relational databases are and how we can use them
• what are relations and how to create them
• the structure of data
• differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for writing queries

This SQL course deals with Microsoft Access dialect of SQL.

The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.

FARM (FastAPI, React, and MongoDB) is similar to MERN, but performs faster with Python and FastAPI replacing Node.js and Express as the backend. FastAPI is a high-performance Python web framework used by top companies, such as Microsoft, Uber, and Netflix. React is an open source front-end JavaScript library, while MongoDB is a fully scalable NoSQL database.

This instructor-led, live training (online or onsite) is aimed at developers who wish to use the FARM (FastAPI, React, and MongoDB) stack to build dynamic, high-performance, and scalable web applications.

By the end of this training, participants will be able to:

• Set up the necessary development environment that integrates FastAPI, React, and MongoDB.
• Understand the key concepts, features, and benefits of the FARM stack.
• Learn how to build REST APIs with FastAPI.
• Learn how to design interactive applications with React.
• Develop, test, and deploy applications (front end and back end) using the FARM stack.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange

The MERN Stack is a collection of web development software, namely MongoDB, Express, React, and Node.js. The MERN Stack provides an end-to-end framework for developers to build and deploy fullstack web applications.

This instructor-led, live training (online or onsite) is aimed at web developers who wish to use the MERN Stack for fullstack development.

By the end of this training, participants will be able to:

• Integrate React with MongoDB, Express, and Node.js.
• Build a fullstack web application from scratch.
• Implement application security through authorization and authentication.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

After the training, you will be able to write extract and modify the data in MongoDB database. You will also learn about powerful Aggregation Pipeline that is a flexible and fast tool for data analytics, and if it's not enough for you, how to connect your current BI tools like Tableau or Excel to data stored in Mongo.