This paper introduces the type of connections, the operation steps of connections, and the connection syntax in SQL. It analyzes how to improve the query efficiency based on the multi-table connection, and further explains with the examples of the student database.