本季课程基于Django第一季的内容为基础，重点结合了mysql数据库存储数据，重点要求使用标准的SQL语句操作数据库，实现数据库的增删查改。掌握本季课程，课程完成基于数据库的开发。

mysql事务，视图，索引，备份

Mysql事务.pdf

对应企业开发的Mysql知识梳理

设计数据敏感型应用，对多种存储组件进行分析，可以用于存储组件的技术选型，深入理解各种存储组件的优劣：Data-intensive applications are pushing the boundaries of what is possible by making use of these technological developments. We call an application data-intensive if data is its primary challenge—the quantity of data, the complexity of data, or the speed at Preface Preface | xiii which it is changing—as opposed to compute-intensive, where CPU cycles are the bottleneck. The tools and technologies that help data-intensive applications store and process data have been rapidly adapting to these changes. New types of database systems (“NoSQL”) have been getting lots of attention, but message queues, caches, search indexes, frameworks for batch and stream processing, and related technologies are very important too. Many applications use some combination of these.

MyISAM 存储引擎 MyISAM 是 MySQL 官方提供默认的存储引擎，其特点是不支持事务、表锁和全文索引，对于一些 OLAP（联机 分析处理）系统，操作速度快。 每个 MyISAM 在磁盘上存储成三个文件。文件名都和表名相同，扩展名分别是.frm（存储表定义）、.MYD (MYData， 存储数据)、.MYI (MYIndex，存储索引)。这里特别要注意的是 MyISAM 不缓存数据文件，只缓存索引文件。 InnoDB 存储引擎 InnoDB 存储引擎支持事务，主要面向 OLTP（联机事务处理过程）方面的应用，其特点是行锁设置、支持外键， 并支持类似于 Oracle 的非