Mysql is the most popular open source database in the world, and we choose it as the teaching database.MySQL, together with other open source softwares Apache and PHP, forms a golden development environment adhering to the spirit of "GUN".MYSQL can be used for Web database development with broad application prospects.
Through the study of this course, you can quickly learn to put knowledge into practice, and you，a learner now, will soon become a developer.Through the study of this course, you will fully understand the principle of relational database and build the database that you need.With MySQL, we can abstract the objective world as a data model, and then develop into a system that can run on a computer.It is hardly no distance between the information at your fingertips and the torrent of data in the cloud, between the spark of your thoughts and wisdom of interconnecting everything.
1.1 An Overview of Database
1.2 Data Model
1.3 Relation Model
1.4 Design for Relation Database
Chapter 2 Getting Started with MySQL
2.1 Introduction to MySQL
2.2 The Configuration of WAMPServer
2.3 Configuration and management of MySQL
2.4 The Use of MySQL Client
2.5 Getting Started with Web Applications for MySQL Databases
Chapter 3 Database,Data Table, Record and Index
3.1 Database Operations
3.2 Data Types
3.3 Data Table Operations
3.4 Modify Data Tables
3.5 Record Operation
3.6 Index
Chapter 4 Data Query and View
4.1 Simple Query
4.2 Condition Query
4.3 Connection Query
4.4 LIMIT and UNION
4.5 Sort and Group
4.6 Functions of MySQL
4.7 Sub Query
4.8 View
Chapter 5 Basics of MySQL Programming
5.1 Constants and Variables
5.2 Operators and Expressions
5.3 IF and CASE Statements
5.4 WHILE Statements
5.5 LOOP and REPEAT Statements
5.6 Cases of Loop and Cursor
Chapter 6 Stored Procedures
6.1 Introduction to Stored Programs
6.2 Create and Call Stored Procedures
6.3 Create and Invoke Stored Functions
6.4 Manage the Stored Routines
6.5 Use Cursors and Transactions in Stored Procedures
6.6 Triggers
6.7 Events
6.8 Case Study - Stored Programs in a System
Chapter 7 Access Control
7.1 Account Management
7.2 Privilege Management
7.3 Backup and Recovery
7.4 Log File Management
7.5 Transaction
Chapter 8 Web Application Based on PHP and MySQL
8.1 An Overview of PHP
8.2 MySQL Database Connection with PHP
8.3 Using PHP to Realize MySQL Database Level Operation
8.4 Using PHP to Realize MySQL Data Table Level Operation
8.5 MySQL Web Development Instance
