The overall concept of big data
13 minutes08 secondsDatabase and relational database-1
08 minutes45 secondsDatabase and relational database-2
10 minutes31 secondsMySQL database
12 minutes11 secondsMySQL download and installation configuration-1
11 minutes11 secondsMySQL download and installation configuration-2
07 minutes22 secondsMySQL download and installation configuration-3
10 minutes18 secondsMySQL download and installation configuration-4
13 minutes28 secondsTools to connect to MySQL-1
09 minutes56 secondsTools to connect to MySQL-2
09 minutes49 secondsOverall structure and library management-1
15 minutes32 secondsOverall structure and library management-2
14 minutes06 secondstable concept
12 minutes37 secondsField data type - 1
16 minutes53 secondsData type of field - 2
07 minutes19 secondsTable management: view all tables and create tables
11 minutes15 secondsTable management: modifying, deleting tables and viewing table structures
17 minutes43 secondsTable management using tools to manage tables
08 minutes46 secondsInsert data-1
11 minutes33 secondsInsert data-2
11 minutes12 secondsInsert data field default value and primary key auto-increment
09 minutes23 secondsData management: modify table data
08 minutes54 secondsData management: deleting table data
16 minutes45 secondsSimple query to query data-1
13 minutes39 secondsSimple query to query data-2
08 minutes42 secondsComparison condition query for query data
06 minutes31 secondsLogical condition query for querying data
12 minutes36 secondsQuery the null condition of query data
10 minutes41 secondsQuery data using fuzzy conditions
11 minutes10 secondsAggregation query for querying data
12 minutes44 secondsQuery data sorting query
12 minutes05 secondsData query paging query-1
11 minutes31 secondsData query paging query-2
10 minutes30 secondsData query paging query-3
12 minutes44 secondsData query group query-1
09 minutes04 secondsData query group query-2
18 minutes22 secondsData query group query-3
07 minutes47 secondsData query if judgment in SQL-1
09 minutes24 secondsData query if judgment in SQL-2
13 minutes19 secondsData query if judgment in SQL-3
10 minutes39 secondsData constraints default value, non-empty, unique
15 minutes42 secondsData constraints primary key
07 minutes27 secondsData constraints automatic growth
14 minutes37 secondsData constraint foreign key -1
16 minutes39 secondsData constraint foreign key-2
09 minutes57 secondsData constraint foreign key-3
12 minutes11 secondsCascade operations of data constraints
12 minutes22 secondsThree major paradigms of database design
06 minutes49 secondsAdvanced query child query-1
14 minutes10 secondsAdvanced query child query-2
08 minutes55 secondsAdvanced query child query-3
21 minutes14 secondsAdvanced query in and not in
08 minutes29 secondsAdvanced query exists and not exists
15 minutes39 secondsMulti-table association query inner join-1
14 minutes56 secondsMulti-table association query inner join-2
13 minutes42 secondsMulti-table related query left join
08 minutes47 secondsThe difference between the on and where conditions of left join in multi-table related queries
20 minutes34 secondsRight join of multi-table related query
16 minutes04 secondsPractice of multi-table related queries
15 minutes14 secondsUse join in update of multi-table related query
22 minutes17 secondsUse join in delete of multi-table related query
17 minutes03 secondsMulti-table related queries using using, union, union all
22 minutes04 secondsA preliminary study on stored procedures
14 minutes26 secondsStored procedures use in, out, and inout type parameters
16 minutes53 secondsUsing variables in stored procedures
14 minutes49 secondsStored procedure flow control-1
20 minutes00 secondsStored procedure flow control-2
11 minutes28 secondstrigger
11 minutes54 secondsfunction
26 minutes23 secondsUser Management
16 minutes42 secondsauthority management
17 minutes20 secondsDDL, DML, DQL and DCL
03 minutes20 secondsThe overall concept of indexing
15 minutes41 secondsIndex Btree
29 minutes05 secondsIndex classification of indexes
26 minutes11 secondsIndex creation timing
07 minutes22 secondsThe concepts and parameters of explan
22 minutes14 secondsExplan's index failure analysis-1
36 minutes35 secondsExplan's Index Failure Analysis-2
27 minutes46 secondsSQL optimization strategy
05 minutes17 secondsGetting Started with Linux (Understanding)
31 minutes17 secondsVMWare virtual machine installation
12 minutes20 secondsCentOS 7.5 installation-1
16 minutes13 secondsCentOS 7.5 installation-2
08 minutes12 secondsVMWare virtual machine hangs
07 minutes22 secondsCentOS 7.5 network configuration-1
32 minutes07 secondsCentOS 7.5 network configuration-2
08 minutes38 secondsCentOS 7.5 network configuration-3
11 minutes10 secondsCentOS 7.5 network configuration-4
19 minutes55 secondsFile and directory structure
25 minutes39 secondsSystem startup process
15 minutes02 secondsUse the tool ssh to log in remotely
18 minutes10 secondsVI, VIM editor-1
21 minutes51 secondsVI, VIM editor-2
17 minutes32 secondsHelp for common commands and commands related to directory files-1
26 minutes35 secondsHelp for common commands and commands related to directory files-2
22 minutes37 secondsHelp for common commands and commands related to directory files-3
32 minutes28 secondsCommonly used commands date-related commands
07 minutes37 secondsCommonly used commands for user and username group management commands
14 minutes35 secondsCommonly used commands related to file permissions
22 minutes42 secondsSearch for commonly used commands to find related commands
18 minutes16 secondsCommonly used commands: compression and decompression related commands
17 minutes28 secondsCommonly used commands: Disk partition and process thread related commands
19 minutes35 secondsCommonly used commands related to scheduled tasks
23 minutes44 secondsVirtual machine cloning
20 minutes04 secondsPractice questions and interview questions
06 minutes07 secondsOverview and parser
09 minutes30 secondsGetting started
15 minutes36 secondsVariable 01
22 minutes26 secondsVariable 02
08 minutes00 secondsoperator
07 minutes44 secondsConditional judgment
08 minutes04 secondsprocess control
30 minutes04 secondsread reads console input and functions
07 minutes14 secondsCustom function
15 minutes06 secondstool cut
26 minutes47 secondsTools sed
08 minutes26 secondsBasic usage of awk tool
25 minutes46 secondsTools awk operator
29 minutes52 secondsTools awk built-in variables
37 minutes51 secondsThe case goes from imitation to variation (you will have your own insights)
03 minutes39 secondsTool awk script
15 minutes51 secondsTools awk built-in functions
32 minutes46 secondsApplication of tool awk in big data query
21 minutes09 secondsTool sort
11 minutes34 secondsReal company interview questions
04 minutes33 secondsIntroduction to big data (understanding)
36 minutes55 secondsBig data technology ecosystem
11 minutes40 secondsHadoop overview
38 minutes02 secondsUse securcrt to upload files to Linux
06 minutes25 secondsVirtual machine configuration, JDK and Hadoop installation-1
22 minutes57 secondsVirtual machine configuration, JDK and Hadoop installation-2
22 minutes52 secondslocal run mode
13 minutes34 secondsFully distributed mode (Hadoop cluster) configuration-1
21 minutes21 secondsFully distributed mode (Hadoop cluster) configuration-2
18 minutes43 secondsFully distributed mode (Hadoop cluster) configuration-3
29 minutes24 secondsSet up ssh password-free login between cluster nodes
24 minutes00 secondsCluster starting and stopping
13 minutes44 secondsCluster configuration history server
12 minutes12 secondsAggregation of cluster configuration logs
17 minutes18 secondsRunning the wordcount case under the cluster
20 minutes06 secondsCompile source code 01
08 minutes09 secondsCompile source code 02
20 minutes57 secondsCompile source code 03
14 minutes44 secondsFrequently Asked Questions and Solutions
08 minutes11 secondsGenerating background and design ideas
24 minutes45 secondsOverview of advantages, disadvantages and composition architecture
28 minutes04 secondsshell operation 01
19 minutes57 secondsshell operation 02
20 minutes29 secondsshell operation 03
27 minutes52 secondsEstablishment of development environment under windows for client operation
20 minutes52 secondsMaven project creation and configuration for client operations
API example of client operation 01
14 minutes51 secondsAPI example of client operation 02
22 minutes46 secondsAPI example of client operation 03
24 minutes08 secondsAPI example of client operation 04
08 minutes21 secondsWriting process (interview focus)
23 minutes38 secondsWriting process (interview focus) 02
20 minutes51 secondsNetwork topology of the writing process-node distance calculation (interview focus)
22 minutes37 secondsCopy storage strategy of writing process - rack awareness
12 minutes45 secondsReading process (interview focus)
11 minutes11 secondsNN and 2NN working mechanism (interview focus)
27 minutes06 secondsFormat hadoop cluster
38 minutes47 secondsFsimage and Edits analysis (interview focus)
20 minutes57 secondsCheckPoint time setting and NameNod
10 minutes23 secondsCluster security model (interview focus)
19 minutes54 secondsDataNode failure mechanism and offline parameter settings (interview focus)
15 minutes44 secondsData integrity of DataNode (interview focus)
06 minutes00 secondsCluster dynamically serves new DataNode data nodes (interview focus)
17 minutes01 secondsCluster dynamically serves new DataNode data nodes (interview focus) 02
26 minutes18 secondsCluster dynamically serves new DataNode data nodes (interview focus) 03
20 minutes17 secondsDecommissioning data nodes and DataNode multi-directory configuration
30 minutes44 secondsDefinition, Advantages and Disadvantages
15 minutes10 secondsCore ideas and official WordCount source code
20 minutes56 secondsMapReduce: Handwritten WordCount 01
45 minutes05 secondsHandwritten WordCount 02
32 minutes02 secondsHandwritten WordCount 03
23 minutes36 secondsHandwritten WordCount 04
36 minutes02 secondsSerialization concepts and specific methods of serialization and deserialization of custom beans
22 minutes18 secondsSerialization practical case 01
20 minutes27 secondsSerialization practical case 02
36 minutes54 secondsSerialization practical case 03
14 minutes36 secondsSlice split and Map Task parallelism determination mechanism
28 minutes10 secondsDetailed explanation of job submission process source code
20 minutes11 secondsSlicing process and FilenputFormat slicing mechanism
14 minutes22 secondsCombine TextInputFormat slicing mechanism
17 minutes09 secondsCombine TextInputFormat case practice
28 minutes50 secondsMapReduce workflow 01
17 minutes50 secondsMapReduce workflow 02
12 minutes11 secondsShuffle overview
29 minutes17 secondsPartition partition and custom partition
13 minutes31 secondsPartition custom partition instance operation 01
32 minutes28 secondsPartition custom partition instance operation 02
11 minutes42 secondsWritableComparable sorting
11 minutes06 secondsWritableComparable custom sorting instance
01 Hours00 minutes07 secondsCombiner merge
21 minutes20 secondsThe working mechanism of Map Task and Reduce Task
16 minutes18 secondsOutputFormat data output
40 minutes43 secondsReduce Join
59 minutes16 seconds
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.
