MySQL Database Programming课程列表：

Chapter 1 Basic Knowledge of Database

-1.1 An Overview of Database

--1.1 An Overview of Database

-1.2 Data Model

--1.2 Data Model

-1.3 Relation Model

--1.3 Relation Model

-1.4 Design for Relation Database

--1.4 Design for Relation Database

-Assignment for chapter 1

-Designing a table structure

Chapter 2 Getting Started with MySQL

-2.1 Introduction to MySQL

--2.1 Introduction to MySQL

-2.2 The Configuration of WAMPServer

--2.2 The Configuration of WAMPServer

-2.3 Configuration and management of MySQL

--2.3 Configuration and management of MySQL

-2.4 The Use of MySQL Client

--2.4 The Use of MySQL Client

-2.5 Getting Started with Web Applications for MySQL Databases

--2.5 Getting Started with Web Applications for MySQL Databases

-Assignment for Chapter 2

-Installing MySQL

Chapter 3 Database,Data Table, Record and Index

-3.1 Database Operations

--3.1 Database Operations

-3.2 Data Types

--3.2 Data Types

-3.3 Data Table Operations

--3.3 Data Table Operations

-3.4 Modify Data Tables

--3.4 Modify Data Tables

-3.5 Record Operation

--3.5 Record Operation

-3.6 Index

--3.6.1 Index(1)

--3.6.2 Index(2)

-Assignment for chapter 3

-Relationship

Chapter 4 Data Query and View

-4.1 Simple Query

--4.1.1 Simple Query(1)

--4.1.2 Simple Query(2)

-4.2 Condition Query

--4.2.1 Condition Query(1)

--4.2.2 Condition Query(2)

-4.3 Connection Query

--4.3.1 Connection Query(1)

--4.3.2 Connection Query(2)

--4.3.3 Connection Query(3)

-4.4 LIMIT and UNION

--4.4 LIMIT and UNION

-4.5 Sort and Group

--4.5.1 Sort

--4.5.2 Group

-4.6 Functions of MySQL

--4.6 Functions of MySQL

-4.7 Sub Query

--4.7 Sub Query

-4.8 View

--4.8.1 View(1)

--4.8.2 View(2)

--4.8.3 View(3)

-Assignment for chapter 4

-Self-joining query

-Limit

Chapter 5 Basics of MySQL Programming

-5.1 Constants and Variables

--5.1 Constants and Variables

-5.2 Operators and Expressions

--5.2 Operators and Expressions

-5.3 IF and CASE Statements

--5.3 IF and CASE Statements

-5.4 WHILE Statements

--5.4 WHILE Statements

-5.5 LOOP and REPEAT Statements

--5.5 LOOP and REPEAT Statements

-5.6 Cases of Loop and Cursor

--5.6 Cases of Loop and Cursor

-Assignment for chapter 5

-MySQL code and PHP script code

-Can case statement be used to realize single selection in practice?

-What will happen to the Loop if you do not use a Leave statement

Chapter 6 Stored Procedures

-6.1 Introduction to Stored Programs

--6.1 Introduction to Stored Programs

-6.2 Create and Call Stored Procedures

--6.2 Create and Call Stored Procedures

-6.3 Create and Invoke Stored Functions

--6.3 Create and Invoke Stored Functions

-6.4 Manage the Stored Routines

--6.4 Manage the Stored Routines

-6.5 Use Cursors and Transactions in Stored Procedures

--6.5 Use Cursors and Transactions in Stored Procedures

-6.6 Triggers

--6.6 Triggers

-6.7 Events

--6.7 Events

-6.8 Case Study - Stored Programs in a System

--6.8 Case Study - Stored Programs in a System

-Assignment for chapter 6

Chapter 7 Access Control

-7.1 Account Management

--7.1 Account Management

-7.2 Privilege Management

--7.2.1 Privilege Management(1)

--7.2.2 Privilege Management(2)

-7.3 Backup and Recovery

--7.3 Backup and Recovery

-7.4 Log File Management

--7.4 Log File Management

-7.5 Transaction

--7.5.1 Transaction(1)

--7.5.2 Transaction(2)

-Add User by using SQL statements

-Update the permission table manually

-Migrate

-When turn on logging functions

-How to reduce the probability of deadlock?

-Assignment for Chapter 7

Chapter 8 Web Application Based on PHP and MySQL

-8.1 An Overview of PHP

--8.1 An Overview of PHP

-8.2 MySQL Database Connection with PHP

--8.2 MySQL Database Connection with PHP

-8.3 Using PHP to Realize MySQL Database Level Operation

--8.3 Using PHP to Realize MySQL Database Level Operation

-8.4 Using PHP to Realize MySQL Data Table Level Operation

--8.4 Using PHP to Realize MySQL Data Table Level Operation

-8.5 MySQL Web Development Instance

--8.5 MySQL Web Development Instance

-Assignment for Chapter 8

© 柠檬大学-慕课导航 课程版权归原始院校所有，
本网站仅通过互联网进行慕课课程索引，不提供在线课程学习和视频，请同学们点击报名到课程提供网站进行学习。