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