{{ variable.name }}
Introduction: To become a qualified back-end engineer, data processing skills are indispensable. No matter which programming language is used, a solid foundation in database knowledge is essential. Even nowadays, many large companies have requirements for data processing capabilities when recruiting front-end engineers. IT is evident that database learning has become the mainstream in the IT circle.
The first lesson for novice programmers: Get started with MySQL in just 5 hours!
The course closely follows technological developments and starts with the current mainstream MySQL8.0. It begins with the most basic database concepts and covers the syntax of SQL statements for operating databases, as well as the installation and uninstallation of databases. Comprehensive coverage of key knowledge and operation methods helps students with no prior knowledge to smoothly get started.
In the course, the instructor uses Markdown format for knowledge notes, which is convenient for students to sort out the key points, deepen the memory of knowledge points, and also makes it more convenient to review after class.
What knowledge can you learn in the course?
-Installation and uninstallation of MySQL database
-SQL basic syntax
-DDL statements - Adding, deleting, modifying and querying databases and tables
-DML statements - Adding, deleting, and modifying data
-DQL statement -- Query of data
-Constraints on database tables
After 5 hours of study, you will meet the basic requirements of MySQL database for back-end project development and be able to handle the basic MySQL questions in the corresponding job interview with ease.
Chapter 1 Introduction to Databases
This chapter introduces the concept of databases, the various data storage methods, and why we should choose MySQL databases, among other knowledge.
1-1 MySQL Database Course Outline
1-2 Overview and Advantages and Disadvantages of the Database
Characteristics and Application Scenarios of Common Databases 1-3
Chapter 2 Installation of MySQL Database
This chapter introduces the installation and uninstallation process of the MySQL database.
2-1 Database uninstallation
2-2 Database Installation
2-3 Three Ways to Start MySQL Service
Chapter 3: SQL Basic Syntax for Beginners
This chapter will guide everyone to learn the basic syntax of SQL. Let's embark on a database journey together.
3-1 dos connection to the database
3-2 Relationships among DBMS, databases, and Tables
3-3 Overview and Classification of SQL
3-4 General Syntax of SQL
Chapter 4: Operations of MySQL Database and Data Tables by the Bronze Bureau
This chapter introduces DDL operation statements and teaches the creation, deletion, modification and query of databases and their data tables.
4-1 Operating Databases with DDL Statements
4-2 Operations on Tables and Columns of DDL Statements
Chapter 5: Adding, Deleting, Modifying and Querying MySQL Table Data in the Silver Bureau
In the previous chapter, we learned how to create, delete, and modify databases and their tables. This chapter will guide you to learn how to perform operations such as adding, deleting, and modifying data in tables.
5-1 Inserting Table Data in DML Statements
5-2 Worm replication
5-3 Modification and deletion of Table data in DML statements
5-4 Simple Queries of DQL Statements
Chapter 6 Equipment Upgrade - Installation and Use of Navicat
Although the command-line window can operate on the database, it is not very friendly to us. sql statements, commands, and results are all mixed together, making it very difficult for me to distinguish. But how could we possibly give up? Let's learn about the database wonder -Navicat together in this chapter.
6-1 Installation of Navicat
6-2 Navicate Practice
Chapter 7 Complex Queries of Data Tables
7-1 Comparison Operator for Conditional Query
7-2 Logical Operators and range Operators for Conditional Queries
7-3 Fuzzy Query Based on Conditional Queries
7-4 Sorting of conditional Query results
7-5 Aggregation Function for Conditional Query
Group queries based on conditions 7-6
7-7 Limit Pagination for Conditional Query
Chapter 8 Database Constraints
8-1 Introduction to Database Constraints
8-2 Database Constraints - Primary Key Constraints
8-3 Database Constraint - Unique Constraint
8-4 Database Constraints - Non-Empty Constraints
8-5 Setting of default values
Chapter 9 Course Summary
9-1 Summary