Big data (MySQL) video tutorial full version-Free online video tutorial-php.cn

Community

Learn

Tools Library

AI Tools

Leisure

English

Big data (MySQL) video tutorial full version

This course is a very comprehensive set of courses. The video knowledge covers the basics, advanced, operation and maintenance of MySQL and many other aspects. The course content is comprehensive and in-depth, which can fully meet our daily development, operation and maintenance, interviews, and self-improvement. It also uses a variety of methods during the explanation process to help students understand the key and difficult content in the course more clearly.

Intermediate

mysql

Big Data

156707 person learning

200class hour

02 days 10 hours 36 minutes 46 secondsTotal course duration

2022-12-13update

王林

Gold lecturer

A total of 180 courses Student180311 Lecturer rating5.9

有朋自远方来，虽远必诛！More>>

Course Introduction Course Outline Other Courses

You will learn：

This course is a very comprehensive set of courses. The video knowledge covers the basics, advanced, operation and maintenance of MySQL and many other aspects. The course content is comprehensive and in-depth, which can fully meet our daily development, operation and maintenance, interviews, and self-improvement. It also uses a variety of methods during the explanation process to help students understand the key and difficult content in the course more clearly.

Big data (MySQL) video tutorial full version

Chapter1 Databases and relational databases
expand retract

Section1 The overall concept of big data
duration： 13 minutes 08 seconds

Section2 Database and relational database-1
duration： 08 minutes 45 seconds

Section3 Database and relational database-2
duration： 10 minutes 31 seconds
Chapter2 MySQL installation configuration
expand retract

Section1 MySQL database
duration： 12 minutes 11 seconds

Section2 MySQL download and installation configuration-1
duration： 11 minutes 11 seconds

Section3 MySQL download and installation configuration-2
duration： 07 minutes 22 seconds

Section4 MySQL download and installation configuration-3
duration： 10 minutes 18 seconds

Section5 MySQL download and installation configuration-4
duration： 13 minutes 28 seconds
Chapter3 Connect to the database
expand retract

Section1 Tools to connect to MySQL-1
duration： 09 minutes 56 seconds

Section2 Tools to connect to MySQL-2
duration： 09 minutes 49 seconds
Chapter4 MySQL fields, tables, libraries
expand retract

Section1 Overall structure and library management-1
duration： 15 minutes 32 seconds

Section2 Overall structure and library management-2
duration： 14 minutes 06 seconds

Section3 table concept
duration： 12 minutes 37 seconds

Section4 Field data type - 1
duration： 16 minutes 53 seconds

Section5 Data type of field - 2
duration： 07 minutes 19 seconds

Section6 Table management: view all tables and create tables
duration： 11 minutes 15 seconds

Section7 Table management: modifying, deleting tables and viewing table structures
duration： 17 minutes 43 seconds

Section8 Table management using tools to manage tables
duration： 08 minutes 46 seconds
Chapter5 Data management
expand retract

Section1 Insert data-1
duration： 11 minutes 33 seconds

Section2 Insert data-2
duration： 11 minutes 12 seconds

Section3 Insert data field default value and primary key auto-increment
duration： 09 minutes 23 seconds

Section4 Data management: modify table data
duration： 08 minutes 54 seconds

Section5 Data management: deleting table data
duration： 16 minutes 45 seconds

Section6 Simple query to query data-1
duration： 13 minutes 39 seconds

Section7 Simple query to query data-2
duration： 08 minutes 42 seconds

Section8 Comparison condition query for query data
duration： 06 minutes 31 seconds

Section9 Logical condition query for querying data
duration： 12 minutes 36 seconds

Section10 Query the null condition of query data
duration： 10 minutes 41 seconds

Section11 Query data using fuzzy conditions
duration： 11 minutes 10 seconds

Section12 Aggregation query for querying data
duration： 12 minutes 44 seconds

Section13 Query data sorting query
duration： 12 minutes 05 seconds

Section14 Data query paging query-1
duration： 11 minutes 31 seconds

Section15 Data query paging query-2
duration： 10 minutes 30 seconds

Section16 Data query paging query-3
duration： 12 minutes 44 seconds

Section17 Data query group query-1
duration： 09 minutes 04 seconds

Section18 Data query group query-2
duration： 18 minutes 22 seconds

Section19 Data query group query-3
duration： 07 minutes 47 seconds

Section20 Data query if judgment in SQL-1
duration： 09 minutes 24 seconds

Section21 Data query if judgment in SQL-2
duration： 13 minutes 19 seconds

Section22 Data query if judgment in SQL-3
duration： 10 minutes 39 seconds
Chapter6 data constraints
expand retract

Section1 Data constraints default value, non-empty, unique
duration： 15 minutes 42 seconds

Section2 Data constraints primary key
duration： 07 minutes 27 seconds

Section3 Data constraints automatic growth
duration： 14 minutes 37 seconds

Section4 Data constraint foreign key -1
duration： 16 minutes 39 seconds

Section5 Data constraint foreign key-2
duration： 09 minutes 57 seconds

Section6 Data constraint foreign key-3
duration： 12 minutes 11 seconds

Section7 Cascade operations of data constraints
duration： 12 minutes 22 seconds
Chapter7 Advanced queries and multi-table related queries
expand retract

Section1 Three major paradigms of database design
duration： 06 minutes 49 seconds

Section2 Advanced query child query-1
duration： 14 minutes 10 seconds

Section3 Advanced query child query-2
duration： 08 minutes 55 seconds

Section4 Advanced query child query-3
duration： 21 minutes 14 seconds

Section5 Advanced query in and not in
duration： 08 minutes 29 seconds

Section6 Advanced query exists and not exists
duration： 15 minutes 39 seconds

Section7 Multi-table association query inner join-1
duration： 14 minutes 56 seconds

Section8 Multi-table association query inner join-2
duration： 13 minutes 42 seconds

Section9 Multi-table related query left join
duration： 08 minutes 47 seconds

Section10 The difference between the on and where conditions of left join in multi-table related queries
duration： 20 minutes 34 seconds

Section11 Right join of multi-table related query
duration： 16 minutes 04 seconds

Section12 Practice of multi-table related queries
duration： 15 minutes 14 seconds

Section13 Use join in update of multi-table related query
duration： 22 minutes 17 seconds

Section14 Use join in delete of multi-table related query
duration： 17 minutes 03 seconds

Section15 Multi-table related queries using using, union, union all
duration： 22 minutes 04 seconds
Chapter8 stored procedure
expand retract

Section1 A preliminary study on stored procedures
duration： 14 minutes 26 seconds

Section2 Stored procedures use in, out, and inout type parameters
duration： 16 minutes 53 seconds

Section3 Using variables in stored procedures
duration： 14 minutes 49 seconds

Section4 Stored procedure flow control-1
duration： 20 minutes 00 seconds

Section5 Stored procedure flow control-2
duration： 11 minutes 28 seconds
Chapter9 Triggers, functions, user management and permission management
expand retract

Section1 trigger
duration： 11 minutes 54 seconds

Section2 function
duration： 26 minutes 23 seconds

Section3 User Management
duration： 16 minutes 42 seconds

Section4 authority management
duration： 17 minutes 20 seconds

Section5 DDL, DML, DQL and DCL
duration： 03 minutes 20 seconds
Chapter10 MySQL index
expand retract

Section1 The overall concept of indexing
duration： 15 minutes 41 seconds

Section2 Index Btree
duration： 29 minutes 05 seconds

Section3 Index classification of indexes
duration： 26 minutes 11 seconds

Section4 Index creation timing
duration： 07 minutes 22 seconds
Chapter11 MySQL：explan
expand retract

Section1 The concepts and parameters of explan
duration： 22 minutes 14 seconds

Section2 Explan's index failure analysis-1
duration： 36 minutes 35 seconds

Section3 Explan's Index Failure Analysis-2
duration： 27 minutes 46 seconds

Section4 SQL optimization strategy
duration： 05 minutes 17 seconds
Chapter12 Getting Started with Linux
expand retract

Section1 Getting Started with Linux (Understanding)
duration： 31 minutes 17 seconds

Section2 VMWare virtual machine installation
duration： 12 minutes 20 seconds

Section3 CentOS 7.5 installation-1
duration： 16 minutes 13 seconds

Section4 CentOS 7.5 installation-2
duration： 08 minutes 12 seconds

Section5 VMWare virtual machine hangs
duration： 07 minutes 22 seconds

Section6 CentOS 7.5 network configuration-1
duration： 32 minutes 07 seconds

Section7 CentOS 7.5 network configuration-2
duration： 08 minutes 38 seconds

Section8 CentOS 7.5 network configuration-3
duration： 11 minutes 10 seconds

Section9 CentOS 7.5 network configuration-4
duration： 19 minutes 55 seconds

Section10 File and directory structure
duration： 25 minutes 39 seconds

Section11 System startup process
duration： 15 minutes 02 seconds

Section12 Use the tool ssh to log in remotely
duration： 18 minutes 10 seconds

Section13 VI, VIM editor-1
duration： 21 minutes 51 seconds

Section14 VI, VIM editor-2
duration： 17 minutes 32 seconds

Section15 Help for common commands and commands related to directory files-1
duration： 26 minutes 35 seconds

Section16 Help for common commands and commands related to directory files-2
duration： 22 minutes 37 seconds

Section17 Help for common commands and commands related to directory files-3
duration： 32 minutes 28 seconds

Section18 Commonly used commands date-related commands
duration： 07 minutes 37 seconds

Section19 Commonly used commands for user and username group management commands
duration： 14 minutes 35 seconds

Section20 Commonly used commands related to file permissions
duration： 22 minutes 42 seconds

Section21 Search for commonly used commands to find related commands
duration： 18 minutes 16 seconds

Section22 Commonly used commands: compression and decompression related commands
duration： 17 minutes 28 seconds

Section23 Commonly used commands: Disk partition and process thread related commands
duration： 19 minutes 35 seconds

Section24 Commonly used commands related to scheduled tasks
duration： 23 minutes 44 seconds

Section25 Virtual machine cloning
duration： 20 minutes 04 seconds

Section26 Practice questions and interview questions
duration： 06 minutes 07 seconds
Chapter13 Getting Started with Shell
expand retract

Section1 Overview and parser
duration： 09 minutes 30 seconds

Section2 Getting started
duration： 15 minutes 36 seconds

Section3 Variable 01
duration： 22 minutes 26 seconds

Section4 Variable 02
duration： 08 minutes 00 seconds

Section5 operator
duration： 07 minutes 44 seconds

Section6 Conditional judgment
duration： 08 minutes 04 seconds

Section7 process control
duration： 30 minutes 04 seconds

Section8 read reads console input and functions
duration： 07 minutes 14 seconds

Section9 Custom function
duration： 15 minutes 06 seconds

Section10 tool cut
duration： 26 minutes 47 seconds

Section11 Tools sed
duration： 08 minutes 26 seconds

Section12 Basic usage of awk tool
duration： 25 minutes 46 seconds

Section13 Tools awk operator
duration： 29 minutes 52 seconds

Section14 Tools awk built-in variables
duration： 37 minutes 51 seconds

Section15 The case goes from imitation to variation (you will have your own insights)
duration： 03 minutes 39 seconds

Section16 Tool awk script
duration： 15 minutes 51 seconds

Section17 Tools awk built-in functions
duration： 32 minutes 46 seconds

Section18 Application of tool awk in big data query
duration： 21 minutes 09 seconds

Section19 Tool sort
duration： 11 minutes 34 seconds

Section20 Real company interview questions
duration： 04 minutes 33 seconds
Chapter14 Hadoop
expand retract

Section1 Introduction to big data (understanding)
duration： 36 minutes 55 seconds

Section2 Big data technology ecosystem
duration： 11 minutes 40 seconds

Section3 Hadoop overview
duration： 38 minutes 02 seconds

Section4 Use securcrt to upload files to Linux
duration： 06 minutes 25 seconds

Section5 Virtual machine configuration, JDK and Hadoop installation-1
duration： 22 minutes 57 seconds

Section6 Virtual machine configuration, JDK and Hadoop installation-2
duration： 22 minutes 52 seconds

Section7 local run mode
duration： 13 minutes 34 seconds

Section8 Fully distributed mode (Hadoop cluster) configuration-1
duration： 21 minutes 21 seconds

Section9 Fully distributed mode (Hadoop cluster) configuration-2
duration： 18 minutes 43 seconds

Section10 Fully distributed mode (Hadoop cluster) configuration-3
duration： 29 minutes 24 seconds

Section11 Set up ssh password-free login between cluster nodes
duration： 24 minutes 00 seconds

Section12 Cluster starting and stopping
duration： 13 minutes 44 seconds

Section13 Cluster configuration history server
duration： 12 minutes 12 seconds

Section14 Aggregation of cluster configuration logs
duration： 17 minutes 18 seconds

Section15 Running the wordcount case under the cluster
duration： 20 minutes 06 seconds

Section16 Compile source code 01
duration： 08 minutes 09 seconds

Section17 Compile source code 02
duration： 20 minutes 57 seconds

Section18 Compile source code 03
duration： 14 minutes 44 seconds

Section19 Frequently Asked Questions and Solutions
duration： 08 minutes 11 seconds
Chapter15 HDFS
expand retract

Section1 Generating background and design ideas
duration： 24 minutes 45 seconds

Section2 Overview of advantages, disadvantages and composition architecture
duration： 28 minutes 04 seconds

Section3 shell operation 01
duration： 19 minutes 57 seconds

Section4 shell operation 02
duration： 20 minutes 29 seconds

Section5 shell operation 03
duration： 27 minutes 52 seconds

Section6 Establishment of development environment under windows for client operation
duration： 20 minutes 52 seconds

Section7 Maven project creation and configuration for client operations
duration：In calculation

Section8 API example of client operation 01
duration： 14 minutes 51 seconds

Section9 API example of client operation 02
duration： 22 minutes 46 seconds

Section10 API example of client operation 03
duration： 24 minutes 08 seconds

Section11 API example of client operation 04
duration： 08 minutes 21 seconds

Section12 Writing process (interview focus)
duration： 23 minutes 38 seconds

Section13 Writing process (interview focus) 02
duration： 20 minutes 51 seconds

Section14 Network topology of the writing process-node distance calculation (interview focus)
duration： 22 minutes 37 seconds

Section15 Copy storage strategy of writing process - rack awareness
duration： 12 minutes 45 seconds

Section16 Reading process (interview focus)
duration： 11 minutes 11 seconds

Section17 NN and 2NN working mechanism (interview focus)
duration： 27 minutes 06 seconds

Section18 Format hadoop cluster
duration： 38 minutes 47 seconds

Section19 Fsimage and Edits analysis (interview focus)
duration： 20 minutes 57 seconds

Section20 CheckPoint time setting and NameNod
duration： 10 minutes 23 seconds

Section21 Cluster security model (interview focus)
duration： 19 minutes 54 seconds

Section22 DataNode failure mechanism and offline parameter settings (interview focus)
duration： 15 minutes 44 seconds

Section23 Data integrity of DataNode (interview focus)
duration： 06 minutes 00 seconds

Section24 Cluster dynamically serves new DataNode data nodes (interview focus)
duration： 17 minutes 01 seconds

Section25 Cluster dynamically serves new DataNode data nodes (interview focus) 02
duration： 26 minutes 18 seconds

Section26 Cluster dynamically serves new DataNode data nodes (interview focus) 03
duration： 20 minutes 17 seconds

Section27 Decommissioning data nodes and DataNode multi-directory configuration
duration： 30 minutes 44 seconds
Chapter16 MapReduce
expand retract

Section1 Definition, Advantages and Disadvantages
duration： 15 minutes 10 seconds

Section2 Core ideas and official WordCount source code
duration： 20 minutes 56 seconds

Section3 MapReduce: Handwritten WordCount 01
duration： 45 minutes 05 seconds

Section4 Handwritten WordCount 02
duration： 32 minutes 02 seconds

Section5 Handwritten WordCount 03
duration： 23 minutes 36 seconds

Section6 Handwritten WordCount 04
duration： 36 minutes 02 seconds

Section7 Serialization concepts and specific methods of serialization and deserialization of custom beans
duration： 22 minutes 18 seconds

Section8 Serialization practical case 01
duration： 20 minutes 27 seconds

Section9 Serialization practical case 02
duration： 36 minutes 54 seconds

Section10 Serialization practical case 03
duration： 14 minutes 36 seconds

Section11 Slice split and Map Task parallelism determination mechanism
duration： 28 minutes 10 seconds

Section12 Detailed explanation of job submission process source code
duration： 20 minutes 11 seconds

Section13 Slicing process and FilenputFormat slicing mechanism
duration： 14 minutes 22 seconds

Section14 Combine TextInputFormat slicing mechanism
duration： 17 minutes 09 seconds

Section15 Combine TextInputFormat case practice
duration： 28 minutes 50 seconds

Section16 MapReduce workflow 01
duration： 17 minutes 50 seconds

Section17 MapReduce workflow 02
duration： 12 minutes 11 seconds

Section18 Shuffle overview
duration： 29 minutes 17 seconds

Section19 Partition partition and custom partition
duration： 13 minutes 31 seconds

Section20 Partition custom partition instance operation 01
duration： 32 minutes 28 seconds

Section21 Partition custom partition instance operation 02
duration： 11 minutes 42 seconds

Section22 WritableComparable sorting
duration： 11 minutes 06 seconds

Section23 WritableComparable custom sorting instance
duration： 01 hours 00 minutes 07 seconds

Section24 Combiner merge
duration： 21 minutes 20 seconds

Section25 The working mechanism of Map Task and Reduce Task
duration： 16 minutes 18 seconds

Section26 OutputFormat data output
duration： 40 minutes 43 seconds

Section27 Reduce Join
duration： 59 minutes 16 seconds

王林 Lecturer Other Courses

ElementaryComplete collection of interview questions in front-end disciplines (Season 1)

25020
Collection
ElementaryFlexible box + responsive page layout practice

9483
Collection
ElementaryMake a responsive website from scratch—Grid layout

18871
Collection
ElementaryThe most easy-to-understand HTML+CSS course in 9 days

47858
Collection
ElementaryBasic tutorial for getting started with Web front-end

260006
Collection
ElementaryWeb front-end development-Zero Basic Programming Admission Guide

71846
Collection
ElementaryFront-end basic HTML5+CSS3 from entry to proficiency (full version)

312801
Collection
ElementaryThe latest CSS3 tutorial is quick and easy to understand

24059
Collection
ElementaryCSS3 Flex flexible box model makes layout fly

30206
Collection
ElementaryLearn DIV+CSS layout in one day (five practical exercises)

11647
Collection
ElementaryHTML5+CSS practice project [Hand Knock Onmyoji official website]

11797
Collection
ElementaryGetting started with HTML5+CSS3 for front-end newbies

280610
Collection

Start Learning

This course includes：

02 days 10 hours 36 minutes 46 seconds Watch videos anytime

0 Download Resources

Popular courses Latest courses

More>