1、 Introduction to Theme 2.0 of Practical Training for Fengge Big Data Operation and Maintenance Architects
Course background:
In order to meet the needs of students who want to learn and master big data operation and maintenance and system architecture, Fengge specially designed a set of systematic training courses for large database operation and maintenance.
Course objectives:
This set of practical training courses for Fengge big data operation and maintenance architects is divided into five stages, namely, big data Hadoop core architecture operation and maintenance practice, big data storage management and query analysis practice, big data computing framework and message search practice, big data security scheduling and data collection practice, and big data cluster management platform operation and maintenance practice. After completing this set of Fengge Big Data courses, you can be familiar with the Hadoop big data ecological technology framework, including Cloudera CM/CDH/CDP, HDFS, Yarn, HBase, Hive, Phoenix, Zookeeper, Kafka, Solr, Spark, Flink, Storm, Flume, Sqoop, ETL/Kettle, ELK, Azkaban, Oozie, Ranger and other components installation configuration and daily maintenance management, as well as ElasticSearch Construction and maintenance of ClickHouse, GreenPlum, TiDB and other OLAP distributed big data platforms.
2、 ETL PDI/Kettle Training Practical Tutorials - 57 Cases (Data Migration, Extraction Synchronization, Conversion Loading) Video Tutorials
Course objectives:
In order to meet the needs of students who want to learn and master ETL data processing technology, Fengge specially designed a set of systematic PDI (Kettle) database migration synchronization, data extraction, conversion and loading training courses;
This set of PDI (Kettle) courses has a total of 13 hours and 57 practical cases, involving 6 commonly used databases, and the content involves the realization of commonly used databases Oracle MySQL, PostgreSQL, DB2, SQLServer, MongoDB, Excel, TXT and other data processing, migration synchronization, extraction conversion, cleaning and loading are suitable for operation and maintenance personnel/database/developers to use in actual project work to solve data integration and processing between heterogeneous databases.
Welcome to:
51CTO School Oracle/MySQL/ETL database learning dedicated QQ group: 787523185、 602580662
III ETL PDI/Kettle Training Practical Tutorial - 57 Cases (Data Migration, Extraction Synchronization, Conversion Loading) Video Tutorials , Feng Ge's video tutorial learning outline
1. Basic knowledge of ETL and Kettle
1) Basic knowledge of ELT data processing
2) PDI/Kettle product introduction
2. Preparation of Kettle data processing actual combat environment
3. Kettle installation configuration and function explanation
1) Kettle installation configuration based on Windows platform
2) Kettle installation configuration based on Linux platform
3) Configuration and management of Kettle resource library
4) Explanation of Kettle's common functions
4. Kettle Common Database Connection Configuration
1) Configure Oracle database connection
2) Configure MySQL database connection
3) Configure PostgreSQL database connection
4) Configure SQL Server database connection
5) Configure DB2 database connection
6) Configure MongoDB database connection
5. Database migration synchronization/data load conversion (57 cases)
5.1. Oracle Data Migration Synchronization and Data Loading Conversion
1)Oracle11g to Oracle19c
2)Oracle to MySQL
3)Oracle to PostgreSQL
4)Oracle to SQLServer
5)Oracle to MongoDB
6)Oracle to DB2
7)Oracle to SQLFile
8)Oracle to Excel
9)Oracle to TXT
5.2. MySQL Data Migration Synchronization and Data Loading Conversion
1)MySQL5.7 to MySQL8.0
2)MySQL to Oracle
3)MySQL to PostgreSQL
4)MySQL to SQLServer
5)MySQL to DB2
6)MySQL to MongoDB
5.3. PostgreSQL Data Migration Synchronization and Data Loading Conversion
1)PostgreSQL to Oracle
2)PostgreSQL to MySQL
3)PostgreSQL to SQLServer
4)PostgreSQL to DB2
5)PostgreSQL to MongoDB
5.4. SQL Server Data Migration Synchronization and Data Loading Conversion
1)SQLServer to Oracle
2)SQLServer to MySQL
3)SQLServer to PostgreSQL
4)SQLServer to DB2
5)SQLServer to MongoDB
5.5. DB2 data migration synchronization and data load conversion
1)DB2 to Oracle
2)DB2 to MySQL
3)DB2 to PostgreSQL
4)DB2 to SQLServer
5.6. MongoDB data migration synchronization and data loading conversion
1)MongoDB to Oracle
2)MongoDB to MySQL
3)MongoDB to PostgreSQL
4)MongoDB to SQLServer
5.7. Excel Table Data Loading Processing
1)Excel to Oracle
2)Excel to MySQL
3)Excel to PostgreSQL
4)Excel to SQLServer
5)Excel to MongoDB
6)Excel to DB2
5.8. TXT text file data loading processing
1)TXT to Oracle
2)TXT to MySQL
4)TXT to MongoDB
4、 Fengge Oracle/MySQL/NoSQL training class series courses (system, case, actual combat)
one ) Oracle Cloud database engineer training course _ Study Guide _ Career planning _ treatment
Free audition: https://edu.51cto.com/course/7015.html
Registration consultation: https://edu.51cto.com/mic-position/131.html
two ) MySQL Database Engineer Training Course _ Study Guide _ Career planning _ treatment
Free audition: https://edu.51cto.com/course/7015.html
Registration consultation: https://edu.51cto.com/mic-position/303.html
three )Dual database (Oracle+MySQL) Sharing of series of training courses one point five (regularly updated)
http://www.fgedu.net.cn/oracle.html
#########################################################################################
Oracle Training course series
------------------------------------
Oracle Database Tutorial (Part I): Oracle of Linux Getting Started
Features: The content of this stage is Linux Introduction basis, yes Oracle The threshold is to learn the necessary skills.
https://edu.51cto.com/topic/1112.html
Oracle Database Tutorial (Part II): Oracle Installation configuration and cluster implementation
Features: Part of the content of this stage is OCP/OCM The course content, guided by the enterprise's actual combat projects, is more practical.
https://edu.51cto.com/topic/1113.html
Oracle Database Tutorial (Part III): Oracle Deep foundation and core technology
Feature: The depth of the course at this stage has exceeded OCP/OCM Course content, part of which is used for training Oracle primary
Senior after-sales engineer of the factory.
https://edu.51cto.com/topic/1114.html
Oracle Database Tutorial (Part IV): Oracle Backup recovery and data migration
Features: the practicability of this stage has exceeded OCP/OCM Course content, a large number of cases of backup and recovery, RAC
Environment ASM Daily maintenance and migration of.
https://edu.51cto.com/topic/1115.html
Oracle Database Tutorial (Part V): Oracle Object management and SQL Basics
Features: The content of this stage is OCP Course content, but practical OCP Courses.
https://edu.51cto.com/topic/1116.html
Oracle Database Tutorial (Part VI): Oracle Performance optimization and tuning
Features: most of the contents in this stage are OCM Course content, but practical OCM Certification courses involving thousands W series
According to the quantity.
https://edu.51cto.com/topic/1117.html
Oracle Database tutorial (Part 7): Oracle Disaster tolerance implementation and data replication
Features: most of the contents in this stage are OCM Course content, but practical OCM Certification courses involving thousands W series
According to the quantity.
https://edu.51cto.com/topic/1118.html
Oracle Database Tutorial (Part VIII): Application System Comprehensive Project
Features: The content of this stage is Oracle The value-added skills middleware application technology of database is Oracle Database engineer's
Comprehensive skills are also necessary for job competition and * *.
https://edu.51cto.com/topic/1120.html
Oracle Database Tutorial( twelve point two New class): Oracle 12cR2 Project practice series
(Features: The content of this stage is Oracle 12.2 The new technology of database is Oracle Skills of cloud database project. )
https://edu.51cto.com/topic/1293.html
MySQL Training course series
#######################################################################
MySQL Database Tutorial (Part I): MySQL Database Prerequisites Linux Basic series
https://edu.51cto.com/topic/1564.html
MySQL Database Tutorial (Part II): MySQL Basic Introduction to Database and Project Practice
https://edu.51cto.com/topic/1429.html
MySQL Database Tutorial (Part III): MySQL data base SQL Language Development and Application Practice
https://edu.51cto.com/topic/1475.html
MySQL Database Tutorial (Part IV): MySQL Deep database foundation and core analysis
https://edu.51cto.com/topic/1498.html
MySQL Database Tutorial (Part V): MySQL Database backup and recovery practice
https://edu.51cto.com/topic/1524.html
MySQL Database Tutorial (Part VI): MySQ L High availability replication and distributed cluster architecture
https://edu.51cto.com/topic/1622.html
The course of this stage is the current Internet main architecture, involving multiple servers, nearly 100 databases W The project experiment of the level data volume.
MySQL Database tutorial (Part 7): MySQL Performance optimization and fault diagnosis
https://edu.51cto.com/mic-position/303.html
MySQL Database Tutorial (Part VIII ++ ): Please watch Brother Zhufeng MySQL Micro position training class
NoSQL Database( Redis 、 MongoDB 、 Memcached )
#########################################################
Other database courses of Brother Feng
#######################################################################
one ) PostgreSQL Database training course : https://edu.51cto.com/course/22644.html
two ) GreenPlum Database training course : https://edu.51cto.com/course/23050.html
three ) IBM DB2 Database training course : https://edu.51cto.com/course/23448.html
four ) SQLServer Database training course : https://edu.51cto.com/course/23927.html
five ) GaussDB Database training course : https://edu.51cto.com/course/22140.html
6) Elastic search+ELK distributed database training course:
https://edu.51cto.com/course/25184.html
https://edu.51cto.com/course/25183.html
7) TIDB database training course:
https://edu.51cto.com/course/25659.html