要求

• ·一台windows或者Mac

• · 安装了SQL编辑器与SQL数据库

当今是数据的时代！各种数据库技术是在数据处理环节不可或缺的核心技术。MySQL作为数据库技术里最受欢迎的开源免费产品，被各大科技公司所用。根据实际工作经验，越来越多的项目要求管着有基本的代码优化技术，其中数据库优化是必不可少的能力。

作为IT从业人员，不管您是开发者还是其他职位，掌握MySQL技术将让您能对公司业务的了解更清晰.其中SQL代码效率优化是一项重要的技能。

通过本课程，您将学到

• · SQL的基本join语法

• · 外连接用法

• · 内连接用法

• · 左外连接用法

• · 右外连接用法

• · 连接效率优化

• · And more!

requirement

• ·A Windows or Mac

• ·Installed SQL editor and SQL database

Today is the age of data! Various database technologies are indispensable core technologies in data processing. As the most popular open source free product in database technology, MySQL is used by major technology companies. According to practical work experience, more and more projects require basic code optimization technology, in which database optimization is an essential ability.

As an it practitioner, whether you are a developer or in other positions, mastering MySQL technology will make you have a clearer understanding of the company's business. Among them, SQL code efficiency optimization is an important skill.

Through this course, you will learn

• ·The basic join syntax of SQL

• ·Usage of outer connection

• ·Inner join usage

• ·Left outer connection usage

• ·Right outer connection usage

• ·Connection efficiency optimization

• · And more!