數據庫培訓

數據庫培訓

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

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

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

客戶評論

★★★★★
★★★★★

數據庫課程大綱

課程名稱
課程時長
概觀
課程名稱
課程時長
概觀
35小時
概觀
聽眾

- 程序員
- 初學者IT專業人士

課程形式

-

部分講座,部分討論,重點實踐練習
28小時
概觀
In this instructor-led, live training in 台灣, 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.
21小時
概觀
This instructor-led, live training in 台灣 (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 distribute data across multiple nodes.
- Improve database performance through tuning.
- Monitor and troubleshoot a Greenplum database.
14小時
概觀
This instructor-led, live training in 台灣 (online or onsite) is aimed at system administrators, database administrators, data architects, and developers who wish to install, configure, and manage MarkLogic Server to optimize their database systems.

By the end of this training, participants will be able to implement, develop, manage, and secure their enterprise data and database systems using MarkLogic Server.
14小時
概觀
此SQL培訓課程適用于希望獲得使用Microsoft Access提取和分析數據所需技能的人員。課程成員將學習:

- 如何編寫SQL查詢
- 什麽是關系數據庫以及我們如何使用它們
- 什麽是關系以及如何創建它們
- 數據結構
- SQL方言之間的差異(Oracle,T-SQL,ANSI)
- 編寫查詢的實用技巧

此SQL課程處理SQL的Microsoft Access方言。
21小時
概觀
本課程的目的是讓參與者掌握VBA for Access和Excel的基礎知識和用法。
14小時
概觀
Microsoft Access is a pseudo-relational database engine from Microsoft.
14小時
概觀
本課程涵蓋了數據庫管理員成功部署和維護MongoDB數據庫所需了解的所有內容。

還包括診斷性能問題,導入和導出數據以及建立正確的備份和還原例程, MongoDB CRUD API概述,命令shell和驅動程序。

本課程的讀者包括想要:

- 從開發人員的角度理解MongoDB ,包括命令shell,查詢API和驅動程序工具。
- 在所有配置中部署MongoDB - 作為單個服務器,具有主/從復制,作為副本集和作為分片集群。
- 評估應用程序並適當選擇硬件。
- 監控MongoDB實例並與標準監控軟件( Munin , Nagios等)集成
- 規劃備份和管理大數據導入和導出。
- 解決最常見的開發人員問題和故障情況。

每位代表都需要進行一系列實踐練習。
14小時
概觀
本課程涵蓋了數據庫開發人員使用MongoDB成功開發應用程序所需了解的所有內容。
14小時
概觀
本課程涵蓋了使用與MongoDB相關的編程語言的高級領域,目標是讓參與者有能力完全掌握該工具。
7小時
概觀
Percona Server for MongoDB是一個免費的,增強的,完全兼容的開源,可直接替代具有企業級功能的MongoDB 3.2 Community Edition。它不需要更改MongoDB應用程序或代碼。

聽眾

本課程適用於尋求從預先存在的MongoDB實例切換到Percona Server的系統管理員和工程師,或者為MongoDB實例部署和管理新的Percona Server。

完成本課程後,代表們將:

- 了解Percona Server的結構和部署機制
- 能夠執行安裝/生產環境/架構任務和配置
- 能夠評估代碼質量,執行調試,監控
- 能夠實現複製,性能調整和日誌記錄等高級生產
14小時
概觀
培訓結束後,您將能夠在MongoDB數據庫中編寫提取和修改數據。您還將了解強大的Aggregation Pipeline,它是一種靈活,快速的數據分析工具,如果它還不夠,那麼如何將當前的BI工具(如Tableau或Excel到存儲在Mongo中的數據。
14小時
概觀
This instructor-led, live training (online or onsite) is aimed at developers wishing to learn how to use MongoDB as the database for Python their applications.

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

- Install and configure MongoDB
- Understand the difference between accessing a NoSQL document database and a traditional relational databases' (e.g., MySQL)
- Query a MongoDB database from within Python
- Create and write data to a MongoDB databasse
- Understand MongoDB's "data processing pipeline"
- Perform real-time analytics and statistical analysis
- Generate reports for dashboarding
- Implement exception handling in Python application

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.
14小時
概觀
This instructor-led, live training (online or onsite) is aimed at administrators wishing to solve complex deployment and management problems using MongoDB Ops Manager.

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

- Install and configure MongoDB Ops Manager
- Set up and manage different types of environments
- Understand and implement MongoDB Enterprise Server specific solutions to solve complex enterprise challenges

Format of the Course

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

Course Customization Options

- This training is based on MongoDB Enterprise Server, which includes Ops Manager. Please consult with us to arrange license requirements.
- To request a customized training for this course, please contact us to arrange.
14小時
概觀
This instructor-led, live training in 台灣 (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.
14小時
概觀
本課程的目的是清楚地了解( SQL )對Microsoft SQL Server的高級用法以及Transact- SQL的高級用法。如需更深入地了解主題,本課程可作為為期三天的課程。
14小時
概觀
此SQL培訓課程適用于希望獲得從任何數據庫中提取和分析數據並創建報告所需技能的人員。課程成員將學習:

- 如何編寫SQL查詢
- 什麽是關系數據庫以及我們如何使用它們
- 什麽是關系以及如何創建它們
- 數據結構
- T-SQL和其他方言之間的差異
- 編寫查詢的實用技巧

此SQL課程處理Microsoft T-SQL方言。如果您對通用SQL感興趣,請參閱SQL Fundamentals課程。
7小時
概觀
代表們將了解Transact SQL的一些更高級的功能,並能夠執行以下各項操作:

- 使用查詢返回複雜的結果集
- 管理數據庫對像以幫助查詢性能
- 調整查詢以更有效地執行

本課程適用於目前使用Transact SQL從Microsoft SQL Server數據庫中提取數據並希望擴展其知識的人員,特別是在數據分析和提高查詢速度方面。
14小時
概觀
此SQL培訓課程適用於希望獲得處理SQL Server Database的基本技能的人員。課程將幫助會員學習:

- 如何使用SQL Server和SQL Server Management Studio。
- Database s, SQL和RDBMS等的含義
- 如何創建表,使用DDL,DML和DAL。
- 哪些是市場上的各種RDBMS軟件包以及它們如何相互比較。
- No SQL簡介及其組織如何轉變為混合數據庫。
14小時
概觀
作為Microsoft數據平台的核心, SQL Server是一個領先的操作數據庫管理系統。
21小時
概觀
Microsoft SQL Server is a relational database management system (RDBMS) for storing and retrieving data.

In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a Microsoft SQL Server database.

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

- Install and configure Microsoft SQL Server
- Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
- Understand the essentials of database design
- Optimize a database through normalization
- Use aggregate functions to generate results similar to those of "pivot-tables"
- Access Microsoft SQL Server through Excel

Audience

- Data analysts
- Business Intelligence professionals
- Business managers
- Excel experts who wish to expand their analysis skill set

Format of the Course

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

Course Customization Options

- This training is based on the latest version of Microsoft SQL Server
- To request a customized training for this course, please contact us to arrange.
35小時
概觀
Audience

- Database Administrator
- Developers
35小時
概觀
此強化培訓提供了使用Windows PowerShell自動管理基於Windows的計算機的基礎知識和技能。本課程中講授的技能適用於使用Windows PowerShell進行日常管理的所有Microsoft產品。

培訓主要側重於使用Windows PowerShell作為交互式命令行界面,但它還包括腳本和編程主題的一些內容。
35小時
概觀
Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects.

The course will also include the new features in SQL Server B.I. 2016. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore, it is not necessary to know the SQL Server itself.

4 Top Takeaways from the Course

- Make your existing data work harder for you
- Integrate diverse data stores to a single repository
- Transform raw data to business intelligence
- Create eloquent reports from raw data
14小時
概觀
SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.

In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses.

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

- Install and configure SSAS
- Understand the relationship between SSAS, SSIS, and SSRS
- Apply multidimensional data modeling to extract business insights from data
- Design OLAP (Online Analytical Processing) cubes
- Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
- Deploy real-world BI solutions using SSAS

Audience

- BI (Business Intelligence) professionals
- Data Analysts
- Database and data warehousing professionals

Format of the Course

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

Course Customization Options

- This training is based on the latest version of Microsoft SQL Server and SSAS.
- To request a customized training for this course, please contact us to arrange.
14小時
概觀
My SQL管理培訓課程適用於任何想要管理My SQL數據庫服務器的人。這是一個涵蓋所有管理員職責的綜合課程。

該課程解釋了My SQL Database如何工作,可用的工具,我們如何使用它們,我們如何保護My SQL Database服務器並對其進行配置。在培訓課程中,您將學習如何管理用戶帳戶以及My SQL Access權限系統的工作方式。您還將學習如何維護數據庫,備份和恢復數據庫以及執行崩潰恢復。
14小時
概觀
此SQL培訓課程適用于希望獲得從任何數據庫中提取和分析數據並創建報告所需技能的人員。課程成員將學習:

- 如何編寫SQL查詢
- 什麽是關系數據庫以及我們如何使用它們
- 什麽是關系以及如何創建它們
- 數據結構
- SQL方言之間的差異(Oracle,T-SQL,ANSI)
- 編寫查詢的實用技巧

此SQL課程處理通用ANSI SQL。它可以在任何數據庫中使用,包括Oracle,MySQL,Microsoft Access,Microsoft SQL Server,DB2,Informix,PostgreSQL等任何其他關系數據庫。
7小時
概觀
本課程是為熟悉SQL人創建的。本課程向您介紹所有SQL數據庫共有的秘密以及My SQL特定的語法,功能和特性。
14小時
概觀
MariaDB Administration培訓課程適用於想要管理MariaDB數據庫服務器的任何人。這是一個涵蓋所有管理員職責的綜合課程。

該課程解釋了MariaDB Database工作原理,可用的工具,我們如何使用它們,如何保護MariaDB Database服務器並對其進行配置。在培訓課程中,您將學習如何管理用戶帳戶以及MariaDB Access權限系統的工作方式。您還將學習如何維護數據庫,備份和恢復數據庫以及執行崩潰恢復。

近期數據庫培訓課程

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

促銷課程

訂閱促銷課程

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

我們的客戶

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