Big data (MySQL) video tutorial full version

The overall concept of big data

Database and relational database-1

Database and relational database-2

MySQL database

MySQL download and installation configuration-1

MySQL download and installation configuration-2

MySQL download and installation configuration-3

MySQL download and installation configuration-4

Tools to connect to MySQL-1

Tools to connect to MySQL-2

Overall structure and library management-1

Overall structure and library management-2

table concept

Field data type - 1

Data type of field - 2

Table management: view all tables and create tables

Table management: modifying, deleting tables and viewing table structures

Table management using tools to manage tables

Insert data-1

Insert data-2

Insert data field default value and primary key auto-increment

Data management: modify table data

Data management: deleting table data

Simple query to query data-1

Simple query to query data-2

Comparison condition query for query data

Logical condition query for querying data

Query the null condition of query data

Query data using fuzzy conditions

Aggregation query for querying data

Query data sorting query

Data query paging query-1

Data query paging query-2

Data query paging query-3

Data query group query-1

Data query group query-2

Data query group query-3

Data query if judgment in SQL-1

Data query if judgment in SQL-2

Data query if judgment in SQL-3

Data constraints default value, non-empty, unique

Data constraints primary key

Data constraints automatic growth

Data constraint foreign key -1

Data constraint foreign key-2

Data constraint foreign key-3

Cascade operations of data constraints

Three major paradigms of database design

Advanced query child query-1

Advanced query child query-2

Advanced query child query-3

Advanced query in and not in

Advanced query exists and not exists

Multi-table association query inner join-1

Multi-table association query inner join-2

Multi-table related query left join

The difference between the on and where conditions of left join in multi-table related queries

Right join of multi-table related query

Practice of multi-table related queries

Use join in update of multi-table related query

Use join in delete of multi-table related query

Multi-table related queries using using, union, union all

A preliminary study on stored procedures

Stored procedures use in, out, and inout type parameters

Using variables in stored procedures

Stored procedure flow control-1

Stored procedure flow control-2

trigger

function

User Management

authority management

DDL, DML, DQL and DCL

The overall concept of indexing

Index Btree

Index classification of indexes

Index creation timing

The concepts and parameters of explan

Explan's index failure analysis-1

Explan's Index Failure Analysis-2

SQL optimization strategy

Getting Started with Linux (Understanding)

VMWare virtual machine installation

CentOS 7.5 installation-1

CentOS 7.5 installation-2

VMWare virtual machine hangs

CentOS 7.5 network configuration-1

CentOS 7.5 network configuration-2

CentOS 7.5 network configuration-3

CentOS 7.5 network configuration-4

File and directory structure

System startup process

Use the tool ssh to log in remotely

VI, VIM editor-1

VI, VIM editor-2

Help for common commands and commands related to directory files-1

Help for common commands and commands related to directory files-2

Help for common commands and commands related to directory files-3

Commonly used commands date-related commands

Commonly used commands for user and username group management commands

Commonly used commands related to file permissions

Search for commonly used commands to find related commands

Commonly used commands: compression and decompression related commands

Commonly used commands: Disk partition and process thread related commands

Commonly used commands related to scheduled tasks

Virtual machine cloning

Practice questions and interview questions

Overview and parser

Getting started

Variable 01

Variable 02

operator

Conditional judgment

process control

read reads console input and functions

Custom function

tool cut

Tools sed

Basic usage of awk tool

Tools awk operator

Tools awk built-in variables

The case goes from imitation to variation (you will have your own insights)

Tool awk script

Tools awk built-in functions

Application of tool awk in big data query

Tool sort

Real company interview questions

Introduction to big data (understanding)

Big data technology ecosystem

Hadoop overview

Use securcrt to upload files to Linux

Virtual machine configuration, JDK and Hadoop installation-1

Virtual machine configuration, JDK and Hadoop installation-2

local run mode

Fully distributed mode (Hadoop cluster) configuration-1

Fully distributed mode (Hadoop cluster) configuration-2

Fully distributed mode (Hadoop cluster) configuration-3

Set up ssh password-free login between cluster nodes

Cluster starting and stopping

Cluster configuration history server

Aggregation of cluster configuration logs

Running the wordcount case under the cluster

Compile source code 01

Compile source code 02

Compile source code 03

Frequently Asked Questions and Solutions

Generating background and design ideas

Overview of advantages, disadvantages and composition architecture

shell operation 01

shell operation 02

shell operation 03

Establishment of development environment under windows for client operation

Maven project creation and configuration for client operations

API example of client operation 01

API example of client operation 02

API example of client operation 03

API example of client operation 04

Writing process (interview focus)

Writing process (interview focus) 02

Network topology of the writing process-node distance calculation (interview focus)

Copy storage strategy of writing process - rack awareness

Reading process (interview focus)

NN and 2NN working mechanism (interview focus)

Format hadoop cluster

Fsimage and Edits analysis (interview focus)

CheckPoint time setting and NameNod

Cluster security model (interview focus)

DataNode failure mechanism and offline parameter settings (interview focus)

Data integrity of DataNode (interview focus)

Cluster dynamically serves new DataNode data nodes (interview focus)

Cluster dynamically serves new DataNode data nodes (interview focus) 02

Cluster dynamically serves new DataNode data nodes (interview focus) 03

Decommissioning data nodes and DataNode multi-directory configuration

Definition, Advantages and Disadvantages

Core ideas and official WordCount source code

MapReduce: Handwritten WordCount 01

Handwritten WordCount 02

Handwritten WordCount 03

Handwritten WordCount 04

Serialization concepts and specific methods of serialization and deserialization of custom beans

Serialization practical case 01

Serialization practical case 02

Serialization practical case 03

Slice split and Map Task parallelism determination mechanism

Detailed explanation of job submission process source code

Slicing process and FilenputFormat slicing mechanism

Combine TextInputFormat slicing mechanism

Combine TextInputFormat case practice

MapReduce workflow 01

MapReduce workflow 02

Shuffle overview

Partition partition and custom partition

Partition custom partition instance operation 01

Partition custom partition instance operation 02

WritableComparable sorting

WritableComparable custom sorting instance

Combiner merge

The working mechanism of Map Task and Reduce Task

OutputFormat data output

Reduce Join