Article
Topic
Learning
Download
Q&A
Programming Dictionary
Game
Recent Updates
LOGIN
简体中文(ZH-CN)
English(EN)
繁体中文(ZH-TW)
日本語(JA)
한국어(KO)
Melayu(MS)
Français(FR)
Deutsch(DE)
Next Section: Establishment of development environment under windows for client operation
(480 plays)
Next Section
Watch Again
ဆ
Chapter
Note
Ask
Courseware
Feedback
Big data (MySQL) video tutorial full version
Chapter1 Databases and relational databases
1-1 The overall concept of big data
1-2 Database and relational database-1
1-3 Database and relational database-2
Chapter2 MySQL installation configuration
2-1 MySQL database
2-2 MySQL download and installation configuration-1
2-3 MySQL download and installation configuration-2
2-4 MySQL download and installation configuration-3
2-5 MySQL download and installation configuration-4
Chapter3 Connect to the database
3-1 Tools to connect to MySQL-1
3-2 Tools to connect to MySQL-2
Chapter4 MySQL fields, tables, libraries
4-1 Overall structure and library management-1
4-2 Overall structure and library management-2
4-3 table concept
4-4 Field data type - 1
4-5 Data type of field - 2
4-6 Table management: view all tables and create tables
4-7 Table management: modifying, deleting tables and viewing table structures
4-8 Table management using tools to manage tables
Chapter5 Data management
5-1 Insert data-1
5-2 Insert data-2
5-3 Insert data field default value and primary key auto-increment
5-4 Data management: modify table data
5-5 Data management: deleting table data
5-6 Simple query to query data-1
5-7 Simple query to query data-2
5-8 Comparison condition query for query data
5-9 Logical condition query for querying data
5-10 Query the null condition of query data
5-11 Query data using fuzzy conditions
5-12 Aggregation query for querying data
5-13 Query data sorting query
5-14 Data query paging query-1
5-15 Data query paging query-2
5-16 Data query paging query-3
5-17 Data query group query-1
5-18 Data query group query-2
5-19 Data query group query-3
5-20 Data query if judgment in SQL-1
5-21 Data query if judgment in SQL-2
5-22 Data query if judgment in SQL-3
Chapter6 data constraints
6-1 Data constraints default value, non-empty, unique
6-2 Data constraints primary key
6-3 Data constraints automatic growth
6-4 Data constraint foreign key -1
6-5 Data constraint foreign key-2
6-6 Data constraint foreign key-3
6-7 Cascade operations of data constraints
Chapter7 Advanced queries and multi-table related queries
7-1 Three major paradigms of database design
7-2 Advanced query child query-1
7-3 Advanced query child query-2
7-4 Advanced query child query-3
7-5 Advanced query in and not in
7-6 Advanced query exists and not exists
7-7 Multi-table association query inner join-1
7-8 Multi-table association query inner join-2
7-9 Multi-table related query left join
7-10 The difference between the on and where conditions of left join in multi-table related queries
7-11 Right join of multi-table related query
7-12 Practice of multi-table related queries
7-13 Use join in update of multi-table related query
7-14 Use join in delete of multi-table related query
7-15 Multi-table related queries using using, union, union all
Chapter8 stored procedure
8-1 A preliminary study on stored procedures
8-2 Stored procedures use in, out, and inout type parameters
8-3 Using variables in stored procedures
8-4 Stored procedure flow control-1
8-5 Stored procedure flow control-2
Chapter9 Triggers, functions, user management and permission management
9-1 trigger
9-2 function
9-3 User Management
9-4 authority management
9-5 DDL, DML, DQL and DCL
Chapter10 MySQL index
10-1 The overall concept of indexing
10-2 Index Btree
10-3 Index classification of indexes
10-4 Index creation timing
Chapter11 MySQL:explan
11-1 The concepts and parameters of explan
11-2 Explan's index failure analysis-1
11-3 Explan's Index Failure Analysis-2
11-4 SQL optimization strategy
Chapter12 Getting Started with Linux
12-1 Getting Started with Linux (Understanding)
12-2 VMWare virtual machine installation
12-3 CentOS 7.5 installation-1
12-4 CentOS 7.5 installation-2
12-5 VMWare virtual machine hangs
12-6 CentOS 7.5 network configuration-1
12-7 CentOS 7.5 network configuration-2
12-8 CentOS 7.5 network configuration-3
12-9 CentOS 7.5 network configuration-4
12-10 File and directory structure
12-11 System startup process
12-12 Use the tool ssh to log in remotely
12-13 VI, VIM editor-1
12-14 VI, VIM editor-2
12-15 Help for common commands and commands related to directory files-1
12-16 Help for common commands and commands related to directory files-2
12-17 Help for common commands and commands related to directory files-3
12-18 Commonly used commands date-related commands
12-19 Commonly used commands for user and username group management commands
12-20 Commonly used commands related to file permissions
12-21 Search for commonly used commands to find related commands
12-22 Commonly used commands: compression and decompression related commands
12-23 Commonly used commands: Disk partition and process thread related commands
12-24 Commonly used commands related to scheduled tasks
12-25 Virtual machine cloning
12-26 Practice questions and interview questions
Chapter13 Getting Started with Shell
13-1 Overview and parser
13-2 Getting started
13-3 Variable 01
13-4 Variable 02
13-5 operator
13-6 Conditional judgment
13-7 process control
13-8 read reads console input and functions
13-9 Custom function
13-10 tool cut
13-11 Tools sed
13-12 Basic usage of awk tool
13-13 Tools awk operator
13-14 Tools awk built-in variables
13-15 The case goes from imitation to variation (you will have your own insights)
13-16 Tool awk script
13-17 Tools awk built-in functions
13-18 Application of tool awk in big data query
13-19 Tool sort
13-20 Real company interview questions
Chapter14 Hadoop
14-1 Introduction to big data (understanding)
14-2 Big data technology ecosystem
14-3 Hadoop overview
14-4 Use securcrt to upload files to Linux
14-5 Virtual machine configuration, JDK and Hadoop installation-1
14-6 Virtual machine configuration, JDK and Hadoop installation-2
14-7 local run mode
14-8 Fully distributed mode (Hadoop cluster) configuration-1
14-9 Fully distributed mode (Hadoop cluster) configuration-2
14-10 Fully distributed mode (Hadoop cluster) configuration-3
14-11 Set up ssh password-free login between cluster nodes
14-12 Cluster starting and stopping
14-13 Cluster configuration history server
14-14 Aggregation of cluster configuration logs
14-15 Running the wordcount case under the cluster
14-16 Compile source code 01
14-17 Compile source code 02
14-18 Compile source code 03
14-19 Frequently Asked Questions and Solutions
Chapter15 HDFS
15-1 Generating background and design ideas
15-2 Overview of advantages, disadvantages and composition architecture
15-3 shell operation 01
15-4 shell operation 02
15-5 shell operation 03
15-6 Establishment of development environment under windows for client operation
15-7 Maven project creation and configuration for client operations
15-8 API example of client operation 01
15-9 API example of client operation 02
15-10 API example of client operation 03
15-11 API example of client operation 04
15-12 Writing process (interview focus)
15-13 Writing process (interview focus) 02
15-14 Network topology of the writing process-node distance calculation (interview focus)
15-15 Copy storage strategy of writing process - rack awareness
15-16 Reading process (interview focus)
15-17 NN and 2NN working mechanism (interview focus)
15-18 Format hadoop cluster
15-19 Fsimage and Edits analysis (interview focus)
15-20 CheckPoint time setting and NameNod
15-21 Cluster security model (interview focus)
15-22 DataNode failure mechanism and offline parameter settings (interview focus)
15-23 Data integrity of DataNode (interview focus)
15-24 Cluster dynamically serves new DataNode data nodes (interview focus)
15-25 Cluster dynamically serves new DataNode data nodes (interview focus) 02
15-26 Cluster dynamically serves new DataNode data nodes (interview focus) 03
15-27 Decommissioning data nodes and DataNode multi-directory configuration
Chapter16 MapReduce
16-1 Definition, Advantages and Disadvantages
16-2 Core ideas and official WordCount source code
16-3 MapReduce: Handwritten WordCount 01
16-4 Handwritten WordCount 02
16-5 Handwritten WordCount 03
16-6 Handwritten WordCount 04
16-7 Serialization concepts and specific methods of serialization and deserialization of custom beans
16-8 Serialization practical case 01
16-9 Serialization practical case 02
16-10 Serialization practical case 03
16-11 Slice split and Map Task parallelism determination mechanism
16-12 Detailed explanation of job submission process source code
16-13 Slicing process and FilenputFormat slicing mechanism
16-14 Combine TextInputFormat slicing mechanism
16-15 Combine TextInputFormat case practice
16-16 MapReduce workflow 01
16-17 MapReduce workflow 02
16-18 Shuffle overview
16-19 Partition partition and custom partition
16-20 Partition custom partition instance operation 01
16-21 Partition custom partition instance operation 02
16-22 WritableComparable sorting
16-23 WritableComparable custom sorting instance
16-24 Combiner merge
16-25 The working mechanism of Map Task and Reduce Task
16-26 OutputFormat data output
16-27 Reduce Join
Previous section
Next Section
Tutorial List
get help
Course Recommendations
Courseware download
Intermediate
Front-end Vue3 actual combat [handwritten vue project]
2857 people are watching
Elementary
APIPOST tutorial [Popularization of technical concepts related to network communication]
1795 people are watching
Intermediate
Issue 22_Comprehensive actual combat
5521 people are watching
Elementary
Issue 22_PHP Programming
5172 people are watching
Elementary
Issue 22_Front-end development
8713 people are watching
Intermediate
Big data (MySQL) video tutorial full version
4525 people are watching
Elementary
Go language tutorial-full of practical information and no nonsense
2794 people are watching
Elementary
GO Language Core Programming Course
2814 people are watching
Intermediate
JS advanced and BootStrap learning
2563 people are watching
Intermediate
SQL optimization and troubleshooting (MySQL version)
3374 people are watching
Intermediate
Redis+MySQL database interview tutorial
2963 people are watching
Elementary
Deliver food or learn programming?
5708 people are watching
Students who have watched this course are also learning
491213 plays
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)
notes
X
About us
Disclaimer
Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!