數據庫培訓

數據庫培訓

由講師進行實時指導的數據庫(DB)或數據庫管理系統(DBMS)本地培訓課程面向系統管理員和開發人員,通過動手實操演示了如何管理數據庫系統以及如何將數據庫與軟件應用程序集成起來。

數據庫培訓形式包括“現場實時培訓”和“遠程實時培訓”。現場實時培訓可在客戶位于台灣的所在場所或NobleProg位于台灣的企業培訓中心進行,遠程實時培訓可通過交互式遠程桌面進行。

NobleProg -- 您的本地培訓提供商

Testimonials

★★★★★
★★★★★

數據庫課程大綱

課程名稱
課程時長
概覽
課程名稱
課程時長
概覽
14小時
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.
  • Test and debug APIs with Postman.
14小時
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.
14小時
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.
14小時
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:
  • Create and manage databases, tables, and queries.
  • Manage query performance.
  • Create and restore database backups.
21小時
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.
21小時
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.
14小時
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.
14小時
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.
14小時
本課程涵蓋了數據庫管理員成功部署和維護MongoDB數據庫所需了解的所有內容。 還包括診斷性能問題,導入和導出數據以及建立正確的備份和還原例程, MongoDB CRUD API概述,命令shell和驅動程序。 本課程的讀者包括想要:
  • 從開發人員的角度理解MongoDB ,包括命令shell,查詢API和驅動程序工具。
  • 在所有配置中部署MongoDB - 作為單個服務器,具有主/從復制,作為副本集和作為分片集群。
  • 評估應用程序並適當選擇硬件。
  • 監控MongoDB實例並與標準監控軟件( Munin , Nagios等)集成
  • 規劃備份和管理大數據導入和導出。
  • 解決最常見的開發人員問題和故障情況。
每位代表都需要進行一系列實踐練習。
14小時
本課程介紹Postgre SQL數據庫的管理和性能調優。 目標受眾包括系統管理員和數據庫架構師。與會者將學習使用專門的Postgre SQL (AKA Postgres)模塊,如復制,連接池和全文搜索。
14小時
This course covers everything a database developer needs to know to successfully develop applications using MongoDB.
21小時
聽眾此培訓適用於開始使用Oracle數據庫中的SQL語言的人員課程回答問題:
  • 如何構建查詢?
  • SQL有哪些可能性?
  • 什麼是關係數據庫?
  • 什麼是結構和SQL命令
28小時
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.
14小時
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.
14小時
這個爲期3天的課程介紹了SQL Developer,SQL * Plus和SQL,用于訪問關系數據庫的結構化查詢語言,並包含最新版ORACLE的新功能。學到的原理也可以應用于Microsoft SQL Server,MySQL,Access,Informix和DB2等多種數據庫。 該課程采用講習班的形式,包括講座,工作實例和實踐練習。雖然內容可以定制,但至少需要2天才能涵蓋核心要素。 提供完整的課程說明以及用于訪問ORACLE數據庫的示例數據庫文件,示例SQL文件和免費軟件工具。
14小時
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.
21小時
這個為期3天的課程介紹了ORACLE PL/ SQL ,這是一個應用程序開發環境,可以使用SQL和PL/ SQL命令編寫存儲過程,函數和触發器。 該課程採用講習班的形式,包括講座,工作實例和實踐練習。雖然內容可以定制,但至少需要2天才能涵蓋核心要素。 提供完整的課程說明以及用於訪問ORACLE數據庫的示例數據庫文件,示例SQL文件和免費軟件工具。
14小時
此培訓專為希望從基礎知識中學習Postgre SQL Database管理員和架構師而設計。 您將學習Postgre SQL體系結構,安裝,設計以及如何在Postgre SQL執行備份和恢復數據庫。
14小時
此SQL培訓課程適用于希望獲得使用Microsoft Access提取和分析數據所需技能的人員。課程成員將學習:
  • 如何編寫SQL查詢
  • 什麽是關系數據庫以及我們如何使用它們
  • 什麽是關系以及如何創建它們
  • 數據結構
  • SQL方言之間的差異(Oracle,T-SQL,ANSI)
  • 編寫查詢的實用技巧
此SQL課程處理SQL的Microsoft Access方言。
14小時
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.
35小時
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.
35小時
PostgreSQL(或Postgres)是最受歡迎的開源關系數據庫之一。 在這個具有指導意義的現場培訓(現場或遠程)中,參與者將學習PostgreSQL的一般和高級方面,包括管理,性能轉換,高級開發和複制,測試,部署和故障排除。 在培訓結束後,參與者將能夠: 使用高級管理技術來配置和管理PostgreSQL服務器優化數據庫和查詢以獲得最佳性能複制並縮放PostgreSQL服務器 聽衆 數據庫管理員系統管理員具有數據庫經驗的開發人員 課程的 格式 部分講座,部分討論,練習和沈重的練習 注意 本課程基于PostreSQL 9,但可以適應不同的版本。 要請求本課程的定制培訓,請聯系我們安排。
14小時
這種由講師主導的現場培訓(現場或遠程)針對希望使用MongoDB Ops Manager解決複雜部署和管理問題的管理員。 在培訓結束時,參與者將能夠:
  • 安裝和配置MongoDB Ops Manager
  • 設置和管理不同類型的環境
  • 了解並實施MongoDB Enterprise Server特定解決方案,以解決複雜的企業挑戰
課程格式
  • 互動講座和討論
  • 大量的練習和練習
  • 在實時實驗室環境中親自實施
課程自定義選項
  • 此培訓基於MongoDB Enterprise Server,其中包括Ops Manager。請諮詢我們以安排許可證要求。
  • 要申請本課程的定制培訓,請聯繫我們安排。
14小時
此SQL培訓課程適用于希望獲得從任何數據庫中提取和分析數據並創建報告所需技能的人員。課程成員將學習:
  • 如何編寫SQL查詢
  • 什麽是關系數據庫以及我們如何使用它們
  • 什麽是關系以及如何創建它們
  • 數據結構
  • T-SQL和其他方言之間的差異
  • 編寫查詢的實用技巧
此SQL課程處理Microsoft T-SQL方言。如果您對通用SQL感興趣,請參閱SQL Fundamentals課程。
14小時
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. 
7小時
Percona Server for MongoDB是一個免費的,增強的,完全兼容的開源,可直接替代具有企業級功能的MongoDB 3.2 Community Edition。它不需要更改MongoDB應用程序或代碼。 聽眾 本課程適用於尋求從預先存在的MongoDB實例切換到Percona Server的系統管理員和工程師,或者為MongoDB實例部署和管理新的Percona Server。 完成本課程後,代表們將:
  • 了解Percona Server的結構和部署機制
  • 能夠執行安裝/生產環境/架構任務和配置
  • 能夠評估代碼質量,執行調試,監控
  • 能夠實現複製,性能調整和日誌記錄等高級生產
14小時
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
14小時
此培訓專為希望學習在Postgre SQL實現高可用性和Database安全性的工具和技術的Database管理員和架構師而設計。 您還將學習如何查找慢查詢,監視數據庫性能以及調整Postgre SQL for Performance。
21小時
The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.
14小時
MERN Stack是Web開發軟件的集合,即MongoDB , Express , React和Node.js MERN堆棧為開發人員提供了一個端到端框架,以構建和部署全堆棧Web應用程序。 這種由講師指導的實時培訓(現場或遠程)針對希望使用MERN Stack進行全棧開發的Web開發人員。 在培訓結束時,參與者將能夠:
  • 將React與MongoDB , Express和Node.js集成。
  • 從頭開始構建一個完整的Web應用程序。
  • 通過授權和身份驗證實現應用程序安全性。
課程形式
  • 互動式講座和討論。
  • 很多練習和練習。
  • 在現場實驗室環境中動手實施。
課程自定義選項
  • 要請求此課程的定制培訓,請與我們聯繫以安排。

Last Updated:

數據庫,培訓,課程,培訓課程, 企業數據庫培訓, 短期數據庫培訓, 數據庫課程, 數據庫周末培訓, 數據庫晚上培訓, 數據庫訓練, 學習數據庫, 數據庫老師, 學數據庫班, 數據庫遠程教育, 一對一數據庫課程, 小組數據庫課程, 數據庫培訓師, 數據庫輔導班, 數據庫教程, 數據庫私教, 數據庫輔導, 數據庫講師

Course Discounts

No course discounts for now.

訂閱促銷課程

為尊重您的隱私,我公司不會把您的郵箱地址提供給任何人。您可以享有優先權和隨時取消訂閱的權利。

Some of our clients

is growing fast!

We are looking to expand our presence in Taiwan!

As a Business Development Manager you will:

  • expand business in Taiwan
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions