This instructor-led, live training in 台灣 (online or onsite) is aimed at developers who wish to use and integrate Node.js, Express, and MongoDB to build fast and scalable REST APIs.
By the end of this training, participants will be able to:
Set up and integrate Node.js and Express with MongoDB.
Understand the features and architecture of Node.js, Express, and MongoDB.
Learn how to build RESTful APIs using the Node.js, Express, and MongoDB backend stack.
Implement routes, filtering, sorting, and pagination to Node.js REST APIs.
Design data models and perform CRUD operations with MongoDB and Mongoose.
This instructor-led, live training in 台灣 (online or onsite) is aimed at data analysts and data scientists who wish to use the MongoDB Aggregation Framework to perform data analysis while simplifying complex operations and aggregation pipelines.
By the end of this training, participants will be able to:
Install and configure MongoDB for data analysis.
Understand the concepts and stages of the MongoDB Aggregation Framework.
Learn about the basic structure, syntax, and operations for aggregation.
Learn how to handle advanced operations in aggregation.
Apply some optimization tools and techniques to improve aggregation performance.
This instructor-led, live training in 台灣 (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.
This instructor-led, live training in 台灣 (online or onsite) is aimed at advanced-level database administrators who wish to learn how to configure and manage data workload on databases.
By the end of this training, participants will be able to:
This instructor-led, live training in 台灣 (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.
By the end of this training, participants will be able to:
Write SQL queries to retrieve, filter, sort, and aggregate data.
Perform data manipulation operations such as inserting, updating, and deleting data.
Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
Integrate MySQL with popular programming languages and execute queries from application code.
This instructor-led, live training in 台灣 (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
This instructor-led, live training in 台灣 (online or onsite) is aimed at data scientists and developers who wish to use and integrate SQL, Python, and Tableau to perform complex data analysis, processing, and visualization.
By the end of this training, participants will be able to:
Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
Get a refresher on the fundamentals of Python and SQL.
Perform data pre-processing techniques in Python.
Learn how to connect Python and SQL for data analysis.
Create insightful data visualizations and charts with Tableau.
This instructor-led, live training in 台灣 (online or onsite) is aimed at intermediate-level data scientists who wish to learn how to utilize the COST IT module of Presto for cost analysis.
By the end of this training, participants will be able to:
Understand the fundamentals of Presto and its role in big data analytics.
Gain proficiency in using Presto's COST IT module for cost analysis.
Optimize Presto queries for improved performance and resource utilization.
Identify and implement cost-based optimizations in Presto.
Troubleshoot and resolve common performance and cost-related issues in Presto.
This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
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.
This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
This course covers the advanced areas in the use of programming languages related to MongoDB, the goal is for the participant to have the ability to completely master the tool.
The training course will help the participants prepare for Web Application Development using Python Programming with Data Analytics. Such data visualization is a great tool for Top Management in decision making.
This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance.
Percona Server for MongoDB是一個免費的,增強的,完全兼容的開源,可直接替代具有企業級功能的MongoDB 3.2 Community Edition。它不需要更改MongoDB應用程序或代碼。 聽眾 本課程適用於尋求從預先存在的MongoDB實例切換到Percona Server的系統管理員和工程師,或者為MongoDB實例部署和管理新的Percona Server。 完成本課程後,代表們將:
Audience
All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.
Format of the course
25% lectures, 75% labs