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
![Front-end Vue3 actual combat [handwritten vue project]](https://img.php.cn/upload/course/000/000/068/639b12e98e0b5441.png)
![APIPOST tutorial [Popularization of technical concepts related to network communication]](https://img.php.cn/upload/course/000/000/068/63996f34c6c94370.png)
